Editing Logical schema

A '''logical data model''' or '''logical schema''' is a [[data model]] of a specific problem domain expressed independently of a particular database management product or storage technology ([[physical data model]]) but in terms of data structures such as 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.

== Overview ==

Logical data models represent the abstract structure of a domain of information. They are often diagrammatic in nature and are most typically used in business processes that seek to capture things of importance to an organization and how they relate to one another. Once validated and approved, the logical data model can become the basis of a [[physical data model]] and form the design of a database.

Logical data models should be based on the structures identified in a preceding [[conceptual data model]], since this describes the semantics of the information context, which the logical model should also reflect.  Even so, since the logical data model anticipates implementation on a specific computing system, the content of the logical data model is adjusted to achieve certain efficiencies.

The term 'Logical Data Model' is sometimes used as a [[synonym]] of '[[domain model]]' or as an alternative to the domain model. While the two concepts are closely related, and have overlapping goals, a domain model is more focused on capturing the concepts in the problem domain rather than the structure of the data associated with that domain.

== History ==
[[Image:4-2 ANSI-SPARC three level architecture.svg|thumb|320px|The ANSI/SPARC [[Three schema approach|three level architecture]], which "shows that a data model can be an external model (or view), a conceptual model, or a physical model. This is not the only way to look at data models, but it is a useful way, particularly when comparing models".<ref name="MW99">Matthew West and Julian Fowler (1999). [http://www.matthew-west.org.uk/documents/princ03.pdf Developing High Quality Data Models] {{webarchive|url=https://web.archive.org/web/20081221084613/http://www.matthew-west.org.uk/documents/princ03.pdf |date=2008-12-21 }}. The European Process Industries STEP Technical Liaison Executive (EPISTLE).</ref> ]]

When ANSI first laid out the idea of a ''logical schema'' in 1975,<ref>American National Standards Institute. 1975. “ANSI/X3/SPARC Study Group on Data Base Management Systems;  Interim Report”.  FDT(Bulletin of ACM SIGMOD) 7:2.</ref> the choices were ''hierarchical'' and ''network''.  The [[relational model]] – where data is described in terms of tables and columns – had just been recognized as a data organization theory but no software existed to support that approach. Since that time, an [[Object-oriented analysis and design|object-oriented]] approach to data modelling – where data is described in terms of classes, attributes, and associations – has also been introduced.

== Logical data model topics ==

=== Reasons for building a logical data structure ===
* Helps common understanding of business data elements and requirement
* Provides foundation for designing a database
* Facilitates avoidance of [[data redundancy]] and thus prevent data and business transaction inconsistency
* Facilitates data re-use and sharing
* Decreases development and maintenance time and cost
* Confirms a logical [[process model]] and helps [[impact evaluation|impact analysis]].

=== Conceptual, logical and physical data model ===
A logical data model is sometimes incorrectly called a physical data model, which is not what the ANSI people had in mind. The physical design of a database involves deep use of particular database management technology.  For example, a table/column design could be implemented on a collection of computers, located in different parts of the world.  That is the domain of the physical model.

Conceptual, logical and physical data models are very different in their objectives, goals and content. Key differences noted below.

{| class="wikitable"
|-
! Conceptual data model (CDM)
! Logical data model (LDM)
! Physical data model (PDM)
|-
| Includes high-level data constructs
| Includes entities (tables), attributes (columns/fields) and relationships (keys)
| Includes tables, columns, keys, data types, validation rules, database triggers, stored procedures, domains, and access constraints
|-
| Non-technical names, so that executives and managers at all levels can understand the data basis of Architectural Description
| Uses business names for entities & attributes
| Uses more defined and less generic specific names for tables and columns, such as abbreviated column names, limited by the database management system (DBMS) and any company defined standards
|-
| Uses general high-level data constructs from which Architectural Descriptions are created in non-technical terms
| Is independent of technology (platform, DBMS)
| Includes primary keys and indices for fast data access.
|-
| Represented in the [[Department of Defense Architecture Framework|DIV-1]] Viewpoint (DoDAF V2.0)
| Represented in the DIV-2 Viewpoint (DoDAF V2.0), and OV-7 View (DoDAF V1.5)
| Represented in the DIV-3 Viewpoint (DoDAF V2.0), and SV-11 View (DoDAF V1.5)
|-
|}

== See also ==
* [[DODAF]]
* [[Core architecture data model]]
* [[Database design]]
* [[Entity-relationship model]]
* [[Database schema]]
* [[Object-role modeling]]
* [[FCO-IM]]

== References ==
{{reflist}}

== External links ==
* [https://web.archive.org/web/20080509063521/http://www.dbmsmag.com/9506d16.html Building a Logical Data Model] By George Tillmann, DBMS, June 1995.

{{Data model}}

{{DEFAULTSORT:Logical Data Model}}
[[Category:Data modeling]]