Query rewrites for data-intensive applications in presence of run-time errors

• US 9,292,373 B2
• Filed: 03/15/2013
• Issued: 03/22/2016
• Est. Priority Date: 03/15/2013
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ercegovac, Vuk, Kanne, Carl-Christian
• Primary Examiner(s): Decady, Albert
• Assistant Examiner(s): Contino, Paul
• Application Number:
  US13/837,172
• Publication Number:
  US 20140281746A1
• Time in Patent Office: 1,103 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 11/0727 in a storage system, e.g. in a DASD or network based storage system drivers for digital recording or reproducing units G06F3/06; circuits for error detection or correction within digital recording or reproducing units G11B20/18; for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS], H04L67/1097
• CPC Class Codes: G06F 11/0751 Error or fault detection not based on redundancy power supply failures G06F1/30; network fault management H04L41/06
• CPC Class Codes: G06F 11/0766 Error or fault reporting or storing
• CPC Class Codes: G06F 11/0775 Content or structure details of the error report, e.g. specific table structure, specific error fields
• CPC Class Codes: G06F 11/0778 Dumping, i.e. gathering error/state information after a fault for later diagnosis
• CPC Class Codes: G06F 11/079 Root cause analysis, i.e. error or fault diagnosis in a hardware test environment G06F11/22; in a software test environment G06F11/36
• CPC Class Codes: G06F 11/0793 Remedial or corrective actions recovery from an exception in an instruction pipeline G06F9/3861; by retry G06F11/1402; for recovering from a failure of a protocol instance or entity H04L69/40
• CPC Class Codes: G06F 16/156 Query results presentation
• CPC Class Codes: G06F 16/43 Querying
• CPC Class Codes: G06F 16/438 Presentation of query results
• CPC Class Codes: G06F 8/00 Arrangements for software engineering testing or debugging G06F11/36; administrative, planning or organisation aspects of software project management G06Q10/06

Abstract

Embodiments relate to a method and computer program product for error handling. The method includes performing at least one query operation. The processing of query operation also includes generating error information data based at least an error encountered during performance of the query operation and generating a data result relating to any portion of the query operation successfully completed. The data result is processed together with the error information data based on encountering any errors. The data result and error information are provided together in a package but separated by an indicator to distinguish between them.

Claims

1. A method comprising:

performing at least one query operation;

generating error information data based on at least an error encountered during performance of the query operation;

generating a data result relating to any portion of the query operation that has successfully completed;

continuing, as a function of at least one of a number of errors encountered and a class of error encountered, the query operation on data results relating to corresponding portions of the query operation that successfully completed; and

processing the data results together with the error information data based on encountering the errors, the data results and the error information distinguishable by an indicator disposed therebetween;

wherein an occurrence of the errors are encountered by an operator that is used to generate the data results, the occurrence of the errors causes the return of an error container instead of other regular data portion included in the data results;

wherein the operator extracts partial results from the error container by consuming its input and passing through any non-error values as output.

2. The method of claim 1, wherein the query operation is performed using declarative reasoning.

3. The method of claim 1, wherein the data results include information and data generated before and after encountering the errors and in performance of the query operation, the data results omitting data deemed affected due to encountering the errors.

4. The method of claim 1, wherein at least one of the errors is a nondeterministic error.

5. The method of claim 1, wherein the query operation is performed responsive to receiving a command request.

6. The method of claim 1, wherein a plurality of query operations are performed responsive to one or more command requests.

7. The method of claim 6, wherein the plurality of query operations are performed in parallel to one another.

8. The method of claim 7, further comprising generating individual data packages for each of the plurality of query operations, the individual data packages including separate data results and error information based upon encountering the errors.

9. The method of claim 3, further comprising extracting, via an iterator, the error information from other data received, the other data received comprising the data results.

10. The method of claim 1, wherein the query operation uses declarative logic.

11. The method of claim 1, wherein the operator is implemented by an iterator.

12. A computer program product comprising a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code being executable by a processor to:

perform at least one query operation;

generate error information data based at least an error encountered during performance of the query operation;

generate a data result relating to any portion of the query operation that has successfully completed;

continue, as a function of at least one of a number of errors encountered and a class of error encountered, the query operation on data results relating to corresponding portions of the query operation that successfully completed; and

process the data results together with the error information data based on encountering the errors, the data results and the error information data distinguishable by an indicator disposed therebetween;

wherein an occurrence of the errors are encountered by an operator that is used to generate the data results, the occurrence of the errors causes the return of an error container instead of other regular data portion included in the data results;

wherein the operator extracts partial results from the error container by consuming its input and passing through any non-error values as output.

13. The program product of claim 12, wherein an error type is identified upon encountering the error.

14. The program product of claim 12, wherein the data results include all performable tasks relating to completing the query operation not relating to the errors.