Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can data be 'over-normalized'?
Message
From
25/01/2001 13:01:18
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00468334
Message ID:
00468616
Views:
19
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform