Database Design and Implemen-tation

Course goals

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. It will also cover core database implementation issues including storage and indexing, query processing and optimization, as well as transaction management, concurrency, and recovery. It will finally touch upon advanced issues pertaining to modern Internet-based data management such as XML data management, data stream management, information integration, and database security. Prerequisites: an undergraduate-level course on operating systems or databases.

3 credits.

Schedule

TuTh 9:30 am-10:45 am (co-taught with Prof. Diao)

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. There will also be a few reading assignments for this course. Those papers will be posted on the course web site.