Lecture Notes
The table below provides overviews of each lecture.
| LEC # | TOPICS |
|---|---|
| 1 | Introduction |
| 2 | The Relational Model |
| 3 | Schema Normalization |
| 4 | Database Design |
| 5 | Indexing and Access Methods |
| 6 | Buffer Pool Design and Memory Management |
| 7 | Join Algorithms |
| 8 | Query Optimization |
| 9 | Introduction to Transaction Processing |
| 10 | Recovery |
| 11 | Optimistic Concurrency Control |
| 12 | Recovery (cont.) |
| 13 | Degrees of Locking |
| 14 | Distributed Databases - Guest Lecture |
| 15 | Distributed Transactions |
| 16 | Replication in Database Systems |
| 17 | Search Engines |
| 18 | Stream Processing |
| 19 | Adaptive Query Processing - Guest Lecture |
| 20 | Online Query Processing |
| 21 | Sensor Networks |
| 22 | XML and Semantic Web |
| 23 | XML |
