US 7,743,053 B2 · Hybrid database query caching

Abstract

In one embodiment, a computer system comprises one or more processors, and a memory module communicatively connected to the one or more processors. The memory module comprises logic instructions stored on a computer readable medium which, when executed on the one or more processors configure the one or more processors to receive, in a hybrid caching module, database query, determine whether at least a portion of an existing execution plan stored in a memory module coupled to the hybrid caching module can be reused to implement the database query, reuse at least a portion of an existing execution plan stored in the memory module coupled to the hybrid caching module when possible, and generate a new execution plan when the memory module lacks an existing execution plan adaptable for use with the database query.

Claims10

Dependent claims

A method, comprising:

receiving, in a hybrid caching module of a computer system executing a database application, a database query;
determining whether at least a portion of an existing execution plan stored in a memory module coupled to the hybrid caching module can be reused to implement the database query by:
searching a text cache of previous database queries for an identical query;
and if an identical query is not found
searching a template cache of execution plans of previous queries for a similar query;
reusing an execution plan of the identical query as an execution plan for the database query when the identical query is found, and reusing a portion of an execution plan of the similar query as the execution plan for the database query when the identical query is not found and the similar query is found;
and
generating a new execution plan for the database query when the memory module lacks an existing execution plan.

5 more elements

A computer system, comprising:

one or more processors;
a memory module communicatively connected to the one or more processors and comprising logic instructions stored on a computer readable storage medium which, when executed on the one or more processors configure the one or more processors to:
receive, in a hybrid caching module, database query;
determine whether at least a portion of an existing execution plan stored in a memory module coupled to the hybrid caching module can be reused to implement the database query by causing the one or more processors to:
search a text cache of previous database queries in the memory module for an identical query;
and if the identical query is not found
search a template cache of execution plans of previous queries in the memory module for a similar query;
reuse an execution plan of the identical query as an execution plan for the database query when the identical query is found, and reuse a portion of an execution plan of the similar query as the execution plan for the database query when the identical query is not found and the similar query is found;
and
generate a new execution plan for the database query when the memory module lacks an existing execution plan.

7 more elements

Dependencies are inferred from the claim text.

Hybrid database query caching

Life of this patent

Hybrid database query caching

Life of this patent

Abstract

Claims10