Advantages and Disadvantages of a Star Schema
Hi all, could anybody explain me about these questions?:
1) About the Advantages of the Star Schema
- Minor maintenance
--> Why this could be an advantage?
- Simple definition of metadata
--> Why this could be an advantage?. I don't find explanation.
2) About the Disadvantages of the Star Schema
- Aggregate is difficult
--> I thought it was the opposite. Why is aggregation difficult in a star-schema?
- frequent queries of very large dimension tables are time-consuming
--> What can be the reason?
3) What happens by inserting (insert-operations) on a star schema. Would it be performant? would it be timely fast than in a snowflake schema?.
I would really appreciate if you could explain me that...