Denormalized Data


Denormalized data is data that has not gone through a normalization process and contains repetitive data.

Not Normalized (Denormalized)

StudentIDFirstNameLastNameTuition

Amt1
Tuition

Amt2
Tuition

Amt3
1000SusieBaker1,500.001,500.001,500.00
1001DanielBishop1,575.001,575.001,575.00
1002JohnBrown1,475.001,475.001,475.00

Example of Denormalized Data in Excel

  • For every tuition payment, student information—such as student ID, first name, and last name—is entered into the table
  • example of denormalized data because the student information is manually keyed in and repeated each time a tuition payment is made
  • there are other reasons for denormalized data to exist that are not related to design flaws in the data entry process
    • denormalize data for the purposes of analysis quite regularly through querying
      • process of querying involves gathering data from all the different single source tables and joining that information together for the purposes of data warehousing, data mining, analysis, and visualization
      • end result in the data set appears denormalized
  • Normalizing data breaks it down, but denormalization brings it back together