|
|
|
|
| Week | Date | Event | Handouts |
|---|---|---|---|
| 1 | Wed. April 4 | Class: Intro. to course, DBMS review, RedBase overview | Lecture Notes 4/4 PF Component RM Component |
| 2 | Mon. April 9 | Class: File & buffer review, PF component, RM component | Lecture Notes 4/9 |
| Wed. April 11 | Class: Query processing lecture #1 | QP Page | |
| Thu. April 12 | Help session for Project Part 1 (7:00 PM, Gates 260) | | |
| Sun. April 15 | Project Part 1 due | | |
| 3 | Mon. April 16 | Class: Indexing review, B+-tree review, IX component | Lecture Notes 4/16
IX Component |
| Wed. April 18 | Class: Query processing lecture #2 | QP Page | |
| 4 | Mon. April 23 | Class: Query processing lecture #3 Help session for Project Part 2 (7:00 PM, Gates 104) | QP Page |
| Wed. April 25 | Class: Query processing lecture #4 | QP Page | |
| Sun. April 29 | Project Part 2 due | | |
| 5 | Mon. April 30 | Class: Metadata review, SM component | Lecture Notes 4/30
SM Component |
| Wed. May 2 | Class: Query processing lecture #5 | QP Page | |
| Thu. May 3 | Help session for Project Part 3 (7:00 PM, Gates 104) | | |
| Sun. May 6 | Project Part 3 due | | |
| 6 | Mon. May 7 | Class: QL component, EX component | Lecture Notes 5/7
QL Component EX Component |
| Wed. May 9 | Quiz #1 | | |
| Thu. May 10 | First help session for Project Part 4 (7:00 PM, Gates 104) | | |
| 7 | Mon. May 14 | Class: Guest lecture Hakan Jakobsson -- Oracle | Talk slides |
| Wed. May 16 | Class: Guest lecture Guy Lohman -- IBM DB2 (part 1: talk) | Talk slides | |
| 8 | Mon. May 21 | Project Part 5 proposal due Class: Guest lecture Guy Lohman -- IBM DB2 (part 2: demo) | Demo script |
| Wed. May 23 | Class: Guest lecture Vivek Narasayya -- Microsoft SQL Server | Talk slides | |
| Thu. May 24 | Second help session for Project Part 4 (7:00 PM, Gates 104) | | |
| Sun. May 27 | Project Part 4 due | | |
| 9 | Mon. May 28 | Holiday | |
| Wed. May 30 | Demo signups Class: Summary and discussion of guest lectures | Lecture Notes 5/30 | |
| 10 | Mon. June 4 | Quiz #2 | |
| Wed. June 6 | Class: Efficiency contest winners, RedBase discussion, Demo hints | | |
| Fri. June 8 | Optional early final project demonstrations | | |
| 11 | Mon. June 11 | Final project demonstrations, including Part 5 | |