Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2011-08-02
2011-08-02
Vy, Hung T (Department: 2164)
Data processing: database and file management or data structures
Database and file access
Query optimization
C707S610000
Reexamination Certificate
active
07991763
ABSTRACT:
A method, apparatus and program product to optimize a database query. In a first system having a first dataspace, a query plan is generated for the database query. Remote statistics collection associated with the database query is initiated on a second system having a second dataspace. The remote statistics collection uses the second dataspace, which includes a current copy of at least a portion of the first dataspace on the first system. Database statistics are collected for the first system by analyzing the second dataspace and then communicating the collected database statistics to the first system for use in optimizing database queries executed by the first system.
REFERENCES:
patent: 6766318 (2004-07-01), Guay et al.
patent: 6957435 (2005-10-01), Armstrong et al.
patent: 7155428 (2006-12-01), Brown et al.
patent: 2003/0065644 (2003-04-01), Horman et al.
patent: 2003/0212668 (2003-11-01), Hinshaw et al.
patent: 2004/0087300 (2004-05-01), Lewis
patent: 2004/0243799 (2004-12-01), Hacigumus et al.
patent: 2005/0028134 (2005-02-01), Zane et al.
patent: 2005/0097078 (2005-05-01), Lohman et al.
patent: 2005/0131878 (2005-06-01), Chen et al.
patent: 2005/0131879 (2005-06-01), Ghosh et al.
patent: 2005/0149505 (2005-07-01), Bossman et al.
patent: 2005/0234900 (2005-10-01), Bossman et al.
patent: 2005/0267877 (2005-12-01), Chaudhuri et al.
patent: 2006/0059205 (2006-03-01), Shah et al.
patent: 2006/0112093 (2006-05-01), Lightstone et al.
patent: 2006/0195416 (2006-08-01), Ewen et al.
patent: 2006/0218123 (2006-09-01), Chowdhuri et al.
patent: 2006/0230016 (2006-10-01), Cunningham et al.
patent: 2008/0133458 (2008-06-01), Zabback et al.
patent: 2008/0162416 (2008-07-01), Sinclair
Bonnet, Philippe et al., Partial Answers for Unavailable Data Sources (12 pages.).
Raman, Vijayshankar et al., Progressive Optimization in Action, 2004 (4 pages.).
Bestgen Robert Joseph
Faunce Michael S.
Hu Wei
Kethireddy Shantan
Passe Andrew Peter
Cao Phuong-Thao
International Business Machines - Corporation
Vy Hung T
Wood Herron & Evans LLP
LandOfFree
Database query optimization utilizing remote statistics... 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 query optimization utilizing remote statistics..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database query optimization utilizing remote statistics... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2720818