| Date | Topic | Slides | Video | PSets | Snippets | Readings |
|---|---|---|---|---|---|---|
| Jan 18, 2021 | Martin Luther King, Jr. National Holiday — No Class | |||||
| Jan 20, 2021 | Course Introduction | [slides] | [annotated slides] | [video] | [pset] | ||
| Jan 25, 2021 | Recap: Storage Management
Assignment 1 Released
|
[slides] | [annotated slides] | [video] | |||
| Jan 27, 2021 | Recap: Access Methods | [slides] | [annotated slides] | [video] | |||
| Feb 1, 2021 | Recap: Query Processing | [slides] | [annotated slides] | [video] | |||
| Chapter I: Logging and Recovery Methods | ||||||
| Feb 3, 2021 | Logging (Part 1) | [slides] | [annotated slides] | [video] | [pset] | § 17, 19 | |
| Feb 8, 2021 | Logging (Part 2)
Assignment 1 Due
Assignment 2 Released
|
[slides] | [annotated slides] | [video] | [pset] | " | |
| Feb 10, 2021 | Recovery (Part 1) | [slides] | [annotated slides] | [video] | [pset] | ||
| Feb 15, 2021 | Recovery (Part 2) | [slides] | [annotated slides] | [video] | [pset] | " | |
| Feb 17, 2021 | ARIES from First Principles | [slides] | [annotated slides] | [video] | [pset] | " | |
| Feb 22, 2021 | Case Studies | [slides] | [annotated slides] | [video] | [pset] | " | |
| Feb 24, 2021 | Write-Behind Logging | [slides] | [annotated slides] | [video] | [pset] | " | |
| Chapter II: Concurrency Control | ||||||
| Mar 1, 2021 | Concurrency Control | [slides] | [annotated slides] | [video] | [pset] | § 18 | |
| Mar 3, 2021 | Two-Phase Locking
Assignment 2 Due
Assignment 3 Released
|
[slides] | [annotated slides] | [video] | [pset] | " | |
| Mar 8, 2021 | Timestamp Ordering
Project Proposals
|
[slides] | [annotated slides] | [video] | [pset] | " | |
| Mar 10, 2021 | Optimistic Concurrency Control | [slides] | [annotated slides] | [video] | [pset] | " | |
| Mar 15, 2021 | Multi-Version Concurrency Control | [slides] | [annotated slides] | [video] | [pset] | " | |
| Mar 17, 2021 | Concurrency Control in MMDBs | [slides] | [annotated slides] | [video] | [pset] | " | |
| Mar 22, 2021 | Case Studies | [slides] | [annotated slides] | [video] | [pset] | " | |
| Mar 24, 2021 | Wellness Day | |||||
| Chapter III: Query Optimization | ||||||
| Mar 29, 2021 | Rule-Based Query Optimization | [slides] | [annotated slides] | [video] | § 16 | ||
| Mar 31, 2021 | Cost-Based Query Optimization
Assignment 3 Due
Assignment 4 Released
|
[slides] | [annotated slides] | [video] | " | ||
| Apr 5, 2021 |
Project Updates
| " | ||||
| Apr 7, 2021 | Design Decisions + Search Strategies | [slides] | [annotated slides] | [video] | " | ||
| Apr 12, 2021 | Mid-term Exam | |||||
| Apr 14, 2021 | Cascades Optimization Framework | [slides] | [annotated slides] | [video] | " | ||
| Apr 19, 2021 | Adaptive Query Optimization & Cost Models | [slides] | [annotated slides] | [video] | |||
| Apr 21, 2021 | User-defined Functions | [slides] | [annotated slides] | [video] | " | ||
| Apr 26, 2021 | Networking + Course Retrospective
Assignment 4 Due
|
[slides] | [annotated slides] | [video] | " | ||
| Apr 28, 2021 | Reading Period | |||||
| May 3, 2021 | Project Presentations | [video] |
NOTE: The schedule is tentative and is subject to change as the semester progresses.
Credits
These slide decks are derived from courses developed by Thomas Neumann and Andy Pavlo.