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.