From oracle-l-bounce@freelists.org Mon Apr 26 06:34:13 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3QBXm511908 for ; Mon, 26 Apr 2004 06:33:58 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3QBXb611886 for ; Mon, 26 Apr 2004 06:33:47 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A044E72CD04; Mon, 26 Apr 2004 06:25:55 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01946-28; Mon, 26 Apr 2004 06:25:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E825B72CCED; Mon, 26 Apr 2004 06:25:54 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Apr 2004 06:24:44 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 98B0672CB88 for ; Mon, 26 Apr 2004 06:24:43 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32102-77 for ; Mon, 26 Apr 2004 06:24:43 -0500 (EST) Received: from gizmo10bw.bigpond.com (gizmo10bw.bigpond.com [144.140.70.20]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 119A672CB70 for ; Mon, 26 Apr 2004 06:24:42 -0500 (EST) Received: (qmail 8021 invoked from network); 26 Apr 2004 11:31:59 -0000 Received: from unknown (HELO bwmam10.bigpond.com) (144.135.24.97) by gizmo10bw.bigpond.com with SMTP; 26 Apr 2004 11:31:59 -0000 Received: from cpe-138-130-85-109.nsw.bigpond.net.au ([138.130.85.109]) by bwmam10.bigpond.com(MAM REL_3_4_2 171/22018148) with SMTP id 22018148; Mon, 26 Apr 2004 21:37:02 +1000 Message-ID: <005c01c42b82$c4b5d410$0100000a@yourns7nxr4r4g> From: "Douglas Hawthorne" To: References: <03a801c42b7c$ac9b8970$63000050@newserver> <004b01c42b7f$8380e500$ed869fd9@porgand> Subject: Re: EF CODE RULES Date: Mon, 26 Apr 2004 21:36:51 +1000 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3739 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dfhawthorne@computer.org Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Tanel, At http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:945283422677 , Thomas Kyte says of the E.F.Codd Rules: "I would say we satisfy (if you do not use ANY of the object relational stuff) 1.1 The foundation rule 1.2 Information rule 1.3 Guaranteed access rule 1.5 Dynamic catalogue rule 1.6 Comprehensive data sub-language rule 1.7 View updating rule ** v8 and up ** 1.8 High-level language rule 1.9 Physical data independence rule 1.10 Logical data independence rule 1.11 Integrity independence rule 1.12 Distribution independence rule 1.13 Non-subversion rule the one we don't is: 1.4 Systematic nulls rule Null values are distinct from an empty character string, a string of blank characters, a zero or any other number, and must be supported by representing missing and/or inapplicable information in a systematic way. the empty character string in general is treated as a NULL in Oracle." Douglas Hawthorne ----- Original Message ----- From: "Tanel Põder" To: Sent: Monday, April 26, 2004 9:13 PM Subject: Re: EF CODE RULES > Oracle doesn't satisfy any of the EF code rules, since there is no such > thing as an EF code rule. > > If you were talking about 12 relational database rules written by E.F. Codd, > then I'd guess that Oracle fully complies only to 4-5 rules (all data has to > be stored in form of tables, special treatment of null values, physical data > independence etc), but others are only partially "supported". > > Tanel. > > ----- Original Message ----- > From: "Computer Centre - NIIPL" > To: "ORALCE LIST" > Sent: Monday, April 26, 2004 1:53 PM > Subject: EF CODE RULES > > > > hi gurus, > > the 12 EF code rules in DBMS how many does oracle 8i satisfy > and > > how many does oracle on the whole satisfy. can any one help me out. > > Thanks in advance > > > > form, > > afsar > > This mail is scaned by eScan Anti Virus Software > > > > > > > > > > ---------------------------------------------------------------- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > ---------------------------------------------------------------- > > To unsubscribe send email to: oracle-l-request@freelists.org > > put 'unsubscribe' in the subject line. > > -- > > Archives are at http://www.freelists.org/archives/oracle-l/ > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html > > ----------------------------------------------------------------- > > > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/ > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------