Schedule
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