Re: Foreign key problem
Date: Thu, 15 Jun 2006 16:25:19 +0300
Message-ID: <e6rmsp$1lb$1_at_nntp.aioe.org>
"paul c" <toledobythesea_at_oohay.ac> wrote in message news:lzckg.29639$iF6.29187_at_pd7tw2no...
> Maybe I should have said that the word glue is a time-waster without any
> practical use, one of those casual metaphors, so rife in IT, that end up
> taking on a life of their own. Some people think keys hold a database
> together, as for what holds a relation together (in a database), I'd say
> it is the complete definition of whatever theory, eg., relational theory
> we use. One could just as easily say that the defined operators are the
> glue, eg., JOIN.
Maybe. But Codd said this about domains. He said that by looking at the domains one can tell if the database can be partitioned in unrelated databases. I understand your position about the operators, but I think JOIN is not one of them (a part of the glue). It is defined on the relations, which are defined on the domains. Maybe Codd viewed operators as special kind of relations so they are included anyway somehow.
> Salesman stole my copy of RM/V2, no idea why. Out-of-print now, not to
> be found in any library I've searched.