Calendar

Week	Date	Type	Description
1	Mon, Mar 30	Lecture	Introduction
	Wed, Apr 1	Lecture	Review of relational model and SQL
	Thu, Apr 2	Section	SimpleDB Overview
	Fri, Apr 3	Lecture	DBMS architecture
2	Mon, Apr 6	Lecture	Data storage and buffer management
	Mon, Apr 6	Assignment	Lab1 - SimpleDB BufferPool (part 1)
	Wed, Apr 8	Lecture	Indexing
	Thu, Apr 9	Section	Lab 1 Part 2 details and extra office hours
	Fri, Apr 10	Lecture	Indexing continued
	Fri, Apr 10	Assignment	HW1 - RA, HeapFiles, Buffer Manager
3	Mon, Apr 13	Lecture	Query execution and operator algorithms
	Wed, Apr 15	Lecture	Operator algorithms (part 2)
	Wed, Apr 15	Assignment	Lab1 - SimpleDB BufferPool (part 2)
	Thu, Apr 16	Section	Indexing
	Fri, Apr 18	Lecture	Operator algorithms (part 3)
4	Mon, Apr 20	Lecture	Query plan costs
	Wed, Apr 22	Lecture	Query Optimization: Search Space
	Thu, Apr 23	Section
	Fri, Apr 24	Lecture	Query Optimization: Algorithms
5	Mon, Apr 27	Lecture	Query Optimization: Algorithms
	Wed, Apr 29	Lecture	Transactions: Concurrency control
	Thu, Apr 30	Section	Query Optimization
	Fri, May 1	Lecture	Transactions: Locking
6	Mon, May 4	Lecture	Transactions: Optimistic Concurrency Control
	Wed, May 6	Lecture	Transactions: Optimistic Concurrency Control cont.
	Wed, May 6	Assignment	HW3 - Query Optimization
	Thu, May 7	Section	Transactions: Concurrency Control
	Fri, May 8	Lecture	Transactions: Optimistic Concurrency Control cont.
	Fri, May 8	Assignment	Lab3 - SimpleDB Transactions (part 1)
7	Mon, May 11	Lecture	Transactions: Recovery
	Wed, May 13	Lecture	Transactions: Recovery part 2
	Wed, May 13	Assignment	Lab3 - SimpleDB Transactions (part 2)
	Thu, May 14	Section	Transactions: Optimisitc Concurrency Control
	Fri, May 15	Lecture	Transactions: Recovery part 3
8	Mon, May 18	Lecture	Parallel DBMSs
	Wed, May 20	Lecture	HW4 - Transactions: Concurrency Control
	Thu, May 21	Section
	Fri, May 22	Lecture
9	Mon, May 25	Lecture
	Wed, May 27	Lecture
	Thu, May 28	Section
	Fri, May 29	Lecture	Lab4 - SimpleDB Recovery)