Basic Info
 Lecture Notes

This page is tentative and may change in the first weeks of class! Last updated 11/22/06

 0 Getting Started with Postgres
9/4/06 0%
 1 PostgreSQL B+-trees UPDATED 9/28/2006  
10/3 20%
 2 PostgreSQL Executor 10/31
3 SQL assignment
4 Normalization Assignment
5 Concurrency Control Homework
11/27 (EXTENDED)
6 DB Application project
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. Homework zero has a simple policy: it must be turned in on time.
Starting with HW 1, 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.