DISTRIBUTED QUERY CACHE IN A DATABASE SYSTEM
First Claim
1. A method comprising:
- receiving a request from a client of a plurality of clients for a compiled skeletal query corresponding to an identified skeletal query form for accessing records of a database;
searching a server cache to determine whether the compiled skeletal query corresponding to the identified skeletal query form from another client of the plurality of clients is available;
if the compiled skeletal query is available, providing access to the compiled skeletal query to the client, in response to the request.
7 Assignments
0 Petitions
Accused Products
Abstract
A distributed query system includes a distributed collection of dynamically created compiled queries. As each client submits a query, a parameterized query skeleton is identified, which identifies the general form of the query, and the parameters associated with the particular query. If a compiled form of the skeletal query is available within the distributed system, it is executed with the parameters of the current query. If the compiled form of the skeletal query is not available within the distributed system, a compiled form is created, and the location of this compiled skeletal query is stored for subsequent access by this client, or other clients. The executable compiled skeletal queries may be stored at each client system, or in a commonly available server storage system.
19 Citations
27 Claims
-
1. A method comprising:
-
receiving a request from a client of a plurality of clients for a compiled skeletal query corresponding to an identified skeletal query form for accessing records of a database; searching a server cache to determine whether the compiled skeletal query corresponding to the identified skeletal query form from another client of the plurality of clients is available; if the compiled skeletal query is available, providing access to the compiled skeletal query to the client, in response to the request. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A non-transitory computer-readable medium that includes a computer program, which, when executed by a processing system at a client causes the processing system to:
-
receive a user query at a client for selecting data from a database; parse the user query to identify a skeletal query form corresponding to the user query and one or more arguments associated with the user query; access a server cache that is in communication with other clients to determine whether a compiled skeletal query from an other client corresponding to the identified skeletal query form is available; and if the compiled skeletal query is available; execute the compiled skeletal query using the one or more arguments of the user query, and provide results of the executing of the compiled skeletal query in response to the user query. - View Dependent Claims (11, 12, 13, 14)
-
-
15. A non-transitory computer-readable medium that includes a computer program, which, when executed by a processing system at a server causes the processing system to:
-
receive a request from a client of a plurality of clients for a compiled skeletal query corresponding to an identified skeletal query form; determine whether the compiled skeletal query from another client corresponding to the identified skeletal query form is available; and
,if the compiled skeletal query is available, providing access to the compiled skeletal query to the client, in response to the request. - View Dependent Claims (16, 17, 18, 19, 20)
-
-
21. A system comprising:
-
a plurality of clients; and a server cache; wherein; a client of the plurality of clients parses a user query to identify a skeletal query form corresponding to the user query and one or more arguments associated with the user query for accessing records of a database, and communicates a request to the server cache to access to a compiled skeletal query from an other client corresponding to the identified skeletal query form; if the server cache determines that the compiled skeletal query is available; the server cache provides access to the compiled skeletal query to the client; and the client executes the compiled skeletal query using the one or more arguments of the user query, and provides results of the execution of the compiled skeletal query in response to the user query. - View Dependent Claims (22, 23, 24, 25, 26, 27)
-
Specification