Method and system for a self-healing query access plan
First Claim
1. A method for automatic handling of errors within a database engine, the method comprising the steps of:
- detecting an error while executing a query access plan;
in response to detecting the error, automatically rebuilding the query access plan to generate a new query access plan;
executing the new query access plan.
1 Assignment
0 Petitions
Accused Products
Abstract
A self-healing database engine and optimizer framework support automatically responding to execution errors to allow continued execution of a query plan. Upon encountering an execution error, the database engine automatically initiates a rebuilding of the query plan and executes the rebuilt execution plan. If an error is encountered in the rebuilt query plan then the query implementation methods are analyzed. If a query function is identified for which an alternative implementation method is available, then this alternative implementation method is substituted to create a new query plan. The new query plan is then executed to determine if the error is corrected.
-
Citations
21 Claims
-
1. A method for automatic handling of errors within a database engine, the method comprising the steps of:
-
detecting an error while executing a query access plan;
in response to detecting the error, automatically rebuilding the query access plan to generate a new query access plan;
executing the new query access plan. - View Dependent Claims (3, 4, 5, 6)
-
-
2. (canceled)
-
7. A method for automatic handling of errors within a database engine, the method comprising the steps of:
-
receiving an error while executing a function within a query access plan;
identifying a first implementation method of the function within the query access plan;
rebuilding the query access plan by replacing the first implementation method with a second implementation method of the function so as to generate a new query access plan; and
executing the new query access plan. - View Dependent Claims (8)
-
- 9. (canceled)
-
12. A method for automatic handling of errors within a database engine, the method comprising the steps of:
-
executing a query access plan comprising a plurality of functions, each function including a first implementation method;
detecting a first error when executing a first function;
rebuilding the query access plan to generate a new query access plan;
executing the new query access plan;
receiving a second error while executing the first function within the new query access plan; and
rebuilding the new query access plan by replacing the first implementation method with a second implementation method of the function.
-
-
13. A program product, comprising:
-
a program code configured upon execution to;
detect an error while executing a query access plan, automatically rebuild the query access plan to generate a new query access plan in response to detecting the error execute the new query access plan; and
a signal bearing medium bearing the program code. - View Dependent Claims (14)
-
-
15. A program product, comprising:
-
program code configured upon execution thereof to;
receive an error while executing a function within a query access plan;
identify a first implementation method of the function within the query access plan, rebuild the query access plan by replacing the first implementation method with a second implementation method of the function so as to generate a new query access plan, and execute the new query access plan; and
a signal bearing medium bearing the program code.
-
-
16. An apparatus comprising:
-
at least one processor;
a memory coupled with the at least one processor; and
a program code residing in memory and executed by the at least one processor, the program code configured to;
detect an error while executing a query access plan;
automatically rebuild the query access plan, in response to detecting the error, to generate a new query access plan, and execute the new query access plan. - View Dependent Claims (18, 19, 20, 21)
-
-
17. (canceled)
Specification