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:
Data warehouses are designed for quick access to large amounts of historical data. Read operations dominate over write operations. survival warehouse reviews
o
Post a Comment