Data query system load optimization

Details Data query system load optimization Data query system load optimization

2006-10-24

2006-10-24

Gaffin, Jeffrey (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C705S026640

Reexamination Certificate

active

07127449

ABSTRACT:
A system, method and article of manufacture for query execution management in a data processing system and, more particularly, for optimizing execution of queries that are repeatedly executed against one or more databases in a data processing system. One embodiment provides a method for optimizing execution of a query that is repeatedly issued from an issuing entity against a database. The method comprises executing the query against the database to obtain an initial query result, returning the initial query result to the issuing entity, and managing re-execution of the query. Managing the re-execution comprises storing the initial query result in a temporary query result data structure, executing a trigger procedure for tracking database changes, when the trigger procedure detects a database change, updating the temporary query result data structure on the basis of the detected database change, and when the query is re-executed against the database, returning the temporary query result data structure to the issuing entity as query result.

REFERENCES:
patent: 5471629 (1995-11-01), Risch
patent: 6212514 (2001-04-01), Eberhard et al.
patent: 2003/0182197 (2003-09-01), Beckman

Affiliated with

Also associated with

Rating

Data query system load optimization does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Data query system load optimization, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Data query system load optimization will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3667692