ScheduleLast Updated: Dec 09, 2024
Last Updated: Dec 09, 2024
| Date | Topic | Slides | Notes | Video |
|---|---|---|---|---|
| Aug 25 | Lecture #00: Course Overview & Logistics(On-line Only) Project:C++ Primer | SLIDES (Lecture #00) | — | VIDEO (Lecture #00) |
| Aug 26 | Lecture #01: Relational Model & Algebra Readings:Chapters 1-2 | SLIDES (Lecture #01) | NOTES (Lecture #01) | VIDEO (Lecture #01) |
| Aug 28 | Lecture #02: Modern SQL Readings:Chapters 3-5 Homework:SQL | SLIDES (Lecture #02) | NOTES (Lecture #02) | VIDEO (Lecture #02) |
| Sep 02 | Labor Day — No Class | |||
| Sep 04 | Lecture #03: Database Storage I Flash Talk:Heikki Linnakangas ( Neon) Readings:Chapter 12.1-12.4, 13.2-13.3 | SLIDES (Lecture #03) | NOTES (Lecture #03) | VIDEO (Lecture #03) |
| Sep 09 | Lecture #04: Database Storage II Readings:Chapter 14.8.1, 24.2 Project:Buffer Pool Manager | SLIDES (Lecture #04) | NOTES (Lecture #04) | VIDEO (Lecture #04) |
| Sep 11 | Lecture #05: Storage Models & Compression Flash Talk:Xiang Fu ( StarTree) Readings:Chapter 11.2, 13.6 Homework:Storage | SLIDES (Lecture #05) | NOTES (Lecture #05) | VIDEO (Lecture #05) |
| Sep 16 | Lecture #06: Memory Management Readings:Chapter 13.2-13.5 | SLIDES (Lecture #06) | NOTES (Lecture #06) | VIDEO (Lecture #06) |
| Sep 18 | Lecture #07: Hash Tables Flash Talk:Niko Göbel ( RelationalAI) Readings:Chapter 14.5, 24.5 | SLIDES (Lecture #07) | NOTES (Lecture #07) | VIDEO (Lecture #07) |
| Sep 23 | Lecture #08: Indexes & Filters I Readings:Chapter 14.1-14.4 | SLIDES (Lecture #08) | NOTES (Lecture #08) | VIDEO (Lecture #08) |
| Sep 25 | Lecture #09: Indexes & Filters II Flash Talk:Ed Huang ( PingCAP TiDB) Readings:Chapter 14.1-14.4, 24.1 Homework:Indexes & Filters | SLIDES (Lecture #09) | NOTES (Lecture #09) | VIDEO (Lecture #09) |
| Sep 30 | Lecture #10: Index Concurrency Control Readings:Chapter 18.10.2 Project:Database Index | SLIDES (Lecture #10) | NOTES (Lecture #10) | VIDEO (Lecture #10) |
| Oct 02 | Lecture #11: Sorting & Aggregations Algorithms Flash Talk:Drew Banin ( dbt Labs) Readings:Chapter 15.4-15.5 | SLIDES (Lecture #11) | NOTES (Lecture #11) | VIDEO (Lecture #11) |
| Oct 07 | Lecture #12: Joins Algorithms Readings:Chapter 15.4-15.6 | SLIDES (Lecture #12) | NOTES (Lecture #12) | VIDEO (Lecture #12) |
| Oct 09 | Mid-Term Exam | |||
| Oct 14 | Fall Break — No Class | |||
| Oct 16 | Fall Break — No Class | |||
| Oct 21 | Lecture #13: Query Execution I Readings:Chapter 15.1-15.3, 15.7 Project:Query Execution | SLIDES (Lecture #13) | NOTES (Lecture #13) | VIDEO (Lecture #13) |
| Oct 23 | Lecture #14: Query Execution II Flash Talk:Robert Schulze ( ClickHouse) Readings:Chapter 22 Homework:Query Execution | SLIDES (Lecture #14) | NOTES (Lecture #14) | VIDEO (Lecture #14) |
| Oct 28 | Lecture #15: Query Planning & Optimization Readings:Chapter 16 | SLIDES (Lecture #15) | NOTES (Lecture #15) | VIDEO (Lecture #15) |
| Oct 30 | Lecture #16: Concurrency Control Theory Flash Talk:Mosha Pasumansky ( Firebolt) Readings:Chapter 18 | SLIDES (Lecture #16) | NOTES (Lecture #16) | VIDEO (Lecture #16) |
| Nov 04 | Lecture #17: Two-Phase Locking Concurrency Control Readings:Chapter 18.1-18.3, 18.9 | SLIDES (Lecture #17) | NOTES (Lecture #17) | VIDEO (Lecture #17) |
| Nov 06 | Lecture #18: Timestamp Ordering Concurrency Control Flash Talk:Etienne Dilocker ( Weaviate) Readings:Chapter 18.5-18.6 Homework:Concurrency Control | SLIDES (Lecture #18) | NOTES (Lecture #18) | VIDEO (Lecture #18) |
| Nov 11 | Lecture #19: Multi-Version Concurrency Control Readings:Chapter 18.7-18.8 Project:Concurrency Control | SLIDES (Lecture #19) | NOTES (Lecture #19) | VIDEO (Lecture #19) |
| Nov 13 | Lecture #20: Database Logging Flash Talk:Mahesh Balakrishnan ( Confluent) Readings:Chapter 19.1-19.8 | SLIDES (Lecture #20) | NOTES (Lecture #20) | VIDEO (Lecture #20) |
| Nov 18 | Lecture #21: Database Recovery Readings:Chapter 19.1-19.9 | SLIDES (Lecture #21) | NOTES (Lecture #21) | VIDEO (Lecture #21) |
| Nov 20 | Lecture #22: Introduction to Distributed Databases Flash Talk:Jonathan Ellis ( DataStax) Readings:Chapter 20.4-20.5, 21, 23.1-23.4 | SLIDES (Lecture #22) | NOTES (Lecture #22) | VIDEO (Lecture #22) |
| Nov 25 | Lecture #23: Distributed OLTP Database Systems Readings:Chapter 20.4-20.5, 21, 23.1-23.4 | SLIDES (Lecture #23) | NOTES (Lecture #23) | VIDEO (Lecture #23) |
| Nov 27 | Thanksgiving — No Class Homework:Distributed Databases | |||
| Dec 02 | Lecture #24: Distributed OLAP Database Systems Readings:Chapter 20.7, 22.9 | SLIDES (Lecture #24) | NOTES (Lecture #24) | VIDEO (Lecture #24) |
| Dec 04 | Lecture #25: Final Review + Systems Potpourri | SLIDES (Lecture #25) | — | VIDEO (Lecture #25) |