When to suggest what
-----
NO | Star Schema | Snowflake Schema |
1. | In star schema, The fact tables and the dimension tables are contained. | While in snowflake schema, The fact tables, dimension tables as well as sub dimension tables are contained. |
2. | Star schema is a top-down model. | While it is a bottom-up model. |
3. | Star schema uses more space. | While it uses less space. |
4. | It takes less time for the execution of queries. | While it takes more time than star schema for the execution of queries. |
5. | In star schema, Normalization is not used. | While in this, Both normalization and denormalization are used. |
6. | It’s design is very simple. | While it’s design is complex. |
7. | The query complexity of star schema is low. | While the query complexity of snowflake schema is higher than star schema. |
8. | It’s understanding is very simple. | While it’s understanding is difficult. |
9. | It has less number of foreign keys. | While it has more number of foreign keys. |
10. | It has high data redundancy. | While it has low data redundancy. |
