Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 27 Jul 2012 @ 13:45:32 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Codd's rules in teradata
From:   Dieter Noeth

sughesh iyyani wrote:

  We know Teradata satisfies 11.5 or 12 codd rules.  

I don't ;-)

At least i don't know how many are satisfied by Teradata, but i would expect less than that.

  Kindly let me know what is meant by Codd rule?  


A quick check shows at least two broken rules:

Rule 2: The guaranteed access rule -> broken by MULTISET tables

Rule 6: The view updating rule -> only very basic views can be updated

Most RDBMSes break those rules, too.

  If a RDBMS satisfies 12 codd rules, what exactly meant by that?  

It's a fully relational DBMS according to Codd's Relational Model.

Some people argue that none of the existing RDBMSes are truly relational based on flaws in implementations and SQL:



Of course they're right, but until there's a "real" RDBMS we have to work with existig implementations :-)


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020