Method and apparatus for generating an intelligent primary key facilitating faster object retrieval

An apparatus comprising at least one processor and at least one memory including computer program code, the at least one memory and the computer program code configured to, with the processor, cause the apparatus to at least:

• receive at least:
• (1) identification information;
• (2) an account type;
• and
• (3) realm information;
• apply a deterministic hash function to the received identification information, the account type, and the realm information to establish a first composite key, wherein the first composite key is a hash of the identification information, the account type, and the realm information;
• perform a single database search in response to establishing the first composite key for a matching composite key for correlation with the first composite key;
• in direct response to correlating the first composite key with a matching composite key in the single database, provide an indication of a conflict with an existing account to a user;
• and
• in response to failing to correlate the first composite key with a matching key, provide for creation of a user linked account, wherein the user linked account provides a realm-dependent user experience, and wherein the user linked account is partitioned according to the realm information.

A computer program product comprising at least one non-transitory computer-readable storage medium having computer-executable program code instructions stored therein, the computer-executable program code instructions comprising program code instructions to:

• receive at least:
• (1) identification information;
• (2) an account type;
• and
• (3) realm information;
• apply a deterministic hash function to the received identification information, the account type, and the realm information to establish a first composite key, wherein the first composite key is a hash of the identification information, the account type, and the realm information;
• perform a single database search in response to establishing the first composite key for a matching composite key for correlation with the first composite key;
• in direct response to correlating the first composite key with a matching composite key in the single database, provide an indication of a conflict with an existing account to a user;
• and
• in response to failing to correlate the first composite key with a matching key, provide for creation of a user linked account, wherein the user linked account provides a realm-dependent user experience, and wherein the user linked account is partitioned according to the realm information.