Data Modeling (Relational Database, Code, Graph, Text)

> (Data|State) Management and Processing > Data Modeling (Relational Database, Code, Graph, Text)

1 - About

A data model in software engineering is a graph that try to represent the reality and describes how data are represented and accessed.

A Data model graph formally define:

There is two world view:

There is not a right or wrong way of doing things as:


3 - Domain

3.1 - Relation Database


3.2 - Code

In code,

3.3 - Text

4 - Data Modeling Concepts


5 - Types of RDBMS Physical Models (Schema)

The difference between model (ER, Dimensional, Vault) has everything to do with terminology and method.

There are two basic types of physical models :

E-R models are designed to minimize data storage redundancy and optimize data updates.

Dimensional models are designed to enhance understandability and to optimize query performance.

  • Data Vault

The Data Vault consists of three primary entity types:

  • Hubs,
  • Links,
  • and Satellites.

The Hubs are core business keys, the Links form all relationships, and the Satellites provide all descriptive information.


6 - Documentation / Reference