|
 |
 |
 |
 |
|
 |
|
 |
|
 |
| |||||||||||
| |||||||||||
| |||||||||||
| |||||||||||
|
This schedule is subject to change so check it frequently. In particular, check for changes to due dates and guest lectures.
Coming to the lectures is crucial for you to understand the gist of the material, and as much as possible will be covered in class. The assigned readings, however, include the entire book chapters. You are expected to carefully read the assigned chapters and ask questions if there are points that need clarification.
During the lectures, I will be mostly using the blackboard; however, there will be lecture notes available in PDF (2up = 2 slides per page with space for notes; 6up = 6 per page; 6upc = 6up color). Many thanks to Joe Hellerstein and Mike Franklin for the beautifully updated book notes!
| Date | Lecture (and what to read) | Notes | Remarks |
|---|---|---|---|
| 1/13 | Introduction (R&G Chapter 1) | 2up, 6up, 6upc | |
| 1/15 | The Entity-Relationship Model (R&G Chapter 2) | 2up, 6up, 6upc | Homework 0 out |
| 1/17 | Recitation | WeH 5409, 3pm | |
| 1/22 | Relational Model (R&G Chapter 3) | 2up, 6up, 6upc | Homework 0 due at 1pm EST |
| 1/24 | Recitation (Postgres, C/GDB, Buffer Manager) | 2up, 6up | WeH 5409, 3:30pm |
| 1/27 | Storing Data - Disks, Buffers, and Files (R&G Chapter 9) | 2up, 6up, 6upc | Homework 1 out |
| 1/29 | File Organizations & Indexing (R&G Chapter 8) | 2up, 6up, 6upc | |
| 1/31 | Recitation | WeH 5409, 3pm | |
| 2/3 | Tree-Structured Indexes (R&G Chapter 10) | 2up, 6up, 6upc | |
| 2/5 | Sorting (R&G Chapter 13) | 2up, 6up, 6upc | |
| 2/7 | Recitation | WeH 5409, 3pm Homework 1 due |
|
| 2/10 | Unary Hashing (not in book) | 2up, 6up, 6upc | Homework 2 out |
| 2/12 | The Relational Algebra (R&G Chapter 4) | 2up, 6up, 6upc
Prof. Faloutsos's notes: 2up, 6up |
Guest lecture by Prof. Faloutsos |
| 2/14 | Recitation | WeH 5409, 3:30pm | |
| 2/17 | Class cancelled due to blizzard | ||
| 2/19 | The Relational Calculus (R&G Chapter 4) | 2up, 6up, 6upc | |
| 2/21 | Recitation | WeH 5409, 3:30pm | |
| 2/24 | SQL: The Query Language Part 1 (R&G Chapter 5) | Set 1: 2up, 6up Set 2: 2up, 6up |
Guest lecture by Prof. Faloutsos |
| 2/26 | SQL: The Query Language Part 2 (R&G Chapter 5) | 2up, 6up, 6upc | |
| 2/28 | Recitation | WeH 5409, 3:30pm | |
| 3/3 | Relational Operators (R&G Chapters 12/14) | 2up, 6up, 6upc | Homework 2 due at 8pm EST Homework 3 out |
| 3/4 | Recitation **Tuesday, due to the mid-semester break** | WeH 5409, 6:30pm | |
| 3/5 | MIDTERM | study guide | |
| 3/10 | SQL Application Development (R&G Chapter 6) | 2up, 6up, 6upc | Guest lecture by Prof. Faloutsos |
| 3/12 | Relational Operators and Query Optimization (R&G Chapters 14/15) | (included in notes from 3/3) | Homework 3 due Homework 4 out answer template (doc, pdf) |
| 3/14 | Recitation | WeH 5409, 3:30pm | |
| 3/17 | Query Optimization (R&G Chapter 15) | 2up, 6up, 6upc | |
| 3/19 | Query Optimization (R&G Chapter 15 PLUS System R Optimizer) | 2up, 6up, 6upc | |
| 3/21 | No Lecture | Homework 4 due Homework 5 out |
|
| 3/31 | Schema Refinement and Normalization (R&G Chapter 19) | 2up, 6up, 6upc | |
| 4/2 | Schema Refinement and Normalization (cont.) | 2up, 6up, 6upc | |
| 4/4 | Recitation (PHP Tour) | 2up, 6up, 6upc | WeH 5409, 3:30pm |
| 4/7 | Physical Database Design and Tuning (R&G Chapter 20) | 2up, 6up, 6upc | |
| 4/9 | Physical Database Design and Tuning (cont.) | (included in notes from 4/7) | |
| 4/10 | Recitation | WeH 5409, 6pm | |
| 4/14 | Transaction Management Overview (R&G Chapter 16) | 2up, 6up, 6upc | |
| 4/16 | Concurrency Control (R&G Chapter 17) | 2up, 6up, 6upc | Homework 5 due Homework 6 out |
| 4/18 | Recitation | WeH 5409, 3pm | |
| 4/21 | Concurrency Control (cont.) | (included in notes from 4/16) | |
| 4/23 | Concurrency Control (cont.) | (included in notes from 4/16) | Homework 6 due |
| 4/25 | Recitation | WeH 5409, 3:30pm | |
| 4/28 | Logging and Recovery (R&G Chapter 18) | 2up, 6up, 6upc, more notes | |
| 4/30 | Logging and Recovery (R&G Chapter 18) | (included in notes from 4/28) |