Database System Implementation
|
|
I use the slides provided to prepare my blackboard lectures. There is no 1-1 mapping from slides to the crazy things I say in class.
| Week | Date | Event | Handouts |
|---|---|---|---|
| 1 | Mon. March 31 | Class: Intro. to course, DBMS review, RedBase overview | Lecture Notes PF Component RM Component |
| Wed. April 2 | Class: File & buffer review, PF component, RM component | Lecture Notes Slides (pdf) | |
| 2 | Mon. April 7 | Class: Buffer Management | QP Page Slides (pdf) |
| Wed. April 9 | Class: Page Layout and File of Records | QP Page | |
| Sun. April 13 | Project Part 1 due | | |
| 3 | Mon. April 14 | Class: Indexing review, B+-tree review, IX component | Lecture Notes
IX Component Slides (pdf and paper) |
| Wed. April 16 | Class: Query processing lecture #1 | QP Page | |
| 4 | Mon. April 21 | Class: Query processing lecture #2 | QP Page
Cost Models |
| Wed. April 23 | Class: Query processing lecture #3 | QP Page | |
| Sun. April 27 | Project Part 2 due | | |
| 5 | Mon. April 28 | Class: Quiz Review and External Sorting | Notes in PDF |
| Wed. April 30 | Quiz #1 | | |
| 6 | Mon. May 5 | Class: Recovery (ARIES)
Metadata review, SM component, EX component. | Lecture Notes
SM Component EX Component |
| Wed. May 7 | Class: Query Languages (SQL and Datalog)
QL component | Lecture Notes QL Component | |
| Sun. May 11 | Project Part 3 due | | |
| 7 | Mon. May 12 | Class: Guest lecture: Dan Olteanu, LogicBlox | |
| Wed. May 14 | Project Part 5 Proposal due Class: Guest lecture: Michalis Petropoulos, Pivotal | | |
| 8 | Mon. May 19 | (CANCELED) Class: Guest lecture Marcel Kornacker, Cloudera (Impala) | |
| Wed. May 21 | Class: Guest lecture Vijayshankar Raman, IBM | | |
| Sun. May 25 | Project Part 4 due | | |
| 9 | Mon. May 26 | No Class, Memorial Day | |
| Wed. May 28 | Demo signups Class: Guest lecture: Eric Sedlar, Oracle Labs (SIGMOD keynote preview!) | | |
| 10 | Mon. June 2 | Class: Guest Lecture: Pauli Gandhi, SAP. HANA Streaming. | |
| Wed. June 4 | Class: Summary and discussion of guest lectures, Efficiency contest winners, RedBase discussion, Demo hints | | |
| Fri. June 6 | Final project demonstrations, including Part 5 | |