| LEC # | TOPICS | KEY DATES |
|---|---|---|
| 1 | Introduction (CC) | |
| 2 | The relational model (MS) | Problem set 1 out |
| 3 | Schema design (MS) | |
| 4 | Introduction to database internals (CC) | Problem set 1 due Lab 1 out |
| 5 | Database operators and query processing (CC) | |
| 6 | Indexing and access methods (CC) | Problem set 2 out Project teams due |
| 7 | Buffer pool design and memory management (CC) | Lab 1 due Lab 2 out |
| 8 | Join algorithms (CC) | |
| 9 | Query optimization (CC) | |
| 10 | Transactions and locking (MS) | Problem set 2 due |
| 11 | Optimistic concurrency control (MS) | Project proposal due Lab 2 due |
| Exam 1 | ||
| 12 | Recovery (MS) | Lab 3 out |
| 13 | Recovery (MS) | |
| 14 | Degrees of consistency (MS) | Problem set 3 out |
| 15 | C-store Guest lecture: Sam Madden, MIT CSAIL | Lab 3 due |
| 16 | Distributed transactions (CC) | Lab 4 out (6.814) |
| 17 | Parallel databases (CC) | |
| 18 | Scientific databases (MS) | |
| 19 | NOSQL (CC) | |
| 20 | ORM, DryadLINQ (CC) | Lab 4 due (6.814) |
| 21 | Streaming databases (MS) | Problem set 3 due Lab 5 out (6.814) |
| Exam 2 | ||
| 22 | Database as a service (CC) | |
| 23 | Final project presentations | Final project due (6.830) Lab 5 due (6.814) |








