Duke DBGroup Logo

CPS 216: Advanced Database Systems
(Data-Intensive Computing Systems, Fall 2009)

Course information
Course schedule and notes
Assignments
Readings
Project

Two exercises are available here and here. These exercises are practice problems for Failure Recovery and Concurrency Control.

The third assignment is available here. Due date and time: Tuesday, Nov. 17, by 2.50 PM (class time). Submission format: In class, or email solution in pdf or plain text to shivnath@cs. You can also drop off written solutions at Shivnath's office: D338 LSRC.

The second assignment is available here. Due date and time: Tuesday, Oct. 13, by 2.50 PM (class time). Submission format: In class, or email solution in pdf or plain text to shivnath@cs. You can also drop off written solutions at Shivnath's office: D338 LSRC.

The first assignment is available here. Due date and time: Friday, Sept. 18, by 5.00 PM. Submission format: In class, or email solution in pdf or plain text to shivnath@cs. You can also drop off written solutions at Shivnath's office: D338 LSRC.

Homework 1 has a programming component that needs to be done on the Hadoop cluster. You have to implement a MapReduce program to compute the average temperature per year over the NCDC data. This component is due on Tuesday, Sept. 22, by 2.50 PM. Submit your program source (e.g., Java files and Jar file if you write the program in Java) and instructions on how to run the program if the program is not in Java. NCDC datasets larger than the toy one will be posted.

An exercise problem is available here. This problem is meant to give you an idea of plans, plan costs, and what it takes to find the plan with the lowest cost. If you can solve Problem 2 in the exercise by 2.50 PM on Tuesday, Sept 8, 2009, then you will get 10 bonus points (out of 100) for the first homework. Submission format: In class, or email solution in pdf or plain text to Shivnath.