ENHANCED CONTROL TO USERS TO POPULATE A CACHE IN A DATABASE SYSTEM
First Claim
1. A method of facilitating a user to populate a cache in a database system, said method being performed in a client system, said method comprising:
- determining in said client system, that processing of a first query in said database system requires an information stored in said database system;
sending, from said client system to said database system on a network, first an explicit indication to load said information into said cache contained in said database system and then said first query to be performed in said database system, wherein said explicit indication is sent in response to said determining; and
receiving, in said client system on said network, a result of performance of said first query from said database system in response to said sending said first query,wherein said client system and said database system are implemented as separate systems coupled by said network.
0 Assignments
0 Petitions
Accused Products
Abstract
Providing enhanced control to users to populate a cache in a database system. A user provides an explicit indication indicating the specific information (available from the data stored in a storage of the database system) to be populated in the cache, and the cache is populated with the corresponding information. The information in the cache (whether due to explicit indications or otherwise) can then be used to generate results of queries, without having to access the same information from the storage of the database system.
-
Citations
12 Claims
-
1. A method of facilitating a user to populate a cache in a database system, said method being performed in a client system, said method comprising:
-
determining in said client system, that processing of a first query in said database system requires an information stored in said database system; sending, from said client system to said database system on a network, first an explicit indication to load said information into said cache contained in said database system and then said first query to be performed in said database system, wherein said explicit indication is sent in response to said determining; and receiving, in said client system on said network, a result of performance of said first query from said database system in response to said sending said first query, wherein said client system and said database system are implemented as separate systems coupled by said network. - View Dependent Claims (2, 3, 4)
-
-
5. A computing system comprising:
-
a network; a database system comprising; a storage storing user data in a plurality of tables, with each table containing a plurality of rows to store corresponding user data; a cache; and a processor to perform queries received on said user data; and a client system operable to; determine that processing of a first query by said database system requires an information stored in said storage; in response to said determination, send on said network, an explicit indication indicating that said information in said storage of said database system is to be loaded into said cache; after sending of said explicit indication, send on said network to said database system, a first request specifying said first query, wherein said processor is designed to receive on said network said explicit indication, examine said storage to determine said information and store said information in said cache as a response to said explicit indication, wherein said processor is further designed to receive on said network said first request, process said first query based on said information already stored in said cache, and send a result of processing of said first query as a response to said first request, wherein said client system and said database system are implemented as separate systems coupled by said network. - View Dependent Claims (6, 7, 8)
-
-
9. A computer readable medium storing one or more sequences of instructions for causing a client system to facilitate a user to populate a cache in a database system, wherein execution of said one or more sequences of instructions by one or more processors contained in said client system causes said client system to perform the actions of:
-
determining in said client system, that processing of a first query in said database system requires an information stored in said database system; sending, from said client system to said database system on a network, first an explicit indication to load said information into said cache contained in said database system and then said first query to be performed in said database system, wherein said explicit indication is sent in response to said determining; and receiving, in said client system on said network, a result of performance of said first query from said database system in response to said sending said first query, wherein said client system and said database system are implemented as separate systems coupled by said network. - View Dependent Claims (10, 11, 12)
-
Specification