DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: EF CODD RULES vs ORACLE

  1. #1
    Join Date
    Nov 2000
    Posts
    101
    Dear Friends,

    We know Codd 12 Rules. How many rules are supported in Oracle 8. How many rules Oracle 8i/9i support.

    Thanks in Advance.



    gandhi

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    THERE ARE 13 OF THEM AND NOT 12.
    YOU CAN SAY ALL OF THEM IF YOU COMPARE THE RULES OUTLINE WITH WHAT ORACLE HAS TO OFFER.
    BUT OFCOURSE IT'S A BROADBASED QUESTION.
    YOU CAN DEBATE FOR HOURS ON THE INTERPRETATIONS OF ORACLE THAT ENHANCE IT'S SCALABILITY BY INNOVATIVE ENHANCEMENTS TO THE SQL WHETHER THEY GO OFFTANGENTS OR COMPLY THRU AND THRU WITH THE RULES.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    The question is more the DBA than the DBMS.

    Oracle can comply with the rules. The DBA has to design to them, and enforce the design to the programmers and other technical personnel.

    Which, in my experience, means more difficult maintenance and political turmoil. And worse performance.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  4. #4
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    I agree, it's is the DBA's interpretation of the rules and whether or not they are applied to a database's schema.
    OCP 8i, 9i DBA
    Brisbane Australia

  5. #5
    Join Date
    Nov 2000
    Posts
    101

    EF CODD vs ORACLE

    Thanks Friends,

    What i heard is Oralce8 Supports only 11 Rules. Except Non-subversion Rule.

    Because of Oracle 8i, Oralce reduced one more rule. So, Currently it supports only 10 Rules.

    Is it true.


    Thanks in Advance,
    gandhi

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Nonsubversion Rule:
    There should be no way to modify the database structure other than through the multiple row database language (like SQL).
    "Nonsubversion rule" is of not much significance in today's world. Most databases today support administrative tools that allow some direct manipulation of the datastructure.
    Many people may find the DBA tools faster and easier than command language (SQL).
    I think the Codd rules should be taken as guide lines and not standard.
    But.. true.. it can be debated for hours without any conclusion !!

    Sanjay

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    The rules are 12, not 13. You probably have heard of Rule Zero and that is why you think the rules are 13.

    "For any system that is claimed to be a relational database management system, that system must be able to manage data entirely through its relational capabilities."

    If you check Codd’s 12 rules and apply them in a way that you give 1 point if the DB fulfils the rule, 1/2 point if the DB fulfils the rule partially and 0 point otherwise, then Oracle 8 is top on the market with 8.5 points.

    It is funny that Oracle 7 fulfiled only 1 rule completely.



  8. #8
    Join Date
    Nov 2000
    Posts
    101

    EV CODD vs ORACLE

    Hi,

    I agree with Julian, Of course Oracle is the No. 1 database on the earth.

    But, Julian you meant to say that Overall Oracle supports only 8.5 Rules.

    Thanks in Advance
    gandhi

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: EV CODD vs ORACLE

    Originally posted by gandhi
    Hi,

    I agree with Julian, Of course Oracle is the No. 1 database on the earth.

    But, Julian you meant to say that Overall Oracle supports only 8.5 Rules.

    Thanks in Advance
    gandhi
    Oracle 8, I've never seen the statistics for 8i and 9i. Not 8.5 rules, all rules but not completely. In 5 rules, Oracle 8 gets only half a point and in one rule zero points.




  10. #10
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Originally posted by Sanjay:
    "Nonsubversion rule" is of not much significance in today's world. Most databases today support administrative tools that allow some direct manipulation of the datastructure.
    Many people may find the DBA tools faster and easier than command language (SQL).
    I think the Codd rules should be taken as guide lines and not standard.


    Codd did not ask you to use SQL. If we mortals have made an imperfect language to access the database, that does not mean that the rule itself is flawed.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width