Subject to change

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

Monday Tuesday WednesdayThursdayFriday
1/7



1/8
Introduction and Relational Model
c1
HW0 assigned(u)
1/9



1/10
Relational Model, Intro DB Internals and Query Processing
c2, c6.1

1/11


Lab 1 assigned(u) / HW0 due (u)
ColDB assigned (g)
1/14



1/15
Relational Algebra and Intro to SQL
c3 (before class), c4

1/16


HW 1 due
1/17
Schema/Database Design
c7

1/18


HW 2 due
1/21



1/22
Data Layout and Access Methods
c10 c10.3-.4(opt)
Lab 1 due(u)/Lab 2 assigned(u)
1/23



1/24
Indexes
ch11.1, 11.6-.7

1/25


HW3 due
1/28



1/29
Indexes Continued
ch11

1/30



1/31
Query Execution and Joins
ch12

2/1


HW4 due
2/4


ColDB milestone1(g)
2/5
Column-oriented Databases
C-Store
Lab 2 due(u)
2/6



2/7
Midterm


2/8



2/11



2/12
Query Optimization
ch13
Lab 3 assigned(u)
2/13



2/14
Concurrency Control
ch14

2/15



2/18



2/19
Concurrency Control
ch15

2/20



2/21
Recovery
ch16
HW5 due
2/22



2/25



2/26
Distributed and Parallel DBs
ch17-18
Lab 3 due(u) /Lab 4 assigned(u)
2/27



2/28
Distributed Txns, Replication, CAP
ch19.1-19.7

3/1



3/4



3/5
Eventual Consistency and Dynamo
Dynamo

3/6



3/7
Log-Structured Storage
Log Structured Merge Tree
HW6 due
3/8



3/11



3/12
BigTable and GFS
GFS, BigTable
Lab 4 due(u)
3/13



3/14
Reading Day

ColDB(g) due
3/15



3/18



3/19
Final: Tues, March 19th, 1:30-3:30 pm


3/20



3/21



3/22