| Date | Title | Comments |
|---|
| Wed 9/12 | Intro and System R (The Roots: 1) | |
| Fri 9/14 | Q&A: Homework 1 | NSH 1305 |
| Mon 9/17 | System R (cont), and Evaluation (The Roots: 2) | |
| Wed 9/19 | Ingres (The Roots: 3,4) | |
| Mon 9/24 | Locking (Concurrency Control: 1) | Hwk 1 due, Hwk 2 out |
| Wed 9/26 | Optimistic CC (Concurrency Control: 2) | |
| Fri 9/28 | Q&A: Homework 2 | NSH 1305 |
| Mon 10/1 | CC on B-trees (Concurrency Control: 3) | |
| Wed 10/3 | ARIES (Logging and Recovery: 1,2) | |
| Mon 10/8 | Joins (Query Processing and Optimization: 1,2) | Hwk 2 due, Hwk 3 out |
| Wed 10/10 | System R Optimizer (Query Processing and Optimization: 3) | |
| Fri 10/12 | Q&A: Homework 3 | NSH 1305 |
| Mon 10/15 | System R Optimizer(cont.) (Query Processing and Optimization: 3) | |
| Wed 10/17 | MIDTERM | In-class exam |
| Mon 10/22 | No class | Mid-semester break |
| Wed 10/24 | DBMin (Buffer Management and OS: 1) | Hwk 3 due, Hwk 4 out |
| Fri 10/26 | Q&A: Homework 4 | NSH 1305 |
| Mon 10/29 | LRU-K (Buffer Management and OS: 2,3) | |
| Mon 10/31 | OS Support and R* ( Distributed Database Systems: 1) | |
| Wed 11/5 | Replication ( Distributed Database Systems: 2,3) | |
| Wed 11/7 | R-trees ( Spatial Applications: 1) | Hwk 4 due, Hwk 5 out
Lecture by Christos Faloutsos |
| Fri 11/9 | Q&A: Homework 5 | NSH 1305 |
| Mon 11/12 | Parallel DBMS (Parallel Database Systems: 1) | |
| Wed 11/14 | Gamma and Alphasort (Parallel Database Systems: 2 and Sorting: 1) | |
| Mon 11/19 | Mariposa ( Distributed Database Systems: 3) | |
| Wed 11/21 | No class | Thanksgiving |
| Mon 11/26 | Benchmarking (Benchmarking and Performance: Background from the benchmark handbook, 1) | Hwk 5 due, Hwk 6 out |
| Wed 11/28 | Characterization of DB workloads (Benchmarking and Performance: 3, skim 4 and 5) | |
| Fri 11/30 | Q&A: Homework 6 | WeH 7220 |
| Mon 12/3 | Cube operator ( Data Mining: 1) | Lecture by Christos Faloutsos |
| Wed 12/5 | Association rules ( Data Mining: 2) | Lecture by Leejay Wu |
| Mon 12/10 | Object-Oriented/Relational Database Systems (Object-Oriented and Object-Relational Database Systems: 1, skim 2 | Hwk 6 due |
