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
Increased overheads on update : On the drawbacks side, it will need the system to ensure that all replicas of a relation are consistent. This shows that all the replicas of the rel

What is called mirroring? The simplest approach to introducing redundancy is to duplicate each disk. This method is called mirroring or shadowing.

What is serializability? Explain its types? The data base system must control concurrent implementation of transactions, to ensure that the data base state remains consistent.

Describe the two types of methods for retrieving rows in Python? Fetchone()- Returns the next row as a sequence Fetch all()- Returns the entire result set like a strin

Explain the Cascadeless Schedule A cascadeless schedule is one in which for every pair of transactions Ti and Tj like that Tj reads a data item before written by Ti, the commit

A database has been designed for this beauty parlour in order for the staff to manage specific things such as bookings made by clients, payments, staff availability, level of exper

#question. acompani datdbase needs to store information about employees (identified by a social security number,with salary and phone as attributes) and departments (identified by

What is the main goal of RAID technology? Describe the levels 1 through 5. RAID stands for Redundant Array of Inexpensive (or sometimes "Independent")Disks. RAID is a met

Hashed File Organisation Hashing is the most common form of purely random access to a database or file. It is also used to access columns that do not have an index as an optimi

Define Outer join Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected