数据库ch1-introdution.ppt

Chapter1 Introduction Database System Software College 2009 Course Information Course Name: Database System (数据库系统) 32 hours class room teaching, 8 hours experiments Public E-mail: neudb2009@163.com Password:neuneu Teacher Name: wang shuang (王爽) E-mail: wangshuang_neu@163.com Text Book and Reference Text Book Database System Concepts (5th Edition), McGraw-Hill, 2005 Reference 数据库系统概论(第5版)，高等教育出版社，2005 Contents and Requirements Basic Concepts Data Model Relational Model Database Language SQL Contents and Requirements Database Design E-R Model Transform Rule Normalize DBMS Functions Query optimization Concurrency Control Recovery Systems Contents and Requirements Database Programming Embedded SQL Triggers Stored Procedure ODBC, JDBC Grading Policy Assignments: 10% Experiments: 10% Final Exam: 80% Chapter 1 Introduction Contents Purpose of Database Systems View of Data Database Languages Relational Databases Database Design Data Storage and Querying Transaction Management Database Architecture Database Users and Administrators Overall Structure History of Database Systems 数据库在计算机系统中的地位 Database System Applications Representative Database Applications Banking: all transactions Airlines: reservations, schedules Universities: registration, grades Sales: customers, products, purchases Online retailers: order tracking, customized recommendations Manufacturing: production, inventory, orders, supply chain Human resources: employee records, salaries, tax deductions Databases touch all aspects of our lives 发展了一门计算机基础学科。 以数据模型和DBMS核心技术为主，内容丰富、领域宽广。 形成了一个巨大的软件产业。 Commercial Database Systems Company Product Remarks Oracle Oracle 8i, 9i, etc. World’s 2nd largest software company CEO, Larry Ellison, world’s 2nd richest IBM DB2, Universal Server World’s 2nd largest after Informix acquisition Microsoft Access, SQL Server Access comes with MS Office Sybase Adaptive Server CEO John Chen Informix Dynamic Server Acquired by IBM in