Saturday, March 8, 2014

Snowflake vs Star Schema - Data Warehouse

#Comparison(Snowflake Schema vs Star Schema) – By Diffen
When choosing a database schema for a data warehouse, snowflake and star schemas tend to be popular choices. This comparison discusses suitability of star vs. snowflake schemas in different scenarios and their characteristics.


#Star vsSnowflake – By Database Architect
The star schema is the simplest data warehouse schema. It is called a star schema because the diagram resembles a star, with points radiating from a centre. The centre of the star consists of one or more fact tables and the points of the star are the dimension tables.
The snowflake schema is a variation of the star schema used in a data warehouse. The snowflake schema (sometimes called snowflake join schema) is a more complex schema than the star schema because the tables which describe the dimensions are normalized.

Posted by at
Labels: ,

4 comments:

  1. marksonDecember 11, 2019 at 2:16 PM

    All things considered, we anticipate this to build the authoritative attention to the log the board an incentive to help application advancement, security and IT operational achievement.Data Analytics Courses

    ReplyDelete
  2. ExistBIFebruary 17, 2020 at 2:18 PM

    In Star schema, the fact tables and the dimension tables are contained. In this schema fewer foreign-key join is used. This schema forms a star with fact table and dimension tables. And in snowflake schema, The fact tables, dimension tables as well as sub dimension tables are contained. This schema forms a snowflake with fact tables, dimension tables as well as sub-dimension tables.

    ReplyDelete
  3. AnonymousJune 29, 2026 at 1:43 PM

    A Star Schema consists of one central fact table connected directly to multiple dimension tables, forming a star-like structure. The fact table stores measurable business data such as sales or revenue, while dimension tables store descriptive attributes like customer, product, and time. Since dimension tables are denormalized, queries are simpler and faster because fewer joins are required.

    ReplyDelete
  4. AnonymousJune 29, 2026 at 1:43 PM

    A Snowflake Schema is an extension of the star schema where dimension tables are further normalized into multiple related tables. This reduces data redundancy by splitting dimension data into sub-dimensions. For example, a location dimension may be split into city, state, and country tables.

    ReplyDelete

Share Your Inspiration...

Subscribe to: Post Comments (Atom)