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:18:33
 
 
À
24/10/2001 18:06:57
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:
00572939
Vues:
23
>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.
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform