Tentative Schedule (subject to changes)
| Date | Topic | Content |
|---|---|---|
| W1: Jan 8 | Lecture 1 | Course Introduction, History of Databases (slides) |
| W1: Jan 10 | Lecture 2 | Relational Model and ER Diagram (slides) |
| W2: Jan 15 | No Class (MLK Day) | |
| W2: Jan 17 | Lecture 3 | Database Design Theory I (slides) |
| W3: Jan 22 | Lecture 4 | Database Design Theory II (slides) |
| W3: Jan 24 | Lecture 5 | Storage (slides) |
| W4: Jan 29 | Lecture 6 Assignment 1 due | Index Basics and B-Tree (slides) |
| W4: Jan 31 | Lecture 7 | Hashing (slides) |
| W5: Feb 5 | Lecture 8 | Query Processing and Optimization (slides) |
| W5: Feb 7 | Lecture 9 Assignment 2 due | Query Optimization, Transaction Intro (slides) |
| W6: Feb 12 | Lecture 10 | Transaction Processing (CC) (slides) |
| W6: Feb 14 | Lecture 11 | Transaction Processing (Recovery) (slides) |
| W7: Feb 19 | Lecture 12 | Data Warehousing and OLAP (slides) |
| W7: Feb 21 | Lecture 13 | Data Mining (slides) |
| W8: Feb 26 | Tech Presentation | A1. Data Mining and OLAP (slides) C4. Data Visualization (slides) |
| W8: Feb 28 | Tech Presentation | C5. Customer Relationship Management (slides) B2. Cloud Platform Offerings (slides) |
| W9: Mar 4 | Tech Presentation | C1. Statistical and ML Techniques for DBMS (slides) C2. Graph Databases (slides) A2. Document Management Systems (slides) |
| W9: Mar 6 | Tech Presentation | A3. Data Warehousing Product (slides) B1. Non-relational Database Systems (slides) |
| W9: Mar 7 | Assignment 3 due | |
| W10: Mar 11 | Tech Presentation Assignments 4, 5 due | C3. Vector Databases (slides) C6. Time-series Databases (slides) |
| W10: Mar 13 | Lecture 14 Midterm released | Map Reduce and Spark (slides) |
| W10: Mar 15 | Midterm due | |
| W11: Mar 18 | No Class (Spring Break) | |
| W11: Mar 20 | No Class (Spring Break) | |
| W12: Mar 25 | Lecture 15 | NewSQL, How to Read Papers (slides) (handout) |
| W12: Mar 27 | Class cancelled due to fire alarm | |
| W13: Apr 1 | Lecture 16 | Vector Databases and ANNS (slides) |
| W13: Apr 3 | Paper Presentation | P1, P2, P3 |
| W14: Apr 8 | Paper Presentation | P4, P5, P6 |
| W14: Apr 10 | Paper Presentation | P7, P8, P9 |
| W15: Apr 15 | Paper Presentation | P10, P11, lecture |
| W15: Apr 17 | Project Presentation Assignment 6, 7 due Quiz released | Groups 6, 2, 12, 7, 8 |
| W15: Apr 19 | Quiz due | |
| W16: Apr 22 | Project Presentation Assignment 8 due | Groups 4, 9, 3, 10, 5, 1 |
| W17: Apr 29 | Final project demo and report due |