Star Schema is a highly denormalized schema whereas snowflake schema is hight normalized schema.Star schema is characterized by large number of rows in a table and less number of joins between tables.Snowflake schema is characterized by less number of rows in a table while more number of joins between tables.
No comments:
Post a Comment