| SES # | TOPICS | KEY DATES |
|---|---|---|
| L1 | Introduction | |
| L2 | The Relational Model | Problem set 1 out |
| L3 | Schema Normalization | |
| L4 | Database Design | Problem set 1 due |
| L5 | Indexing and Access Methods | Project teams due Problem set 2 out |
| L6 | Buffer Pool Design and Memory Management | |
| L7 | Join Algorithms | |
| L8 | Query Optimization | |
| L9 | Introduction to Transaction Processing | Problem set 2 due Problem set 3 out |
| L10 | Recovery | Project proposals due |
| L11 | Optimistic Concurrency Control | |
| L12 | Recovery (cont.) | Problem set 3 due |
| L13 | Degrees of Locking | |
| Q1 | Exam 1 | |
| L14 | Distributed Databases - Guest Lecture | |
| L15 | Distributed Transactions | |
| L16 | Replication in Database Systems | |
| L17 | Search Engines | |
| L18 | Stream Processing | |
| L19 | Adaptive Query Processing - Guest Lecture | |
| L20 | Online Query Processing | |
| L21 | Sensor Networks | |
| L22 | XML and Semantic Web | |
| Q2 | Exam 2 | |
| L23 | XML | |
| P1 | Final Project Presentation | Final projects due |