Duke DBGroup Logo

CPS 216: Advanced Database Systems
(Fall 2008, Shivnath Babu)

Course information
Course schedule and notes
Assignments
Readings
Project
 Homework 4 is available here. It is due on Tuesday Nov. 25, 2008 by 2.50 PM. The homework can be handed over in class or emailed in pdf format to the instructor.

Homework 3 is an open-ended homework that is based on how Flash Memory changes database design and implementation. It is due on Nov 11 and carries 10% of the final grade. This homework requires you to rethink all parts of database systems that we have seen in class---indexes, operators like selection and joins, logging and recovery, query optimization, etc.---and to see:

  1. What assumptions do their design and implementation make regarding the properties of hard disks?
  2. Should their design and implementation change if flash memory is used to store data?
  3. Your thoughts on how their design and implementation should change, if needed.
You are encouraged to read some of the papers cited from the "Case for SSDs ..." paper.

Homework 2 Part B is available here. It is due on Thursday Oct. 16, 2008 by 2.50 PM. The homework can be handed over in class or emailed in pdf format to the instructor. Sample solutions will be emailed when the homework is submitted.

Homework 2 Part A is available here. It is due on Thursday Oct. 9, 2008 by 2.50 PM. The solutions can be handed over in class or emailed in pdf format to the instructor.

Homework 1 is available here. It is due on Thursday Sept. 25, 2008 by 2.50 PM. The solutions can be handed over in class or emailed in pdf format to the instructor.