| March 28 |
Introduction (small , large)
|
| March 30 |
Review of relational model and SQL (small , large)
|
| April 1 |
DBMS architecture (small , large)
|
| April 4 |
Data storage and buffer management (small , large)
|
| April 6 |
Indexing (small , large)
|
| April 8 |
Indexing continued (no new lecture notes)
Query execution and operator algorithms (part 1) (small , large)
|
| April 11 |
Operator algorithms (part 2) (small , large, example)
|
| April 13 |
Query plan cost estimation (small , large)
|
| April 15 |
Query optimization (small , large)
|
| April 18 |
Query optimization (small , large)
|
| April 20 |
Query optimization (small , large) Guest lecturer: Brandon Haynes
|
| April 22 |
Transactions: Concurrency control (small , large)
|
| April 25 |
Transactions: Concurrency control (small , large)
|
| April 27 |
Transactions: Concurrency control (small , large)
|
| April 29 |
Transactions: Concurrency control continued
|
| May 2 |
Transactions: Recovery (small , large, example)
|
| May 4 |
Transactions: Recovery continued
|
| May 6 |
Transactions: Recovery continued
|
| May 9 |
Transactions: Recovery ended
|
| May 11 |
Parallel DBMSs (small , large)
|
| May 13 |
Parallel DBMSs continued
|
| May 16 |
MapReduce (small , large)
|
| May 18 |
Spark (small , large)
|
| May 20 |
Distributed transactions (small , large)
|
| May 23 |
Replication (small , large)
|
| May 27 |
NoSQL: KeyValue Stores (small , large)
|
| June 1 |
NewSQL: In-memory OLTP (small , large)
|
| June 3 |
WRAP-UP
|