Interception of database queries for delegation to an in memory data grid

• US 10,120,897 B2
• Filed: 06/06/2011
• Issued: 11/06/2018
• Est. Priority Date: 06/06/2011
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Antani, Snehal S., Bhogal, Kulvir S., Gaur, Nitin, Johnson, Christopher D.
• Primary Examiner(s): Wu, Yicun
• Application Number:
  US13/154,407
• Publication Number:
  US 20120310992A1
• Time in Patent Office: 2,710 Days
• Field of Search: 707769, 707607, 714 10, 714 18, 711162, 712 29, 709216
• CPC Class Codes: G06F 16/24532 of parallel queries

Abstract

Embodiments of the present invention provide a method, system and computer program product for the seamless integration of an application with an in memory data grid. In an embodiment of the invention, a method for intercepting database queries from a computer program for delegation to an in memory data grid is provided. The method includes retrieving database queries from a database driver for a database management system from a requesting computer program and comparing at least a portion of each of the database queries to a listing of database queries. Thereafter, the database queries are selectively routed to a data grid, such as an in memory data grid, in lieu of the database management based upon the comparison.

Claims

1. A method for intercepting database queries from a computer program for delegation to an in memory data grid, the method comprising:

enabling a client database driver for a database management system to delegate database queries from interfacing with a database to interfacing with an in memory data grid;

retrieving database queries from the enabled client database driver from a requesting computer program;

comparing at least a portion of each of the retrieved database queries to a listing of database queries that have been a priori determined for routing onto the in memory data grid; and

,

selectively delegating the retrieved database queries to the in memory data grid in lieu of the database management system based upon the comparison and on condition that one of the retrieved database queries is delegated to the in memory data grid in lieu of the database management system, determining a fetch routine from the query routing list from the listing of database queries.

2. The method of claim 1, wherein the client database driver is a Java Database Connectivity (JDBC) driver.

3. The method of claim 1, wherein the database driver is included as part of the computer program.

4. The method of claim 1, wherein selectively routing the database queries to a data grid in lieu of the database management based upon the comparison, comprises routing to the data grid only those of the database queries that are included in the listing of database queries.

5. The method of claim 1, wherein selectively routing the database queries to a data grid in lieu of the database management based upon the comparison, comprises routing to the database management system only those of the database queries that are included in the listing of database queries.

6. The method of claim 1, wherein selectively routing the database queries to a data grid in lieu of the database management based upon the comparison, comprises routing to the data grid only those of the database queries that are included in the listing of database queries and only when the data grid is determined not have been contemporaneously utilized above a threshold level.

7. The method of claim 1, wherein selectively routing the database queries to a data grid in lieu of the database management based upon the comparison, comprises routing to the data grid only those of the database queries that are included in the listing of database queries using a correspondingly specified data grid handler in the listing of the database queries.

8. A method for use with a client database driver that selectively forwards incoming database queries to one of the following recipient components:

a database or an in memory data grid, the method comprising;

receiving, by the client database driver, a grid eligible query type data set including information indicative of query types that are eligible to be sent to the in memory data grid instead of to the database;

receiving, by the client database driver, a new database query;

determining, by the client database driver and based upon the grid eligible query type data set, that the new database query is of a query type such that the new database query is a grid-eligible database query that is eligible to be sent to the in memory data grid;

responsive to the determination that the new database query is a grid-eligible query, determining, by the client database driver, a utilization level value of the in memory data grid;

comparing, by the client database driver, the utilization level value of the in memory data grid to a predetermined threshold value to determine that the utilization level value is higher than the predetermined threshold value; and

responsive to the determination that the utilization level value is higher than the threshold value, forwarding, by the client database driver, the grid-eligible database query to the database instead of to the in memory data grid.

9. The method of claim 8, wherein the grid eligible query type data set includes a grid handler.

10. The method of claim 8, further comprising:

receiving, by client database driver, over a communication network and from the database, query results; and

forwarding, by client database driver, over a communication network and to a requesting device, the query results.

11. A method for use with a client database driver that selectively forwards incoming database queries to one of the following recipient components:

a database or an in memory data grid, the method comprising;

receiving, by the client database driver, a grid eligible query type data set including information indicative of query types that are eligible to be sent to the in memory data grid instead of to the database;

receiving, by the client database driver, a new database query;

determining, by the client database driver and based upon the grid eligible query type data set, that the new database query is of a query type such that the new database query is a grid-eligible database query that is eligible to be sent to the in memory data grid;

responsive to the determination that the new database query is a grid-eligible query, determining, by the client database driver, a utilization level value of the in memory data grid;

comparing, by the client database driver, the utilization level value of the in memory data grid to a predetermined threshold value to determine that the utilization level value is lower than the predetermined threshold value; and

responsive to the determination that the utilization level value is lower than the predetermined threshold value, forwarding, by the client database driver, the grid-eligible database query to the in memory data grid instead of to the database.

12. The method of claim 11, wherein the grid eligible query type data set includes a grid handler.

13. The method of claim 11, further comprising:

receiving, by client database driver, over a communication network and from the in memory data grid, query results; and

forwarding, by client database driver, over a communication network and to a requesting device, the query results.