CPS 216: Advanced Database Systems
(Spring 2005)

Course Information
Lecture Notes
Assignments
Tentative Syllabus
Programming Notes
Blackboard (Grades)
Newsgroup (Discussion)
Reading Assignments

Reading assignments will be posted regularly here. Please read every assigned paper before its due date. If the paper is marked with  eval , please prepare a short review and email it to the instructor by 11:59pm on the due date. Each review should be no more than a single page and discuss the following:

  • At least three important things that the paper says;
  • At least two interesting things that you found in the paper (e.g., a non-obvious pitfall, an uncanny insight, a neat trick that could be used elsewhere);
  • At least one thing that you did not like about the paper.
For some papers (those marked with  related  next to  eval ), you will also need to identify at least three pieces of follow-up or related work not mentioned in the original papers. Summarize each piece using no more than two sentences. Useful tools for hunting down related work are CiteSeer and DBLP.

AssignmentDownloadDue
Codd. "A Relational Model of Data for Large Shared Data Banks." Communications of the ACM, 13(6), 1970.PDFThursday, 01-20 eval 
Ailamaki et al. "Weaving Relations for Cache Performance." VLDB 2001.PDFWednesday, 01-26 eval   related 
Chamberlin et al. "A History and Evaluation of System R." Communications of the ACM, 24(10), 1981.PDFThursday, 02-03 eval 
Lomet. "The Evolution of Effective B-tree Page Organization and Techniques: A Personal Account." SIGMOD Record, 30(3), 2001.PDFThursday, 02-03 eval 
Hellerstein et al. "Generalized Search Trees for Database Systems." VLDB 1995.PDFMonday, 02-15 eval 
Brin and Page. "The Anatomy of a Large-Scale Hypertextual Web Search Engine." WWW 1998.PDFThursday, 02-17 eval 
Graefe. "Query Evaluation Techniques for Large Databases." ACM Computing Surveys 1993.PDFWednesday, 02-23 eval 
O'Neil and Quass. "Improved Query Performance with Variant Indexes." SIGMOD 1997.PDFMonday, 02-28 eval   related 
Chou and DeWitt. "An Evaluation of Buffer Management Strategies for Relational Database Systems." VLDB 1985.PDFWednesday, 03-02 eval 
McHugh and Widom. "Query Optimization for XML." VLDB 1999.PDFWednesday, 03-31 eval 
Halverson et al. "Mixed Mode XML Query Processing." VLDB 2003.PDFWednesday, 03-31 eval 
Selinger et al. "Access Path Selection in a Relational Database Management System." SIGMOD 1979.PDFMonday, 04-18 eval 
 
Homework Assignments

Homework may be submitted after lectures or at the intructor's office. If the instructor is not in the office, slip the homework underneath the office door. Email submissions to the instructor are okay but not encouraged. No late submissions will be graded.

AssignmentDownloadAssignedDue
Homework #1PDFThursday, 01-20Tuesday, 02-08
Homework #2PDFTuesday, 02-15Thursday, 03-03
Homework #3PDFTuesday, 03-29Tuesday, 04-12
Homework #4PDFThursday, 04-21Thursday, 04-28
 
Project

See project description (PDF) for details.

 
Last updated Sun Apr 24 20:57:05 EDT 2005