发明授权
- 专利标题: Adaptive query processing infrastructure
- 专利标题(中): 自适应查询处理基础设施
-
申请号: US11869509申请日: 2007-10-09
-
公开(公告)号: US09087102B2公开(公告)日: 2015-07-21
- 发明人: Robert Joseph Bestgen , Michael S. France , Brian Robert Muras
- 申请人: Robert Joseph Bestgen , Michael S. France , Brian Robert Muras
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理商 Craig F. Taylor
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
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.
公开/授权文献
- US20090094192A1 Adaptive Query Processing Infrastructure 公开/授权日:2009-04-09
信息查询