Modeling of Data Warehouses
Modeling data warehouses: dimensions & measurements
- Star schema: A single object (fact table) in the middle connected to objects (dimension tables)
- Snowflake schema: Dimensional hierarchy is normalizes dimension tables.
- Fact constellations: Multiple fact tables share dimension tables.