清华大学数据库原理第一章.讲课.ppt

数 据 库 原 理 王 建 民 清 华 大 学 软 件 学 院 2003年/秋 Overview 授课时间 第1周－第16周 学生教材 Database System Concepts(4th Edition)，高等教育出版社 参考教材 数据库系统概论(第3版)， 萨师煊、王珊 高等教育出版社 Overview (c1) 作业 平时作业(h)、项目作业(pr) 考试 期中考试(mt，第9周) 期末考试(ft，第17/18周) 成绩 h*15%+pr*25%+ mt*20%+ft*40% Overview (c2) 学习方式 学思统一 团队学习(3-5人) 课程辅导 骆科东、潘莉莉 其它信息 清华大学网络学堂 Aim 深入理解数据库系统的基本概念、原理和方法 重点掌握关系数据模型及关系数据语言，能熟练应用SQL语言表达各种数据操作 掌握E-R模型的概念和方法，关系数据库规范化理论和数据库设计方法 了解并掌握数据库管理系统的基本实现与应用技术 Knowledge Background You Should be familiar with Basic Data Structure Computer Organization A High-level Programming Language JAVA, PASCAL or C Main Contents Database Systems and File Systems Data Abstraction/Data Model Database Languages Database Users and Administrator Transaction Management Overall System Structure Application Architectures History and the Future Basic Words Data－数据 Database －数据库 Database Management System －数据库管理系统 Database System－数据库系统 Database Application－数据库应用 Database Management System Collection of interrelated data and Set of programs to access the data DBMS contains information about a particular enterprise DBMS provides an environment that is both convenient and efficient to use. Databases touch all aspects of our lives Database Applications Banking: all transactions Airlines: reservations, schedules Universities: registration, grades Sales: customers, products, purchases Manufacturing: production, inventory, orders, supply chain Human resources: employee records, salaries, tax deductions IP Phone/Dial-Up Systems:AAA Purpose of Database System In the early days, database applications were built on top of file systems Drawbacks of using file systems to store data: Data redundancy and inconsistency Multiple file formats, duplication of information in different files E.g. address and telephone number saved in savings-account record checking-account record Purpose of Database Systems(c1) Drawbacks of using file systems Difficulty in accessing data Need to write a new program to c