Schedule (subject to change)

3/28 : Introduction

3/30 : Relational Model and Design

4/4 : Schema/Database Design

4/6 : Basics of SQL

4/11 : Intro to Query Processing & DB Internals

4/13 : Advanced SQL & Join Algorithms

4/18 : Data Layout, Access Methods

4/20 : Buffer Pool Management & Indexes

4/25 : B-Trees

4/27 : Midterm

5/2 : Transactions and Concurrency Control

5/4 : Concurrency Control

5/9 : Recovery

5/11 : Distributed and Parallel Databases

5/16 : Distributed Transactions, Data Replication, and CAP

5/18 : Eventual Consistency and Dynamo

5/23 : Warehousing and Column-Oriented Databases

5/25 : GFS and BigTable

5/30 : MapReduce and Spark

6/1 : Impala, Hive, LSMs, and others

6/8 : Final Thurs, June 8th, 1:30pm, Ry 276