|
|
|
The course schedule will be posted here.
| Week | Date | Topic | Lecture slides and reference |
| 1 | 01-07 | Introduction and overview |
Notes: pptx,
pdf
|
| 2 | 01-12 |
Data Models |
html
|
| 01-14 |
Introduction to data storage |
Notes: ppt,
pdf
|
| 3 | 01-21 | Index-based access |
Notes: ppt,
pdf
|
| 4 | 01-26 | Index-based access (contd.) |
Notes: ppt,
pdf
|
| 01-28 | Google Bigtable |
html
|
| 5 | 02-02 | Google Bigtable (contd.) |
html
|
| 02-04 |
Overview of query processing, Query rewrites |
Notes: ppt,
pdf
|
| 6 | 02-09 |
Midterm1
|
|
| 02-11 |
Pipelining (iterators) and Materialization, Costing |
Notes: ppt,
pdf
|
| 7 | 02-16 | Sort processing |
Notes: ppt,
pdf
|
| 02-18 |
Introduction to MapReduce
|
html
|
| 8 | 02-23 | Introduction to Spark |
Paper1,
Paper2,
Slides: pptx,
Slides: pdf
|
| 02-25 | Introduction to Join processing |
Notes 10: ppt,
pdf
|
| 9 | 03-02 | Sort-merge joins, Block and Index nested-loop joins, Hash joins |
Notes 10: ppt,
pdf
|
| 03-04 | Cost-based Query Optimization |
Notes 11: ppt,
pdf
|
| 10 | 03-16 | Cost-based Query Optimization |
Notes 11: ppt,
pdf
|
| 03-18 | Failure recovery, Logging, Checkpointing |
Notes 12: ppt,
pdf
|
| 11 | 03-23 |
Project demos
|
|
| 03-23 |
Concurrency control and Serializability
|
Notes 13: ppt,
pdf,
Exercises
|
| 03-25 |
Concurrency control, locking
|
Notes 14: ppt,
pdf
|
| 12 | 03-30 |
Midterm2 |
|
|