Normalize (the Data)

July 25, 2012

See also: Data Cleansing, Scrubbing the Data, Harmonize the Data

CIMM DEFINITION: The process of organizing data in various groupings so as to eliminate redundancy.

2: In creating a database, normalization is the process of organizing it into tables in such a way that the results of using the database are always unambiguous and as intended. Normalization may have the effect of duplicating data within the database and often results in the creation of additional tables. (While normalization tends to increase the duplication of data, it does not introduce redundancy, which is unnecessary duplication.) Normalization is typically a refinement process after the initial exercise of identifying the data objects that should be in the database, identifying their relationships, and defining the tables required and the columns within each table. (Source: