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

Dynamically Selecting Alternative Query Access Plans

  • US 20070282794A1
  • Filed: 08/16/2007
  • Published: 12/06/2007
  • Est. Priority Date: 06/24/2004
  • Status: Active Grant
First Claim
Patent Images

1. A method of providing fee-based processing in a processor system, whereby fees are based on additional computer resources being added for enabling provision of alternative query access plans, the processor system including at least one processor;

  • a memory coupled to the at least one processor, a query optimizer residing in the memory; and

    , a manager residing in the memory and executable by the at least one processor, said method comprising the steps of;

    generating with said query optimizer a first query access plan for executing a query, said first query access plan being generated with said query optimizer based on a first set of computer resources to be used for executing said query;

    evaluating said first query access plan by determining whether additional computer resources are available to execute said query, said additional computer resources being computer resources in addition to said first set of computer resources;

    dynamically selecting an alternative query access plan for executing said query responsive to determining that said additional computer resources are available to execute said first query and responsive to determining that at least a parameter value of the alternative query access plan exceeds a corresponding parameter value of the first query access plan, whereby the alternative query access plan is improved over the first query access plan, said alternative query access plan being based on an alternative set of computer resources which includes said additional computer resources to be used for executing the query; and

    dynamically adding the computer resources for running the dynamically selected alternative query access plan, wherein the manager dynamically adds the computer resources based on determining the cost for usage for the additional computer resources.

View all claims
  • 0 Assignments
Timeline View
Assignment View
    ×
    ×