Learn VisualLearn DB Visual
JA

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?