6.830 2005秋季课程：数据库系统(Database Systems, Fall 2005)
|
硬磁盘的内部结构。（图片来源： Brandon Blinkenberg 和stock.xchng提供。）
Inside of a hard drive. (Image courtesy of Brandon Blinkenberg and stock.xchng.)
Inside of a hard drive. (Image courtesy of Brandon Blinkenberg and stock.xchng.)
课程重点
本课程提供一系列可利用资源：丰富的课堂讲稿 、作业包含的问题集和答案、以及相关测验内容。
This course features an extensive set of lecture notes and problem sets with solutions in the assignments section. In addition, exams are available.
This course features an extensive set of lecture notes and problem sets with solutions in the assignments section. In addition, exams are available.
课程描述
本课程主要通过数据库社群的读物、向研究生介绍数据库系统的基础知识，着重介绍比如关系代数和数据模型，范式规范，查询优化和交易。本课程的对像为已修读6.033 （或同等课程）的学生，无需数据库经验；也适合曾修读数据库本科生课程的学生。有关操纵和设计数据库系统的题目包括：数据模型；数据库和模式设计；模式正规化（范式）和完整性约束；查询处理；查询优化和估计成本；交易；恢复；并行控制；独立性和一致性；分布型、并行型、异质型数据库；适应型数据库；触发系统；发表—订阅系统；半结构化数据和XML查询。
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.
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.
技术需求
需要特定软件运行课程的.gz 和.java文件。
Special software is required to use some of the files in this course: .gz and .java.
