Invention Grant
US07958113B2 Automatically and adaptively determining execution plans for queries with parameter markers 失效
自动和自适应地确定具有参数标记的查询的执行计划

Automatically and adaptively determining execution plans for queries with parameter markers
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.
Information query
Patent Agency Ranking
0/0