| March 31 |
Introduction
|
| April 2 |
Review of relational model and SQL
|
| April 4 |
DBMS architecture
|
| April 7 |
Data storage and buffer management
|
| April 9 |
Indexing
|
| April 11 |
Indexing (no new lecture notes)
|
| April 14 |
Query execution and operator algorithms (part 1)
|
| April 16 |
Operator algorithms (part 2)
|
| April 18 |
Query plan cost estimation
|
| April 21 |
Query optimization
|
| April 23 |
Query optimization
|
| April 25 |
Query optimization
|
| April 28 |
Transactions: Concurrency control
|
| April 30 |
Transactions: Concurrency control
|
| May 2 |
Transactions: Concurrency control
|
| May 5 |
Transactions: Recovery
|
| May 7 |
Lecture
|
| May 9 |
Transactions: Recovery
|
| May 12 |
Parallel DBMSs
|
| May 14 |
Parallel DBMSs
|
| May 16 |
MapReduce
|
| May 19 |
Distributed query processing and optimization
|
| May 21 |
Distributed transactions
|
| May 23 |
Replication
|
| May 28 |
NoSQL: KeyValue Stores
|
| May 30 |
NoSQL: Record Stores (Big Table)
|
| June 2 |
NewSQL
|
| June 4 |
Provenance
|
| June 6 |
Cancelled
|