Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2011-03-29
2011-03-29
Fleurantin, Jean B. (Department: 2162)
Data processing: database and file management or data structures
Database and file access
Query optimization
C707S803000
Reexamination Certificate
active
07917502
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.
REFERENCES:
patent: 6847978 (2005-01-01), Ellis et al.
patent: 2004/0236722 (2004-11-01), Waas et al.
patent: 2004/0243555 (2004-12-01), Bolsius et al.
patent: 2005/0108199 (2005-05-01), Ellis et al.
patent: 2006/0230016 (2006-10-01), Cunningham et al.
patent: 2006/0294058 (2006-12-01), Zabback et al.
patent: 2007/0050330 (2007-03-01), Karn et al.
patent: 2007/0185912 (2007-08-01), Gupta et al.
patent: 2008/0133458 (2008-06-01), Zabback et al.
patent: 2008/0177694 (2008-07-01), Chaudhuri et al.
patent: 2008/0256025 (2008-10-01), Bestgen et al.
patent: 2008/0275840 (2008-11-01), Burger et al.
patent: 2009/0100114 (2009-04-01), Bestgen et al.
Wikipedia, Computer Data Storage, printout from Web archive: http://web.archive.org/web/20071026074644/http://en.wikipedia.org/wiki/Computer—data—storage, Oct. 24, 2007, 10 pages.
El-Helw, A., et al.; “Collecting and Maintaining Just-In-Time Statistics”; IEEE 23rdInternational Conference on Data Engineering (ICDE 2007), Apr. 15-20, 2007; 11 pages.
Cheng Qi
Hornibrook John Frederick
Lau Wing Yan
Popivanov Ivan
Qian Xiaoyan
Fleurantin Jean B.
International Business Machines - Corporation
Nguyen Phong
Sughrue & Mion, PLLC
LandOfFree
Optimized collection of just-in-time statistics for database... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Optimized collection of just-in-time statistics for database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimized collection of just-in-time statistics for database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2773176