System and method for loading a cache with query results

Details System and method for loading a cache with query results System and method for loading a cache with query results

2005-08-23

2005-08-23

Corrielus, Jean M. (Department: 2172)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

06934699

ABSTRACT:
A system and method for avoiding accessing a remote database twice, once during query execution and again to retrieve objects identified by the query, when an application requires objects on which to operate. During query plan generation in response to a request for database objects from an application, a query optimizer inserts cache operators into the candidate plans, and then a cost-benefit analysis is undertaken to identify the best plan. The best plan is then used to execute the query, with the cache operators causing objects identified during query execution to be cached locally to the requesting application as the query is being executed, thereby avoiding requiring the application to access the database after query execution.

REFERENCES:
patent: 5530799 (1996-06-01), Marsh et al.
patent: 5598559 (1997-01-01), Chaudhuri
patent: 5615362 (1997-03-01), Jensen et al.
patent: 5668987 (1997-09-01), Schneider
patent: 5706506 (1998-01-01), Jensen et al.
patent: 5812996 (1998-09-01), Rubin et al.
patent: 5822747 (1998-10-01), Graefe et al.
patent: 5822749 (1998-10-01), Agarwal
patent: 5897634 (1999-04-01), Attaluri et al.
patent: 5903887 (1999-05-01), Kleewein et al.
patent: 5956706 (1999-09-01), Carey et al.
patent: 6275818 (2001-08-01), Subramanian et al.

Affiliated with

Also associated with

Rating

System and method for loading a cache with query results 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 loading a cache with query results, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for loading a cache with query results will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3502969