| Fundamentals |
| 1 |
Introduction |
Problem set 1 out |
| 2 |
The Relational Model and SQL |
|
| 3 |
Logical Design and Physical Database Fundamentals |
Problem set 1 due |
| 4 |
Introduction to Modern Relational Database Systems |
Problem set 2 out |
| Query Processing |
| 5 |
Optimization Fundamentals |
|
| 6 |
Join Algorithms and Memory Management |
|
| 7 |
Indexing |
|
| 8 |
Distributed Databases |
Problem set 2 due |
| 9 |
Data Warehouses |
Project proposals due |
| 10 |
Extensibility and Object Databases |
Problem set 3 out |
| Transactions |
| 11 |
Introduction to Transactions |
|
| 12 |
Transactions Part 2 |
|
| 13 |
Locking and Consistency |
|
| 14 |
Optimistic Concurrency Control |
Problem set 3 due |
|
Exam 1 |
|
| 15 |
Distributed Transactions and Replication |
|
| Networked Data Management |
| 16 |
Web Services |
|
| 17 |
Semistructured Data |
|
| 18 |
Continuous Queries |
|
| 19 |
Adaptive Query Processing |
|
| 20 |
Stream Databases |
|
| Advanced Topics |
| 21 |
Data Mining and Sequence Queries |
|
| 22 |
Approximate Querying |
|
|
Exam 2 |
|
| 23 |
Consistency and Availability in Data Streams |
|
| 24 |
Last day of Class Presentations |
Project Reports due |