Schedule
Class Schedule
Subject to change
(u) undergrad only, (g) grad only
| Date | Topic | Tentative Work | Reading c1 = chapter 1 optional = (opt) |
|---|---|---|---|
| 1/4 | Introduction and Relational Model | HW0 assigned(u) | c1 |
| 1/9 | Relational Model, Intro DB Internals and Query Processing | Lab 1 assigned(u) / HW0 due (u) ColDB assigned (g) | c2, c6.1 |
| 1/11 | Relational Algebra and Intro to SQL | c3 (before class), c4 | |
| 1/16 | Schema/Database Design | HW 1 due | c7 |
| 1/18 | Data Layout and Access Methods | c10 c10.3-.4(opt) | |
| 1/23 | Indexes | Lab 1 due(u)/ HW 2 due / Lab 2 assigned(u) | ch11.1, 11.6-.7 |
| 1/25 | Indexes Continued | HW3 due | ch11 |
| 1/30 | Query Execution and Joins | ch12 | |
| 2/1 | Column-oriented databases | HW4 due \ ColDB Milestone 1(g) | C-Store |
| 2/6 | Midterm | ||
| 2/8 | Query Optimization | Lab 2 due(u) / Lab 3 assigned(u) | ch13 |
| 2/13 | Concurrency Control | ch14 | |
| 2/15 | Concurrency Control | HW5 due (skipping) | ch15 |
| 2/20 | Recovery | ch16 | |
| 2/22 | Distributed and Parallel DBs | Lab 3 due(u) / Lab 4 assigned(u) | ch17-18 |
| 2/27 | Distributed Txns, Replication, CAP | ch19.1-19.7 | |
| 3/1 | Eventual Consistency and Dynamo | HW6 due | Dynamo |
| 3/6 | BigTable and GFS | GFS, BigTable | |
| 3/8 | Reading Day | Lab 4 due on 3/7 11:59pm(u) | |
| 3/16 | Final: Thursday, March 15th, 1:30-3:30 pm | ColDB(g) due on 3/14 |