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.
When is storing orders.total justified?