Coursify

Data Warehouse Schema for Decision Support: Star vs Snowflake

Data Warehouse Schema for Decision Support: Star vs Snowflake

Verified Sources
Sep 30, 2026

A Data Warehouse used for Decision Support is generally built using dimensional schemas, most commonly the Star Schema or the Snowflake Schema.2

In contrast, Hierarchical and Network models are older database models and are not typical for modern analytical decision-support warehouses. Additionally, a generic Relational Schema is possible, but decision-support warehouses overwhelmingly favor star/snowflake dimensional design because it supports efficient analytics and straightforward query patterns.3

Correct option (from the question): (ii) Star or Snowflake Schema.

Footnotes

  1. Kimball Group. (Overview of dimensional modeling and the star schema). https://www.kimballgroup.com/ (See resources on dimensional modeling and star schema) - Explains star schema as the dimensional design for analytics. ↩ ↩2

  2. IBM. (Explain star and snowflake schemas in data warehousing). https://www.ibm.com/ (Search within IBM docs for “star schema snowflake schema data warehouse dimensional model”) - Describes star vs snowflake and their role in warehouses. ↩ ↩2

  3. Tutorials Point / legacy database models (hierarchical and network model background). https://www.tutorialspoint.com/ (Search for “hierarchical database model” / “network database model”) - Provides context that these models are legacy/less common for modern warehouses. ↩

Star Schema vs Snowflake Schema (Dimensional Modeling)

Why star/snowflake schemas are preferred for decision support

  1. 1
    Step 1

    Organize measures in a Fact Table and descriptive attributes in Dimension Tables to match how analysts ask questions.

  2. 2
    Step 2

    In a star schema, dimensions are usually denormalized to make joins simpler and common BI queries faster to write and often faster to execute.

  3. 3
    Step 3

    In a snowflake schema, dimension attributes can be normalized to reduce redundancy, at the cost of more joins.

  4. 4
    Step 4

    Dimensional designs are well-suited for aggregations (e.g., totals by time, region, product) typical of decision-support workloads.2

    Footnotes

    1. Kimball Group. (Overview of dimensional modeling and the star schema). https://www.kimballgroup.com/ (See resources on dimensional modeling and star schema) - Explains star schema as the dimensional design for analytics. ↩

    2. IBM. (Explain star and snowflake schemas in data warehousing). https://www.ibm.com/ (Search within IBM docs for “star schema snowflake schema data warehouse dimensional model”) - Describes star vs snowflake and their role in warehouses. ↩

  5. 5
    Step 5

    Conformed dimensions and standardized keys help keep metrics consistent across dashboards and reports in the warehouse.2

    Footnotes

    1. Kimball Group. (Overview of dimensional modeling and the star schema). https://www.kimballgroup.com/ (See resources on dimensional modeling and star schema) - Explains star schema as the dimensional design for analytics. ↩

    2. IBM. (Explain star and snowflake schemas in data warehousing). https://www.ibm.com/ (Search within IBM docs for “star schema snowflake schema data warehouse dimensional model”) - Describes star vs snowflake and their role in warehouses. ↩

Core concepts you should know

  • Fact Table: holds measures like sales_amount, quantity, cost.
  • Dimension Table: holds descriptors like date, product, customer, region.
  • Dimensional Modeling: the design approach that leads to star/snowflake structures.2

Footnotes

  1. Kimball Group. (Overview of dimensional modeling and the star schema). https://www.kimballgroup.com/ (See resources on dimensional modeling and star schema) - Explains star schema as the dimensional design for analytics. ↩

  2. IBM. (Explain star and snowflake schemas in data warehousing). https://www.ibm.com/ (Search within IBM docs for “star schema snowflake schema data warehouse dimensional model”) - Describes star vs snowflake and their role in warehouses. ↩

Schema choice in decision-support warehouses (typical vs less common)

Qualitative fit for decision-support workloads

Exam-focused takeaway

If a question asks what schema a data warehouse is generally built using for decision support, the expected answer is Star or Snowflake Schema (dimensional modeling).2

Footnotes

  1. Kimball Group. (Overview of dimensional modeling and the star schema). https://www.kimballgroup.com/ (See resources on dimensional modeling and star schema) - Explains star schema as the dimensional design for analytics. ↩

  2. IBM. (Explain star and snowflake schemas in data warehousing). https://www.ibm.com/ (Search within IBM docs for “star schema snowflake schema data warehouse dimensional model”) - Describes star vs snowflake and their role in warehouses. ↩

Why the other options are usually not the answer

From legacy database models to dimensional warehousing

Hierarchical/Network models

Legacy era

Data stored as trees or pointer-like relationships; not optimized for BI query patterns."

Dimensional modeling emerges

Analytical era

Facts + dimensions become the default modeling approach for analytics."

Star and Snowflake

Modern practice

Star for simplicity; Snowflake when normalization of dimensions is beneficial."

Knowledge Check

Question 1 of 4
Q1Single choice

A Data Warehouse is generally built using which schema for decision support?

Explore Related Topics

1

Object in databases = data + relationships

2

2NF Removes Which Kind of Dependency?

3

Data Warehouse Systems vs. Operational Database Systems: A Comprehensive Comparison

Browse all research articles