Snowflake Schema (EN)

Concept

A further normalized variant of the Star Schema with hierarchical dimensions

Architecture

flowchart TD     F[Faktentabelle] --> D1[Dimension 1]     F --> D2[Dimension 2]     F --> D3[Dimension 3]          D1 --> D1_1[Unterdimension 1.1]     D1 --> D1_2[Unterdimension 1.2]          D2 --> D2_1[Unterdimension 2.1]     D2 --> D2_2[Unterdimension 2.2]          D3 --> D3_1[Unterdimension 3.1]     D3 --> D3_2[Unterdimension 3.2]          style F fill:#f9f,stroke:#333,stroke-width:2px     style D1 fill:#bbf,stroke:#333,stroke-width:1px     style D2 fill:#bbf,stroke:#333,stroke-width:1px     style D3 fill:#bbf,stroke:#333,stroke-width:1px     style D1_1 fill:#bfb,stroke:#333,stroke-width:1px     style D1_2 fill:#bfb,stroke:#333,stroke-width:1px     style D2_1 fill:#bfb,stroke:#333,stroke-width:1px     style D2_2 fill:#bfb,stroke:#333,stroke-width:1px     style D3_1 fill:#bfb,stroke:#333,stroke-width:1px     style D3_2 fill:#bfb,stroke:#333,stroke-width:1px

In Context

  • Typically used in Data Warehousing environments
  • Related to: Star Schema, OLAP, Data Modeling
  • Example use: Analysis of sales data with product categories and geographic dimensions
Quelle: AI Generated