In a data warehouse, the snowflake structure is created when highly repeated fields are placed into separate tables. The resulting diagram has short and long branches extending from the original dimension that resemble the irregularities of a snowflake. Snowflake structures are generally not recommended as they slow down browsing the data. See
data warehouse.