The need for three level architecture, Database Management System

The need for three level architecture

The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.

  • Support of multiple user views: Every user is able to access the similar data, but have a different customized view of the data. Every user should be able to change the way he or she analysis the data and this change should not affect other users.
  • Insulation between user programs and data that does not concern them: Users should not directly govern with physical storage details, such as hashing or indexing. The user's interactions with the database have to be independent of storage considerations.

 

Posted Date: 3/5/2013 5:05:09 AM | Location : United States







Related Discussions:- The need for three level architecture, Assignment Help, Ask Question on The need for three level architecture, Get Answer, Expert's Help, The need for three level architecture Discussions

Write discussion on The need for three level architecture
Your posts are moderated
Related Questions
What are the reasons for having variable length records? What are the various ways to store variable length records? Variable-length records arise in a database in various wa

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

he SQL query that will return the order number, quantity ordered, price each and total cost of an order (quantity * price each) from the order details table. Label the calculated c

Physical Records These are the records that are stored in the secondary storage devices. For the database relation, physical records are the group of fields kept in adjacent me

DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

we need example of 2phase locking

Improved availability: The data in a distributed system may be replicated so that it is at more than one site. Thus, the failure of a node or a communication link does not necessar

What is the difference between WHERE and HAVING clauses?. Predicates in the WHERE clause applies to every tuple while the predicate in the HAVING clause applies to groups.

What are the problems if one were not to normalize?  When do these problems surface?           Ans:  Database normalization, sometimes considered to as  canonical synthesis, is