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:
Mar. 29, 2011
Filed:
Feb. 27, 2008
Qi Cheng, North York, CA;
John Frederick Hornibrook, Markham, CA;
Wing Yan Lau, Toronto, CA;
Ivan Popivanov, Markham, CA;
Xiaoyan Qian, Aurora, CA;
Michael Joshua Snowbell, Thornhill, CA;
Michael Arthur Franciscus Stuy, Markham, CA;
Calisto Paul Zuzarte, Pickering, CA;
Qi Cheng, North York, CA;
John Frederick Hornibrook, Markham, CA;
Wing Yan Lau, Toronto, CA;
Ivan Popivanov, Markham, CA;
Xiaoyan Qian, Aurora, CA;
Michael Joshua Snowbell, Thornhill, CA;
Michael Arthur Franciscus Stuy, Markham, CA;
Calisto Paul Zuzarte, Pickering, CA;
International Business Machines Corporation, Armonk, NY (US);
Abstract
A system and method are provided for updating database statistics for use in generating query execution plans. A first query for a database is received, for example by a compiler, and the compiler accesses statistics associated with the first query for optimizing a query execution plan for the first query. The statistics may be accessed from a first cache. If the statistics retrieved from the first cache are determined to be stale, the system obtains updated statistics and may store them in a temporary cache. The stale statistics in the first cache are marked as invalid. Existing queries using the first cache may continue to use the first cache, while new queries may be provided with updated statistics.