Week
|
Description |
Material |
| 2 |
Introduction to the Minibase System
|
 |
| 3
|
Exercises: Storage and Indexing Overview Official Announcement of Topics for the Semester Presentation
|
|
| 4
|
Exercises: Tree-based Indexing (B+ Tree Delete Algorithm)
|
|
5
|
Indroduction to Postgress Indexes |
|
| 6
|
Exercises: External Sorting & Evaluation of Relational Operators (Projections) |
|
| 7
|
Exercises: Evaluation of Relational Operators (Joins)
|
|
| 8
|
Explanation of AS2/3 & Exercises: Query Optimization Problems |
|
9
|
Setting up SSH public/private keys & Exercises: Characterizing Schedules on Serializability and Recoverability
|
|
|
10
|
Introduction to Postgress transactions
|
|
11
|
Exercises: Concurrency Control with Locking
|
|
| 12
|
Exercises: Concurrency Control with Timestamps |
|
13
|
Exercises: Database Recovery Techniques |
|
