DATABASE QUERY CACHING AND REUSE

摘要

A query block may be cached, not like the traditional solution, which can only cache a query result for the query block. For example, a work file for storing a result set of a query block may be maintained after relevant query has been completed. In subsequent use, once a query for the query block is received, query may be processed quickly by directly reusing the result set. In this way, the data overheads for reducing the query processing can be significantly reduced, and the response time for shorting the query processing can be shortened. Corresponding methods and systems are described in the present disclosure.

主权项

1. A method, comprising:
obtaining a query block contained in a query for a database; and in response to the query block satisfying a predetermined caching condition, creating a cache entry for the query block, wherein the cache entry indicates a plurality of statements and a result set for the query block, and wherein the cache entry is maintained after the query is completed.