ANSI-SPARC Architecture

The ANSI-SPARC Three-level architecture.

The ANSI-SPARC Architecture, where ANSI-SPARC stands for American National Standards Institute, Standards Planning And Requirements Committee, is an abstract design standard for a Database Management System (DBMS), first proposed in 1975.[1]

The ANSI-SPARC model however never became a formal standard. No mainstream DBMS systems are fully based on it (they tend not to exhibit full physical independence or to prevent direct user access to the conceptual level), but the idea of logical data independence is widely adopted.

Three-level architecture

The objective of the three-level architecture is to separate the users’ view,

three level are:

The Three Level Architecture has the aim of enabling users to access the same data but with a personalised view of it. The distancing of the internal level from the external level means that users do not need to know how the data is physically stored in the database. This level separation also allows the Database Administrator (DBA) to change the database storage structures without affecting the users' views.

Some important facts about this level are:

  1. DBA works at this level.
  2. Describes the structure of all users.
  3. Only DBA can define this level.
  4. Global view of database.
  5. Independent of hardware and software.

Database schemas

There are three different types of schema corresponding to the three levels in the ANSI-SPARC architecture.

The overall description of a database is called the database schema.

See also

References

  1. ANSI/X3/SPARC Study Group on Data Base Management Systems: (1975), Interim Report. FDT, ACM SIGMOD bulletin. Volume 7, No. 2

Further reading

This article is issued from Wikipedia - version of the 3/3/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.