DUAL OVERLAY QUERY PROCESSING
First Claim
1. A method of processing a query at a plurality of storage devices, comprising:
- receiving a dual query from a client;
executing the dual query at a first storage device and a second storage device;
receiving a result set of the dual query, wherein the result set includes a first set of database records from the first storage device and a second set of database records from the second storage device;
identifying one or more database records of the first set of database records, wherein the one or more database records of the first set have not been used above a threshold number of times within a time period;
copying one or more identified database records of the first set stored in the first storage device to the second storage device; and
removing the copied database records of the first set from the first storage device.
1 Assignment
0 Petitions
Accused Products
Abstract
An example method of processing a query at a plurality of storage devices includes receiving a dual query from a client and generating a synchronous query and an asynchronous query based on the dual query. The dual query includes a set of conditions for selecting data from a set of database tables. The method further includes sending the synchronous query to a first storage device, sending the asynchronous query to a second storage device, and receiving a result set of the synchronous query. The result set of the synchronous query includes data selected from a set of database records in a set of primary database tables, which is stored in the first storage device and is a subset of the set of database tables. The method further includes marking a database record. A marked database record indicates usage of the data selected from the database record within a time period.
2 Citations
20 Claims
-
1. A method of processing a query at a plurality of storage devices, comprising:
-
receiving a dual query from a client; executing the dual query at a first storage device and a second storage device; receiving a result set of the dual query, wherein the result set includes a first set of database records from the first storage device and a second set of database records from the second storage device; identifying one or more database records of the first set of database records, wherein the one or more database records of the first set have not been used above a threshold number of times within a time period; copying one or more identified database records of the first set stored in the first storage device to the second storage device; and removing the copied database records of the first set from the first storage device. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A system for processing a query at a plurality of storage devices, comprising:
-
a query proxy that receives a dual query from a client, executes the dual query at a first storage device and a second storage device, and receives a result set of the dual query, wherein the result set includes a first set of database records from the first storage device and a second set of database records from the second storage device, wherein the query proxy identifies one or more database records of the first set of database records, copies one or more identified database records of the first set stored in the first storage device to the second storage device, and removes the copied database records of the first set from the first storage device, wherein the one or more database records of the first set have not been used above a threshold number of times within a time period. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18, 19)
-
-
20. A machine-readable medium comprising a plurality of machine-readable instructions that when executed by one or more processors is adapted to cause the one or more processors to perform a method comprising:
-
receiving a dual query from a client; executing the dual query at a first storage device and a second storage device; receiving a result set of the dual query, wherein the result set includes a first set of database records from the first storage device and a second set of database records from the second storage device; identifying one or more database records of the first set of database records, wherein the one or more database records of the first set have not been used above a threshold number of times within a time period; copying one or more identified database records of the first set stored in the first storage device to the second storage device; and removing the copied database records of the first set from the first storage device.
-
Specification