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
Explain how you can define an object model of a system. A list of terms that shall be used by end users to describe state and behaviour of objects in system.   Different use

Create 1 experiment to demonstrate an aspect of query optimisation by using access-path structures (indexes), decomposition, or denormalisation. Once satisfied with your experiment

What are the situations while DBMS should not be used? DBMS should not be used in situations like: (i) No need of security. (ii) Not difficulty to access the data (iii) N

Which method of access uses key transformation? A Hash method of access uses key transformation.

Update Operations and Dealing with Constraint Violations There are three basic operations to be executes on relations: Insertion Deletion Update The INSER

Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.

What is known as clustering file organization? In the clustering file organization, records of several dissimilar relations are stored in the similar file.

Design Of Distributed Databases: The distributed databases are mainly relational at local level. So a local database schema is the similar as that of a centralised database design

Question : (a) Differentiate between database integrity and database security (b) Database security involves measures to avoid loss of privacy and loss of confidentiality. D

Describe the nested-loop join and block-nested loop join.   Ans:   The block nested- loop join algorithm is as described below:     for every block B r of relation R do beg