Invention Grant
- Patent Title: Hybrid query execution plan generation and cost model evaluation
- Patent Title (中): 混合查询执行计划生成和成本模型评估
-
Application No.: US12972360Application Date: 2010-12-17
-
Publication No.: US08356027B2Publication Date: 2013-01-15
- Inventor: Bernhard Jaecksch , Franz Faerber
- Applicant: Bernhard Jaecksch , Franz Faerber
- Applicant Address: DE Walldorf
- Assignee: SAP AG
- Current Assignee: SAP AG
- Current Assignee Address: DE Walldorf
- Agency: Mintz, Levin, Cohn, Ferris, Glovsky and Popeo, P.C.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A procedural pattern in a received query execution plan can be matched to a stored pattern for which an equivalent declarative operator has been pre-defined. The query execution plan can describe a query for accessing data. A hybrid execution plan can be generated by replacing the procedural pattern with the equivalent declarative operator. A hybrid execution plan processing cost can be assigned to execution of the hybrid execution plan and a query execution plan processing cost can be assigned to execution of the query execution plan. The assigning can include evaluating a cost model for the hybrid execution plan and the query execution plan. The query can be executed using the hybrid execution plan if the hybrid execution plan processing cost is less than the query execution plan processing cost or the query execution plan if the hybrid execution plan processing cost is greater than the query execution plan processing cost. Related systems, methods, and articles of manufacture are disclosed.
Public/Granted literature
- US20120089595A1 Hybrid Query Execution Plan Public/Granted day:2012-04-12
Information query