Schedule
Subject to change
(u) undergrad only, (g) grad only
Topic
Reading
Assignment
Monday | Tuesday | Wednesday | Thursday | Friday |
1/6 |
1/7 Introduction and Relational Model c1 (6/7th) HW0 assigned(u) Projects Published (g) |
1/8 Projects Proposal (g) |
1/9 Relational Model, Intro to DB Internals and Query Processing c2, c6.1 (6th) c2 (7th) |
1/10 Lab 1 assigned(u) / HW0 due (u) HW1 assigned (u) Projects Assigned (g) |
1/13 |
1/14 SQL c3 (before class), c4 (6/7th) |
1/15 |
1/16 Schema/Database Design c7 (6th) c6 (7th) HW 1 due |
1/17 |
1/20 |
1/21 Data Layout, Access Methods, and Nested Loop Joins c10 c10.3-.4(opt) (6th) c12, c13 (7th) Lab 1 due(u)/Lab 2 assigned(u) |
1/22 |
1/23 Indexes c11 (6th) c14 (7th) HW 2 due |
1/24 Projects Meeting 1 (g) |
1/27 |
1/28 Indexes Continued c11 (6th) c14 (7th) |
1/29 |
1/30 Log-Structured Merge Trees and Buffer Pools c10.8 (6th) c13.1-5, c24.1-2 (7th) HW3 due |
1/31 |
2/3 |
2/4 Query Execution and Joins c12 (6th) c15 (7th) Lab 2 due(u) |
2/5 |
2/6 Midterm HW4 due |
2/7 Projects Meeting 2 (g) |
2/10 |
2/11 Query Optimization c13 (6th) c16 (7th) Lab 3 assigned(u) |
2/12 |
2/13 Transactions c14 (6th) c17 (7th) |
2/14 |
2/17 |
2/18 Concurrency Control c15 (6th) c18 (7th) |
2/19 |
2/20 Recovery c16 (6th) c19 (7th) HW5 due |
2/21 Projects Meeting 3 (g) |
2/24 |
2/25 Distributed and Parallel DBs c17-18 (6th) c20.1-5, c21, c22 (7th) Lab 3 due(u) /Lab 4 assigned(u) |
2/26 |
2/27 Distributed Txns, Replication, CAP c19.1-19.7 (6th) c20.6, c23 (7th) |
2/28 |
3/2 |
3/3 Eventual Consistency and Dynamo |
3/4 |
3/5 Columnar and Main-Memory Databases c13.6-7 (7th) HW6 due |
3/6 Projects Meeting 4 (g) |
3/9 |
3/10 Streaming Lab 4 due(u) |
3/11 |
3/12 Reading Day |
3/13 Final Project Meeting (g) |
3/16 |
3/17 |
3/18 |
3/19 |
3/20 |