Star Schema (EN)

Concept

A data model with a central fact table and directly connected dimension tables

Star Schema

You learn the Star Schema as a fundamental data model for data warehouse systems. It consists of a central fact table containing numerical metrics and multiple dimension tables that are directly connected to the facts. The dimension tables are normalized to avoid redundancies and enable efficient data analysis.

Architecture

flowchart TD   F[Fact table] --> D1[Dimension 1]   F --> D2[Dimension 2]   F --> D3[Dimension 3]   F --> D4[Dimension N]      classDef fact fill:#f9f,stroke:#333,stroke-width:2px   classDef dimension fill:#bbf,stroke:#333,stroke-width:2px      class F fact   class D1,D2,D3,Dn dimension

In Context

  • Typically used together with Snowflake Schema
  • Related to: OLAP, Data Warehouse, Dimensional Modeling
  • Example use: Sales analyses with facts like revenue and quantity, dimensioned by time, product, customer, and region
Quelle: AI Generated