Building and using combined multi-type sub-indices to search NoSQL databases

A computer system for building and using multiple different types of sub-indices to search a database, the computer system comprising:

• a bus system;
• a storage device connected to the bus system, wherein the storage device stores program instructions;
• and
• a processor connected to the bus system, wherein the processor executes the program instructions to:
• generate a plurality of different physical data ranges within the database based on a set of logical hot data ranges and a set of logical non-hot data ranges of a plurality of different logical data ranges to form a set of physical hot data ranges and a set of physical non-hot data ranges;
• build a set of sub-index types for each respective data range of the plurality of different physical data ranges within the database, wherein the set of sub-index types includes a set of selected high-speed sub-index types for the set of physical hot data ranges and includes a second set of selected sub-index types for the set of physical non-hot data ranges to accelerate data availability for query, wherein the set of selected high-speed sub-index types are different from the second set of selected sub-index types;
• build an index for the database using the set of sub-index types built for each respective data range of the plurality of different physical data ranges within the database;
• receive a query of a particular search type requesting to perform an action on a physical data range within the database;
• generate a result for the query based on a search of that physical data range within the database;
• and
• output the result for the query.

A computer program product for building and using multiple different types of sub-indices to search a database, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a computer to cause the computer to perform a method of:

• generating, by the computer, a plurality of different physical data ranges within the database based on a set of logical hot data ranges and a set of logical non-hot data ranges of a plurality of different logical data ranges to form a set of physical hot data ranges and a set of physical non-hot data ranges;
• building, by the computer, a set of sub-index types for each respective data range of the plurality of different physical data ranges within the database, wherein the set of sub-index types includes a set of selected high-speed sub-index types for the set of physical hot data ranges and includes a second set of selected sub-index types for the set of physical non-hot data ranges to accelerate data availability for query, wherein the set of selected high-speed sub-index types are different from the second set of selected sub-index types;
• building, by the computer, an index for the database using the set of sub-index types built for each respective data range of the plurality of different physical data ranges within the database;
• receiving, by the computer, a query of a particular search type requesting to perform an action on a physical data range within the database on the computer;
• generating, by the computer, a result for the query based on a search of that physical data range within the database;
• and
• outputting, by the computer, the result for the query.