Schedule
Schedule (subject to change)
| Date | Topic | Tentative Work | Reading db.X = DB Concepts Chp X di.Y = Prin. of Data Integration Chapter Y optional = (opt) |
|---|---|---|---|
| 3/27 | Introduction | db1 | |
| 3/29 | Relational Model and Design | db2, db6.1 | |
| 4/3 | Intermediate SQL | db3, db4 | |
| 4/5 | Schema/Database Design | db7-7.8, db8(opt) | |
| 4/10 | Intro to Query Processing & DB Internals | hw1 due (4/8) | db1.9,12.1 |
| 4/12 | Data Layout, Access Methods, Buffer Pool, Indexes | hw2 due | db10.1,10.5-10.8 |
| 4/17 | Indexes | db11-11.6 | |
| 4/19 | Warehousing and Column-Oriented Databases | db20.1-20.2, c-store paper, di10(opt) | |
| 4/24 | Join Algorithms & Sorting | db12.4-12.5 | |
| 4/26 | Midterm | ||
| 5/1 | Join Algorithms & Sorting | db14,15.1 | |
| 5/3 | Transactions | db14,15.1 | |
| 5/8 | Recovery | db16.1-16.4,16.8 | |
| 5/10 | Distributed and Parallel Databases, Replication | db17.3-17.4,18-18.6 | |
| 5/15 | CAP, Eventual Consistency and Dynamo | Dynamo Paper | |
| 5/17 | GFS, BigTable, and MapReduce | BigTable and GFS papers | |
| 5/22 | |||
| 5/24 | |||
| 5/29 | |||
| 5/31 | Second Exam (In Class) | ||
| 6/7 | Final HW due |