+1 vote
372 views
in Database Management Systems by

1 Answer

+1 vote
by
selected by (user.guest)
 
Best answer

The goal of the three-schema architecture, is to separate the user applications and the physical database. In this architecture, schemas can be defined at the following three levels:  

1. The internal level has an internal schema, which describes the physical storage structure of the database. The internal schema uses a physical data model and describes the complete details of data storage and access paths for the database.  

2. The conceptual level has a conceptual schema, which describes the structure of the whole database for a community of users. The conceptual schema hides the details of physical storage structures and concentrates on describing entities, data types, relationships, user operations, and constraints. A high-level data model or an implementation data model can be used at this level.  

3. The external or view level includes a number of external schemas or user views.

Each external schema describes the part of the database that a particular user group is interested in and hides the rest of the database from that user group. A high-level data model or an implementation data model can be used at this level.The three-schema architecture is a convenient tool for the user to visualize the schema Levels in a database system. Most DBMSs do not separate the three levels completely, but support the three-schema architecture to some extent. Some DBMSs may include physical-level details in the conceptual schema. In most DBMSs that support user views, external schemas are specified in the same data model that describes the conceptual-level information. Some DBMSs allow different data models to be used at the conceptual and external levels.  

Notice that the three schemas are only descriptions of data; the only data that actually exists is at the physical level. In a DBMS based on the three-schema architecture, each user group refers only to its own external schema. Hence, the DBMS must transform a request specified on an external schema into a request against the conceptual schema, and then into a request on the internal schema for processing over the stored database. If the request is a database retrieval, the data extracted from the stored database must be reformatted to match the user’s external view. The processes of transforming requests and results between levels are called mappings. These mappings may be time- consuming, so some DBMSs—especially those that are meant to support small databases—do not support external views. Even in such systems, however, a certain amount of mapping is necessary to transform requests between the conceptual and internal levels.

Related questions

0 votes
1 answer 576 views
0 votes
0 answers 144 views
+2 votes
1 answer 789 views
+1 vote
1 answer 650 views
+1 vote
1 answer 3.3k views
+1 vote
1 answer 498 views
+1 vote
0 answers 11 views
+1 vote
1 answer 25 views
+1 vote
1 answer 34 views
+1 vote
1 answer 138 views
+1 vote
1 answer 221 views
asked Sep 22, 2020 in Database Management Systems by (user.guest)
+1 vote
1 answer 259 views
+2 votes
1 answer 913 views
+1 vote
1 answer 1.3k views
+1 vote
1 answer 316 views
+1 vote
1 answer 180 views
+1 vote
1 answer 33 views
+1 vote
1 answer 28 views
+1 vote
1 answer 29 views
+1 vote
1 answer 39 views
0 votes
1 answer 71 views
0 votes
1 answer 57 views
asked Oct 25 in Database Management Systems by (user.guest)
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...