Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
When do you split into separate tables?
Message
De
24/10/2001 18:21:37
 
 
À
24/10/2001 18:18:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00572907
Message ID:
00572941
Vues:
30
>>Steve-
>>
>>I appreciate you voicing your views. I've read a lot on "Data Normalization" and I guess I wanted to here the views of FoxPro programmers on the UT.
>>
>>One pitfall I would like to avoid is over-normalization. The two symptoms of over-normilization I have found is too complicated and too slow.
>>
>>That may not be the case here but if I'm going to raise the level of complexity, I better have a good reason.
>>
>>Higher complexity usually equates to increased maintenance hours.
>>
>
>Dan,
>
>Proper normalization is more flexible, I think. I also think it leads to lower maintenance. Making changes to a table will have fewer unexpected side effects, because each table has a clear purpose.
>
>I hope others chime in, too. I think it is an interesting topic of discussion.

That's a good point.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform