Re: foundations of relational theory? - some references for the truly starving

"Bob Badour" <bbadour_at_golden.net> wrote in message news:<GumdnaAjFvrJmQaiU-KYvg_at_golden.net>...
> The values in a foreign key reference are redundant because they appear in
> multiple relations. In this case, the redundancy is appropriate and
> necessary to represent the data.

Interesting "admission", or at least an observation. Of course this redundancy is ONLY necessary because of the "flat earth" nature of SQL implementations.

If the data were stored in a multi-valued database, or even an XML data store, then the redundant data could be removed.

I find it "interesting" that when speaking in relation to SQL database structures you are willing to accept some fundamental flaws as being "necessary", and yet will go to extraordinary lengths to attempt to debunk systems that can happily eliminate this flaw.

I'm reminded of a biblical quote about splinters, logs & eyes, but that would be only natural as you do appear to posses many of the traits of a religious zealot, and whilst I may see many of your comments are based on a total lack of understanding or knowledge of multi-valued database implementations in the real world, no doubt there are those that will blindly follow.

For example, you may like to check your facts regarding Codd compliance of mv Data Structures, as I believe you will find that the latest 4.1 release of jBASE scores a perfect 12 ?!? (whilst even the Oracle darling can only scrape in an 11) Received on Sun Oct 26 2003 - 14:41:35 CET