Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-11-21
2006-11-21
Alam, Shahid (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C715S762000
Reexamination Certificate
active
07139749
ABSTRACT:
Provided are a method, system, an program for tuning a database query. Provided are a base access plan to implement the database query and statistics including information on a layout of the database against which the query will be executed. The statistics are processed to determine performance problems with the base access plan as part of a first analysis of the base access plan and the determined performance problems are processed as part of a second analysis to provide an analysis of the determined performance problems and processing cost of the base access plan. Recommendations are generated to tune the base access plan to improve performance.
REFERENCES:
patent: 5761654 (1998-06-01), Tow
patent: 5852818 (1998-12-01), Guay et al.
patent: 6266658 (2001-07-01), Adya et al.
patent: 6321218 (2001-11-01), Guay et al.
patent: 6374257 (2002-04-01), Guay et al.
patent: 6460045 (2002-10-01), Aboulnaga et al.
patent: 6529901 (2003-03-01), Chaudhuri et al.
patent: 6598038 (2003-07-01), Guay et al.
patent: 6704724 (2004-03-01), Ellmann et al.
patent: 6766318 (2004-07-01), Guay et al.
patent: 6801903 (2004-10-01), Brown et al.
IBM Corp., “Using AS/400 Database Monitor and Visual Explain To Identify and Tune SQL Theories.,” Jan. 2001, pp. 1-40 [online], available from ibm.com/redbooks.
IBM Corp., “DBS UDB V7.1 Performance Tuning Guide,” Dec. 200, pp. 1-395 [online], available from ibm.com/redbooks.
IBM Corp., “DB2 UDB for AS/400 Visual Explain Illustrating the Secrets,” pp. 1-36 [online], available from ibm.com/redbooks.
Hellerstein, Joseph M. “Optimization Theories for Queries with Expensive Methods.” University of California, Berkeley. In ACM Transactions on Database Systems, vol. 23, No. 2, Jun. 1998, pp. 113-157.
Bossman Patrick Dooling
Fuh You-Chin
Liu Chan-Hua
Wang Ping
Wang Yun
Alam Shahid
Fleurantin Jean Bolte
Konrad Raynes & Victor LLP
Victor David W.
LandOfFree
Method, system, and program for performance tuning a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method, system, and program for performance tuning a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system, and program for performance tuning a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3625975