Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Codd's rules

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
iknow

Active User


Joined: 22 Aug 2005
Posts: 413
Location: Colarado, US

PostPosted: Thu Oct 13, 2005 8:07 am    Post subject: DB2 Codd's rules
Reply with quote

Hi folks
I came to know that DB2 is the first RDBMS at the mainframe end. Can anyone tell me like how many CODD'S rules does DB2 satisfies. If possible please list out the rules so that it would be really helpful for me.
Back to top
View user's profile Send private message

jeyakanthan

New User


Joined: 18 May 2005
Posts: 12
Location: chennai

PostPosted: Thu Oct 13, 2005 12:31 pm    Post subject: Re: DB2-Codd's rules
Reply with quote

Dr. E.F. Codd, an IBM researcher, first developed the relational data model in 1970. In 1985, Dr. Codd published a list of 12 rules that concisely define an ideal relational database, which have provided a guideline for the design of all relational database systems ever since.

Code:

Rule 1: The Information Rule
All data should be presented to the user in table form. Last week's newsletter already discussed the basics of this rule.

Rule 2: Guaranteed Access Rule
All data should be accessible without ambiguity. This can be accomplished through a combination of the table name, primary key, and column name.

Rule 3: Systematic Treatment of Null Values
A field should be allowed to remain empty. This involves the support of a null value, which is distinct from an empty string or a number with a value of zero. Of course, this can't apply to primary keys. In addition, most database implementations support the concept of a nun- null field constraint that prevents null values in a specific table column.

Rule 4: Dynamic On-Line Catalog Based on the Relational Model A relational database must provide access to its structure through the same tools that are used to access the data. This is usually accomplished by storing the structure definition within special system tables.

Rule 5: Comprehensive Data Sublanguage Rule
The database must support at least one clearly defined language that includes functionality for data definition, data manipulation, data integrity, and database transaction control. All commercial relational databases use forms of the standard SQL (Structured Query Language) as their supported comprehensive language.

Rule 6: View Updating Rule
Data can be presented to the user in different logical combinations, called views. Each view should support the same full range of data manipulation that direct-access to a table has available. In practice, providing update and delete access to logical views is difficult and is not fully supported by any current database.

Rule 7: High-level Insert, Update, and Delete
Data can be retrieved from a relational database in sets constructed of data from multiple rows and/or multiple tables. This rule states that insert, update, and delete operations should be supported for any retrievable set rather than just for a single row in a single table.

Rule 8: Physical Data Independence
The user is isolated from the physical method of storing and retrieving information from the database. Changes can be made to the underlying architecture ( hardware, disk storage methods ) without affecting how the user accesses it.

Rule 9: Logical Data Independence
How a user views data should not change when the logical structure (tables structure) of the database changes. This rule is particularly difficult to satisfy. Most databases rely on strong ties between the user view of the data and the actual structure of the underlying tables.

Rule 10: Integrity Independence
The database language (like SQL) should support constraints on user input that maintain database integrity. This rule is not fully implemented by most major vendors. At a minimum, all databases do preserve two constraints through SQL.

No component of a primary key can have a null value. (see rule 3)
If a foreign key is defined in one table, any value in it must exist as a primary key in another table.
Rule 11: Distribution Independence
A user should be totally unaware of whether or not the database is distributed (whether parts of the database exist in multiple locations). A variety of reasons make this rule difficult to implement; I will spend time addressing these reasons when we discuss distributed databases.

Rule 12: Nonsubversion Rule
There should be no way to modify the database structure other than through the multiple row database language (like SQL). Most databases today support administrative tools that allow some direct manipulation of the datastructure.
Back to top
View user's profile Send private message
iknow

Active User


Joined: 22 Aug 2005
Posts: 413
Location: Colarado, US

PostPosted: Mon Dec 05, 2005 8:33 pm    Post subject: Re: DB2-Codd's rules
Reply with quote

Hi Jeyakanthan,

Thanks for information. But could you please tell me that whether there exists ZEROth rule.

To my understanding

Code:
ZEROth Rule

DB2, it has to be relational.



Let me know in case of any concerns.
Back to top
View user's profile Send private message
bhoompallipraveen

New User


Joined: 07 Dec 2005
Posts: 6

PostPosted: Fri Dec 30, 2005 12:13 pm    Post subject:
Reply with quote

Hi jeyakanthan,

How many CODD rules does DB2 supports?? And what is the min number that RDBMS package has to suppot??

Pls give me the number

Regds
Praveen
Back to top
View user's profile Send private message
iknow

Active User


Joined: 22 Aug 2005
Posts: 413
Location: Colarado, US

PostPosted: Fri Dec 30, 2005 6:02 pm    Post subject: Re: DB2-Codd's rules
Reply with quote

Hi,

I think it supports 11 Codd's rules.

Version must also taken into consideration.


Every RDBMS package supports more than 7 CODD's rules.


Correct me if I am wrong.
Back to top
View user's profile Send private message
ranjitbhingare

New User


Joined: 30 Nov 2005
Posts: 94
Location: PUNE

PostPosted: Tue Feb 14, 2006 10:48 pm    Post subject:
Reply with quote

DB2 supports 10.5 rules. It partially supports rule 6 and does not support Rule 11.
Back to top
View user's profile Send private message
small_world

New User


Joined: 22 Jul 2005
Posts: 24
Location: pune

PostPosted: Tue Feb 21, 2006 12:08 pm    Post subject:
Reply with quote

Hi,
There are 12 Codd's Rule (Plus one)

Codd's Rule Zero.
the information rule
the guaranteed access rule
systematictreatment of nulls
active online catalog based on the relational model
the comprehensive data sub-languagerule
the view updating rule
high level inser update and delete
physical data independence
logical data independence
integrity independence
distribution independence
the non subversion rule

icon_wink.gif
Back to top
View user's profile Send private message
asifaddy
Warnings : 1

New User


Joined: 06 Feb 2007
Posts: 5
Location: Bangalore

PostPosted: Thu Mar 01, 2007 10:20 am    Post subject: Codd's Rule Zero.
Reply with quote

RULE 0 or CODD'S RULE ZERO or ZEROth RULE : this rule states that all subsequent rules are based on the notion that in order for a database to be considered relational, it must use its relational facilities exclusively to manage the database.
Back to top
View user's profile Send private message
dr_te_z

New User


Joined: 08 Jun 2007
Posts: 71
Location: Zoetermeer, the Netherlands

PostPosted: Mon Jun 18, 2007 1:54 pm    Post subject:
Reply with quote

Hmm. IBM added the XML column in V9. Therefore the content of a column is no longer 1 atomic value...(they just sqeezed a subset of IMS in that column)

I wonder: can DB2 still be concedered as a pure-relational database? Might that be the reason why IBM is referring to DB2 as: database-engine?
Back to top
View user's profile Send private message
ILdba

New User


Joined: 11 Feb 2010
Posts: 3
Location: Illinois, USA

PostPosted: Fri Feb 19, 2010 2:09 am    Post subject:
Reply with quote

The "zero rule" was added to keep vendors of non-relational products from adding SQL to their product and calling it relational.

The FUN part of the 0 rule is that everything IBM is zero relative; counting does not start with one.
Back to top
View user's profile Send private message
Maddipatla Rajasekhar

New User


Joined: 10 Mar 2009
Posts: 16
Location: Hyderabad

PostPosted: Wed Nov 03, 2010 6:10 pm    Post subject:
Reply with quote

For any database to be considered as a RDBMS, it has to satisfy atleast 6 CODD rules

Regards
Raj Maddipatla
Back to top
View user's profile Send private message
Jim Herrmann

New User


Joined: 09 Apr 2013
Posts: 3
Location: US

PostPosted: Mon May 06, 2013 8:02 pm    Post subject:
Reply with quote

ranjitbhingare wrote:
DB2 supports 10.5 rules. It partially supports rule 6 and does not support Rule 11.

It does support rule 11 via nicknames and aliases.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Rules for evaluating JES output to de... AntonioS JCL & VSAM 9 Wed Jul 01, 2015 2:03 am
No new posts racf password complexity rules Ismael Vazquez All Other Mainframe Topics 13 Thu Apr 21, 2011 12:49 am
No new posts need to update ACF2 rules ! rohanthengal CA Products 1 Wed Apr 20, 2011 4:01 pm
No new posts Rules for boys to score... Anuj Dhawan General Talk & Fun Stuff 12 Tue Oct 05, 2010 8:14 pm
No new posts SMS ML2 deletitions - RACF rules non-... BobGilbert JCL & VSAM 8 Fri Feb 19, 2010 9:42 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us