Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 20 Nov 2009 @ 13:00:07 GMT


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


Subj:   Re: GUID/UUID generation in UDF
 
From:   Victor Sokovin

  We need an UDF (user defined function) to generate a Universally Unique IDentifiers (UUIDs).  


MD5 provides _almost_ unique identifiers in most practical applications. Have a look at the UDF available for download on the Teradata site: www.teradata.com/DownloadCenter.

Hash collisions (two distinct values mapped to the same hash) are unlikely but possible!

The mathematics of unique IDs in general is tough because of combinatorial complexity. If you scope your requirements to something more manageable then you can find a suitable algorithm.


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: 15 Jun 2023