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