Snowflake of ice. At that stage, the snowflake has the shape of a minute hexagon. The six "arms" of the snowflake, or dendrites, then grow independently from each of the corners of the hexagon, while either side of each arm grows independently. The microenvironment in which the snowflake grows changes dynamically as the snowflake falls through the cloud and tiny changes in temperature and humidity affect the way in which water molecules attach to the snowflake. Since the micro-environment (and its changes) are very nearly identical around the snowflake, each arm tends to grow in nearly the same way. However, being
Snowflake schema that may not be necessary to fulfill certain queries. The snowflake schema is in the same family as the star schema logical model. In fact, the star schema is considered a special case of the snowflake schema. The snowflake schema provides some advantages over the star schema in certain situations, including: The primary disadvantage of the snowflake schema is that the additional levels of attribute normalization adds complexity to source query joins, when compared to the star schema. Snowflake schemas, in contrast to flat single table dimensions, have been heavily criticised. Their goal is assumed to be an efficient and