System and method for addressing inefficient query processing

Details System and method for addressing inefficient query processing System and method for addressing inefficient query processing

2003-12-24

2008-05-20

Rimell, Sam (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07376638

ABSTRACT:
A system and method for analyzing predicate usage and proposing solutions to improve query performance. The system comprises a system for collecting performance statistics for database queries; an aggregation system that organizes the performance statistics based on predicate combinations used in the database queries; and an evaluation system that compares the performances of queries having similar predicate combinations. Further features include a problem identification system that identifies a predicate, which when added to a query, results in a low performing query, and a solution proposal system that automatically proposes a solution to address the low performing query.

REFERENCES:
patent: 5778354 (1998-07-01), Leslie et al.
patent: 5848408 (1998-12-01), Jakobsson et al.
patent: 5857184 (1999-01-01), Lynch
patent: 5864840 (1999-01-01), Leung et al.
patent: 5899986 (1999-05-01), Ziauddin
patent: 6189004 (2001-02-01), Rassen et al.
patent: 6651055 (2003-11-01), Kilmer et al.
patent: 2002/0198867 (2002-12-01), Lohman et al.
patent: 2004/0210563 (2004-10-01), Zait et al.
Stillger et al. “LEO—DB2's LEaring Optimizer” Proccedings of the 27th VLDB Conferance, Italy 2001pp. 1-10.
Lohman et al. “Smart: Making DB2 (More) Automatic” Proceedings of the 28th VLBD Conferance, Hong Kong, China, 2002 pp. 1-3.
Valentin et al. “DB2 Advisor: An Optimizer Smart Enough to Recomend Its Own Indexes” pp. 1-9.
“Oracle8 Server Tuning” Jun. 1997 Chapter 22 pp. 22-1-22-32.

Affiliated with

Also associated with

Rating

System and method for addressing inefficient query processing does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for addressing inefficient query processing, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for addressing inefficient query processing will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3981477