CSPP 53010-2: Advanced Database

Spring Quarter, 2002
Wednesdays, 5:30pm-8:30pm
Ryerson 251

Index

Announcements/Updates
Personnel Contacts
Course Description
Course Textbook
Course Policies
Lectures Schedule, Slides, and Assignments

Announcements/Updates

Final Solutions (doc; ps) are now available.

Personnel

Name	Role	Office	Office hours	Phone	Email
Himanshu Gupta	Professor	Ryerson 250	Wed: Before & After Class	(773) 702-4029	hgupta@cs.uchicago.edu
Xuehai Zhang	TA	Ryerson 403, Cubicle 12	Mon, Tue: 5:30PM - 6:30PM or by appointment	(773) 955-4040 ext. 57395	hai@cs.uchicago.edu

Course Description

This is intended to be a graduate level second database principles course with CSPP 53010 or equivalent as a prerequisite.

The objective of the course is to give students a deep understanding of the theory behind data models, logical and physical database design, database data structures, query processing, transaction management, and other issues related to management of database systems. Towards the end of the course we would briefly study some advanced topics like data warehousing, data mining, and querying XML data.

Please refer to Lectures Schedule for details. The course will have a theoretical flavor.

Course Textbook

We will use the following textbook:

Database Systems: The Complete Book (DS:CB) by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom.

Feel free to download the first two chapters of the book.

Course Policies

Grading will be based on the following:
- Assignments: 40% (8 assignments given every Wednesday)
- Midterm: 20%
- Final: 40%
Assignments: There will be eight assignments each of 5% weight. The assignments will be given out almost every Wednesday and due the next Wednesday (in a week). For exact dates of assignment hand-out and due dates, please see the course schedule.
Late Assignment Submissions: You can submit any assignment 2 days late (by Friday midnight) with a 20% penalty.
Collaboration: As in most courses, we encourage that students discuss course material among themselves. Discussions on assignment problems is also permitted to an extent. In either case, you must acknowledge any discussions on assignments in the work submitted. Needless to say, submitted assignment should be your own work
Examination Dates: The mid term will be held on May 1st and the final examination will be held on June 5th.

Lectures Schedule, Slides, and Handouts

The schedule of lectures and assignments is tentative and may change during the course of the class. The link contains lecture slides, assignments, examinations, and solutions.