Automatic error mitigation in database statements using alternate plans
AssigneeOracle International Corporation
InventorsKrishna Kantikiran Pasupuleti, Hong Su, Jiakun Li, Mohamed Ziauddin
Life of this patent
Estimating the term…
Abstract
Techniques for automatic error mitigation in database systems using alternate plans are provided. After receiving a database statement, an error is detected as a result of compiling the database statement. In response to detecting the error, one or more alternate plans that were used to process the database statement or another database statement that is similar to the database statement are identified. A particular alternate plan of the one or more alternate plans is selected. A result of the database statement is generated based on processing the particular alternate plan.
Claims20
A method comprising:
- after receiving a database statement, detecting an error as a result of compiling the database statement, wherein the error prevents generation of an execution plan for the database statement;
- in response to detecting the error, identifying one or more alternate plans that were used, previous to receiving the database statement, to process a prior instance of the database statement or another database statement that is similar to the database statement;
- selecting a particular alternate plan of the one or more alternate plans;
- generating a result of the database statement based on processing the particular alternate plan;
- wherein the method is performed by one or more computing devices.
One or more non-transitory storage media storing instructions which, when executed by one or more computing devices, cause:
- after receiving a database statement, detecting an error as a result of compiling the database statement, wherein the error prevents generation of an execution plan for the database statement;
- in response to detecting the error, identifying one or more alternate plans that were used, previous to receiving the database statement, to process a prior instance of the database statement or another database statement that is similar to the database statement;
- selecting a particular alternate plan of the one or more alternate plans;
- generating a result of the database statement based on processing the particular alternate plan;
- wherein the method is performed by one or more computing devices.
Dependencies are inferred from the claim text.