Main difference
The 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 normalized with each dimension represented by a single table.Snowflake
Snowflake schema is tailored for OLTP and therefore optimized for INSERT, UPDATE and DELETE. An example of snowflake schema:
Star
Star schemas are designed to optimize user ease-of-use and retrieval performance by minimizing the number of tables to join to materialize a transaction. OLAP cubes are built on top of star schemas.A sample start schema:
