Date | Topic | Reading List | Slides | Deadlines |
| | | | |
August 22 | Course Introduction and History of Databases | Paper 1, Paper 2 | Slides | |
August 24 | Data System Architecture Essentials | Paper 1, Paper 2, Paper 3 | Slides | |
August 29 | Project #1 Brief by TAs | | Slides | Project #1 Release |
August 31 | In-Memory Indexing (Trees, Tries) | Paper 1, Paper 2, Paper 3, Paper 4, Paper 5, Paper 6 | Slides | Paper Report #1 Due |
September 5 | Concurrency Control (Latches) | Paper 1, Paper 2,Paper 3, Paper 4 | Slides | |
September 7 | Concurrency Control (Locks) | | Slides | |
September 12 | Multi-Version Concurrency Control | Paper 1, Paper 2, Paper 3, Paper 4, Paper 5 | Slides | Project #1 Due |
September 14 | Storage Models, Data Layout, File Organization | Paper 1, Paper 2, Paper 3 | Slides | Project #2 Release |
September 19 | Logging and Recovery Protocols I | Paper 1 | Slides | Paper Report #2 Due |
September 21 | Logging and Recovery Protocols II | Paper 1 | Slides | |
September 26 | Be-Trees and SplinterDB | Paper1, Paper 2 | Slides | |
September 28 | Be-Tree code Walk-through | | | |
October 3 | Log-Structured Merge (LSM) trees | Paper 1, Paper 2, Paper 3 | Slides | |
October 5 | Row Stores vs Column Stores | Paper 1, Paper 2 | Slides | Project #2 Due |
October 17 | Final Project Discussion | | | Paper Report #3 Due |
October 19 | Query Processing I | Paper 1, Paper 2, Paper 3 | Slides | Final Project Proposal Due |
October 24 | Filters and GPU Databases (TA: Hunter McCoy) | Paper 1, Paper 2, Paper 3 | Slides | |
October 26 | Learned Indexes (Yuvaraj Chesetti) | | Slides | |
October 31 | Query Processing II | | | Paper Report #4 |
November 2 | Query Optimization I | | Slides | |
November 7 | Query Optimization II | | | |
November 9 | Vectorization | Paper 1, Paper 2, Paper 3, Paper4 | Slides | Project Mid-Point Report |
November 14 | Machine Learning for Database Systems | Paper 1, Paper 2, Paper 3 | Slides | |
November 16 | In-class quiz | | | Paper Report #5 |
November 21 | Learned Indexes I | Paper 1, Paper 2, Paper 3 | | |
November 28 | Learned Indexes II | | | |
November 30 | Final Project Presentation I | | | Final Project Report Due |
December 5 | Final Project Presentation II | | | |
December 7 | Final Project Presentation III | | | Final Exam Due |
|