Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A real world example of denormalization
Message
 
À
27/12/1999 18:11:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00308992
Message ID:
00309064
Vues:
25
Peter,

A very good example of denormalization. It clearly demonstrates that the process of normalization is to minimize anomalies in update and insert actions sometimes at the expense of retrieval actions. Denormalization is used to obtain acceptable data retrieval from the design. The key to effective use of denormalization is to only do it when the benefit (amount of performance increase) outwiegth the costs (problems of keeping everything consistent).
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform