Re: primary and foregin keys
Date: 27 Dec 2004 14:07:54 -0800
>> That particular design flaw is called "attribute splitting" , in
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