SYSTEM AND METHOD FOR MODIFYING AN EXECUTING QUERY

• US 20120054215A1
• Filed: 08/26/2010
• Published: 03/01/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
• Granted Patent: US 8,229,943 B2
• Time in Patent Office: Days
• 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 a no-wait message for the query to a control broker;

receiving 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 the modification.

2. The method recited in claim 1 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.

3. 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.

4. The method recited in claim 3, 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.

5. The method recited in claim 3, comprising:

sending 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 a reply to the second no-wait message.

6. The method recited in claim 3, 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.

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

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

receiving 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 the second modification to the query.

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

9. A computer system for modifying a query executing in a database management system (DBMS), the computer system comprising a processor configured to:

receive a no-wait message for the query;

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.

10. The computer system recited in claim 9, wherein the processor is configured to perform the modification to the query.

11. The computer system recited in claim 9, 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.

12. The computer system recited in claim 9, 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.

13. The computer system recited in claim 12, wherein the processor configured to identify the query is configured to:

identify the object based on the identifier; and

identify the query based on the object.

14. The computer system recited in claim 9, wherein the processor is configured 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.

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

16. The computer system recited in claim 15, 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.

17. The computer system recited in claim 9, wherein the processor is configured 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.

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

receive a no-wait message for a query;

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.

19. The non-transitory, machine-readable medium of claim 18, comprising machine-readable instructions that, when executed by the processor, cause the processor 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.

20. The non-transitory, machine-readable medium of claim 18, comprising machine-readable instructions that, when executed by the processor, cause the processor 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.