What is Denormalization?

Share this topic

What is Denormalization?

From the book I Am Datapedia!, published here free by the author.

Part of I Am Datapedia!

Self-check

Questions 1–10 of 10

  1. 1. What is Denormalisation?

    Question 1
  2. 2. What is the core idea behind denormalisation?

    Question 2
  3. 3. Which of the following is a typical denormalisation technique?

    Question 3
  4. 4. In which environments are the benefits of denormalisation especially visible?

    Question 4
  5. 5. Which modelling techniques have denormalisation as their structural foundation?

    Question 5
  6. 6. Which of the following is NOT a trade-off of denormalisation?

    Question 6
  7. 7. In the loan example, what fields might a denormalised LoanFact table contain?

    Question 7
  8. 8. What redundancy appears in the denormalised LoanFact example?

    Question 8
  9. 9. How does denormalisation relate to normalisation?

    Question 9
  10. 10. In the modelling journey, what roles do normalisation and denormalisation respectively play at the hinge point?

    Question 10