Method and apparatus for caching result sets from queries to a r

Details Method and apparatus for caching result sets from queries to a r Method and apparatus for caching result sets from queries to a r

1997-09-15

1999-05-11

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 3, 707 10, G06F17/30

Patent

active

059038870

ABSTRACT:
A method enables a data manipulation action to occur between data from a data source and data in a table in a database, where the database is remote from the data source. The method includes the steps of: determining whether data from the data source comprises unique values, and if not, enabling a caching procedure. The caching procedure obtains values from the data source and transmits a query to a database management system which controls the table, including a value from the data source. A result set is received from the table, is cached, and additionally is stored for purposes of responding to the query. Thereafter, if a value from the data source is retrieved which is identical to a previously retrieved data source value, the cached corresponding result set is utilized, in lieu of transmitting a further query to the table.

REFERENCES:
patent: 5548758 (1996-08-01), Pirahesh et al.
IBM Technical Disclosure Bulletin, vol. 31, No. 5, Oct. 1988, pp. 301-303, "Interpretive Database Merge Join Operation".
CIKM 93, Nov. 1-5, 1993, pp. 423-438, Chun-Nan Hsu et al., "Reformulating Query Plans for Multidatabase Systems".
CIKM 94, Nov. 29-Dec. 2, 1994, pp. 433-438, Ygal Arens et al., "Intelligent Caching: Selecting, Representing, and Reusing Data in an Information Server".

Affiliated with

Also associated with

Rating

Method and apparatus for caching result sets from queries to a r does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for caching result sets from queries to a r, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for caching result sets from queries to a r will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-255564