Database sharding based on a universally unique identifier (UUID)

A system, comprising:

• a processor configured to:
• receive a database record having a unique identifier including a universally unique identifier (UUID) compatible with at least Version 8, wherein the unique identifier comprises a first bit-field encoding an organization identifier and a second bit-field encoding a secondary identifier, wherein the unique identifier is utilized to uniquely identify the database record among other database records;
• extract, for database sharding, the first bit-field and the second bit-field from the unique identifier;
• identify a corresponding database shard for the database record based on the first bit-field and the second bit-field and a hierarchical relationship between the first bit-field encoding the organization identifier and the second bit-field encoding the secondary identifier, wherein the unique identifier of the first bit-field and the second bit-field is a primary key that is a shard key such that the corresponding database shard is identified independent of a hash function;
• and
• route the database record to the corresponding database shard for database storage balancing;
• and
• a memory coupled to the processor and configured to provide the processor with instructions.

A computer program product embodied in a non-transitory computer readable medium and comprising computer instructions for:

• receiving a database record having a unique identifier including a universally unique identifier (UUID) compatible with at least Version 8, wherein the unique identifier comprises a first bit-field encoding an organization identifier and a second bit-field encoding a secondary identifier, wherein the unique identifier is utilized to uniquely identify the database record among other database records;
• extracting, for database sharding, the first bit-field and the second bit-field from the unique identifier;
• identifying a corresponding database shard for the database record based on the first bit-field and the second bit-field and a hierarchical relationship between the first bit-field encoding the organization identifier and the second bit-field encoding the secondary identifier, wherein the unique identifier of the first bit-field and the second bit-field is a primary key that is a shard key such that the corresponding database shard is identified independent of a hash function;
• and
• routing the database record to the corresponding database shard for database storage balancing.