Schedule

Date Topic Slides Video
Jan 17, 2017 Course Introduction and History of Database Systems
Jan 19, 2017 In-Memory Databases
Assignment Released: EXTRACT Function
Jan 24, 2017 Concurrency Control Challenges
Jan 26, 2017 Optimistic Concurrency Control (OCC)
Jan 31, 2017 Multi-Version Concurrency Control (MVCC)
Assignment Due: EXTRACT Function
Assignment Released: Concurrent Index
Feb 02, 2017 Index Locking & Latching
Feb 07, 2017 Latch-free OLTP Indexes (Part I)
Feb 09, 2017 Latch-free OLTP Indexes (Part II)
Feb 14, 2017 OLAP Indexes
Feb 16, 2017 Storage Models & Data Layout
Feb 21, 2017 Database Compression
Feb 23, 2017 Logging Protocols
Feb 28, 2017 Checkpointing Protocols
Mar 02, 2017 Optimizer Implementation (Part I)
Assignment Due: Concurrent Index
Assignment Released: Final Project
Mar 07, 2017 Optimizer Implementation (Part II)
Assignment Released: Extra Credit
Mar 09, 2017 Cost Models
Mar 14, 2017 Spring Break — No Class
Mar 16, 2017 Spring Break — No Class
Mar 21, 2017 Student Project Proposals
Mar 23, 2017 Execution & Scheduling
Mar 28, 2017 Hash Joins
Mar 30, 2017 Sort-Merge Joins
Apr 04, 2017 Query Compilation
Apr 06, 2017 Vectorized Execution (Part I)
Apr 11, 2017 Vectorized Execution (Part II)
Apr 13, 2017 Student Project Meetings — No Class
Apr 18, 2017 Student Project Updates
Apr 20, 2017 Scan Sharing
Apr 25, 2017 Larger-than-Memory Databases
Apr 27, 2017 Non-Volatile Memory Database Systems
May 02, 2017 Final Review
Guest Speaker: Marcel Kornacker (Cloudera Impala)
May 04, 2017 Final Exam

Trigger Warning: The material presented in this lecture uses explicit language and discusses certain situations in database management systems that may be triggering to some students.