Data Modeling - Data Models

1 - About

In the data warehousing environment, you can find several models.

3 - Data Model Architecture

3.1 - Hub-and-spoke

3.1.1 - Corporate Information Factory

Inmon

3.1.2 - Data Vault

Data Vault (linstedt)

3.2 - Data mart bus

Kimball Star Schema with conformed dimensions.

(1) Attributes of Dim Order which is a fact dimension can be degenerated.

3.3 - Centralized Data Warehouse Architecture

Normalized relational warehouse (3NF) (atomic/some summarized data)

4 - Layer

  • Persistent Staging Area (PSA) - Persistent Data Store (PDS)
data/modeling/data_model_datawarehousing.txt ยท Last modified: 2017/09/13 21:21 by gerardnico