Subject Re: [Firebird-Architect] Re: GUID Key Fields
Author Alexandre Benson Smith
Hi Adem !

adem wrote:

>
>On the subject of 'cluster unique dentifiers':
>
>Take this as I am thinking aloud.
>
>First question: Is tehre a limit on the size of the identifier, if not:
>
>Why don't you let the 'cluster unique dentifiers' be composed of 2
>UUIDs (i.e. 128 + 128 bit number)?
>
>Which means, the first UUID half represents the cluster/node/CPU
>(whatever) ID, and the second UUID half is the record ID.
>
>Naturally, this is assuming UUIDs can be made unique enough (which I
>believe they can be).
>
>Or is this such a wild/unworkable idea?
>
>Cheers,
>Adem
>
>
Doesn't need to be 2 * 128 bits values, since a single 128 bit value é
enough to assure a unique identifier for every computer for at least
2030, even if each of this computers are generating thousands of Id's
per second.

64 bit is a huge number that I think I can't even spell it. The UUID was
designed to be unique among computers without a central management. so
part of the 128 bits are used to identify the computer itself (or as MS
have modified it to some random (?) number as pointed by Kevin), and the
rest for the unique ID inside this computer, the combination makes a
unique ID across the "entire universe".

256 bits is a very very big key, the indices will suffer this choice.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.5 - Release Date: 29/03/2005