Question

In: Computer Science

How does a snowflake schema differ from a STAR schema? Name two advantages and two disadvantages...

How does a snowflake schema differ from a STAR schema? Name two advantages and two
disadvantages of the snowflake schema.

Solutions

Expert Solution

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


Related Solutions

How does scent marketing differ from other forms of marketing? Discuss its advantages and disadvantages. What...
How does scent marketing differ from other forms of marketing? Discuss its advantages and disadvantages. What role does scent marketing play at company like Abercrombie & Fitch?
Explain how centralized and decentralized companies differ. What are the advantages and disadvantages of each
Explain how centralized and decentralized companies differ. What are the advantages and disadvantages of each
7.Name two advantages to a floating rate exchange regime. 8.Name two disadvantages to a floating rate...
7.Name two advantages to a floating rate exchange regime. 8.Name two disadvantages to a floating rate exchange regime. 9.Name two advantages to a fixed rate exchange regime. 10.Name two disadvantages to a fixed rate exchange regime.
1. How do chronological and functional resumes differ? 2. What are the advantages and disadvantages of...
1. How do chronological and functional resumes differ? 2. What are the advantages and disadvantages of EACH style? 3. What style of resume do you currently use when applying for jobs?
1) How does a bailment differ from a gift? 2) How does a bailment differ from...
1) How does a bailment differ from a gift? 2) How does a bailment differ from a lease? 3) Give an example of a bailment that is not a contract. Give an example of a bailment that is a contract.
How do term, whole life, and universal life insurance differ? What are the advantages and disadvantages...
How do term, whole life, and universal life insurance differ? What are the advantages and disadvantages of each policy?
How does the fish circulatory system differ from the mammal circulatory system? (Be comprehensive.) Name one...
How does the fish circulatory system differ from the mammal circulatory system? (Be comprehensive.) Name one significant feature that is the same between fish and mammal circulation.
how does urine differ from blood
how does urine differ from blood
What are the advantages and disadvantages of foreign investing? How does an ADR help overcome the...
What are the advantages and disadvantages of foreign investing? How does an ADR help overcome the disadvantages?
What advantages does a CIO bring to a business? What might be two disadvantages of having...
What advantages does a CIO bring to a business? What might be two disadvantages of having a CIO? What are the trade-offs between cost, quality, and time when designing a project plan? What criteria would managers use to manage this trade-off? How do social analytics aid an organization?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT