The calendar below provides information on the course's lecture (L), quiz (Q) and project (P) sessions.

L1 Introduction
L2 The Relational Model Problem set 1 out
L3 Schema Normalization
L4 Database Design Problem set 1 due
L5 Indexing and Access Methods Project teams due

Problem set 2 out
L6 Buffer Pool Design and Memory Management
L7 Join Algorithms
L8 Query Optimization
L9 Introduction to Transaction Processing Problem set 2 due

Problem set 3 out
L10 Recovery Project proposals due
L11 Optimistic Concurrency Control
L12 Recovery (cont.) Problem set 3 due
L13 Degrees of Locking
Q1 Exam 1
L14 Distributed Databases - Guest Lecture
L15 Distributed Transactions
L16 Replication in Database Systems
L17 Search Engines
L18 Stream Processing
L19 Adaptive Query Processing - Guest Lecture
L20 Online Query Processing
L21 Sensor Networks
L22 XML and Semantic Web
Q2 Exam 2
P1 Final Project Presentation Final projects due