Part 1 Background Chapter 1 Introduction to Databases Chapter Objectives Structure of this Chapter 1.1 Introduction 1.2 Traditional File-Based Systems 1.2.1 File-Based Approach 1.2.2 Limitations of the File-Based Approach 1.3 Database Approach 1.3.1 The Database 1.3.2 The Database Management System (DBMS) 1.3.3 (Database) Application Programs 1.3.4 Components of the DBMS Environment 1.3.5 Database Design: The Paradigm Shift 1.4 Roles in the Database Environment 1.4.1 Data and Database Administrators 1.4.2 Database Designers 1.4.3 Application Developers 1.4.4 End-Users 1.5 History of Database Management Systems 1.6 Advantages and Disadvantages of DBMSs Chapter Summary Review Questions Exercises Chapter2 Database Environment Chapter Objectives Structure of this Chapter 2.1 The Three-Level ANSI-SPARC Architecture 2.1.1 Extemal Level 2.1.2 Conceptual Level 2.1.3 Intemal Level 2.1.4 Schemas, Mappings, and Instances 2.1.5 Data Independence 2.2 Database Languages 2.2.1 The Data Definition Language(DDL) 2.2.2 The Data Manipulation Language (DML) 2.2.3 Fourth-Generation Languages(4GLs) 2.3 Data Models and Conceptual Modeling 2.3.1 Object-Based Data Models 2.3.2 Record-Based Data Models 2.3.3 Physical Data Models 2.3.4 Conceptual Modeling 2.4 Functions of a DBMS 2.5 Components of a DBMS 2.6 Multi-User DBMS Architectures 2.6.1 Teleprocessing 2.6.2 File-Server Architecture 2.6.3 Traditional Two-Tier Client-Server Architecture 2.6.4 Three-Tier Client-Server Architecture …… Part 2 The Relational Model and Languages Part 3 Database Analysls and Design Techniques Part 4 Methodology Part 5 Selected Database Issues Part 6 Distributed DBMSs and Replication Part 7 Object DBMSs Part 8 Web and DBMSs Part 9 Business Intelligence Appendices
鄂公網(wǎng)安備 42010302001612號 