About: Data Anomalies   Sponge Permalink

An Entity of Type : owl:Thing, within Data Space : dbkwik.org associated with source dataset(s)

Normalization is necessary because if you do not do it then the overall integrity of the data stored in the database will eventually degrade. Specifically, this is due to data anomalies. These anomalies naturally occur and result in data that does not match the real-world the database purports to represent. The normalization process was created largely in order to reduce the negative effects of creating tables that will introduce anomalies into the database. There are three types of Data Anomalies: Update Anomalies, Insertion Anomalies, and Deletion Anomalies.

AttributesValues
rdfs:label
  • Data Anomalies
rdfs:comment
  • Normalization is necessary because if you do not do it then the overall integrity of the data stored in the database will eventually degrade. Specifically, this is due to data anomalies. These anomalies naturally occur and result in data that does not match the real-world the database purports to represent. The normalization process was created largely in order to reduce the negative effects of creating tables that will introduce anomalies into the database. There are three types of Data Anomalies: Update Anomalies, Insertion Anomalies, and Deletion Anomalies.
dcterms:subject
abstract
  • Normalization is necessary because if you do not do it then the overall integrity of the data stored in the database will eventually degrade. Specifically, this is due to data anomalies. These anomalies naturally occur and result in data that does not match the real-world the database purports to represent. Anomalies are caused when there is too much redundancy in the database's information. Anomalies can often be caused when the tables that make up the database suffer from poor construction. So, what does "poor construction mean?" Poor table design will become evident if, when the designer creates the database, he doesn't identify the entities that depend on each other for existence, like the rooms of a hotel and the hotel, and then minimize the chance that one would ever exist independent of the other. The normalization process was created largely in order to reduce the negative effects of creating tables that will introduce anomalies into the database. There are three types of Data Anomalies: Update Anomalies, Insertion Anomalies, and Deletion Anomalies. Update Anomalies happen when the person charged with the task of keeping all the records current and accurate, is asked to change an employee’s title due to a promotion. If the data is stored redundantly in the same table, and the person misses any of them, update anomalies and other undesirable things will start to show up. Insertion Anomalies happen when inserting vital data into the database is not possible because other data is not there. An example of this could be, if a clerk needed to add customer information for a new customer who has not yet made a purchase yet. Deletion Anomalies happen when the deletion of unwanted information causes wanted information to get deleted as well.
Alternative Linked Data Views: ODE     Raw Data in: CXML | CSV | RDF ( N-Triples N3/Turtle JSON XML ) | OData ( Atom JSON ) | Microdata ( JSON HTML) | JSON-LD    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 07.20.3217, on Linux (x86_64-pc-linux-gnu), Standard Edition
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2012 OpenLink Software