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)
Mar 07, 2017 Optimizer Implementation (Part II)
Assignment Released: Final Project
Mar 09, 2017 Cost Models
Assignment Due: Concurrent Index
Assignment Released: Extra Credit
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.