Three Level Architecture Essay Example | Topics and Well Written Essays - 2750 words

Three Level Architecture - Essay Example In this section I will present some of major objectives of the three levels of the database architecture. The DBA is able to transform the structure of database, for example without altering the software program for example external schema. Every user is able to access the data as of his/her necessities. Users are sovereign of the storage issues similar to indexing limitations etc of the database. The conceptual architecture of the database has no influence because of the transform of the physical storage systems.The External LevelThe external level is one near to users. That is the one associate with the mode in which the data is observed through particular users. At the external level the DBMS outlines every user by means of a shared or particular view or representation of the data. There are numerous views of the information and data at this phase, as well as every view is an illustration of fraction of the whole database. A view permits a client access to their part of the databa se, as well as shields the remaining database from them. Every external view is described through means of an external representation, that composed of fundamentally of descriptions of all of variety of kinds of outer record discovered that external view. In external level, the diverse views can have diverse illustrations of the similar data. For instance one user can view date in the structure as day, month, year as another may analysis as year, month, day.The external level or view of DBMS is basically associated.