Data Warehouse Modeling
Star Schema vs. Snowflake Schema
The star schema and the snowflake schema are ways to organize data marts or entire data warehouses using
relational databases. Both of them use dimension tables to describe data aggregated in a fact table.
Everyone sells something, be it knowledge, a product, or a service. Storing this information, either in an
operational system or in a reporting system, is also a need. So we can expect to find some type of sales
model inside the data warehouse of nearly every company.
Let’s take one more look at the sales model in both the star and snowflake schemas.
The Star Schema
