Schedule

No	Date	Topic	Slides	Video	PSets	Readings
		Chapter 0: Introduction
1	Jan 11	Course Introduction	[slides] \| [annotated slides]	[video]	[pset]	§ 1
2	Jan 13	Recap: Storage Management	[slides] \| [annotated slides]	[video]		§ 12, 13
3	Jan 18	Recap: Access Methods Assignment 1 Released	[slides] \| [annotated slides]	[video]		§ 14, 18
4	Jan 20	Recap: Query Execution	[slides] \| [annotated slides]	[video]		§ 15
		Chapter 1: Logging and Recovery Methods
5	Jan 25	Logging (Part 1)	[slides] \| [annotated slides]	[video]	[pset]	§ 17, 19
6	Jan 27	Logging (Part 2)	[slides] \| [annotated slides]	[video]	[pset]	"
7	Feb 01	Recovery (Part 1) Assignment 1 Due Assignment 2 Released	[slides] \| [annotated slides]	[video]	[pset]	"
8	Feb 03	Recovery (Part 2)	[slides] \| [annotated slides]	[video]	[pset]	"
9	Feb 08	ARIES from First Principles	[slides] \| [annotated slides]	[video]	[pset]	"
10	Feb 10	Case Studies	[slides] \| [annotated slides]	[video]	[pset]	"
11	Feb 15	Persistent Memory Databases	[slides] \| [annotated slides]	[video]	[pset]	"
	Feb 17	Write-Behind Logging		[video]		"
		Chapter 2: Concurrency Control
12	Feb 22	Concurrency Control	[slides] \| [annotated slides]	[video]	[pset]	§ 18
13	Feb 24	Two-Phase Locking	[slides] \| [annotated slides]	[video]	[pset]	"
14	Mar 01	Timestamp Ordering Assignment 2 Due Assignment 3 Released	[slides] \| [annotated slides]	[video]	[pset]	"
15	Mar 03	Optimistic Concurrency Control	[slides] \| [annotated slides]	[video]	[pset]	"
16	Mar 08	Multi-Version Concurrency Control	[slides] \| [annotated slides]	[video]	[pset]	"
17	Mar 10	Concurrency Control in MMDBs	[slides] \| [annotated slides]	[video]	[pset]	"
	Mar 15	Project Proposals
18	Mar 17	Case Studies	[slides] \| [annotated slides]	[video]	[pset]	"
		Chapter 3: Query Optimization
	Mar 22	Spring Break — No Class
	Mar 24	Spring Break — No Class
	Mar 29	Mid-term Exam
19	Mar 31	Rule-Based Query Optimization	[slides] \| [annotated slides]	[video]		§ 16
20	Apr 05	Cost-Based Query Optimization Assignment 3 Due Assignment 4 Released	[slides] \| [annotated slides]	[video]		"
21	Apr 07	Design Decisions + Search Strategies	[slides] \| [annotated slides]	[video]		"
	Apr 12	Project Checkpoint Presentations
22	Apr 14	Cascades Optimization Framework	[slides] \| [annotated slides]			"
23	Apr 19	Adaptive Query Optimization & Cost Models	[slides]			"
24	Apr 21	User-defined Functions and Course Retrospective Assignment 4 Due	[slides]			"
	Apr 26	Project Presentations
	Apr 28	Reading Period — No Class
	May 03	Final Exam

NOTE: The schedule is tentative and is subject to change as the semester progresses.

Credits

These slide decks are derived from courses developed by Thomas Neumann and Andy Pavlo.