A common form of dimensional model. In a snowflake schema, different hierarchies in a dimension can be extended into their own dimensional tables. Therefore, a dimension can have more than a single dimension table.

A variation of the star schema that uses some normalized elements in the dimensions ()

an expansion and extension of a star schema to additional secondary dimensional tables

an extension of star schema, where the dimension tables are normalized (or snowflaked in the diagrammatic representation of the schema) to eliminate redundancy of data

a star schema structure normalized through the use of dimension tables

a star with each dimension broken out into more normalized tables

A variant of the star schema with normalized dimension tables.

A type of star schema in which the dimension tables are partly or fully normalized. See Also: schema and star schema

An extension of a star schema such that one or more dimensions are defined by multiple tables. In a snowflake schema, only primary dimension tables are joined to the fact table. Additional dimension tables are joined to primary dimension tables.

A layering of Star Schema that scales that technique to handle an entire warehouse.

A snowflake schema is a set of tables comprised of a single, central fact table surrounded by normalized dimension hierarchies. Each dimension level is represented in a table. Snowflake schema implement dimensional data structures with fully normalized dimensions. Star schema are an alternative to snowflake schema.

The snowflake schema is a variation of the star schema used in a data warehouse. The snowflake and star schema are methods of storing data which are multidimensional in nature (i.e. which can be analysed by any or all of a number of independent factors) in a relational database.