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
How to define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a

What is a records management consultation? Our organization is an authority for disseminating your specific requirements and giving you with a solution to effectively manage yo

Explain several types of constraints that can be specified using CREATE TABLE command. Explain CASCADE and RESTRICT clauses of DROP SCHEMA command? Constraint Description PRIM

Which are the two ways in which entities can participate in a relationship? Total and partial are the two ways in which entities can participate in a relationship

Making Common Behaviour Abstract Let us define abstraction "Abstraction means to focus on the necessary, inherent aspects of an entity and ignoring its accidental features". O

Vertical Fragmentation- Vertical fragmentation groups together only those attributes in a relation that are used jointly by various important transactions. A vertical fragment is d

What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on

Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro

give some example real-life situations where DBMS are most suiitabe

Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t