Article does not exist.

Database normalization

A community portal about Database normalization with blogs, videos, and photos. According to Wikipedia.org: In relational database theory, normalization is the process of restructuring the logical data model of a database to eliminate redundancy, organize data efficiently, reduce repeating data and to reduce the potential for anomalies during data operations. Data normalization also may improve data consistency and simplify future extension of the logical data model. The formal classifications used for describing a relational database's level of normalization are called normal forms

Write an Article

RSS

Articles

From Zimbio|From The Web

Sort: Top Picks

Data Quality and Ad Hoc Analysis

Written by illuminate-blog on

From: ianalyze.net

Is the concept of Good Enough ever applicable to data quality measurements in a data warehouse environment? I think most people would agree with the concept seen in the graph below comparing resource cost to data quality level. Data quality is expensive in both time and money. But when building a data warehouse, one must assume that every data element in the entire warehouse has a purpose and will be used. In that scenario, every data element must be as clean as possible. In an ad hoc... Read Full Story

Add Comment

The Atomic Data Warehouse

Written by illuminate-blog on

From: ianalyze.net

No, this isnt a post about a place to store information on nuclear weapons. The long-running debate between Bill Inmon and Ralph Kimball over the optimum data warehouse model has come up again in a discussion of our approach to data warehouse structure. So, should it be a bus (Kimball) or a CIF (Inmon)? Both of these models recognize the importance of having atomic-level data available and both recognize the limitations of the relational model in providing access to this data. They propose... Read Full Story

Add Comment

Welcome to our blog about Database normalization

Written by The_Zimbio_Team on

This is our group blog, which is unique because any Zimbio member can post an entry to it. Some members blog about recent news and trends related to the portal topic, others recount relevant personal stories. You can also comment on and rate existing blog entries, to voice your opinion and to help the community identify which members and entries on the portal are must-reads. Got an interesting idea or story to share with other members of this portal? Well, then put on your journalist's cap... Read Full Story

Add Comment

From Our Partners

PC World»

Investors Business Daily»

People in Pictures

Olivia Munn

Morgan Webb

Emma Watson