Schedule

  • This course schedule is subject to change through the semester.

  • Lecture slides will be uploaded here (and on Canvas Files) before each lecture.

  • Recorded lectures will not be posted online.

  • The recorded lectures will only be shared in case of emergencies if a student can not attend in-person.

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
November 14 Vectorization Paper 1, Paper 2, Paper 3, Paper4 Paper Report #5
November 19 Machine Learning for Database Systems Paper 1, Paper 2, Paper 3
November 21 Vector Databases
November 26 Project #3 Due
December 3
December 5 Final Exam Due