CMPSCI 645: Database Design and Implementation

This course covers the design and implementation of traditional relational database systems as well as advanced data analytics systems. The course will treat fundamental principles of databases such as the relational model, relational algebra, SQL, 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 big data analytics systems, including data exploration, data mining, machine learning for systems, and unified data analytics.

Course work will include homework assignments, a midterm exam, a paper review, and a course project.

Prerequisites: undergraduate-level courses on algorithms, databases and/or operating systems. 3 credits.

Course Time:

Tue Thu 8:30 - 9:45 am EST, classed offered online in Zoom


Yanlei Diao
Office Hours: Tue 10 - 11 am EST (priority given to research projects)
Thu 7:30 - 8:30 am EST

Teaching Assistants:

Matteo Brucato
Contact: matteo [at] cs [dot] umass [dot] edu
Office Hours: Mon 8 - 9 am EST

Shivam Srivastava
Contact: shivam [at] cs [dot] umass [dot] edu
Office Hours: Tue 11 am - 12 pm
Wed 10:15 - 11:15 am

Kajal Tiwari and Nitin Srinivasan
Contact: kajaltiwari [at] umass [dot] edu, nitinsriniva [at] umass [dot] edu
Office Hours: Fri 11 am - 12 pm

Recommended Textbook:

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.

Dissemination of Course Materials

The course materials will be posted on the course website. Students can post questions on Piazza. We will use Gradescope (upon student consent) for collecting submissions for the homework assignments.