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. We will also cover core database implementation issues including storage and indexing, query processing and optimization, and transaction management. Additionally, we will cover modern topics and challenges through paper readings and discussions.

Course work will include homework assignments, paper reviews and presentations, a (late) midterm, and a mini, collaborative project.

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

Course Time:

Mo We 2:30 pm - 3:45 pm, Hasbrouck Lab Add room 124

Instructional team:

Alexandra Meliou Instructor
Ardavan Bozorgi Teaching Assistant
Xi Chen Teaching Assistant

Contact:

Please use Campuswire for questions to the instructional team

Office hours:

Please see Campuswire.


Recommended textbook:

Our recommended textbook 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.