Snowflake Schema in the Dimensional Modeling

Snowflake Schema Design

If we did not de-normalize our dimensions into one table each, then the schema would have looked like this

olap snowflake schema

You can see,  this looks like a snow flake, hence this type of schema is called Snowflake Schema.  General rule of thumb is keep away from snow flake schemas as even though they may save you some space, they will cost a lot in terms of query times.

Copyright 2005-2016 KnowledgeHills. Privacy Policy. Contact .