Sergey Prokhorenko

What about account or license number (hash) for the DBMS or operating system? But I still believe that random number is more convenient.

The local entity type (10 bit) (i.e. database table alias) as a last field of UUID would be a convinient additional "shared knowledge". It can be used to quickly find...

These values can be used as "shared knowledge": - [Shard](https://en.wikipedia.org/wiki/Shard_(database_architecture)) or [Horizontal partitioning tag](https://en.wikipedia.org/wiki/Partition_(database)#Partitioning_methods) - [Hash](https://en.wikipedia.org/wiki/Hash_function) of source system name - [Entity type (i.e. database table alias)](https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model). This optional field...

@broofa , what is the reason of your dislike?

@broofa I understand your motives. Almost everyone hates the world of large corporations. I, too, like you. But we have to live with them and try to meet their needs,...

@broofa, "shared knowledge" (in the network) is a broader concept than "central authority"

> If you want to argue your example is relevant to UUIDs, you''ll need to point to some central authority that is responsible for allocating db table name identifiers to...

@fluffy > ...Today most those devices have hardware RNG support... Do you mean [Hardware random number generator](https://en.wikipedia.org/wiki/Hardware_random_number_generator)? It would be great to use it to generate the "[seed](https://en.wikipedia.org/wiki/Random_seed)" for a...

You probably haven't seen chaos in databases with compound business keys. Often, incomplete compound keys are used for relationships between tables, hoping for luck. Such databases are definitely unsafe. UUIDs...

> > UUIDs are designed to displace compound business keys > > UUIDs are designed to provide IDs that satisfy certain key criteria. To the extent such criteria make them...