Update Anomaly

noun

say it: “up-DAYT uh-NOM-uh-lee” /ʌpˈdeɪt əˈnɒməli/

A problem in a poor table design where changing one fact means changing many rows, and missing one leaves the data inconsistent.

What is Update Anomaly in a relational database?

Update Anomaly — A design problem where repeated copies of one fact can become inconsistent during an update.

In a sentence

  • “Storing the customer's phone on every order caused an update anomaly when it changed.”

Level: Journeyman · More Database terms at this level

Updated