Wednesday, October 31, 2012

Data Warehouse: Data Normalization

Data Normalization splits up data to avoid redundancy (duplication) by moving commonly repeating groups of data into new tables. 


Database Normalization Example


The following graphic gives an example of a typical conversion of an un-normalized table to multiple normalized tables.
Advantages of Database Normalization:
  • Data integrity is maintained.
  • Results of queries are predictable.
  • Changes to data have to be made only once.

  • Amount of storage required by the database is optimal.


Read more reference:
http://en.wikipedia.org/wiki/Data_normalization
http://en.wikipedia.org/wiki/Database_normalization
http://www.sqlsteps.com/what-sql-classes-dont-normally-cover
.

2 comments:

albina N muro said...

Data warehouses are designed for quick access to large amounts of historical data. Read operations dominate over write operations. survival warehouse reviews

Unknown said...

o

Post a Comment