CPSC 504: Data Management.Principles and techniques for the design and implementation of data management systems. History of data management. Design of relational systems.Data management applications. Alternate data models.

Pre-requisites: CPSC 404 or consent of the instructor


Instructors: Laks Lakshmanan, Raymond Ng, Rachel Pottinger



The course introduces students to many aspects of data management system design, including traditional database systems. The following is a tentative outline:


Introduction and History [3 hours]

Relational Systems [16 hours]

Data Management Applications [6 hours]

Alternate data models [11 hours]


Learning Outcomes

Upon completion of this course, students will have:


Students will be able to:

Sources of information:
A preliminary set of readings has been prepared from a set of papers from prominent database conferences.Some papers have been chosen from Michael Stonebraker, Joseph M. Hellerstein: Readings in Database Systems, Third Edition Morgan Kaufmann 1998.
Other texts that could be used to provide background and supplementary materials include:
         Database Systems: The Complete Book, by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom, Prentice-Hall 2002
         Database Management Systems, Third Edition by Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill 2002
         Jeffrey D. Ullman: Principles of Database and Knowledge-Base Systems, Volume I Computer Science Press 1988
         Jeffrey D. Ullman: Principles of Database and Knowledge-Base Systems, Volume II Computer Science Press 1989


[504 home] [grading] [schedule] [project] [WebCT]

Rachel Pottinger
E-mail Address: rap [at] cs [dot] ubc [dot] ca
Office Location: CICSR 345
Phone: (604)822-0436
Postal/Courier address:
The Department of Computer Science
University of British Columbia
201-2366 Main Mall
Vancouver, B.C. V6T 1Z4