This course covers the design and implementation of traditional relational database systems and advanced data management systems. The course will treat fundamental principles of databases: the relational model, conceptual design, query languages, and selected theoretical topics. We also cover core database implementation issues including storage and indexing, query processing and optimization, as well as transaction management, concurrency, and recovery. Additional topics will address the challenges of modern Internet-based data management. These include XML data management, information integration, incomplete and probabilistic databases, and database security.
Course work will include written homework assignments, paper reviews, a midterm, and a course project. Prerequisites: an undergraduate-level course on operating systems or databases. 3 credits.
Course Time: |
TuTh 11:15-12:30, MRST 15 |
Professor: |
Gerome Miklau |
| Contact: | miklau [at] cs [dot] umass [dot] edu |
| Office Hours: | By appointment |
Teaching Assistant: |
Daniel Gyllstrom |
| Contact: | dpg [at] cs [dot] umass [dot] edu |
| Office Hours: | TBD |
Text:
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. There will also be a few reading assignments for this course. Those papers will be posted on the course web site.Course Mailing List:
cs645 [at] cs [dot] umass [dot] edu
Midterm Details :
When: Thursday April 17, 7PM-9PM
Where: LGRT 117