|
Answer» Following table enlists the difference between the star schema and the snowflake schema: | Star Schema | Snowflake Schema |
|---|
| The fact TABLES and DIMENSION tables are both contained in the star schema. | The fact tables, dimension tables, and sub dimension tables are all contained in the snowflake schema. | | It is a top-down model. | It is, however, a bottom-up model. | | The star schema takes up more room. | It takes up less space. | | Star schema has a low query complexity. | Snowflake schema has a higher query complexity than star schema. | | It is really simple to comprehend. | It is tough to comprehend. | | It contains less foreign keys. | It has a greater number of foreign keys. | | It has a lot of redundancy in its data. | It has a low level of data redundancy. | | The execution of QUERIES takes less time. | The execution of queries takes longer than star schema. | | Normalization is not EMPLOYED in the star schema. | Both normalisation and denormalization are used in this. | | It has a PRETTY simple design. | It has a complicated design. |
|
