Learn VisualLearn DB

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?