System and method for modifying an executing query

• US 8,229,943 B2
• Filed: 08/26/2010
• Issued: 07/24/2012
• Est. Priority Date: 08/26/2010
• Status: Active Grant

• Current Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Hanlon, Michael J., Sharma, Anoop, Kakarlamudi, Subbarao, Govindarajan, Selvaganesan
• Primary Examiner(s): Breene, John E
• Assistant Examiner(s): Ly, Anh
• Application Number:
  US12/868,895
• Publication Number:
  US 20120054215A1
• Time in Patent Office: 698 Days
• Field of Search: 707/718, 707/759, 707/769, 707/758, 707/803, 707/E17.014, 707/E17.069, 707/E17.075, 709/223, 709/246, 715/220, 715/788, 715/968, 370/469, 370/424, 370/413
• US Class Current: 707/759
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

There is provided a computer-implemented method of modifying a query executing in a database management system. The method comprises sending a no-wait message for the query to a control broker. The method also comprises receiving a reply to the no-wait message from the control broker. The reply to the no-wait message specifies a modification to the query. Additionally, the method comprises performing the modification.

Claims

1. A computer-implemented method of modifying a query executing in a database management system (DBMS), comprising:

sending, by the DBMS, a no-wait message for the query to a control broker, wherein the no-wait message permits the control broker to interrupt the DBMS by replying to the no-wait message;

receiving, by the DBMS, a reply to the no-wait message from the control broker, wherein the reply to the no-wait message specifies a modification to the query; and

performing, by the DBMS, the modification, wherein the modification is one of

a cancellation of the query;

a suspension of the query;

a change in priority of the query; and

a change in a semantic of the query.

2. The method recited in claim 1, wherein the reply is sent by the control broker in response to a request from a client to modify the query, and wherein the no-wait message comprises an identifier for the query, and wherein the request comprises the identifier.

3. The method recited in claim 2, further comprising:

allocating, by the control broker, an object that comprises the identifier; and

sending, by the control broker, the reply to the no-wait message based on the object.

4. The method recited in claim 2, further comprising:

sending, by the DBMS, a second no-wait message to the control broker that specifies the query is finished;

de-allocating, by the control broker, the object in response to receiving the second no-wait message; and

sending, by the control broker, a reply to the second no-wait message.

5. The method recited in claim 2, wherein the client is one of:

a workload monitor that monitors a health of the DBMS;

a java database connectivity client; and

an object database connectivity client.

6. The method recited in claim 5, further comprising:

sending, by the DBMS, a second no-wait message for the query to the control broker;

receiving, by the DBMS, a reply to the second no-wait message from the control broker, wherein the reply to the second no-wait message specifies a second modification to the query; and

performing, by the DBMS, the second modification to the query.

7. The method recited in claim 1, wherein the control broker is a persistent process that is external to the DBMS.

8. A computer system for modifying a query executing in a database management system (DBMS), the computer system comprising:

at least one processor; and

at least one memory comprising instructions that, when executed by the at least one processor, cause the computer system to

receive a no-wait message for the query, wherein the no-wait message permits the computer system to interrupt the DBMS by replying to the no-wait message;

allocate an object to track the query;

receive a request to perform a modification to the query;

identify the query based on the request; and

send a reply to the no-wait message, wherein the reply is sent to the identified query, and wherein the reply specifies the modification, and wherein the modification is one of

a cancellation of the query;

a suspension of the query;

a change in priority of the query; and

a change in a semantic of the query.

9. The computer system recited in claim 8, wherein the no-wait message specifies an identifier for the query, and wherein the object comprises the identifier, and wherein the request specifies the identifier.

10. The computer system recited in claim 9, wherein the at least one memory comprises further instructions that, when executed by the at least one processor, cause the computer system to

identify the object based on the identifier;

and

identify the query based on the object.

11. The computer system recited in claim 8, wherein the at least one memory comprises further instructions that, when executed by the at least one processor, cause the computer system to

receive a second no-wait message that specifies the query is finished;

de-allocate the object in response to receiving the second no-wait message; and

send a reply to the second no-wait message.

12. The computer system recited in claim 8, wherein the request is received from a client.

13. The computer system recited in claim 12, wherein the client is one of:

a workload monitor that monitors a health of the DBMS;

a java database connectivity client; and

an object database connectivity client.

14. The computer system recited in claim 8, wherein the at least one memory comprises further instructions that, when executed by the at least one processor, cause the computer system to

receive a second no-wait message that specifies a second modification to the query;

send a reply to the second no-wait message, wherein the reply to the second no-wait message specifies the second modification; and

perform the second modification to the query.

15. A non-transitory, machine-readable medium that stores machine-readable instructions that, when executed by a processor, cause a device to:

receive a no-wait message for a query, wherein the no-wait message permits the device to interrupt a DBMS by replying to the no-wait message;

allocate an object to track the query;

receive a request to perform a modification to the query;

send a reply to the no-wait message based on the request and the object; and

perform the modification to the query, wherein the modification is one of

a cancellation of the query;

a suspension of the query;

a change in priority of the query; and

a change in a semantic of the query.

16. The non-transitory, machine-readable medium of claim 15, comprising further machine-readable instructions that, when executed by the processor, cause the device to:

receive a second no-wait message that specifies the query is finished; and

de-allocate the object in response to receiving the second no-wait message.

17. The non-transitory, machine-readable medium of claim 15, comprising further machine-readable instructions that, when executed by the processor, cause the device to:

receive a second no-wait message that specifies a second modification to the query;

send a reply to the second no-wait message, wherein the reply to the second no-wait message specifies the second modification; and

perform the second modification to the query.