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