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