System And Method For Query Resource Caching
AssigneeOracle International Corporation
InventorsOleksiy Ignatyev, Mihail Mihaylov
Life of this patent
Estimating the term…
Abstract
Operations include determining whether to cache resources accessed by a query based on the execution time of the query. The system identifies a set of executions of a same query. The system determines a cumulative execution time for the set of executions of the same query. If the cumulative execution time exceeds a threshold value, then the system caches a resource used for execution of the query.
Claims21
One or more non-transitory computer readable media comprising instructions which, when executed by one or more hardware processors, causes performance of operations comprising:
- identifying a first plurality of executions of a first query during a first period of time;
- comparing an execution time of each execution, of the first plurality of executions of the first query, to a first threshold value;
- identifying a first subset of executions, of the first plurality of executions, with corresponding execution times that exceed the first threshold value;
- determining whether a first number of executions, in the first subset of executions, exceeds a second threshold value;
- responsive to determining that the first number of executions, in the first subset of executions, exceeds the second threshold value:
- caching a first resource, used for execution of the first query, for a second period of time.
A method including operations comprising:
- identifying a first plurality of executions of a first query during a first period of time;
- comparing an execution time of each execution, of the first plurality of executions of the first query, to a first threshold value;
- identifying a first subset of executions, of the first plurality of executions, with corresponding execution times that exceed the first threshold value;
- determining whether a first number of executions, in the first subset of executions, exceeds a second threshold value;
- responsive to determining that the first number of executions, in the first subset of executions, exceeds the second threshold value:
- caching a first resource, used for execution of the first query, for a second period of time,
- wherein the method is executed by at least one device including a hardware processor.
A system comprising:
- at least one device including a hardware processor;
- the system being configured to perform operations comprising:
- identifying a first plurality of executions of a first query during a first period of time;
- comparing an execution time of each execution, of the first plurality of executions of the first query, to a first threshold value;
- identifying a first subset of executions, of the first plurality of executions, with corresponding execution times that exceed the first threshold value;
- determining whether a first number of executions, in the first subset of executions, exceeds a second threshold value;
- responsive to determining that the first number of executions, in the first subset of executions, exceeds the second threshold value:
- caching a first resource, used for execution of the first query, for a second period of time.
Dependencies are inferred from the claim text.