Class Schedule

Subject to changeā€¦

  • 09/29/2015 Introduction
  • 10/1/2015 Relational Model and Design
  • 10/6/2015 Schema/Database Design
  • 10/8/2015 Basics of SQL
  • 10/13/2015 Intro to Query Processing
  • 10/15/2015 Advanced SQL & Intro DB Internals
  • 10/20/2015 Data Layout, Indexes, Access Methods
  • 10/22/2015 Buffer Pool Management
  • 10/27/2015 Indexes
  • 10/29/2015 B+ Trees
  • 11/3/2015 Recovery / Quiz
  • 11/5/2015 Concurrency Control
  • 11/10/2015 Distributed and Parallel DBs, Distributed Queries
  • 11/12/2015 Distributed Txns, Replication, CAP
  • 11/17/2015 Eventual Consistency, Dynamo (paper: Replicated Data Consistency Explained Through Baseball)
  • 11/19/2015 BigTable and Impala (paper: A comparison of approaches to large-scale data analysis)
  • 11/24/2015 Warehousing (paper: Hive: a warehousing solution over a map-reduce framework)
  • 11/26/2015 No Class
  • 12/1/2015 Column-oriented databases (paper: OLTP Through the Looking Glass and What We Found There)
  • 12/3/2015 NewSQL or Other Topics? (paper: Resilient Distributed Datasets: A Fault-Tolerant Abstraction for In-Memory Cluster Computing)
  • 12/8/2015 Final