Pattern for integrating primary and secondary data stores in a sharded data domain

A method comprising:

• receiving, by a data access logic (DAL) framework comprising one or more processors, a request for a read operation of a record, the DAL framework managing cache persistence associated with a sharded database, a level 2 (L2) cache, and an alternative key global indexes (AKGI) database;
• determining whether the L2 cache includes the record;
• and
• in response to a determination that the L2 cache includes the record:
• generating an alternative key (AK) hash value associated with the record,
• searching the L2 cache to identify a primary key (PK) associated with the record using the AK hash value, and
• retrieving the record using the PK value.

An apparatus comprising:

• a memory configured to store data and one or more sets of instructions;
• and
• one or more processors coupled to the memory, the one or more processors configured to execute the one or more sets of instructions and perform operations comprising:
• receiving a request for a write operation of a record in a level 2 (L2) cache associated with a sharded database and an alternative key global indexes (AKGI) database;
• determining whether the L2 cache includes the record;
• and
• in response to a determination that the L2 cache includes the record:
• initializing the L2 cache by updating metadata of the record in the L2 cache, the metadata including a primary key (PK) associated with the record and an alternative key (AK) hash value associated with the record,
• performing, based on the PK and the AK hash value, a write operation of the record in the AKGI database and the sharded database, respectively, and
• updating content data of the record in the L2 cache in response to determining that the write operation is successfully completed.