About

data model in a relational environment

Articles Related

List

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

There are two basic types of physical models :

• Relational Data Modeling - Entity-Relationship Diagram (ERD) (E-R) and

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

• Modeling

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.

• Relational Data Modeling - Generic Data Model

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

• Data Warehouse - Data Models