Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A real world example of denormalization
Message
 
To
27/12/1999 18:11:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00308992
Message ID:
00309064
Views:
26
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).
Previous
Reply
Map
View

Click here to load this message in the networking platform