Method, query optimizer, and computer program product for...

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S793000, C707S793000

Reexamination Certificate

active

10443921

ABSTRACT:
A method, a query optimizer, and computer program product are provided for implementing live switchover to a temporary sparse index for faster query performance. A first plan using an existing index is used for processing a query. A temporary sparse index is built for the query simultaneously with the first plan processing the query. When the temporary sparse index is built, processing the query with the first plan is stopped and a live switchover to the temporary sparse index is provided. Then a second plan using the temporary sparse index is used to continue processing the query at a point where processing stopped with the first plan.

REFERENCES:
patent: 6643636 (2003-11-01), Au et al.
Kabra et al., “Efficient mid-query re-optimization of sub-optimal query execution plans”, International Conference on Management of Data Proceedings of the 1998 ACM SIGMOD international conference on Management of data, Seattle, Washington, 1998.
Antoshenkov, “Dynamic Optimization of Index Scans Restricted by Booleans”, ICDE, Proceedings of the Twelfth International Conference on Data Engineering, 1996.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Method, query optimizer, and computer program product for... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method, query optimizer, and computer program product for..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, query optimizer, and computer program product for... will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-3778744

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.