第一篇数据库课件.ppt

* School of Software，Yunnan University School of Software, YunNan University Chapter 1 Introduction 1.1 Fundamental Database Concepts 1.2 Database Users (reference to ‘Database System Summary’) 1.3 Overview of Relational and Object-Relational DBMS 1.4 Putting It All Together 1.1 Fundamental Database Concepts DBMS Concepts It is a program product for keeping computerized records about an enterprise. It is used to business, universities, libraries, airlines , factories and so on. A DBMS may deal with more than one database at a time. 1.1 Fundamental Database Concepts History of Database Systems 1968, IBM’s IMS( Information Management System), Hierarchical data model. 1971,Cullinet Software’s IDMS, Network data model. Late 1970, E.F.Codd，Relational model Recently，Object-relational model 1.1 Fundamental Database Concepts Features of these two data model Ｒ1 Root node Ｒ2 Twin node 　 Ｒ3 Leaf node Ｒ4 Twin node 　 Ｒ5 Leaf node Leaf node Figure 1 Hierarchical data model 1.1 Fundamental Database Concepts Features of these two data model Figure 2 network data model Ｒ1 Ｒ2 R3 L1 L2 R1 R2 L3 L1 L2 R3 L4 R4 R5 1.1 Fundamental Database Concepts The Database Systems Covered ORACLE Server, denoted ORACLE. DB2 Universal Database, denoted DB2 UDB. Informix Dynamic Server 2000, denoted INOFRMIX. DB2 for OS/390, the original IBM mainframe DB2 denoted DB2. 1.2 Database Users End users Casual users [专家用户] Naive users [一般用户] Application programmers Database administrators 1.2 Database Users Casual users A casual user is expected to have some facility with the SQL language, the standard query language for relational database systems. Naive users A naive user is one who performs all database application