Invention Grant
- Patent Title: Database optimizer plan validation and characterizations
- Patent Title (中): 数据库优化器计划验证和表征
-
Application No.: US11565797Application Date: 2006-12-01
-
Publication No.: US07870123B2Publication Date: 2011-01-11
- Inventor: Bibhu Ranjan Priyadarshi , Grace Au , Olli Pekka Kostamaa
- Applicant: Bibhu Ranjan Priyadarshi , Grace Au , Olli Pekka Kostamaa
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
The invention relates to a method of determining the performance of an optimizer program arranged to generate a plan. The method generally comprises the steps of executing the optimizer utilising at least one test case to derive a pre-variation plan; executing the pre-variation plan to generate a first output; varying a strategy of the optimizer program; executing the varied optimizer program utilising the at least one test case to derive a post-variation plan; and executing the post-variation plan to generate a second output. The outputs are then grouped according to at least one element of the plans to assess the performance of the optimizer.
Public/Granted literature
- US20080133457A1 DATABASE OPTIMIZER PLAN VALIDATION AND CHARACTERIZATIONS Public/Granted day:2008-06-05
Information query