AUTONOMIC CACHING FOR IN MEMORY DATA GRID QUERY PROCESSING

• US 20160117366A1
• Filed: 01/07/2016
• Published: 04/28/2016
• Est. Priority Date: 03/15/2012
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bhogal, Kulvir S., Gaur, Nitin, Johnson, Chris D., Kaplinger, Todd E.
• Granted Patent: US 10,540,353 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24539 using cached or materialised query results
• CPC Class Codes: G06F 2209/5013 Request control

Abstract

A method, system and computer program product for autonomic caching in an IMDG has been provided. A method for autonomic caching in an IMDG includes receiving from a client of the IMDG a request for a primary query in the IMDG. The method also includes associating the primary query with a previously requested sub-query related to the primary query. Finally, the method includes directing the sub-query concurrently with a directing of the primary query without waiting to receive a request for the sub-query from the client. In this way, the method can proactively predict a receipt of the request for a sub-query following a request for a primary query prior the actual receipt of the request for the sub-query.

Claims

1. A method for autonomic caching in an in memory data grid (IMDG), the method comprising:

receiving from a client of the IMDG a request for a primary query in the IMDG;

associating the primary query with a previously requested sub-query related to the primary query comprising determining that a sub-query uses a portion of a result set from a previously requested primary query;

directing the sub-query concurrently with a directing of the primary query without waiting to receive a request for the sub-query from the client; and

,

caching query results of the sub-query subsequent to a completion of the primary query.

2. The method of claim 1, 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.

3. The method of claim 1, wherein the request for the primary query is received in a proxy to the IMDG that provides caching of query results in order to satisfy received query requests.

4. The method of claim 1, further comprising:

monitoring resource utilization in the IMDG; and

,

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.

5. The method of claim 4, wherein the resource utilization is central processing unit (CPU) utilization.

6. The method of claim 4, wherein the resource utilization is memory utilization.

7. The method of claim 4, wherein the resource utilization is a request processing capacity for processing query requests.

8. 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 from a client of the IMDG a request for a primary query in the IMDG,

associate the primary query with a previously requested sub-query related to the primary query comprising determining that a sub-query uses a portion of a result set from a previously requested primary query,

direct the sub-query concurrently with a directing of the primary query without waiting to receive a request for the sub-query from the client, and

cache query results of the sub-query subsequent to a completion of the primary query.

9. The system of claim 8, 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.

10. The system of claim 8, wherein the proxy cache module is disposed within the IMDG.

11. The system of claim 8, the program code of the proxy cache module is further enabled to monitor resource utilization in the IMDG and to 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.

12. The system of claim 11, wherein the resource utilization is central processing unit (CPU) utilization.

13. The system of claim 11, wherein the resource utilization is memory utilization.

14. The system of claim 11, wherein the resource utilization is a request processing capacity for processing query requests.

15. 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 from a client of the IMDG a request for a primary query in the IMDG;

computer readable program code for associating the primary query with a previously requested sub-query related to the primary query comprising determining that a sub-query uses a portion of a result set from a previously requested primary query;

computer readable program code for directing the sub-query concurrently with a directing of the primary query without waiting to receive a request for the sub-query from the client; and

,

computer readable program code for caching query results of the sub-query subsequent to a completion of the primary query.

16. The computer program product of claim 15, 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.

17. The computer program product of claim 15, wherein the request for the primary query is received in a proxy to the IMDG that provides caching of query results in order to satisfy received query requests.

18. The computer program product of claim 15, further comprising:

computer readable program code for monitoring resource utilization in the IMDG; and

,

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.

19. The computer program product of claim 18, wherein the resource utilization is central processing unit (CPU) utilization.

20. The computer program product of claim 18, wherein the resource utilization is memory utilization.

21. The computer program product of claim 18, wherein the resource utilization is a request processing capacity for processing query requests.