Three level architecture of dbms-logical architecture, Database Management System

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

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
Related Questions
Define the terms  1) physical schema 2) logical schema.  Physical schema:  The physical schema explains the database design at the physical level, which  is  the  lowest  lev

Data slice explanation

Differentiate between static hashing and dynamic hashing.  Ans: Static Hashing comprises the number of primary pages in the directory fixed. So, while a bucket is full, we requ

Data Warehousing & Mining 1. What is the concept of knowledge discovery in database? 2. Describe the following types of Multidimensional Data Models. • Stars, Snowflakes and

construct an er diagram for a hospital with a set of patients and a set of medical doctors. associate with each patient a log of various test and examination conducted.convert er d

What are the DBMS languages? Explain.  Ans: a) Data Definition Languages (DDL): It is employed to specify database schema for example CREATE DROP statements etc.     b)  Dat


Write a Query that uses the UNION Operator 1. Use the Software Experts database to:   a. Display the first and the last name of all consultants who worked on any projects f

In E-R Diagram how relationship type is represented ? In E-R Diagram relationship type is represented as a Diamond.

What are the aggregate objects in the data dictionary? Views Match codes Lock objects.