Schedule
Class Schedule
Subject to change
- 1/3 Introduction and Relational Model
- 1/5 Relational Model, Intro DB Internals and Query Processing (Lab 1 assigned)
- 1/10 Relational Algebra and Intro to SQL (Aaron out of town, Adam Dziedzic lecturing)
- 1/12 Data Layout and Access Methods
- 1/17 Schema/Database Design (HW 1 due)
- 1/19 Indexes (Lab 1 due / Lab 2 assigned)
- 1/24 Indexes Continued (HW 2 due)
- 1/26 Query Execution and Joins
- 1/31 Query Optimization (HW3 due)
- 2/2 Midterm
- 2/7 Concurrency Control (Lab 2 due / Lab 3 assigned)
- 2/9 Concurrency Control
- 2/14 Recovery (HW4 due)
- 2/16 Distributed and Parallel DBs, Distributed Queries
- 2/21 Distributed Txns, Replication, CAP (Lab 3 due / Lab 4 assigned)
- 2/23 Eventual Consistency and Dynamo
- 2/28 Column-oriented databases
- 3/2 BigTable and Impala
- 3/7 Main Memory DBMS (Lab 4 due)
- 3/9 Reading Day
- 3/16 Final: Thursday, March 16th, 1:30-3:30 pm