EF CODD RULES vs ORACLE

[gandhi]

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

[Tarry]

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.

[jrpm]

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.

[grjohnson]

I agree, it's is the DBA's interpretation of the rules and whether or not they are applied to a database's schema.

[gandhi]

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

[SANJAY_G]

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

[julian]

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.

[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

[julian]

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.

[Raminder]

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.