Systems and methods for shard-based data indexing and retrieval in multi-key environments

A computer program product for shard-based data indexing and retrieval in multi-key environments the computer program product comprising a non-transitory computer-readable medium comprising code causing an apparatus to:

• receive input data for the creation or addition of a key to a database record;
• compute a shard key hash based on the input data;
• access a shard directory within a sharded database environment to determine if the computed shard key hash exists within the shard directory;
• perform a search operation by receiving a search query comprising a single domain and a single key type, locating a shard key hash in the shard directory corresponding to the single domain and the single key type, and executing a targeted search in the sharded database environment using the located shard key hash when the search query is associated with a single key;
• update the database record by receiving updated data, locating an existing shard key hash from the shard directory;
• modify the database record and the shard directory entry to reflect the updated data;
• delete the database record by identifying the database record to be deleted, locating an associated shard key hash in the shard directory, and removing the database record and the corresponding shard directory entry;
• and
• maintain each shard key hash as immutable with a single database record or a set of records sharing the single domain and the single key type.

A method for shard-based data indexing and retrieval in multi-key environments the method comprising:

• providing a computing system comprising a computer processing device and a non-transitory computer readable medium, where the computer readable medium comprises configured computer program instruction code, such that when said instruction code is operated by said computer processing device, said computer processing device performs the following operations:
• receiving input data for the creation or addition of a key to a database record;
• computing a shard key hash based on the input data;
• accessing a shard directory within a sharded database environment to determine if the computed shard key hash exists within the shard directory;
• performing a search operation by receiving a search query comprising a single domain and a single key type, locating a shard key hash in the shard directory corresponding to the single domain and the single key type, and executing a targeted search in the sharded database environment using the located shard key hash when the search query is associated with a single key;
• updating the database record by receiving updated data, locating an existing shard key hash from the shard directory;
• modifying the database record and the shard directory entry to reflect the updated data;
• deleting the database record by identifying the database record to be deleted, locating an associated shard key hash in the shard directory, and removing the database record and the corresponding shard directory entry;
• and
• maintaining each shard key hash as immutable with a single database record or a set of records sharing the single domain and the single key type.