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) relational tables and columns, object-oriented classes, or XML tags. This is as opposed to a conceptual data model, which describes the semantics of an organization without reference to technology, or a physical data model, which describes the particular physical mechanisms used to capture data in a storage medium.

The next step in creating a database, after the logical schema is produced, is to create the physical schema.


Wikimedia Foundation. 2010.

Look at other dictionaries:

  • Logical data model — A logical data model also referred to as LDM in computer science is a representation of an organization s data, organized in terms of a particular data management technology. When ANSI first laid out the idea of a logical schema (in 1975 [1] ),… …   Wikipedia

  • Schema (Kant) — In Kantian philosophy, a schema (plural: schemata ) is the procedural rule by which a category or pure, non empirical concept is associated with a mental image of an object. It is supposedly produced by the imagination through the pure form of… …   Wikipedia

  • Schema matching — The terms schema matching and mapping are often used interchangeably. For this article, we differentiate the two as follows: Schema matching is the process of identifying that two objects are semantically related (scope of this article) while… …   Wikipedia

  • 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 — (pl. schemata) In many logical calculi, axioms and rules are presented as forms or schemata, with the provision that any of an infinite number of substitution instances are axioms. For example, the rule of inference modus ponens may be presented… …   Philosophy dictionary

  • 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… …   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

  • White pages schema — A white pages schema is a data model, specifically a logical schema, for organizing the data contained in entries in a directory service, database, or application, such as an address book. In a white pages directory, each entry typically… …   Wikipedia

  • Axiom schema of specification — For the separation axioms in topology, see separation axiom. In axiomatic set theory and the branches of logic, mathematics, and computer science that use it, the axiom schema of specification, axiom schema of separation, subset axiom scheme or… …   Wikipedia

  • Snowflake schema — A snowflake schema is a logical arrangement of tables in a relational database such that the entity relationship diagram resembles a snowflake in shape. Closely related to the star schema, the snowflake schema is represented by centralized fact… …   Wikipedia

Share the article and excerpts

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

We are using cookies for the best presentation of our site. Continuing to use this site, you agree with this.