Statistics adjustment to improve query execution plans

Details Statistics adjustment to improve query execution plans Statistics adjustment to improve query execution plans

2011-01-25

2011-01-25

Pham, Hung Q (Department: 2159)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S688000, C707S719000

Reexamination Certificate

active

07877374

ABSTRACT:
A query execution system is provided. The system includes a monitor component that detects data value changes in a database. An adjustment component initiates an intermediate query in view of detected data value changes, the intermediate query employed to adjust statistics related to a query plan optimization.

REFERENCES:
patent: 6029163 (2000-02-01), Ziauddin
patent: 6272487 (2001-08-01), Beavin et al.
patent: 6353821 (2002-03-01), Gray
patent: 6477523 (2002-11-01), Chiang
patent: 6691099 (2004-02-01), Mozes
patent: 6738755 (2004-05-01), Freytag et al.
patent: 7035843 (2006-04-01), Bellamkonda et al.
patent: 7299248 (2007-11-01), Popivanov
patent: 2004/0181521 (2004-09-01), Simmen
patent: 2005/0050041 (2005-03-01), Galindo-Legaria et al.
patent: 2005/0097078 (2005-05-01), Lohman et al.
patent: 2005/0131914 (2005-06-01), Abdo et al.
patent: 2005/0267877 (2005-12-01), Chaudhuri et al.
patent: 2006/0031189 (2006-02-01), Muras et al.
patent: 2008/0133454 (2008-06-01), Markl et al.
V. Markl, et al. LEO: An autonomic query optimizer for DB2. IBM Systems Journal, vol. 42, No. 1, 2003. http://www.research.ibm.com/journal/sj/421/markl.pdf, Last accessed Sep. 12, 2006.
Nicolas Bruno, et al. Efcient Creations of Statistics over Query Expressions. http://www.cs.brown.edu/courses/cs227/Papers/AutoAdmin/buildsits.pdf. Last Accessed Sep. 12, 1006.
Ning Zhang, et al. XSEED: Accurate and Fast Cardinality Estimation for XPath Queries. http://softbase.uwaterloo.ca/˜ddbms/publications/xml/TR-CS-2005-22.pdf. Last accessed Sep. 12, 2006.

Affiliated with

Also associated with

Rating

Statistics adjustment to improve query execution plans does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Statistics adjustment to improve query execution plans, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Statistics adjustment to improve query execution plans will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2707207