Subject to change

(u) undergrad only, (g) grad only
Topic
Reading
Assignment

Monday Tuesday WednesdayThursdayFriday
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