Logical Data Modeling - Data Model

Data System Architecture


A data model is an (abstract) model that describes how data are represented and accessed.

Data models formally define entity and relationships among entities for a domain of interest.

This is schema but on an entity/relationship level and not on raw data.

A data model is a representation of:

A data model is a formal way to represent the business rules.

It is built and modified until it represents the business well enough to write a system. Data models must be built during requirements.

A Data Model has three main components:



Without Data Model

Without Data Model

Data Modeling Process

Data Modeling Process


Logical Data Modeling - Logical data model

Physical data model

Logical design is what you draw with a pen and paper or design with a data modeling tools before building your data warehouse database. Physical design is the creation :

During the physical design process, you convert the data gathered during the logical design phase into a description of the physical structure. Physical design decisions are mainly driven by:

  • query performance
  • and database maintenance aspects.

For example, choosing a partitioning strategy that meets common query requirements enables the Database to take advantage of partition pruning, a way of narrowing a search before performing it.

A Physical Data Model is the physical manifestation of the logical data model (relationships) into database tables and foreign key constraints.

A physical DB schema describes the storage structures and access methods used in order to effectively access and maintain data.

Difference between logical and physical

Both, the logical and physical data model are presented as ER diagrams. A logical model is slightly more abstract than a physical model.

  • A physical model represents exactly what is implemented in a database (table, column names, schema, indexes, data types, contraints, tablespaces, partitions and all the other requirements to define the database.
  • A logical model shows entities, attributes, keys and relationships. Names are usually more free-form and descriptive.

Data Model Fit-Gap Analysis

Fit-gap analysis is where you compare your information needs and business requirements with the actual data model structure.

Documentation / Reference

  • Source: Batini, C., Ceri, S., and Navathe, S. B., Conceptual Database Design: An Entity-Relationship Approach, The Benjamin/Cummings Publishing Company, Inc., 1992.

Discover More
Card Puncher Data Processing
Business - Rule

A business rule is a rule that constrains some aspect of the business process. According to the white paper by the Business Rules Group, a business...
Graph - Graph Model (Network Model)

for a graph. A graph data model is also known as a Network model The schema is composed: entity (object type) are nodes relationship (types) are [[edge|arcs (egde) The property graph contains:...
Card Puncher Data Processing
JPA - Java Persistence API (JPA)

API The Java Persistence API is the Java API for the management of persistence and object/relational mapping for: Java EE and Java SE environments The Java Persistence consists of: The Java...
Data System Architecture
Logical Data Modeling

A data model in software engineering is a graph of entity that try to represent the reality and describes how data are represented and accessed. the real world consists of entities and relationships....
Data System Architecture
Logical Data Modeling - (Metadata|Descriptor)

Metadata are data data. They are data that describes other data. Metadata is also known as: Descriptor. Ancillary data Metadata is information stored in the data dictionary components of the...
Association Entity Example
Logical Data Modeling - Association

An association is a relationship between two or more entities. It's represented by a link in the data model. An association: answers to the question why two entity need to know one another. specifies...
Uml Note Symbol
Logical Data Modeling - Comment / Note

A note symbol is an element that content a comment. It permits to add context and extra information the model. In uml, it's shown as a rectangle with the upper right corner bent where the rectangle...
Data System Architecture
Logical Data Modeling - Element

An element is a constituent of a data model.
Data System Architecture
Logical Data Modeling - Logical data model

A logical data model is a data model that shows the organization of data without indicating how it is physically stored, created, or manipulated (it this is not a physical data model). It just describe...
Data System Architecture
Logical Data Modeling - Software

This page shows some specialized data modeling software. A a data model is just a graph, you can use all graph visualization tool also. Power Architect...

Share this page:
Follow us:
Task Runner