Three Level Architecture of DBMS or Logical DBMS Architecture

The logical architecture defines how data in the database is perceived by users. It is not deals with how the data is handled and processed by the DBMS, but only with how it looks. The process of data storage on the underlying file system is not revealed, and the users can influence the data without worrying about where it is located or how it is really stored. This results in the database having dissimilar levels of abstraction.

The majority of commercial Database Management Systems available today are based on the SPARC / ANSI generalised DBMS architecture, as proposed by the SPARC / ANSI Study Group on Data Base Management Systems. Therefore, this is also called as the SPARC / ANSI model. It separates the system into three levels of abstraction: the physical or internal level, the conceptual level, and the view or external level.

 

Posted Date: 3/5/2013 4:54:20 AM | Location : United States

Ask an Expert

Related Discussions:- Three level architecture of dbms-logical architecture, Assignment Help, Ask Question on Three level architecture of dbms-logical architecture, Get Answer, Expert's Help, Three level architecture of dbms-logical architecture Discussions

Write discussion on Three level architecture of dbms-logical architecture
Your posts are moderated

Write your message here..

Related Questions

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

Relationship, what is the relationship between receipt and owner entities i... what is the relationship between receipt and owner entities in computer sales and service company

Relational algebra and calculus, Q.  What is relational algebra and calcul... Q.  What is relational algebra and calculus? Explain the relational algebra operators :- Selection and predicate, set operation, joins and division. Sol. Relational Algebra

Windows 8 Administrative Tools, Which two tools are used to administer user... Which two tools are used to administer users for Active Directory?

Explain how the associations are implemented as classes, Explain how the as... Explain how the associations are implemented as classes. A general approach in this case is to transform an association class into a simple class linked to two original classes

A distributed transaction, A Distributed Transaction Let us demonstrate... A Distributed Transaction Let us demonstrate the concept of a distributed transaction by considering a banking system having of three branches located in 3 different cities. Ev

Basic set operation, These are the binary operations; i.e., each is applied... These are the binary operations; i.e., each is applied to two relations or sets. These two relations can be union compatible excluding in case of Cartesian product. Two relations R

Memory components of sga, Problem 1. Describe the Oracle Architecture w... Problem 1. Describe the Oracle Architecture with a neat labeled diagram, Also explain the individual components of the Architecture. 2. Write about the following Oracle 9i o

Transactions t1 and t2 are in a deadlock, Evaluate: a.When transactions... Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.

What is dml (data manipulation language)?, This language that enable user m... This language that enable user manipulate to or access data as organized by appropriate data model. Low level or Procedural DML : DML needs a user to specify what data ar