Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: The wisdom of the object mentors (Was: Searching OO Associations with RDBMS Persistence Models)

Re: The wisdom of the object mentors (Was: Searching OO Associations with RDBMS Persistence Models)

From: Erwin <e.smout_at_myonline.be>
Date: 8 Jun 2006 06:19:21 -0700
Message-ID: <1149772761.404764.220960@h76g2000cwa.googlegroups.com>


> Are you suggesting that RDBs cannot have duplicate rows, or even
> duplicate tables?

You seem to be obviously ignorant of the fact that duplicate "rows" (as you call them) are indeed very much ruled out by the relational model. And of the fact that this has been the case ever since the model was first defined. As a certain person named "Ted Codd" (whom maybe you might have heard of, by accident) once put it : "if something is true, then saying it twice will not make it any truer.".

Where :

'something' : a fact in the real world, e.g. "Robert Martin is a male". 'saying it twice' : inserting two identical rows ("Robert Martin",male) in the same table.

It's pointless.

And so is retaining duplicate rows in "derived" or "computed" tables. Received on Thu Jun 08 2006 - 08:19:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US