Techniques for query homogenization in cache operations

A computer-program product tangibly embodied in a non-transitory machine-readable storage medium, the computer-program product including instructions operable to cause a processor component to perform operations including:

• receive query instructions executable to retrieve and process data items from a data set for a new database query, wherein the data items are organized within the data set according to an index comprising index labels;
• perform operations to generate homogenized instructions from the query instructions, including:
• identify a declaration instruction within the query instructions that declares an object, names the object and associates the object with an index label of the data set;
• replace the name provided to the object in the declaration instruction with an archetypal name based on the index label;
• and
• generate change data that associates the name provided to the object in the declaration instruction with the archetypal name;
• take an instruction hash of the homogenized instructions;
• compare the instruction hash to a plurality of instruction hashes of a results cache, wherein each instruction hash of the plurality of instruction hashes corresponds to a cached result of an earlier database query;
• and
• in response to a determination that the instruction hash of the homogenized instructions matches an instruction hash of the plurality of instruction hashes, perform operations including:
• retrieve a cached result from an entry of the results cache associated with the matching instruction hash of the plurality of instruction hashes;
• and
• replace a name of an object within the retrieved cached result based on the change data and the query instructions to generate a new result of the new database query.

A computer-implemented method comprising:

• receiving, at a computing device, query instructions executable to retrieve and process data items from a data set for a new database query, wherein the data items are organized within the data set according to an index comprising index labels;
• identifying a declaration instruction within the query instructions that declares an object, names the object and associates the object with an index label of the data set;
• replacing the name provided to the object in the declaration instruction with an archetypal name based on the index label to generate homogenized instructions from the query instructions;
• generating change data that associates the name provided to the object in the declaration instruction with the archetypal name;
• take an instruction hash of the homogenized instructions;
• comparing the instruction hash to a plurality of instruction hashes of a results cache, wherein each instruction hash of the plurality of instruction hashes corresponds to a cached result of an earlier database query;
• and
• in response to a determination that the instruction hash of the homogenized instructions matches an instruction hash of the plurality of instruction hashes, retrieving a cached result from an entry of the results cache associated with the matching instruction hash, and replacing a name of an object within the retrieved cached result based on the change data and the query instructions to generate a new result of the new database query.