Duplicate a Fact Only with a Reason
Denormalization deliberately stores a derived or repeated fact after establishing a normalized model. A stored order total may speed a measured read path, but every source update must keep the duplicate correct. The benefit, consistency strategy, and repair plan must be explicit.
GOAL
Evaluate denormalization by its read benefit and consistency cost.
When is storing orders.total justified?