Lecture Schedule and Slides
Monday + Wednesday, 3:15 pm - 4:30 pm, SB 104
The course schedule and linked slides will be updated over time. The slides are a modified version of the <a href="">slides</a> used by Hector Garcia-Molina for the CS 245 course at Stanford.
For convenience, here is a combined versions of all slides and all handouts (6 slides per page).
Lectures and Slides
| 01/09 | 01. Introduction | slides or handout (6 slides per page) |
| 01/11 | 02. Hardware | slides or handout (6 slides per page) |
| 01/18 | 03. Disk Organization | slides or handout (6 slides per page) |
| 01/23 | 04. Index Structures - Conventional Indexes and B-Trees | slides or handout (6 slides per page) |
| 01/25 | 05. Index Structures - Hashing | slides or handout (6 slides per page) |
| 01/30 | 06. Index Structures - Advanced Index Techniques | slides or handout (6 slides per page) |
| 02/01 | 07. Query Processing - Overview | slides or handout (6 slides per page) |
| 02/06 | 08. Query Processing - Parsing and Analysis | slides or handout (6 slides per page) |
| 02/08 | 09. Query Processing - Logical Optimization | slides or handout (6 slides per page) |
| 02/13 | 10. Query Processing - Query Execution | slides or handout (6 slides per page) |
| 02/15 | ||
| 02/20 | ||
| 02/22 | 11. Query Processing - Physical Optimization | slides or handout (6 slides per page) |
| 02/27 | ||
| 03/01 | ||
| 03/06 | ||
| 03/08 | 12. Recovery and Concurrency Control - Transaction Management | slides or handout (6 slides per page) |
| 03/20 | ||
| 03/22 | ||
| 03/27 | ||
| 03/29 | ||
| 04/03 | 13. Recovery and Concurrency Control - Failure and Recovery | slides or handout (6 slides per page) |
| 04/05 | ||
| 04/10 | ||
| 04/12 | 14. Recovery and Concurrency Control - Concurrency Control | slides or handout (6 slides per page) |
| 04/17 | ||
| 04/19 | 15. Contest and QA Session |