Database optimizer plan validation and characterizations

Details Database optimizer plan validation and characterizations Database optimizer plan validation and characterizations

2011-01-11

2011-01-11

Pham, Hung Q (Department: 2159)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S713000, C707S714000

Reexamination Certificate

active

07870123

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.

REFERENCES:
patent: 7370043 (2008-05-01), Shelton et al.
patent: 7383246 (2008-06-01), Lohman et al.
patent: 2006/0004695 (2006-01-01), Day et al.
patent: 2006/0106839 (2006-05-01), Shen et al.
patent: 2008/0114718 (2008-05-01), Anderson et al.

Affiliated with

Also associated with

Rating

Database optimizer plan validation and characterizations does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database optimizer plan validation and characterizations, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database optimizer plan validation and characterizations will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2663320