Introduction to Database Principles ….pptVIP

Maoying Wu (吴茂英) bi203.sjtu@ May 27, 2017 2012-2013 (2)BI203: Introduction to Database Principles/course/database Course Syllabus Terminologies and Concepts Data (数据) Database (数据库) Database Management System (DBMS，数据库管理系统) Database Administrator (DBA，数据库管理员) Database System (DBS，数据库系统) DBMS: 数据库管理系统 hardware Operating system DBMS/compiler Application developer Application DBS: 数据库系统 Textbook and Reference Abraham Silberschatz, Henry F. Korth, S. Sudarshan. Database System Concepts. McGraw-Hill Companies. 杨冬青，马秀莉，唐世渭。数据库系统概念。机械工业出版社 Jeffrey D. Ullman, Jennifer Wildom. A First Course in Database Systems. Dept. of CS, Stanford University 王珊，萨师煊。数据库系统概论。高等教育出版社 Frequently-used DBMS Oracle MySQL PostgreSQL Microsoft SQL Server IBM DB2 Course Outline Ch1. Introduction Section 1: Relational database (关系型数据库) Ch2. Relational model (关系模型) Ch3. SQL (结构化查询语言) Ch4. Advanced SQL Ch5. Other Relational Query Languages Section 2: Database design (数据库设计) Ch6. Database Design: Entity-Relationship Model (实体-关系模型) Ch7. Relational Database Design (关系数据库设计) Ch8. Application Design (应用程序设计) Course Outline (cont.) Section 3: Data storage、query (数据存储与查询) Ch9. Storage and File Structure (存储与文件结构) Ch10. Indexing and Hashing (索引与哈希) Ch11. Query Processing (查询处理) Ch12. Query Optimization (查询优化) Section 4: Transaction Management (事务管理) Ch13. Transaction (事务概念) Ch14. Concurrency Control (并发控制) Ch15. Recovery system (系统恢复) Section 5: Object-Based Databases and XML (面向对象数据库) Ch16. Object-Based Databases Ch17. XML Ch18. Data mining (数据挖掘) Schedule Lecture + Discussion 32 hours Computer Labs 16 hours Group-based Project 10 hours Final Exam (written) 2 hours Scoring Policy Assignments 10% Computer Lab Reports 20% Group projects 10% Final 60% Evaluation form for reports 0: Not Done 1: Incomplete 2: Late Complete 3: Needs Improvement 4: Complete 5: Well Done -- Introduction to database principles Maoying Wu (bi203.sjtu@) 23-Feb-13 Chapter 1: Introduction Outlines Database History Why