UNIFIED STAR SCHEMA (USS)
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What central structure does the Unified Star Schema (USS) introduce?
2. What is the primary goal of the Unified Star Schema?
3. What is a fan trap?
4. What does the Puppini Bridge essentially consist of?
5. How do analysts query a Unified Star Schema?
6. Which combined report is given as an example that a Puppini Bridge makes safe in a loan approval environment?
7. Why does the Unified Star Schema support self-service BI well?
8. Which of the following is NOT listed as a trade-off of the Unified Star Schema?
9. To which modelling family does the Unified Star Schema belong?
10. Why does the query logic built on the Bridge_Puppini remain valid when new facts such as Repayments or Collections are added later?