The external or view level in dbms, Database Management System

The External or View Level

The external or view level is the highest level of abstraction of database. It gives a window on the conceptual view, which permits the user to see only the data of interest to them. The user can be either an end user or an application program. There can be a lot of external views as any number of external schemas can be defined and they can overlap each other. It contains of the definition of logical records and relationships in the external view. It also has the methods for deriving the objects such as attributes, entities and relationships in the external view from the Conceptual view.

156_Logical DBMS Architecture.png

           Logical DBMS Architecture

Posted Date: 3/5/2013 4:59:31 AM | Location : United States







Related Discussions:- The external or view level in dbms, Assignment Help, Ask Question on The external or view level in dbms, Get Answer, Expert's Help, The external or view level in dbms Discussions

Write discussion on The external or view level in dbms
Your posts are moderated
Related Questions
What three major types of actions includes databases? Briefly discuss these The three major types of actions including databases are: (i) Defining: It includes specifyin

Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica

Project Description: Need Point of Sale software for pizza restaurant. Delivery and take out service, client's database, inventory control, order history, last order, order from

Lack of standards and experience: The lack of standards has considerably limited the potential of distributed DBMSs. As well, there are no tools or methodologies to help users cha

Give short note on the following terms:Dirty pages and ETL a.) Dirty pages. These are buffer pages which comprise modifications which haven't been written to disk. b.

Describe the algorithm to draw the dependency graph?   Ans: Algorithm to draw Precedence Graph is like this: a.  For every transaction T i participating in schedule S, make

Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b

What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be

What is an Operand? The data on which the operation is to be performed is known as an Operand

Explain the term - Handling Boundary Condition These are some circumstances that to be handled in any system initialization and termination. Describes how system is bro