Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Jun 2004 @ 07:51:55 GMT


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


Subj:   Re: Exclusion Joins
 
From:   Victor Sokovin

Jim,

  For close to 20 years I have been telling Teradata technicians to avoid using nulls in their databases. There is a place for nulls, but not what I find in customer developed applications.  


It might be difficult at times but it should be possible to build a database without NULLs in the tables. However, NULLs will soon appear in intermediate data sets in SQL queries. For example, in outer joins. I think NULL is a mathematical necessity required by the algebraic model used in relational databases. We might try to give them different names but at the end of the day there will emerge something which mathematicians might call an isomorphic algebra. Until some significant progress is made in the current algebraic model there will be no progress in the isomorphic one. I am not aware of any alternative working algebraic model which would deliver consistently better results.

It would be difficult to get rid of such constructs as outer joins. Many users like to use them because they have to work with different RDBMS, and on some platforms outer joins are rather efficient.

Just a few thoughts on the topic. It would be interesting to hear your comments on them.


Regards,

Victor



     
  <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: 27 Dec 2016