Lectures

Date	Slides
March 30	Introduction
April 1	Review of relational model and SQL
April 3	DBMS architecture
April 6	Data storage and buffer management
April 8	Indexing
April 10	Indexing cont.
April 13	Query execution and operator algorithms
April 15	Operator algorithms (part 2)
April 17	Operator algorithms (part 3)
April 20	Query plan costs
April 22	Query Optimization: Search Space
April 24	Query Optimization: Algorithms
April 27	Query Optimization: Algorithms
April 29	Transactions: Concurrency control
May 1	Transactions: Locking
May 4	Transactions: Optimistic Concurrency Control
May 6	Transactions: Optimistic Concurrency Control cont.
May 8	Transactions: Optimistic Concurrency Control cont.
May 11	Transactions: Recovery
May 13	Transactions: Recovery part 2
May 15	Transactions: Recovery part 3
May 18	Parallel DBMSs