Apparatus and method for refreshing a database query

Details Apparatus and method for refreshing a database query Apparatus and method for refreshing a database query

2006-11-14

2006-11-14

Kindred, Alford W. (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07136848

ABSTRACT:
Previously-optimized database queries are stored in memory. When a new query needs to be optimized, the previously-optimized queries are examined to determine whether the new query has been previously optimized. If the new query has not been previously optimized, the previously-optimized queries are examined to determine whether any previously-optimized queries differ only in data type of one or more operands when compared to the new query. If a previously-optimized query that differs only in data type is located, the previously-optimized query is refreshed to reflect the different data type without the need of optimizing the new query from scratch. Portions of previously-optimized queries may thus be re-used even when a previously-optimized query is not identical to a new query to be optimized. As a result, the performance of query optimization in a database system is increased.

REFERENCES:
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6263328 (2001-07-01), Coden et al.
patent: 6314430 (2001-11-01), Chang
patent: 2002/0069193 (2002-06-01), Beavin et al.
G. Mitchell, “Extensible Query Processing in an Object-Oriented Database,” May 1993, Thesis, Department of Computer Science, Brown University, pp. 1-166.
IBM Patent Application filed on even date herewith by Carlson et al., “Runtime Query Optimization for Dynamically Selecting from Multiple Plans in a Query Based Upon Runtime-Evaluated Performance Criterion”.
IBM Patent Application filed on even date herewith by Carlson et al., “Parallel Database Query Processing for Non-Uniform Data Sources via Buffered Access”.
IBM Patent Application filed on even date herewith by Carlson et al., “Method for Efficient Processing of Multi-State Attributes”.

Affiliated with

Also associated with

Rating

Apparatus and method for refreshing a database query does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3663031