Relational Data Modeling - Data Model

Data System Architecture


data model in a relational environment


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.


You can represent any object in a database using just four tables.

Discover More
3nf Sales
Data Warehouse - Data Models

In the data warehousing environment, you can find several relational data models. The staging area is a temporary layer where data can persisted in order to assist the data integration in the persistence...
Datawarehouse Data Modeling - Data Vault

The data vault (DV) is a relational data model technique used in the persistence layer of a datawarehouse The Data Vault consists of three primary entity types: ...
Without Data Model
Logical Data Modeling - Data Model

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. schema A data...
Cardinality Representation Erd
Relational Data Modeling - Entity-Relationship Diagram (ERD)

The entity-relationship (E-R) diagram is a diagram that helps visualize relational data models and shows relationships between relation (ie the entities) ER modeling technique was first developed by Peter...
Data System Architecture
Relational Data Modeling - Generic Data Model

The generic data model is a relation data model that represent any object in a database using just four tables. It's really good for the flexibility but not good for the database performance and...
Data System Architecture
Relational Data Modeling - Schema

A relational schema is a data schema that: contains all relational modeling object such table, query,. view. is also a namespace functionality meaning that two tables with the same name may exist...
Erd Graphical Notation
Relational Data Modeling - Visualization

The vizualization of a relational data model is done as a sepecialized Entity relationship diagram. A best practice is to draw the child table above the parent table. One way to see the different...

Share this page:
Follow us:
Task Runner