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 is similar to the star schema. However, in the snowflake schema, dimensions are normalized into multiple related tables, whereas the star schema's dimensions are denormalized with each dimension represented by a single table. A complex snowflake shape emerges when the dimensions of a snowflake schema are elaborate, having multiple levels of relationships, and the child tables have multiple parent tables ("forks in the road"). Star and snowflake schemas are most commonly found in dimensional data warehouses and data marts where speed of data retrieval is more important than the efficiency of data manipulations. As such, the tables in these schemas