Invention Grant
US07958113B2 Automatically and adaptively determining execution plans for queries with parameter markers
失效
自动和自适应地确定具有参数标记的查询的执行计划
- Patent Title: Automatically and adaptively determining execution plans for queries with parameter markers
- Patent Title (中): 自动和自适应地确定具有参数标记的查询的执行计划
-
Application No.: US12125221Application Date: 2008-05-22
-
Publication No.: US07958113B2Publication Date: 2011-06-07
- Inventor: Wei Fan , Guy Maring Lohman , Volker Gerhard Markl , Nimrod Megiddo , Jun Rao , David Everett Simmen , Julia Stoyanovich
- Applicant: Wei Fan , Guy Maring Lohman , Volker Gerhard Markl , Nimrod Megiddo , Jun Rao , David Everett Simmen , Julia Stoyanovich
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Schmeiser, Olsen & Watts
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30 ; G06F15/16

Abstract:
A method and system for automatically and adaptively determining query execution plans for parametric queries. A first classifier trained by an initial set of training points is generated. A query workload and/or database statistics are dynamically updated. A new set of training points is collected off-line. Using the new set of training points, the first classifier is modified into a second classifier. A database query is received at a runtime subsequent to the off-line phase. The query includes predicates having parameter markers bound to actual values. The predicates are associated with selectivities. A mapping of the selectivities into a plan determines the query execution plan. The determined query execution plan is included in an augmented set of training points, where the augmented set includes the initial set and the new set.
Public/Granted literature
- US20080222093A1 AUTOMATICALLY AND ADAPTIVELY DETERMINING EXECUTION PLANS FOR QUERIES WITH PARAMETER MARKERS Public/Granted day:2008-09-11
Information query