CMPSCI 645: Database Design and Implementation

This course covers the design and implementation of traditional relational database systems as well as advanced data management systems. The course will treat fundamental principles of databases such as the relational model, conceptual design, and schema refinement. It will also cover core database implementation issues including storage and indexing, query processing and optimization, and transaction management. In this course, we will finally address challenges in modern Internet-based data management. These topics include XML data management, data stream management, and database security.

Prerequisites: an undergraduate-level course on databases or operating systems. 3 credits.

Course Time:

Tu Th 11:15 am-12:30 pm, CMPS 140


Yanlei Diao
Office Hours: Tuesday 5-6 pm or by appointment, CMPS 232

Teaching Assistant:

Jagrati Agrawal
Contact: jagrati [at] cs [dot] umass [dot] edu
Office Hours: Thursday 2:00 pm - 3:00 pm, CMPS 307


The textbook for this course is the 3rd Edition of "Database Management Systems" by Ramakrishnan and Gehrke. The textbook is available from Amazon. The lecture notes will be posted online after each class.

Course Mailing List:

cs645 [at] edlab-mail [dot] cs [dot] umass [dot] edu