Method of retrieving data from a relational database

Details Method of retrieving data from a relational database Method of retrieving data from a relational database

1996-10-28

1999-12-28

Ho, Ruay Lian

Data processing: database and file management or data structures

Database design

Data structure types

707203, G06F 1730

Patent

active

060092718

ABSTRACT:
A computerized method of retrieving data from a relational database stored in a computer memory, using SQL queries, which give rise to result sets derived from data objects in the database. The method includes the steps of capturing an SQL query and corresponding result set, and saving the SQL query and result set. In another feature of the invention, the method includes, before the step of capturing an SQL query and corresponding result set, the step of monitoring the SQL queries. In another feature of the invention, the method includes, before the step of saving the SQL result set, the steps of comparing the SQL query with prior saved SQL queries, determining if an identical prior SQL query already exists in cache, and if an identical prior SQL query does not already exists, saving the SQL query and result set. In another feature of the invention, each data object used by the saved result sets has an associated data object time stamp, and the method of the invention monitors the data object time stamps of all data objects used by the result sets.

REFERENCES:
patent: 5222235 (1993-06-01), Hintz et al.
patent: 5257366 (1993-10-01), Adair et al.
patent: 5280612 (1994-01-01), Lorie et al.
patent: 5317742 (1994-05-01), Bapat
patent: 5367675 (1994-11-01), Cheng et al.
patent: 5396623 (1995-03-01), McCall et al.
patent: 5408654 (1995-04-01), Barry
patent: 5430871 (1995-07-01), Jamoussi et al.
patent: 5432933 (1995-07-01), Janicek
patent: 5440692 (1995-08-01), Janicek
patent: 5446885 (1995-08-01), Moore et al.
patent: 5619713 (1997-04-01), Baum et al.
patent: 5630127 (1997-05-01), Moore et al.
patent: 5671403 (1997-09-01), Shekita et al.
patent: 5692174 (1997-11-01), Bireley et al.
patent: 5692182 (1997-11-01), Desai et al.
patent: 5706506 (1998-01-01), Jensen et al.
patent: 5742810 (1998-04-01), Ng et al.
patent: 5875334 (1999-02-01), Chow et al.

Affiliated with

Also associated with

Rating

Method of retrieving data from a relational database 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 of retrieving data from a relational database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method of retrieving data from a relational database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2388696