Autonomic caching for in memory data grid query processing

An in memory data grid (IMDG) data processing system comprising:

• a host computing system comprising at least one computer with at least one processor and a memory;
• an IMDG disposed in the host computing system;
• and,
• a proxy cache module comprising program code that when executed on the host computing system causes the host computing system to:
• receive in the IMDG from a client of the IMDG a request for a primary query, wherein the request for the primary query is received in a proxy to the IMDG that provides catching of query results, wherein the proxy cache module is disposed within the IMDG;
• monitor resource utilization in the IMDG;
• identify within a query/sub-query table that is dynamically constructed over time as initial queries and follow-on sub-queries are directed in the IMDG, both the primary query, and also a sub-query that uses a portion of a result set from a previously requested invocation of the primary query, the sub-query being related to the primary query based upon the use by the sub-query of a portion of a result set from a previously requested primary query, the previously requested sub-query is associated with the primary query in reference to fields of the primary query upon which the sub-query is based;
• direct concurrently both an invocation of the primary query and also an invocation of the sub-query without waiting to receive a request for the sub-query from the client,
• perform the associating of the primary query with the previously requested sub-query, and the concurrent directing of the sub-query in response to the monitored resource utilization falling below a threshold value indicating available resource utilization;
• and
• cache query results of both the primary query and the sub-query subsequent to a completion of the primary query.

A computer program product for autonomic caching in an in memory data grid (IMDG), the computer program product comprising:

• a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising:
• computer readable program code for receiving in the IMDG from a client of the IMDG a request for a primary query, wherein the request for the primary query is received in a proxy to the IMDG that provides caching of query results;
• computer readable program code for monitoring resource utilization in the IMDG;
• computer readable program code for identifying within a query/sub-query table that is dynamically constructed over time as initial queries and follow-on sub-queries are directed in the IMDG, both the primary query, and also a sub-query that uses a portion of a result set from a previously requested invocation of the primary query, the sub-query being related to the primary query based upon the use by the sub-query of a portion of a result set from a previously requested primary query, wherein the previously requested sub-query is associated with the primary query in reference to fields of the primary query upon which the sub-query is based;
• computer readable program code for directing concurrently both an invocation of the primary query and also an invocation of the sub-query without waiting to receive a request for the sub-query from the client;
• computer readable program code for performing the associating of the primary query with the previously requested sub-query, and the concurrent directing of the sub-query in response to the monitored resource utilization falling below a threshold value indicating available resource utilization;
• and,
• computer readable program code for caching query results of both the primary query and the sub-query subsequent to a completion of the primary query.