Basic Info
 Lecture Notes
Due dates not yet finalized.

1 PostgreSQL Buffer Manager
answer for Part4

Part 1 W 2/1
Part 2 Tu 2/14
2 PostgreSQL Executor
Help Section [ppt], [pdf]
Tue 3/14
3 PostgreSQL Optimizer Assignment
Friday 3/24, 5pm

Application Development Project

Tue 4/25
5 DB Design and Transactions Assignment (Optional)
HW 5 Answers (.txt)
Fri 5/12
5% (if submitted)

This semester, we will be doing three types of projects.  First, we will be modifying the internals of the PostgreSQL database management system -- a full-function, open-source DBMS with most of the features we will study this semester.  The second set of assignments will involve building a web application over Postgres, using SQL and the PHP scripting langauge. Finally, there will be some small homework assignments.  PostgreSQL is written in C, and it is assumed that you are comfortable programming in C, debugging via gdb, and so on. Resources to help you with these issues can be found on the course resources page.

Late Policy on Homeworks. Each student gets an automatic extension of 4 calendar days. You can use the extension on any assignment(s) remaining during the semester (in increments that are rounded up to the nearest integer). For instance, you can hand in one assignment 4 days late, or each of four assignments 1 day late. For group project assignments, the slip time will be deducted from each team member's remaining slip time. When you hand in a late assignment, you must identify in the README file the following: (i) how late this assignment is, and (ii) how much of the total slip time you have left. No assignment will be accepted more then 4 days late. After you have used up your slip time, any assignment handed in late will be marked off 25% per day. There will be no extensions granted.