CS346 - Spring 2011
Database System Implementation

Schedule and Handouts
Links to more handouts may be added over time.

WeekDateEventHandouts
1 Mon. March 28 Class: Intro. to course, DBMS review, RedBase overview Lecture Notes
PF Component
RM Component
Wed. March 30 Class: File & buffer review, PF component, RM component Lecture Notes
2 Mon. April 4 Class: Query processing lecture #1 QP Page
Wed. April 6 Class: Query processing lecture #2
QP Page
Sun. April 10 Project Part 1 due
--
3 Mon. April 11 Class: Indexing review, B+-tree review, IX component
Lecture Notes
IX Component
Wed. April 13 Class: Query processing lecture #3
QP Page
4 Mon. April 18 Class: Query processing lecture #4 QP Page
Wed. April 20 Class: Query processing lecture #5 QP Page
Sun. April 24 Project Part 2 due
--
5 Mon. April 25 Class: Metadata review, SM component, EX component Lecture Notes
SM Component
EX Component
Wed. April 27 Quiz #1
--
Sun. May 1 Project Part 3 due
--
6 Mon. May 2 Class: QL component Lecture Notes
QL Component
Wed. May 4 Class: Query processing lecture #6
--
7 Mon. May 9 Class: Guest lecture
Guy Lohman -- IBM DB2
Talk slides
Wed. May 11 Project Part 5 Proposal due
Class: Guest lecture
Guy Lohman -- IBM DB2
Demo script
8 Mon. May 16 Class: Guest lecture
Hakan Jakobsson -- Oracle
Talk slides
Wed. May 18 Quiz #2
--
Sun. May 22 Project Part 4 due
--
9 Mon. May 23 Demo signups
Class: Guest lecture
Ravi Ramamurthy -- Microsoft SQL Server
Talk slides
Wed. May 25 Class: Guest lecture
Florian Wass -- EMC Greenplum
--
10 Mon. May 30 Memorial Day (no class)
--
Wed. June 1 Class: Summary and discussion of guest lectures,
Efficiency contest winners, RedBase discussion,
Demo hints
--
Thu.-Fri. June 2-3 Final project demonstrations, including Part 5
--