What is denormalization?
Understand the concept
Denormalization stores a fact in more than one place to make common reads simpler or faster. It trades extra storage and update work for fewer lookups. Some copies are historical snapshots, while others must track the current source of truth; those are different consistency requirements.
Important ideas
-
Store a copy of data to make reads simpler or faster.
-
Example: store the purchased product name inside an order.
-
Decide whether the copy is a historical snapshot or must stay in sync.
-
An order's purchased price should normally remain the original price even if the product price changes later.
Can you explain it without the notes?
What is denormalization?
Use your own words. Explain an example and one limitation before checking the explanation.
Check your explanation
Denormalization stores a fact in more than one place to make common reads simpler or faster. It trades extra storage and update work for fewer lookups. Some copies are historical snapshots, while others must track the current source of truth; those are different consistency requirements.
Turn this concept into a clear answer.
- Name the authoritative source and explain whether copied values are snapshots or synchronized current data.
Adapted from 04_MONGODB_MONGOOSE.md · “What is denormalization?”. Examples are study fragments; framework behavior can depend on your version.