Can you explain Snowflaking Schema ?

Saturday, 19 January 2019

Can you explain Snowflaking Schema ?

03:43 No Comments

Snowflake Schema: An extension of the star schema by means of applying additional dimensions to the Dimensions of a star schema in a relational environment. Snowflaking is a form of dimensional modeling; dimensions are stored in multiple relational dimension tables. A snowflake schema is a variation of the star schema. Snowflaking is used to improve the performance of specific queries. The schema is diagramed with each fact surrounded by its associated dimensions as in a star schema, and those dimensions are further related to other dimensions, branching out into a snowflake pattern.

Share this

kumar1

Related Posts

0 Comment to "Can you explain Snowflaking Schema ?"

Post a Comment

Subscribe to: Post Comments (Atom)