6.830 Database Systems

As taught in: Fall 2005

Photo of the inside of a hard drive.

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

Level:

Graduate

Instructors:

Prof. Samuel Madden

Course Features

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 MIT course 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.