| Fundamentals |
| 1 |
Introduction |
| 2 |
The Relational Model and SQL |
| 3 |
Logical Design and Physical Database Fundamentals (PDF) |
| 4 |
Introduction to Modern Relational Database Systems (PDF) |
| Query Processing |
| 5 |
Optimization Fundamentals |
| 6 |
Join Algorithms and Memory Management (PDF) |
| 7 |
Indexing |
| 8 |
Distributed Databases |
| 9 |
Data Warehouses |
| 10 |
Extensibility and Object Databases |
| Transactions |
| 11 |
Introduction to Transactions |
| 12 |
Transactions Part 2 |
| 13 |
Locking and Consistency (PDF) |
| 14 |
Optimistic Concurrency Control |
|
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 |