| No | Date | Topic | Readings | Code |
|---|---|---|---|---|
| Chapter 0: Introduction | ||||
| 1 | Jan 13, 2026 | Lecture 01: Course Introduction | § 1 | [v1] |
| 2 | Jan 15, 2026 | Lecture 02: Recap: Storage Management | § 12, 13 | [v2] [v18] |
| 3 | Jan 20, 2026 | Lecture 03: Recap: Access Methods | § 14, 18 | [v25] [v33] [inverted index] |
| 4 | Jan 22, 2026 | Lecture 04: Recap: Query Execution | § 15 | [v35] [v44] [columnar] |
| Chapter 1: Logging and Recovery Methods | ||||
| 5 | Jan 27, 2026 | Lecture 05: Logging (Part 1) | § 17, 19 | |
| 6 | Jan 29, 2026 | Lecture 06: Logging (Part 2) | " | |
| 7 | Feb 3, 2026 | Lecture 07: Recovery (Part 1) | " | |
| Feb 5, 2026 | Instructor Sick — No Class | |||
| 8 | Feb 10, 2026 | Lecture 08: Recovery (Part 2) | " | |
| 9 | Feb 12, 2026 | Lecture 09: ARIES from First Principles | " | |
| 10 | Feb 17, 2026 | Lecture 10: Case Studies | " | |
| 11 | Feb 19, 2026 | Lecture 11: Persistent Memory Databases | " | |
| Chapter 2: Concurrency Control | ||||
| 12 | Feb 24, 2026 | Lecture 12: Concurrency Control | § 18 | |
| 13 | Feb 26, 2026 | Lecture 13: Two-Phase Locking | " | |
| 14 | Mar 3, 2026 | Lecture 14: Timestamp Ordering | " | |
| Mar 5, 2026 | Exam 1 | |||
| 15 | Mar 10, 2026 | Lecture 15: Optimistic Concurrency Control | " | |
| 16 | Mar 12, 2026 | Lecture 16: Multi-Version Concurrency Control | " | |
| 17 | Mar 17, 2026 | Lecture 17: Concurrency Control in MMDBs | " | |
| Mar 19, 2026 | Spring Break — No Class | |||
| Mar 24, 2026 | Spring Break — No Class | |||
| Mar 26, 2026 | Spring Break — No Class | |||
| 18 | Mar 31, 2026 | Lecture 18: Case Studies | " | |
| Chapter 3: Query Optimization | ||||
| 19 | Apr 2, 2026 | § 16 | ||
| 20 | Apr 7, 2026 | " | ||
| 21 | Apr 9, 2026 | " | ||
| 22 | Apr 14, 2026 | " | ||
| 23 | Apr 16, 2026 | " | ||
| 24 | Apr 21, 2026 | " | ||
| Apr 23, 2026 | Buffer Space | |||
| Apr 28, 2026 | Project Presentations | |||
| Apr 30, 2026 | Buffer Space | |||
| May 5, 2026 | Buffer Space | |||
| May 7, 2026 | Exam 2 |
NOTE: The schedule is tentative and is subject to change as the semester progresses.
Credits
These slide decks are derived from courses developed by