| No | Date | Topic | Slides | Video | PSets | Code | Readings |
|---|---|---|---|---|---|---|---|
| Chapter 0: Introduction | |||||||
| 1 | Aug 23 | Course Introduction | [slides] | [annotated slides] | [video] | [pset] | § 1 | |
| 2 | Aug 25 | Relational Model | [slides] | [annotated slides] | [video] | [pset] | § 2 | |
| 3 | Aug 30 | Advanced SQL
Assignment 1 Released
|
[slides] | [annotated slides] | [video] | [pset] | § 3, 4 | |
| Chapter 1: Storage Management | |||||||
| 4 | Sep 01 | Disk Space Management | [slides] | [annotated slides] | [video] | [pset] | § 12, 13 | |
| Sep 06 | Labor Day — No Class | ||||||
| 5 | Sep 08 | Memory Management | [slides] | [annotated slides] | [video] | [pset] | " | |
| 6 | Sep 13 | Data Representation
Assignment 1 Due
Assignment 2 Released
|
[slides] | [annotated slides] | [video] | [pset] | " | |
| 7 | Sep 15 | Buffer Management (Part 1) | [slides] | [annotated slides] | [video] | [pset] | " | |
| 8 | Sep 20 | Buffer Management (Part 2) | [slides] | [annotated slides] | [video] | [pset] | " | |
| 9 | Sep 22 | Compression | [slides] | [annotated slides] | [video] | [pset] | " | |
| 10 | Sep 27 | Larger-than-Memory Databases | [slides] | [annotated slides] | [video] | [pset] | " | |
| Sep 29 | Project Proposal | ||||||
| 11 | Oct 04 | Persistent Memory Databases | [slides] | [annotated slides] | [video] | [pset] | " | |
| Chapter 2: Access Methods | |||||||
| 12 | Oct 06 | Access Methods
Assignment 2 Due
Assignment 3 Released
|
[slides] | [annotated slides] | [video] | [pset] | § 14, 18 | |
| Oct 11 | Fall Break — No Class | ||||||
| 13 | Oct 13 | Hash Tables | [slides] | [annotated slides] | [video] | [pset] | " | |
| Oct 18 | Exam 1 | ||||||
| 14 | Oct 20 | Trees (Part 1) | [slides] | [annotated slides] | [video] | [pset] | " | |
| 15 | Oct 25 | Trees (Part 2) | [slides] | [annotated slides] | [video] | [pset] | " | |
| 16 | Oct 27 | Index Concurrency Control | [slides] | [annotated slides] | [video] | [pset] | " | |
| Nov 01 | Project Updates (Part 1) | ||||||
| Nov 03 | Project Updates (Part 2) | ||||||
| 17 | Nov 08 | Modern OLTP Indexes (Part 1)
Assignment 3 Due
Assignment 4 Released
|
[slides] | [annotated slides] | [video] | [pset] | " | |
| Chapter 3: Query Execution | |||||||
| 18 | Nov 10 | Sorting and Aggregation | [slides] | [annotated slides] | [video] | [pset] | § 15 | |
| 19 | Nov 15 | Joins | [slides] | [annotated slides] | [video] | [pset] | " | |
| Nov 17 | Guest Lecture: AWS Redshift Tech Talk | Sanuj Basu | ||||||
| Nov 22 | Exam 2 | ||||||
| Nov 24 | Student Recess — No Class | ||||||
| 20 | Nov 29 | Query Execution + Conclusion
Assignment 4 Due
|
[slides] | [annotated slides] | [video] | [pset] | " | |
| Dec 01 | Final Project Presentations (Part 1) | [video] | |||||
| Dec 06 | Final Project Presentations (Part 2) | [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.