About
In the data warehousing environment, you can find several relational data models.
Articles Related
Layer
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.
Persistence
Centralized Data Warehouse
Normalized relational warehouse (3NF) (atomic/some summarized data) - Relational Data Modeling - Entity Relationship Model (3NF)
Data Vault
Data Vault (linstedt)
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.