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 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