Date | Topic | Reading List | Slides | Deadlines |
| | | | |
August 19 | Course Introduction and History of Databases | Paper 1, Paper 2 | Slides | |
August 22 | Project #1 Brief by TAs | | Slides | Project #1 Release |
August 27 | Data System Architecture Essentials | Paper 1, Paper 2, Paper 3 | Slides | |
August 29 | In-Memory Indexing (SkipList, B+-Trees) | Paper 1, Paper 2, Paper 3, Paper 4 | Slides | Paper Report #1 Due |
September 3 | In-Memory Indexing (Tries) | Paper 1, Paper 2 | Slides | |
September 5 | Concurrency Control (Latches) | Paper 1, Paper 2,Paper 3, Paper 4 | Slides | |
September 10 | Concurrency Control (Locks) | | Slides | Project #1 Due |
September 12 | Multi-Version Concurrency Control | Paper 1, Paper 2, Paper 3, Paper 4, Paper 5 | Slides | |
September 17 | Storage Models, Data Layout, File Organization | Paper 1, Paper 2, Paper 3 | Slides | Paper Report #2 Due |
September 19 | Be-Trees and SplinterDB | Paper1, Paper 2 | Slides | Project #2 Release |
September 24 | Be-Tree code walk through | | | |
September 26 | Log-Structured Merge (LSM) trees | Paper 1, Paper 2, Paper 3 | Slides | |
October 1 | Filters (Bloom) | Paper 1 | Slides | |
October 3 | Filters (Quotient, Cuckoo) | Paper 1, Paper 2, Paper 3 | | Project #2 Due |
October 15 | Logging and Recovery Protocols I | Paper 1 | Slides | |
October 17 | Logging and Recovery Protocols II | Paper 1 | Slides | Project #3 Release |
October 22 | Logging and Recovery Protocols (Continued) | | | Paper Report #3 Due |
November 24 | Learned Indexes | Paper 1, Paper 2, Paper 3 | | |
October 29 | Row Stores vs Column Stores | Paper 1, Paper 2 | Slides | |
October 31 | Query Processing I | Paper 1, Paper 2, Paper 3 | Slides | |
November 5 | Query Processing II | | | Paper Report #4 |
November 7 | Query Optimization I | | Slides | |
November 12 | Project 3 Deep-Dive | | | |
November 14 | Vectorization | Paper 1, Paper 2, Paper 3, Paper4 | Slides | Paper Report #5 |
November 19 | Databases on Modern Hardware (Hunter McCoy) | Paper 1, Paper 2, Paper 3 | Slides | |
November 21 | Machine Learning for Database Systems | Paper 1, Paper 2, Paper 3 | Slides | |
November 26 | Vector Databases | | | Project #3 Due |
December 3 | Final Exam Review | | | |
December 5 | Final Exam | | | |
|