Assignments

	Assignment	TA in charge	Out	Due	% of assignments grade
0	Getting started with PostgreSQL	Shashank	1/18	1/25	0%
1	The Entity-Relationship Model  [soln]	Tabreez	1/25	2/1	6%
2	SQL & Relational Algebra Solns: [ Algebra | SQL]	Shashank	2/1	2/8	6%
3	PostgreSQL buffer manager	Tabreez	2/8	2/20	10%
4	FIRST MAJOR PROJECT: Database application development	Shashank	2/20	3/10	30%
5	SECOND MAJOR PROJECT: Query processing in PostgreSQL	Tabreez	3/20	4/10	30%
6	Schema refinement  [soln]	Shashank	4/10	4/17	6%
7	Concurrency control  [soln]	Tabreez	4/17	4/24	6%
8	Crash recovery  [soln]	Shashank	4/24	5/1	6%

• Postgres documentation (and getting started guide)
  • PostgreSQL: Introduction and Concepts by Bruce Momjian
  • Documents on the Home Page of Bruce Momjian
• Postgres developer website
  • High-level tour
  • Internals with pictures
• PHP manual
• JDBC documentation
• DDD: Data Display Debugger
• Further reading on hybrid hashing and query execution algorithms:
  • Goetz Graefe, Query evaluation techniques for large databases, ACM Surveys, 25(2):73-170.
    Primary reference, section 2.2 in particular (p90 for hybrid hashing and partitioning).
  • Kjell Bratbergsengen, Hashing methods and relational algebra operators, Proc. VLDB 1984, pp 323-333.
  • Joseph M. Hellerstein and Jeffrey F. Naughton, Query execution techniques for caching expensive methods, Proc. SIGMOD 1996, pp 423-464.

Late policy

• The homework due date and time is the one posted on the web.
• To accommodate for coinciding deadlines you may have from other courses, or personal unforeseen events such as sickness, each student is granted an automatic extension of 4 calendar days. You can use the extension on any assignment(s) remaining during the semester. For instance, you can hand in one assignment 4 days late, or each of four assignments 1 day late. Slip time can only be used starting Homework 1.
• Late days count in increments that are rounded up to the nearest integer. For example, a submission that is 4 hours late will count as one day late.
• For group project assignments, the slip time will be deducted from each team member's remaining slip time. This means that in order to use a slip day, all team members must have at least one slip day unused.
• When you hand in a late assignment, you must identify at the top of the assignment, (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 or if you have spent your 4-day allowance.
• After you have used up your slip time, any assignment handed in late will be marked off 25% per day. No additional extensions will be granted.