6.830 Database Systems

Fall 2005

Inside of a hard drive.
Inside of a hard drive. (Image courtesy of Brandon Blinkenberg and stock.xchng.)

Course Highlights

This course features an extensive set of lecture notes and problem sets with solutions in the assignments section. In addition, exams are available.

Course Description

This course relies on primary readings from the database community to introduce graduate students to the foundations of database systems, focusing on basics such as the relational algebra and data model, schema normalization, query optimization, and transactions. It is designed for students who have taken 6.033 (or equivalent); no prior database experience is assumed though students who have taken an undergraduate course in databases are encouraged to attend. Topics related to the engineering and design of database systems, including: data models; database and schema design; schema normalization and integrity constraints; query processing; query optimization and cost estimation; transactions; recovery; concurrency control; isolation and consistency; distributed, parallel, and heterogeneous databases; adaptive databases; trigger systems; pub-sub systems; semi structured data and XML querying.

Technical Requirements

Special software is required to use some of the files in this course: .gz and .java.

Donate Now


Prof. Samuel Madden

Course Meeting Times

Two sessions / week
1.5 hours / session