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.
