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 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.

Data model

Main	Role History Architecture Modeling Properties Organization Structure Theory Patterns

Schemas	Conceptual Logical Physical

Types	Database Data structure diagram (DSD) Entity-relationship (ERM) (and Enhanced notation - EERM) Geographic Generic Semantic

Related models	Data flow diagram (DFD) Information model Object model Object-role model (ORM) Unified Modeling Language models (UML)

See also	Database design Business process model Core architecture data model Enterprise model Function model Process model XML schema Data Format Description Language (DFDL)

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

Logical schema

See also