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 address challenges in modern networked information systems, including data mining, provenance, data stream management, and probabilistic databases.

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


Alexandra Meliou
Contact: ameli [at] cs [dot] umass [dot] edu
Office Hours: Tuesdays, 1:30-2:30pm, CS 330
Yanlei Diao
Contact: yanlei [at] cs [dot] umass [dot] edu
Office Hours: Wednesdays, 12:30-1:30pm, CS 360 (expected travel days: March 21, April 25)

Teaching Assistants:

My Phan
Contact: myphan [at] cs [dot] umass [dot] edu
Office Hours: Thursdays, 2:45-3:45pm, CS 207
Tim Contois
Contact: tcontois [at] umass [dot] edu
Office Hours: Thursdays, 10-11am, LGRT 220
Josh Pikovsky
Contact: jpikovsk [at] umass [dot] edu
Office Hours: Mondays, 11am-12pm, LGRT 220

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.