Archives of the TeradataForum
Message Posted: Fri, 20 Nov 2009 @ 13:00:07 GMT
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
|