Schedule

Date

Topics

Notes and Dues
08/27/2024

Lecture #1: Course Overview, Logistics, and Relational Model (Ch. 1-2)

Lab 0 Released
08/29/2024

Lecture #2: Interface - Modern SQL (Ch. 3-5)
09/03/2024

Lecture #3: Storage - Data Organization (Ch. 12.1-12.4, 13.2-13.3)
09/05/2024

Lecture #4: Storage - Buffer Manager (Ch. 13.2-13.5)
09/10/2024

Lecture #5: Storage - B+Tree Index (Ch. 14.1-14.4)

Lab 1 Released
09/12/2024

Lecture #6: Storage - Hash Table Index, LSM Trees (Ch. 14.5, 14.8, 24.5)
09/17/2024

Lecture #7: Storage - Index Concurrency Control (Ch. 18.10.2)

Lab 0 Due
09/19/2024

Lecture #8: Execution - Sorting/Aggregation (Ch. 15.4-15.5)
09/24/2024

Lecture #9: Execution - Join Algorithms (Ch. 15.4-15.6)
09/26/2024

Lecture #10: Execution - Execution Model (Ch. 15.7)

In-Class Quiz 1
10/01/2024

Lecture #11: Execution - Parallel Execution (Ch. 22.1, 22.2, 22.3.1, 22.4.1)
10/03/2024

Lecture #12: Query Optimizations 1 (Ch. 16.1-16.2)
10/08/2024

Lecture #13: Query Optimizations 2 (Ch. 16.3, 16.4.1-16.4.3)

Lab 1 Due; Lab 2 Released
10/10/2024

Midterm Review
10/15/2024

Midterm Exam
10/17/2024

Lecture #14: Execution - Transaction Theory (Ch. 17.1-17.8)
10/22/2024

Lecture #15: Execution - 2PL (Ch. 18.1.1-18.1.4, 18.2-18.4)
10/24/2024

Lecture #16: Execution - OCC/TO/MVCC (Ch. 18.5-18.7)
10/29/2024

Lecture #17: Logging and Recovery 1 (Ch. 19.1-19.4)

Lab 3 Released
10/31/2024

Lecture #18: Logging and Recovery 2 (Ch. 19.8, 19.9)

Lab 2 Due
11/05/2024

Lecture #19: Distributed Databases (Ch. 21.2 - 21.5, 23.4.1, 23.4.2)
11/07/2024

Lecture #20: Distributed Transactions (Ch. 23.1-23.3)
11/12/2024

Family Event / No Class
11/14/2024

Family Event / No Class
11/19/2024

Lecture #21: Analytical Databases (Ch. 11.2, 13.6)
11/21/2024

Lecture #22: Interface - User-Defined Functions

In-Class Quiz 2; Lab 3 Due
11/26/2024

Fall Break / No Class
11/28/2024

Fall Break / No Class
12/03/2024

Lecture #23: Distributed Analytical Databases
12/05/2024

Final Review