Modeling and implementing complex data access operations based on lower level traditional operations

• US 7,822,767 B2
• Filed: 10/09/2003
• Issued: 10/26/2010
• Est. Priority Date: 10/09/2003
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard D., Stevens, Richard J.
• Primary Examiner(s): Pham; Khanh B
• Application Number:
  US10/682,133
• Publication Number:
  US 20050080765A1
• Time in Patent Office: 2,574 Days
• Field of Search: 707 1- 10, 707/100, 707/103.R, 707/102
• US Class Current: 707/774
• CPC Class Codes: G06F 16/2454 Optimisation of common expressions
• CPC Class Codes: G06F 16/24549 Run-time optimisation

Abstract

A system, method and article of manufacture for data processing and, more particularly, for managing execution of complex data access operations in a data processing system. One embodiment provides a method of managing execution of query operations in a data processing system. The method comprises issuing, by a requesting entity, a request to perform a composite query operation defining an initial query operation and a subsequent query operation to be executed against a data repository of the data processing system, executing the initial query operation, determining an operation status of the initial query operation, and managing execution of the subsequent query operation on the basis of the determined operation status.

Claims

1. A method of managing execution of query operations in a data processing system, comprising:

issuing, by a requesting entity, a request to perform a composite query operation defined by at least an initial query operation and a plurality of subsequent query operations to be executed against a data repository of the data processing system;

executing the initial query operation;

determining an operation status of the initial query operation;

selecting one of the plurality of subsequent query operations based on the operation status;

performing the selected subsequent query operation;

updating the operation status based on a result of the subsequent query operation;

managing execution of any remaining subsequent query operations on the basis of the updated operation status; and

upon determining the composite query operation has completed, returning a result of the composite query operation to the requesting entity.

2. The method of claim 1, wherein the determining and managing are performed by a composite query operations manager.

3. The method of claim 1, wherein the requesting entity is an application and wherein the determining and managing are performed by a composite query operations manager.

4. The method of claim 1, wherein the initial and the subsequent query operation are SQL statements.

5. The method of claim 1, wherein determining an operation status of the initial query operation comprises determining a number of items affected by the initial query operation.

6. The method of claim 1, wherein determining an operation status of the initial query operation comprises determining whether the initial query operation completed successfully.

7. The method of claim 1, wherein determining an operation status of the initial query operation comprises determining, on the basis of a return code received upon completion of the initial query operation, whether the initial query operation completed successfully.

8. The method of claim 1, wherein managing execution of the subsequent query operation comprises:

executing the subsequent query operation only if the initial query operation did not complete successfully.

9. A computer readable storage medium containing a program which, when executed, performs a process of managing execution of query operations in a data processing system, the process comprising:

receiving, from a requesting entity, a request to perform a composite query operation defined by at least an initial query operation and a plurality of subsequent query operations to be executed against a data repository of the data processing system;

executing the initial query operation;

determining an operation status of the initial query operation;

selecting one of the plurality of subsequent query operations based on the operation status;

performing the selected subsequent query operation;

updating the operation status based on a result of the subsequent query operation;

managing execution of any remaining subsequent query operations on the basis of the updated operation status; and

upon determining the composite query operation has completed, returning a result of the composite query operation to the requesting entity.

10. The computer readable storage medium of claim 9, wherein the determining and managing are performed by a composite query operations manager.

11. The computer readable storage medium of claim 9, wherein the initial and the subsequent query operation are SQL statements.

12. The computer readable storage medium of claim 9, wherein determining an operation status of the initial query operation comprises determining a number of items affected by the initial query operation.

13. The computer readable storage medium of claim 9, wherein determining an operation status of the initial query operation comprises determining whether the initial query operation completed successfully.

14. The computer readable storage medium of claim 9, wherein determining an operation status of the initial query operation comprises determining, on the basis of a return code received upon completion of the initial query operation, whether the initial query operation completed successfully.

15. The computer readable storage medium of claim 9, wherein managing execution of the subsequent query operation comprises:

executing the subsequent query operation only if the initial query operation did not complete successfully.

16. A data processing system comprising:

a data repository; and

a composite query operations manager residing in memory for managing execution of query operations in the data processing system, the composite query operations manager being configured for;

receiving a request to perform a composite query operation defined by at least an initial query operation and a plurality of subsequent query operations to be executed against the data repository;

executing the initial query operation;

determining an operation status of the initial query operation;

selecting one of the plurality of subsequent query operations based on the operation status;

performing the selected subsequent query operation;

updating the operation status based on a result of the subsequent query operation;

managing execution of any remaining subsequent query operations on the basis of the updated operation status; and

upon determining the composite query operation has completed, storing and returning a result of the composite query operation to the requesting entity.