Physical schema

Physical schema

Physical Schema is a term used in relation to data management.

In the ANSI four-schema architecture, the "internal schema" was the view of data that involved data management technology. This was as opposed to the "external schema" that reflected the view of each person in the organization, or the "conceptual schema" that was the integration of a set of external schemas. Subsequently the internal schema was recognized to have two parts:

The logical schema was the way data were represented to conform to the constraints of a particular approach to database management. At that time the choices were hierarchical and network. Describing the logical schema, however, still did not describe how physically data would be stored on disk drives. That is the domain of the "physical schema". Now logical schemas describe data in terms of relational "tables and columns", object-oriented "classes", and XML "tags". The underlying technology has since exploded. A single set of tables, for example can be implemented in dozens of different ways, up to and including the architecture where some rows are on a computer in Cleveland and others are on a computer in Warsaw.

This is the physical schema.


Wikimedia Foundation. 2010.

Игры ⚽ Поможем написать реферат

Look at other dictionaries:

  • Schéma d'URI — En informatique, un schéma d’URI est le premier niveau de la structure de nommage des identifiants uniformes de ressources (URI). Toutes les URIs sont construites à partir d’un nom de schéma, suivi de deux points (« : ») puis du reste… …   Wikipédia en Français

  • Schema object — A schema object is a logical data storage structure. Schema objects do not have a one to one correspondence to physical files on disk that store their information. However, Oracle stores a schema object logically within a tablespace of the… …   Wikipedia

  • Schema crosswalk — A crosswalk is a table that shows equivalent elements (or fields ) in more than one database schema. It maps the elements in one schema to the equivalent elements in another schema. For example, this is a metadata crosswalk from MARC to Dublin… …   Wikipedia

  • Three schema approach — The three schema approach, or the Three Schema Concept , in software engineering is an approach to building information systems and systems information management, that promotes the conceptual model as the key to achieving data integration. [http …   Wikipedia

  • Logical schema — A Logical Schema is a data model of a specific problem domain expressed in terms of a particular data management technology. Without being specific to a particular database management product, it is in terms of either (for example, in 2007)… …   Wikipedia

  • Database schema — A depiction of MediaWiki database schema. A database schema (pronounced skee ma, /ˈski.mə/) of a database system is its structure described in a formal language supported by the database management system (DBMS) and refers to the organization of… …   Wikipedia

  • Conceptual schema — A conceptual schema or conceptual data model is a map of concepts and their relationships. This describes the semantics of an organization and represents a series of assertions about its nature. Specifically, it describes the things of… …   Wikipedia

  • Electron beam physical vapor deposition — Traduction à relire Electron beam physical vapor deposition → …   Wikipédia en Français

  • Entity–attribute–value model — (EAV) is a data model to describe entities where the number of attributes (properties, parameters) that can be used to describe them is potentially vast, but the number that will actually apply to a given entity is relatively modest. In… …   Wikipedia

  • Data model — Overview of data modeling context: A data model provides the details of information to be stored, and is of primary use when the final product is the generation of computer software code for an application or the preparation of a functional… …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”