|
 |
 |
 |
 |
|
 |
|
 |
|
 |
| |||||||||||
| |||||||||||
| |||||||||||
| |||||||||||
|
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.
Lecture notes are available in PDF.
| Date | Day | Lecture (and what to read) | Notes | Comments | |
|---|---|---|---|---|---|
| 1/18 | Wed | Introduction (R&G Chapter 1) | PDF (2 slides/page) (6 slides/page) |
Asn. 0 out |
1/23 | Mon | The Entity-Relationship Model (R&G Chapter 2) | PDF (2 slides/page) (6 slides/page) |
| 1/25 | Wed | Relational Model (R&G Chapter 3) | PDF (2 slides/page) (6 slides/page) |
Asn. 0 due; Asn. 1 out |
|
| 1/30 | Mon | The Relational Algebra (R&G Chapter 4) | PDF (2 slides/page) (6 slides/page) |
||
| 2/1 | Wed | SQL: The Query Language Part 1 (R&G Chapter 5) | PDF (2 slides/page) (6 slides/page) |
Asn. 1 due; Asn. 2 out |
|
| 2/6 | Mon | Storing Data - Disks, Buffers, and Files (R&G Chapter 9) | PDF (2 slides/page) (6 slides/page) |
||
| 2/8 | Wed | File Organizations & Indexing (R&G Chapter 8) | PDF (2 slides/page) (6 slides/page) |
Asn. 2 due; Asn. 3 out |
|
| 2/13 | Mon | The Relational Calculus (R&G Chapter 4) | PDF (2 slides/page) (6 slides/page) |
Instructor: Prof. Christos Faloutsos | |
| 2/15 | Wed | Tree-Structured Indexes (R&G Chapter 10) | PDF (2 slides/page) (6 slides/page) |
||
| 2/20 | Mon | SQL: The Query Language Part 2 (R&G Chapter 5) | PDF (2 slides/page) (6 slides/page) |
Asn. 3 due; Asn. 4 out |
|
| 2/22 | Wed | SQL Application Development (R&G Chapter 6) | PDF (2 slides/page) (6 slides/page) |
||
| 2/27 | Mon | Midterm Review | Study guide | ||
| 3/1 | Wed | **** MIDTERM EXAM **** | Solutions for the Midterm. | ||
| 3/6 | Mon | Sorting (R&G Chapter 13) | PDF (2 slides/page) (6 slides/page) |
||
| 3/8 | Wed | Single-Table Query Processing (not in book) | PDF (2 slides/page) (6 slides/page) |
||
| 3/10 | Fri | **** MID-SEMESTER BREAK **** | Asn. 4 due! |
||
| 3/13 | Mon | **** SPRING BREAK -- NO CLASS **** | |||
| 3/15 | Wed | **** SPRING BREAK -- NO CLASS **** | |||
| 3/20 | Mon | Relational Operators (R&G Chapter 12/14) | PDF (2 slides/page) (6 slides/page) |
Asn. 5 out |
|
| 3/22 | Wed | Query Optimization (R&G Chapter 15) | PDF (2 slides/page) (6 slides/page) |
||
| 3/27 | Mon | Query Optimization (System R Optimizer) | PDF (2 slides/page) (6 slides/page) |
||
| 3/29 | Wed | Schema Refinement and Normalization (R&G Chapter 19) | PDF (2 slides/page) (6 slides/page) |
||
| 4/3 | Mon | Schema Refinement and Normalization (R&G Chapter 19) | PDF (2 slides/page) (6 slides/page) |
||
| 4/5 | Wed | Physical Database Design and Tuning (R&G Chapter 20) | Stratos Papadomanolakis will be teaching this class |
||
| 4/10 | Mon | Transaction Management Overview (R&G Chapter 16) | PDF (2 slides/page) (6 slides/page) |
Asn. 5 due; Asn. 6 out |
|
| 4/12 | Wed | Concurrency Control (R&G Chapter 17) | PDF (2 slides/page) (6 slides/page) |
||
| 4/17 | Mon | Concurrency Control (R&G Chapter 17) | PDF (2 slides/page) (6 slides/page) |
Asn. 6 due; Asn. 7 out |
|
| 4/19 | Wed | Concurrency Control (cont.) | PDF (2 slides/page) (6 slides/page) |
||
| 4/24 | Mon | Logging and Recovery (R&G Chapter 18) | PDF (2 slides/page) (6 slides/page) |
Asn. 7 due; Asn. 8 out |
|
| 4/26 | Wed | Logging and Recovery (R&G Chapter 18) | PDF (2 slides/page) (6 slides/page) |
||
| 5/1 | Mon | Review I | Asn. 8 due |
||
| 5/3 | Mon | Review II | |||
| 5/9 | Tue | **** FINAL EXAM **** 1:00pm-4:00pm | Study guide |