01introduction.ppt

Principles of Database Systems  王岩 wangyanme@ Course information About this course-bilingual(双语) 采用双语教学，具体做法是： 英文版教材+ 中文版教材 多媒体教学，幻灯片以英文为主。为帮助大家理解，重要章节：补充中文内容和中文幻灯片 双语教学的目的： 接触国外优秀原版教材 提高计算机英语水平，提高原版资料的阅读能力 About this course-Text book Text book and main references： Text book ： Database system concepts 数据库系统概念（中文版）机械工业出版社 Main reference books ： 数据库系统原理与应用（SQL Server2005），廖瑞华等编著，机械工业出版社 数据库系统概论(第四版)，王珊主编，高等教育出版社 About this course- Prerequisites (先修课程) Data structure Some important concepts of Operating system Programming languages C++ Java Delphi ASP About this course－ Course website 校园网用户： 0 Internet： Some Questions What is database? What is database management system(DBMS)? List some commercial DBMS? List some database applications? How the database system works? How to design a database system? … … Course Goals To help students achieve the following: Develop a conceptual model of a database Become familiar with a database management system Implement a database To cover mostly relational databases how to design and create such databases how to use them (via SQL query language) how to implement them (only briefly) To touch on some advanced issues About this course－Course Contents Introduction Entity-Relationship Model(E-R 模型) Relational Model(关系模型) SQL(结构化查询语言) Integrity and Security (完整性和安全性) Relational Database Design (关系数据库设计) Storage and Indexing (数据库存储和索引) About this course－Course Contents Query Processing and Optimization(查询处理和优化) Transactions (事务) Concurrency Control (并发控制) Recovery System (数据库恢复) Database System Architectures (数据库体系结构) New Technology in Database (数据库新技术) SQL Server 2005(上机环境) 、Powerdesigner About this course－ Approaches to learn this course Attendance Class participation (Answer question, discussion) Homework Lab programming Project (In group) Select an application that needs a database Build a database application from start to finish Mini-Test（20%） and Final Exam（70%） 数据库技术的重要性 数据库技术产生于六十年代末，是数据管理的最新技术，是计算机科学的重