Application-transparent deployment-aware identifier encoding for database consolidation

A method comprising:

• receiving, by an identifier translation component executing on one or more processors, a request for executing a database operation from an application layer, the request including an application identifier in an application identifier format, wherein the application identifier is an integer identifier;
• determining, by the identifier translation component, a deployment identifier associated with the database operation based on the request, wherein the deployment identifier identifies a source deployment from among a plurality of source deployments;
• generating, by the identifier translation component, a database identifier by applying an encoding function to the application identifier and the deployment identifier, wherein the database identifier is a globally unique integer identifier across the plurality of source deployments, and wherein the encoding function packs the deployment identifier and the application identifier into a fixed-width integer;
• and
• executing the database operation in a consolidated database using the database identifier.

A non-transitory computer-readable medium storing instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:

• receiving a request for executing a database operation from an application, the request including an application identifier in an application identifier format, wherein the application identifier is an integer identifier used by the application;
• obtaining a deployment identifier associated with the database operation based on a context associated with the request, wherein the deployment identifier distinguishes a source deployment from other source deployments in a multi-deployment environment;
• generating a database identifier by applying a deterministic encoding function to the application identifier and the deployment identifier, wherein the deterministic encoding function packs the deployment identifier and the application identifier into a fixed-width integer, and wherein the database identifier is globally unique across the multi-deployment environment;
• and
• executing the database operation in a consolidated database using the database identifier.