6.0. References

References

1. Universally unique identifier. Wikipedia.

2. A Universally Unique IDentifier (UUID). RFC-4122.

3. To UUID or not to UUID?

4. Store UUID in an optimized way.

5. UUID "Version 6": the version RFC 4122 forgot.

6. DCE 1.1: Security-Version (Version 2) UUIDs. The Open Group.

7. The Cost of GUIDs as Primary Keys (COMB Algorithm)

8. How to Generate Sequential GUIDs for SQL Server in .NET

9. ULID Specification - Universally Unique Lexicographically Sortable Identifier

10. Sequential UUID Generators

Classic implementations

• Linux Kernel's unified UUID/GUID definition
• Util-Linux's Universally Unique ID Library
• Apple Computer's modifications "to make this thing work on the Macintosh"
• Boost C++ Libraries' UUID Module
• CERN's ROOT Library TUUID Class

More links about UUID

• ISO/IEC 9834-8:2014 (only a preview)

• How to Do UUID as Primary Keys the Right Way

• A brief history of the UUID

• A (real) Brief History of the UUID

• Syntax and semantics of the DCE variant of Universal Unique Identifiers (The OpenGroup)

• How is a Time-based UUID / GUID made

• Sequential UUID Generators

• Sequential UUID Generators on SSD

• Be Careful with UUID or GUID as Primary Keys

• Ordered-uuid - npmjs package

• To UUID or not to UUID

• Primary Keys: IDs versus GUIDs

• GUIDs are globally unique, but substrings of GUIDs aren’t

• MySQL Performance When Using UUID For Primary Key

• What are the performance improvement of Sequential Guid over standard Guid?

• Auto increment keys vs. UUID

• GUIDs as fast primary keys under multiple databases

• Do you really need a UUID/GUID?

• Oracle Universal Unique Identifier

• Oracle Reference 12c - SYS_GUID

• Why Auto Increment Is A Terrible Idea

• Sequential UUID based entity key generator - COMB GUID

• UUID Collisions

• Has there ever been a UUID collision?

• The article contains a footnote about UUIDs as primary keys

• Software engineer — from monolith to cloud: Auto Increment to UUID

• When are you truly forced to use UUID as part of the design?

• How unique is UUID? - StackOverflow

• When does it make sense in a RDBMS to make your primary key a UUID rather than an int?

• Why aren't programmers comfortable with the uniqueness guarantee of UUID version 4?

• Is there any difference between a GUID and a UUID?

• UUID1 vs UUID4

• Probability of GUID collisions with different versions

• Are UUIDs really unique?

• How good is Java's UUID.randomUUID?

• ITU-T - ASN.1 PROJECT - Universally Unique Identifiers (UUIDs)

• GUID/UUID Performance - MariaDB

• Difference between CLOCK_REALTIME and CLOCK_MONOTONIC? (StackOverflow)

• Is System.currentTimeMillis() monotonically increasing? (StackOverflow)

• GUID structure (Microsoft)

• UUID structure (Microsoft)

• UuidCreate function (Microsoft)

• UuidCreateSequential function (Microsoft)

• GUID/UUID Performance Breakthrough

• Storing UUID Values in MySQL Tables

• Going deep on UUIDs and ULIDs

• The mysterious “Ordered UUID”

• UUID proposal for ECMAScript

• NPM UUID

• How does the Docker assign MAC addresses to containers?

• EcmaScript UUID Proposal

• User identifier (POSIX UID)

• Group identifier (POSIX GID)

• Name spaces

• Domain Name System

• URL;

• ISO Object identifier;

• X.500;

• How many ways are there to sort GUIDs? How much time do you have?

• How are GUIDs compared in SQL Server 2005?

• When are you truly forced to use UUID as part of the design?

• Python UUID Module to Generate Universally Unique Identifiers

• Java UUID generation – Performance impact

• How Secure Are Your Universally Unique IDentifiers - UUIDs

• Uniqueidentifier and Clustered Indexes

• ThechDictionary - Universally Unique Identifier

• ThechDictionary - Globally Unique Identifier