Re: primary and foregin keys
Date: 27 Dec 2004 14:07:54 -0800
Message-ID: <1104185274.888376.153800_at_z14g2000cwz.googlegroups.com>
>> That particular design flaw is called "attribute splitting" , in
this
case on a temporal value. You can also look up what Chris Date and
Dave McGovern have to say about this under orthogonal design.
Newbies do this because this is how they stored physical magnetic tape files. The labels in the IBM systems were labelled with "yyddd" codes that blew up in 2000. Since you do not do random searching on a tape, you had to keep the current data PHYSICALLY separated ... <<
Newbies? Included, but not limited to.
In fact, Serge Rielau advocates this approach ("Updatable UNION ALL
Views in DB2 Universal Database Version 8")
http://www-128.ibm.com/developerworks/db2/library/techarticle/0209rielau/0209rielau.html Received on Mon Dec 27 2004 - 23:07:54 CET