RE: Codde's Rules and Oracle

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Mon, 21 Jan 2002 06:34:26 -0800
Message-ID: <F001.003F5B14.20020121061029@fatcity.com>

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: Stephen.Karniotis_at_Compuware.com
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 <jkstill_at_cybcon.com> 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, Jared.Still_at_radisys.com 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" <vikas_s40_at_hotmail.com>
  > > Sent by: root_at_fatcity.com
  > > 01/18/02 02:30 AM
  > > Please respond to ORACLE-L
  > >
  > >
  > > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > > 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: jkstill_at_cybcon.com
  >
  > 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com

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: ListGuru_at_fatcity.com (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: Stephen_Karniotis_at_compuware.com

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: ListGuru_at_fatcity.com (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).

Received on Mon Jan 21 2002 - 08:34:26 CST