Shard Optimization for Parameter-Based Indices

A system for querying a searchable database comprised of multiple data-segments, the system comprising:

• a processor;
• and
• a memory communicatively coupled to the processor, the memory storing instructions executable by the processor to perform a method comprising:
• receiving a database query including at least one index parameter and an index parameter criteria;
• accessing a parameter table of data-segments comprising one or more associated index parameters;
• determining a set of relevant data-segments from the parameter table meeting the index parameter criteria;
• and
• performing a query on the set relevant data-segments.

A non-transitory computer-readable storage medium having embodied thereon instructions, which when executed by at least one processor, perform steps of a method, the method comprising:

• a processor;
• and
• a memory communicatively coupled to the processor, the memory storing instructions executable by the processor to perform a method comprising:
• receiving a database query including at least one index parameter and an index parameter range;
• accessing a parameter table of shards comprising one or more associated index parameters;
• determining a set of relevant shards from the parameter table meeting the index parameter range;
• and
• performing a query on the set relevant shards.