Invention Grant
US09128984B2 Query plan analysis of alternative plans using robustness mapping
有权
使用鲁棒性映射的替代计划的查询计划分析
- Patent Title: Query plan analysis of alternative plans using robustness mapping
- Patent Title (中): 使用鲁棒性映射的替代计划的查询计划分析
-
Application No.: US12364107Application Date: 2009-02-02
-
Publication No.: US09128984B2Publication Date: 2015-09-08
- Inventor: Janet L. Wiener , Goetz Graefe , Harumi Kuno
- Applicant: Janet L. Wiener , Goetz Graefe , Harumi Kuno
- Applicant Address: US TX Houston
- Assignee: Hewlett-Packard Development Company, L.P.
- Current Assignee: Hewlett-Packard Development Company, L.P.
- Current Assignee Address: US TX Houston
- Agency: International IP Law Group, PLLC
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
Computer-implemented and associated operating methods evaluate robustness of a query plan by measuring performance with regard to a range of runtime conditions and producing a map of relative performance of the given query plan when compared with alternative plans for a range of conditions. The computer-implemented system comprises logic that evaluates the selected query plan in comparison to multiple alternative query plans in a predetermined range of runtime conditions that include data characteristics. The logic produces a set of performance measurements and analyzes the measured performance to map performance of the selected query plan in comparison to performance of one or more alternative query plans.
Public/Granted literature
- US20100198811A1 QUERY PLAN ANALYSIS OF ALTERNATIVE PLANS USING ROBUSTNESS MAPPING Public/Granted day:2010-08-05
Information query