Please download the dossier by clicking on the dossier button x
×

Method and system for a self-healing query access plan

  • US 8,775,412 B2
  • Filed: 01/08/2004
  • Issued: 07/08/2014
  • Est. Priority Date: 01/08/2004
  • Status: Active Grant
First Claim
Patent Images

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, wherein the error is an execution error of a type that halts execution of the query access plan, wherein the query access plan is of the type generated by a query optimizer, wherein the query access plan is generated prior to installation of a patch to at least one of the database engine and the query optimizer, wherein the patch comprises a program fix including executable code that modifies at least one of the database engine and the query optimizer, and wherein detecting the error is performed after installation of the patch;

    in response to detecting the error, automatically rebuilding the query access plan with the query optimizer to generate a new query access plan, wherein the new query access plan is generated after installation of the patch; and

    executing the new query access plan to generate at least a portion of a result set for storage or display.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×