The calendar below provides information on the course's lecture (L), quiz (Q) and project (P) sessions.
Course schedule.
| SES # |
TOPICS |
KEY DATES |
| 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 |
|
| L23 |
XML |
|
| P1 |
Final Project Presentation |
Final projects due |