CMPSCI 645: Database Design and Implementation

subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link
subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link
subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link
subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link
subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link
subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link
subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link
subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link

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.

Course Time:

TuTh 9:30 am-10:45 am, CMPS 140

Professor:

Yanlei Diao
Contact:
Office Hours: TuTh 10:45 am-11:45 am, CMPS 232

Teaching Assistant:

Shaolei Feng
Contact:
Office Hours:

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: