The ANSI-SPARC architecture is a high-level standard for the design of database management systems. ANSI-SPARC is characterized by its three-layer design\u2014external, conceptual, and internal. This architecture is designed to provide a useful abstraction to simplify database access at varying levels of requirements complexity.<\/p>\n
The ANSI-SPARC architecture was defined in 1978 in a joint effort of the American National Standards Institute’s (ANSI)\u00a0 Standards Planning and Requirements Committee (SPARC) department [1]. This standard was reportedly developed after a growing adoption of database management systems that have become “central elements of information processing systems.”<\/p>\n
The ANSI-SPARC standard acknowledged that there were two primary levels of existing database structure common among modern (of the time) applications. These layers, the internal and external, distinguished how data was being seen by the programmer<\/a> vs. the developer. The ANSI-SPARC standard outlined the need for a third layer, the conceptual layer, used for the “enterprise’s description of the information as modeled in the database.”\u00a0 The three layers of the ANSI-SPARC architecture are described more fully as such:<\/p>\n The user’s view of the database contains data representations that may represent higher-level abstractions than how data are actually stored in the database<\/a>. An example is an application that produces dynamic graphs based on numerical data from the database. The user would see illustrations but the actual data would be numbers.<\/p>\n The conceptual layer defines how the data is stored within the entire database and provides a global view of data. Relationships between data are defined here as are the conceptual models for database data<\/a>. This layer, while lower-level than the external layer, is still independent of the hardware of software.<\/p>\nExternal Layer<\/h3>\n
Conceptual Layer<\/h3>\n
Internal Layer<\/h3>\n