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