| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: EF CODE RULES
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
> 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" <compute_at_ponyneedles.com>
> To: "ORALCE LIST" <oracle-l_at_freelists.org>
> 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_at_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_at_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
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Apr 26 2004 - 06:34:13 CDT
 |
 |