Data Warehouse - Data Models

1 - About

3 - Layer

3.1 - Staging

The staging area is a temporary layer where data can persisted in order to assist the data integration in the persistence layer. There is not really a structure or relationship between tables.

3.2 - Persistence

3.2.1 - Centralized Data Warehouse

Normalized relational warehouse (3NF) (atomic/some summarized data) - Relational Data Modeling - Entity Relationship Model (3NF)

3.2.2 - Data Vault

Data Vault (linstedt)

3.3 - Data mart

poke Data Warehousing - Data Marts

Kimball Star Schema with conformed dimensions.

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

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap