Invention Grant
- Patent Title: Adaptive query processing infrastructure
- Patent Title (中): 自适应查询处理基础设施
-
Application No.: US11869509Application Date: 2007-10-09
-
Publication No.: US09087102B2Publication Date: 2015-07-21
- Inventor: Robert Joseph Bestgen , Michael S. France , Brian Robert Muras
- Applicant: Robert Joseph Bestgen , Michael S. France , Brian Robert Muras
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Craig F. Taylor
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Methods, systems, and computer program products are provided for improving the processing of database queries. Some embodiments include detecting an overly long running query execution plan, stopping execution of the plan, and utilizing the query optimizer to select an alternate plan for execution. Embodiments may utilize system timers which are set with a time limit for the first selected plan, with instructions to re-optimize and initiate selection of an alternate plan when the timer times out. Risky constructs may be located in the first plan and removed from future consideration for executing the query. In some embodiments, the additional overhead for non-problem queries consists of little more than creating and sending a message or setting a timer when starting query execution, and canceling a timer upon successful query processing completion. A secondary thread may be created responsive to detecting a long running query, to supervise selecting an alternate execution plan.
Public/Granted literature
- US20090094192A1 Adaptive Query Processing Infrastructure Public/Granted day:2009-04-09
Information query