The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Apr. 21, 2009
Filed:
Mar. 16, 2008
Ulrich Thiemann, Rochester, MN (US);
Wei HU, Middleton, WI (US);
Shantan Kethireddy, Rolling Meadows, IL (US);
Andrew Peter Passe, Rochester, MN (US);
Robert Joseph Bestgen, Rochester, MN (US);
Ulrich Thiemann, Rochester, MN (US);
Wei Hu, Middleton, WI (US);
Shantan Kethireddy, Rolling Meadows, IL (US);
Andrew Peter Passe, Rochester, MN (US);
Robert Joseph Bestgen, Rochester, MN (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
This is an example of a new method for optimization of database queries which uses an asynchronous task which keeps the most current status of the database objects by directly interfacing the existing storage management system. This asynchronous task in combination with query plan and cache data is able to aid in detecting and choosing 'warm' query costing alternatives. The cold/warm status information of the asynchronous task helps query optimizer to determine: if it is suitable to use 'warm' costing for a new query optimization; validate previous decisions to use a “warm”-optimized query plan, when it comes to potentially reuse and run with such a plan again; decide whether it's worthwhile to still cache such a plan in the plan cache.