Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Issue of denormalizing data keeps me of being in questioned
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Issue of denormalizing data keeps me of being in questioned
Miscellaneous
Thread ID:
00341984
Message ID:
00341984
Views:
57
Since college, it has been my practice to normalize data using 3rd normal form. But when I started working in the real world of programming, I've noticed the importance of denormalizing data by way of distributing information into tables which are actually related to each other i.e. date, companyid are both found or stamped in the parent table and child table; area, item classification of items with a maximum of 15 char width are directly stamped to the item table (no area id or classification id involved). That way, I could generate report specific for the child table without much relationship to establish. These method put me in questioned by upper management which I successfully explained though that it's an issue of "speed and functionality" that is at stake here and not on disk space. Recently, I was amazed by a sample database schema showing an invoice table with an stamped customer address, contact person, telephone, etc. What is this all about folks? Is this a good design or poor design?
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Next
Reply
Map
View

Click here to load this message in the networking platform