CMPSCI 345: Practice and Applications of Data Management

Fall 2014

This course will provide a comprehensive introduction to the use of data management systems within the context of various applications. Some of the covered topics include data models, basic and advanced SQL, design and tuning of relational schemas, implementation of basic transactions, and data visualization tools. The class will alternate between lecture and practice, and the students will experience the covered topics through a semester-long collaborative mini-project.

Course work will include homework assignments, web quizzes, a collaborative mini-project, and a midterm and final exam.

Prerequisites: CS 187 (grade C or greater). 3 credits.

Students who have taken CMPSCI 445 are not eligible to take this class!

Course Time:

Mo We 2:30 pm - 3:45 pm, LGRC A310


Alexandra Meliou
Contact: ameli [at] cs [dot] umass [dot] edu
Office Hours: Thursday 4-5pm, CS 330

Teaching Assistant:

Wenzhao Liu
Contact: wenzhao [at] cs [dot] umass [dot] edu
Office Hours: Friday 10-11am, CS 207 (alternating with Haopeng)

Teaching Assistant:

Haopeng Zhang
Contact: haopeng [at] cs [dot] umass [dot] edu
Office Hours: Friday 10-11am, CS 207 (alternating with Wenzhao)


The textbook for this course is the 2nd Edition of "Database Systems: The Complete Book" by Garcia-Molina, Ullman, and Widom. The textbook is available from Amazon. The lecture notes will be posted online after each class.

Talk to the instructor if you want to consider a different textbook, or to not use a textbook at all, in order to understand the tradeoffs before you make this choice.