Lectures
Below are readings and lecture notes for each topic in the course.
Lecture notes will be posted below as they become available. Often this will be after the lecture.
A lot happens in lecture that will not be represented in these slides, and you should augment them with your own personal notes. Experience shows that students who take and study from their own notes consistently do better on tests than those who simply study from supplied notes. If you miss class, it would be a good idea to get notes from someone who was there.
By Week
Here is the tentative schedule of topics for each week of the course. Some topics may shift around depending on how we progress.
| Week | Topics | Readings (Ramakrishnan & Johannes) | Tutorilas |
|---|---|---|---|
| 1 and 2 | Introduction, Storage and Indexing | Chapter 1, Chapter 8-10 | No Tutorial this week |
| 3 | Hash Indexing & External sorting | Chapter 11 & 13 | Memory Hierarchy & data layout |
| 4 | Query Evaluation(part 1) | Chapter 12 | Basic Indexing |
| 5 | Query Evaluation(part 2) | Chapter 14 | Problem Solving |
| 6 | Query Optimization | Chapter 15 | A2 clarification |
| 8 | Concurrency Control | Chapter 17 | A2 Q/A |
| 9 | Crash Recovery | Chapter 18 | Problem Solving |