Important Dates
- 08/27 Assignment 1 handed out
- 09/11 Assignment 1 due
- 09/08 Assignment 2 handed out
- 09/29 Assignment 2 due
- 09/29 Assignment 3 handed out
- 11/03 Assignment 3 due
- 11/03 Assignment 4 handed out
- 12/01 Assignment 4 due
- 12/10 Optional Assignment due
- 12/02 Contest is due
- 09/22 Quiz 1 handout
- 09/29 Quiz 1 due
- 11/17 Quiz 2 handout
- 11/26 Quiz 2 due
- 10/20 Mid Term Exam, 1:50pm-3:05pm, E1 Building 104
- 12/09 Final Exam, 10:30am - 12:30pm, Stuart Building 104
Schedule
The course schedule and linked slides will be updated over time. The slides are a modified version of the slides 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).
08/25 | 1. Introduction | slides or handout (6 slides per page) |
2. Hardware | slides or handout (6 slides per page) | |
08/27 | 3. Disk Organization | slides or handout (6 slides per page) |
09/01 | 4. Index Structures - Conventional Indexes and B-Trees | slides or handout (6 slides per page) |
09/03 | 4. Index Structures - Hashing | slides or handout (6 slides per page) |
09/08 | 4. Index Structures - Advanced Index Techniques | slides or handout (6 slides per page) |
09/10 | 5. Query Processing - Overview | slides or handout (6 slides per page) |
09/15 | 5. Query Processing - Parsing and Analysis | slides or handout (6 slides per page) |
09/17 | 5. Query Processing - Logical Optimization | slides or handout (6 slides per page) |
09/22 | 5. Query Processing - Query Execution | slides or handout (6 slides per page) |
09/24 | ||
09/29 | 5. Query Processing - Physical Optimization | slides or handout (6 slides per page) |
10/01 | ||
10/06 | ||
10/08 | ||
10/13 | ||
10/15 | 6. Recovery and Concurrency Control - Transaction Management | slides or handout (6 slides per page) |
10/20 | Mid Term Exam | Info |
10/22 | ||
10/27 | ||
10/29 | ||
11/03 | ||
11/05 | 6. Recovery and Concurrency Control - Failure and Recovery | slides or handout (6 slides per page) |
11/10 | ||
11/12 | ||
11/17 | 6. Recovery and Concurrency Control - Concurrency Control | slides or handout (6 slides per page) |
11/19 | ||
11/24 | ||
12/01 | ||
12/03 | Contest and QA Session | |
12/09 | Final Exam | Info |