1 / 19

Advanced Database System Framework: Levels, Mappings & Administration

Explore the intricate levels, mappings, and functions of an advanced database system, including conceptual, internal, and external aspects, coupled with database administration procedures and data communications in a client-server architecture.

cabreraj
Download Presentation

Advanced Database System Framework: Levels, Mappings & Administration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 2.1 Introduction • A framework: ANSI/SPARC study Group on Data Base Management Systems Advanced Database System

  2. The three levels: (See Fig. 2.1) a. The internal level b. The external level c. The conceptual level 2.2 The Three Levels of the Architecture Advanced Database System

  3. Example (Fig. 2.2) Advanced Database System

  4. The interrelationships (Fig. 2.3) Advanced Database System

  5. Data sublanguage vs. host language Tightly coupled vs. loosely coupled Data definition language (DDL) vs. Data manipulation language (DML) External view, external record, and external schema 2.3 The External Level Advanced Database System

  6. Conceptual view, conceptual record, and conceptual schema. A great many additional features, such as the security and integrity constraints. 2.4 The Conceptual Level 2.5 The Internal Level • Internal view, internal record, and internal schema • The internal view is still at one remove from the physical level. Advanced Database System

  7. 2.6 Mappings • The conceptual/internal mapping • The external/conceptual mapping • The external/external mapping Advanced Database System

  8. The functions: a. defining the conceptual schema (logical database design) b. defining the internal schema (physical database design) c. liaising with users d. defining security and integrity constraints e. defining dump and reload policies f. monitoring performance and responding to changing requirements 2.7 The Database Administrator Advanced Database System

  9. Procedures: a. A user issues an access request. b. The DBMS intercepts the request and analyze it. c. The DBMS inspects the external schema for that user, the external/conceptual mapping, the conceptual schema, the conceptual/internal mapping, and the storage structure definition. d. The DBMS executes the necessary operations on the stored database. 2.8 The Database Management System Advanced Database System

  10. The functions (Fig. 2.4) a. Data definition b. Data manipulation • Planned requests vs. unplanned requests c. Optimization and execution d. Data security and integrity e. Data recovery and concurrency (transaction manager) f. Data dictionary g. Performance Advanced Database System

  11. The DC manager is not part of the DBMS but is an autonomous system in its own right. Database/data-communications system 2.9 Data Communications Advanced Database System

  12. 2.10 Client / Server Architecture • A server (the backend) and a set of clients (frontends) (See Fig. 2.5) • Applications a. user-written applications b. vendor-provided applications (tools) • The possibility arises of running clients and servers on different machines. Advanced Database System

  13. Utilities: a. Load routines b. Unload/reload routines c. Reorganization routines d. Statistical routines e. Analysis routines 2.11 Utilities Advanced Database System

  14. 2.12 Distributed Processing • The DBMS backend on one machine and the application frontends on another. (See Fig. 2.6) • Many arguments in favor of such a scheme: a. parallel processing b. server ⇒ a database machine c. client ⇒ a personal workstation d. A single database might be shared across several distinct client systems. (See Fig. 2.7) Advanced Database System

  15. One server machine, many client machines (Fig. 2.7) Advanced Database System

  16. A distributed database system (Fig. 2.8) Advanced Database System

  17. User accesses can basically be provided in two different ways: a. A given client might be able to access any number of servers, but only one at a time. The user in such a system has to know which particular machine holds which pieces of data. b. The client might be able to access many servers simultaneously. The servers look to the client as if they were really a single server, and the user does not have to know which machines hold which pieces of data. 2.12 Distributed Processing (Cont.) Advanced Database System

  18. The End. Advanced Database System

More Related