Re: primary and foregin keys

From: <ak_tiredofspam_at_yahoo.com>
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

Original text of this message