DatabaseSystems数据库管理系统.pptVIP

70420403- Database Systems 数据库管理系统 Li Jianguojli@math.tsinghua.edu.cn References Raghu Ramakrishnan/Johannes Gehrke, Database Management Systems, 2nd Ed. , 清华大学出版社/McGraw-Hill, 2000 C. J.Date, 数据库系统导论（第7版）, 机械工业出版社 What is DBMS? Need for information management A very large, integrated collection of data. Models real-world enterprise. Entities (e.g., students, courses) Relationships (e.g., Liu Wei is taking A Database Management System (DBMS) is a software package designed to store and manage databases. Why Use a DBMS? Data independence and efficient access. Data integrity and security. Uniform data administration. Concurrent access, recovery from crashes. Replication control Reduced application development time. File Systems Database Management Why Study Databases?? Shift from computation to information at the “low end”: access to physical world at the “high end”: scientific applications Datasets increasing in diversity and volume. Digital libraries, interactive video, Human Genome project, e-commerce, sensor networks ... need for DBMS/data services exploding DBMS encompasses several areas of CS OS, languages, theory, AI, multimedia, logic Key Terms cont. Database System A database, a database management system and appropriate hardware and personnel. Database System: Hardware Set of physical devices on which a database resides. It consists of one or more computers, disk drives, CRT terminals, printers, tape drives, connecting cables and other auxiliary and connecting hardware. Database System: Hardware cont. Database System: Software A database software includes two types of software General-purpose database management software, usually called the database management system (DBMS) Application software that uses DBMS facilities to manipulate the database to achieve a specific business function, such as providing reports or documents, which can be used by users. Database System: Software cont. Application software is generally written standard progr