Re: Foreign superkey support
Date: Thu, 10 Aug 2006 11:47:12 GMT
Message-ID: <41FCg.1558$QK.1504_at_trndny06>
"Marshall" <marshall.spight_at_gmail.com> wrote in message
news:1155134332.345985.119920_at_m73g2000cwd.googlegroups.com...
> David Cressey wrote:
> > "Marshall" <marshall.spight_at_gmail.com> wrote in message
> > news:1155100237.103860.180160_at_h48g2000cwc.googlegroups.com...
> >
> > > In other words, there is a many-to-many relationship between
> > > constraints and relvars. (Or relations, if we are thinking in
> > > descriptive rather than prescriptive terms.) For example,
> > > we often speak of a foreign key constraint as belonging to
> > > one particular table, but it is equally a constraint on two tables.
> > > On one table it restricts inserts and on another table it restricts
> > > deletes. So we must necessarily classify it as a database
> > > constraint. But really, all constraints are all database constraints,
> > > although there may be some database constraints that only
> > > happen to be quantified over a single relvar.
> > >
> >
> > Here I am as Johnny one note, chiming in again.
>
> Dude, any time. I'm not a recent college graduate who believes
> he already knows everything he needs to :-) The Wisdom of
> the Elders is welcome.
>
>
> > And how did I come to know DSRI? DEC Rdb/VMS was DSRI compliant.
> > You knew I was going to come around to that, didn't you???
>
> I googled for Digital System Relational Interface and there wasn't
> much. Might you be able to find some on-line references?
>
>
> Marshall
>
While chasing around for DSRI documentation, I ran across this paper http://www.hpl.hp.com/hpjournal/dtj/vol7num1/vol7num1art1.txt
In the bilbiography, it mentions the DSRI handbook. That probably has what you asked me for, but I haven't found that online. The best bet is to start at www.oracle.com/rdb and navigate down to DSRI.
I'm interested in the subject matter of the above paper for different reasons. Received on Thu Aug 10 2006 - 13:47:12 CEST