Getpage-workload based index optimizer

Details Getpage-workload based index optimizer Getpage-workload based index optimizer

2006-05-16

2006-05-16

Amsbury, Wayne (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07047231

ABSTRACT:
The index optimization (XOP) program is a method to recommend new or improved performance indexes for use by an IBM mainframe DB2 database server for a given set of SQL statements. The recommendations are calculated based on a single call of the DB2 optimizer for each SQL statement with the existing index set, parsing of the SQL statements, the filter factors of the SQL statement predicates, and the getpage workload of an SQL statement. The getpage workload of an SQL statement is the read/change activity on each table and each index currently used for all invocations of an SQL statement. The XOP program computes new and improved performance indexes based on the getpage workload of all relevant SQL statements and does not use the DB2 optimizer to determine the usefulness of potential indexes.

REFERENCES:
patent: 5404510 (1995-04-01), Smith et al.
patent: 6006232 (1999-12-01), Lyons
patent: 6182079 (2001-01-01), Lenzie
patent: 6314420 (2001-11-01), Lang et al.
patent: 6662175 (2003-12-01), Ghazal et al.
patent: 6728720 (2004-04-01), Lenzie
patent: 6842753 (2005-01-01), Chaudhuri et al.
patent: 2003/0093408 (2003-05-01), Brown et al.
patent: 2003/0115183 (2003-06-01), Abdo et al.
patent: 2004/0003132 (2004-01-01), Stanley et al.
patent: 1065606 (2001-01-01), None
Gary Bronziet; “Index optimization white paper”; published by: Cogito Limited, Chislehurst, Kent, U.K.; Jul. 7, 2000; 13 pages.
Gary Bronziet; “Index Design Analysis—Why and How?”; The Idug Solutions Journal; May 1, 2001; 3 pages; vol. 8, Issue 1; publisher: International DB2 Users Group, Chicago, USA.

Affiliated with

Also associated with

Rating

Getpage-workload based index optimizer does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Getpage-workload based index optimizer, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Getpage-workload based index optimizer will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3630257