Denormalized Data
Denormalized data is data that has not gone through a normalization process and contains repetitive data.
Not Normalized (Denormalized)
| StudentID | FirstName | LastName | Tuition Amt1 | Tuition Amt2 | Tuition Amt3 |
|---|---|---|---|---|---|
| 1000 | Susie | Baker | 1,500.00 | 1,500.00 | 1,500.00 |
| 1001 | Daniel | Bishop | 1,575.00 | 1,575.00 | 1,575.00 |
| 1002 | John | Brown | 1,475.00 | 1,475.00 | 1,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
- denormalize data for the purposes of analysis quite regularly through querying
- Normalizing data breaks it down, but denormalization brings it back together
