What is Denormalization?
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is Denormalisation?
2. What is the core idea behind denormalisation?
3. Which of the following is a typical denormalisation technique?
4. In which environments are the benefits of denormalisation especially visible?
5. Which modelling techniques have denormalisation as their structural foundation?
6. Which of the following is NOT a trade-off of denormalisation?
7. In the loan example, what fields might a denormalised LoanFact table contain?
8. What redundancy appears in the denormalised LoanFact example?
9. How does denormalisation relate to normalisation?
10. In the modelling journey, what roles do normalisation and denormalisation respectively play at the hinge point?