Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can data be 'over-normalized'?
Message
De
25/01/2001 13:01:18
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00468334
Message ID:
00468616
Vues:
26
>Another reason for breaking normalization is maintain integrity in your reporting. For example, let's say you have item descriptions that can change. In a lineitems table, you might elect to carry the description that existed when the lineitem was created. This way, when your item descriptions change, your past reports won't change.

Not to nit-pick, but this isn't really denormalization. If the item description for a lineitem needs to be recorded at the time of the invoice, and that description can later change independently of the invoice description, the current description and the historical description are two distinctly different pieces of information, and are not duplicated.
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform