In: Computer Science
snow flake schema differ from star schema
* In snow flake schema ,the fact tables , dimensions tables as well as subdimensional tables are contained.
Where in star schema subdimensional tables are not contained
*Snow flake schema is bottom up approach and uses less space
Where star schema is top down approach and uses more space
*It takes more time for execution of quieries than star schema
*Snow flake has both normalisation and denormalisation where star schema has only normalisation
*It has low redundancy where star schema has more redundancy
Advantages of snowflake schema
*It has better data quality
*And less less disk space is used
*Easy understand
*Improvement in query performance
*Reduces the problem of data integrity
*It has high flexibility
Disadvantages of snowflake schema
*It requires complex quieries
*Normalisation of dimensional table can impair the performance of a datawarehouses
*Database maintainance effort is increased because there are more tables to maintain