CHAPTER 2 Database Environment

標籤：gic   out   its   服務   his   func   prepare   attr   efi   

Chapter Objectives   （章節目標）

In this chapter you will learn:  （在本章中，你將學習：）

• The purpose and origin of the three-level database architecture.  （三層資料庫的架構和起源。）
• The contents of the external, conceptual, and internal levels. （外部、概念、內部層次的內容。）
• The purpose of the external/conceptual and the conceptual/internal mappings. （外部/概念、和概念/內部映射的目的。）
• The meaning of logical and physical data independence. （邏輯和物理資料獨立性的意義。）
• The distinction between a Data Definition Language (DDL) and a Data Manipulation Language (DML).  （資料定義語言 (Data Definition Language)（DDL）和資料操作語言（DML）之間的區別。）
• A classification of data models.  （資料模型的分類。）
• The purpose and importance of conceptual modeling.  （概念建模的目的和重要性）
• The typical functions and services that a DBMS should provide.  （DBMS 應提供的典型功能和服務。 ）
• The function and importance of the system catalog.  （系統目錄的功能和重要性）

　　A major aim of a database system is to provide users with an abstract view of data, hiding certain details of how data is stored and manipulated. Therefore, the starting point for the design of a database must be an abstract and general description of the information requirements of the organization that is to be represented in the database. In this chapter, and throughout this book, we use the term "organization" loosely to mean the whole organization or part of the organization. For example, in the  DreamHome case study, we may be interested in modeling:

• the "real=-world" entities Staff, PropertyforRent, PrivateOwner, and Client; 
• attributes describing properties or qualities of each entity (for example, each Staff entry has a name, position, and salary);
• relationships between these entities (for example, staff Manages PropertyforRent).

　　Furthermore, because a database is a shared resource, each user may require a different view of the data held in the database. To satisfy these needs, the architecture of most commercial DBMSs available today is based to some extent on the so-called ANSI-SPARC architecture. In this chapter, we discuss various architectural and functional characteristics of DBMSs.

 

 

Structure of this chapter       In Section 2.1, we examine the three-level ANSI-SPARC architecture and its associated benefits. In Section 2.2, we consider the types of language that are used by DBMSs, and in Section 2.3, we introduce the concepts of data models and conceptual modeling, which we expand on in later parts of the book. In Section 2.4, we discuss the functions that we would expect a DBMS to provide. The examples in this chapter are drawn from the DreamHome case study, which we discuss more fully in Section 11.4 and Appendix A. 

　　Much of the material in this chapter provides important background information on DBMSs. However, the reader who is new to the area of database systems may find some of the material difficult to comprehend fully on first reading. Do not be too concerned about this, but be prepared to revisit parts of this chapter at a later data when you have read subsequent chapters of the book. 

 

2.1 The Three-level ANSI-SPARC Architecture

 

 

An early for a standard terminology and general architecture for database systems was produced in 1971 by the DBTG appointed by CODASYL in 1971. The DBTG recognized the need for  a two-level approach with a system view called the schema and user views called subschemas. 

 

CHAPTER 2 Database Environment