MIT OpenCourseWare
  • OCW home
  • Course List
  • about OCW
  • Help
  • Feedback
  • Support MIT OCW

6.830 Database Systems, Fall 2005

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

Highlights of this Course

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.



Prof. Samuel Madden

Course Meeting Times

Two sessions / week
1.5 hours / session




Send feedback about OCW or this course.