Jared is correct:
There is no database in the marketplace today that conforms to the 12
rules established by E.F. Codd's paper on relational theory. Many have
tried, however, trying to achieve 10, 11, & 12 have been very difficult.
Because of the "openness" of our market, it may be quite some time before we
achieve the complexity defined by Codd.
Several students in my data modeling classes asked the same question
years ago. They were disheartened that no one has achieved this in 25
years.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web: www.compuware.com
-----Original Message-----
Sent: Saturday, January 19, 2002 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Codde's Rules and Oracle
for 11 it depends on how you define user I think. If the DBA has set up
the synonyms, db links etc properly then any OTHER user would not
necesssarily know the database is distributed
--- Jared Still <[EMAIL PROTECTED]> wrote:
>
> Here's a URL for a list of the rules:
>
> http://luna.pepperdine.edu/~ckettemb/class/Codd12R.html
>
> After taking a quick glance at the rules, I think that Oracle fails
> on 7 and 11, probably others, but those were the ones that stood
> out without too much pondering. :)
>
> Jared
>
> On Friday 18 January 2002 09:51, [EMAIL PROTECTED] wrote:
> > No.
> >
> > In fact, I don't believe that there is a database in existence that
> > does conform to all 12 rules.
> >
> > I'll let someone else answer the hard part, just not enough time
> for that.
> >
> > Jared
> >
> >
> >
> >
> >
> > "Vikas S" <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 01/18/02 02:30 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > cc:
> > Subject: Codde's Rules and Oracle
> >
> >
> >
> > Dear All,
> >
> > Does Oracle confirm to all 12 Codde's Rules. Can
> anyone
> > point out the Rules violated by each version (6/7/8/9) of Oracle.
> >
> > Thanks,
> > Vikas
> >
> >
> >
> > _________________________________________________________________
> > Chat with friends online, try MSN Messenger:
> http://messenger.msn.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Karniotis, Stephen
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
