Explain the ansi sparc architecture, Database Management System

Assignment Help:

Explain the ANSI SPARC architecture

The three-schema architecture is as well known as ANSI SPARC architecture. The aim of the three-schema architecture is to separate the user applications and the physical database. The view at every of these levels is described by a schema. The procedures of transforming requests and results among levels are known as mappings. In this architecture, schemas can be illustrated at the following three levels:

  • External Level or Subschema - It is the highest level of database abstraction in which only those portions of the database of concern to a user or application program are involved. Any number of user views might exist.
  • Conceptual Level or Conceptual Schema - At this levels of database abstraction all the database entities and the relationships between them are included. There is just only one conceptual schema per database.
  • Internal Level or Physical Schema - It is closest to the physical storage method employed.

Related Discussions:- Explain the ansi sparc architecture

Which database object does not physically exist, Which database object does...

Which database object does not physically exist? A view database object does not physically exist.

Emergence of client server architecture, Emergence of Client Server Archite...

Emergence of Client Server Architecture Some of the pioneering work that was completed by some of the relational database vendors permitted the computing to be distributed on m

Differance between unordered and ordered file, Differance between Unordered...

Differance between Unordered and ordered file ? Unordered file do no has any sequence although ordered file has arranged in a few sequence and data are assigned in ordered form

Consistency, what do you mean by consistency in rdbms?

what do you mean by consistency in rdbms?

Define various ways in which select statement, Define various ways in which...

Define various ways in which SELECT statement can be used for record selection Technology?  SELECT gives you control over a number of aspects for record retrieval: 1) Which

What is a database, What is a database? At any given time, they're sto...

What is a database? At any given time, they're storing a tremendous amount of information - inventory, in the case of Amazon, messages and interrelationships in the case of Tw

Explain about data independence, Data Independence This brings us to ou...

Data Independence This brings us to our next topic: data independence. It is the property of the database which tries to make sure that if we make any change in any level of sc

State in detail about data flow diagram, What is a Data Flow Diagram?  ...

What is a Data Flow Diagram?  Data Flow Diagram: A data flow diagram is the graph that shows flow of data values from their sources in objects in the course of processes whic

Hierarchical model is also known by, Hierarchical model is also known by? ...

Hierarchical model is also known by? A hierarchical model is also known as a Tree structure.

Construct a generalization-specialization hierarchy, Construct a generaliza...

Construct a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles that comprise an engine number and cost; cars that have a chass

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd