Subject to change

Topic
Reading
db.X = DB Concepts Chp X
di.Y = Prin. of Data Integration Chapter Y
optional = (opt)
Assignment Due

Monday Tuesday WednesdayThursdayFriday
4/1



4/2
Introduction
db1

4/3



4/4
Relational Model and Design
db2, db6.1
hw0
4/5



4/8



4/9
Intermediate SQL
db3(before), db4

4/10


hw1(ra)
4/11
Schema/Database Design
db7-7.8, db8(opt)

4/12



4/15



4/16
Intro to Query Processing & DB Internals
db1.9,12.1
hw2(sql)
4/17



4/18
Data Layout, Access Methods, Buffer Pool, Indexes
db10.1,10.5-10.8
hw3(erd)
4/19



4/22



4/23
Indexes
db11-11.6

4/24



4/25
Indexes Continued
db12.4-12.5
hw4(sql)
4/26



4/29



4/30
Join Algorithms & Sorting


5/1



5/2
Transactions
db14,15.1

5/3


hw5(costs)
5/6



5/7
Warehousing and Columnar Databases
db20.1-20.2, c-store paper, di10(opt)

5/8



5/9
First Exam


5/10



5/13



5/14
Intro to Data Integration, String Matching
di1,di3

5/15



5/16
String and Record Matching
di4

5/17


hw6(py)
5/20



5/21
Record Matching
di7

5/22



5/23
Schema Matching
di5

5/24


hw7-1(di)
5/27



5/28
Distributed and Parallel Databases, Replication
db17.3-17.4,18-18.6

5/29



5/30
CAP, Eventual Consistency and Dynamo
Dynamo Paper

5/31



6/3



6/4
GFS, BigTable, and MapReduce
BigTable and GFS papers
hw7-2(di)
6/5



6/6
Second Exam (In Class)


6/7



6/10



6/11



6/12



6/13


hw8
6/14