Method and apparatus for retrieving cached database search results
AssigneeMcKesson Financial Holdings
InventorRyan Scanlon
Life of this patent
Estimating the term…
Abstract
A method, apparatus and computer program product are provided to efficiently respond to database queries. In the context of a method, a database query is received and a hashed representation of the database query is created. The method also determines whether the hashed representation of the database query serves as a key to a database cache. In an instance in which the hashed representation of the database query is determined to serve as the key to the database cache, the method retrieves database search results from the database cache. Alternatively, in an instance in which the hashed representation of the database query is determined not to serve as the key to the database cache, a search of the database is performed based upon the database query.
Claims20
A method comprising:
- receiving a database query;
- creating, by a processor, a hashed representation of the database query;
- determining whether the hashed representation of the database query serves as a key to a database cache;
- in an instance in which the hashed representation of the database query is determined to serve as the key to the database cache, retrieving database search results from the database cache;
- and
- in an instance in which the hashed representation of the database query is determined not to serve as the key to the database cache, performing a search of a database based upon the database query.
An apparatus comprising processing circuitry configured to:
- receive a database query;
- create a hashed representation of the database query;
- determine whether the hashed representation of the database query serves as a key to a database cache;
- in an instance in which the hashed representation of the database query is determined to serve as the key to the database cache, retrieve database search results from the database cache;
- and
- in an instance in which the hashed representation of the database query is determined not to serve as the key to the database cache, perform a search of a database based upon the database query.
A computer readable storage medium comprising instructions that, when executed by a processor, cause the processor to:
- receive a database query;
- create a hashed representation of the database query;
- determine whether the hashed representation of the database query serves as a key to a database cache;
- in an instance in which the hashed representation of the database query is determined to serve as the key to the database cache, retrieve database search results from the database cache;
- and
- in an instance in which the hashed representation of the database query is determined not to serve as the key to the database cache, perform a search of a database based upon the database query.
Dependencies are inferred from the claim text.