Optimizing performance of complex transactions across databases
AssigneeInternational Business Machines Corporation
InventorsYuan Gao, Xiao Min Zhao, Shuang Li, Hao Wu
Life of this patent
Estimating the term…
Abstract
Method, computer program product, and computer system are provided. A plurality of query activities are captured from one or more monitored databases. The query activities are persisted into a graph-enabled database repository. The plurality of query activities are classified into a plurality of workload rules based on there being a correlations between the plurality of query activities. A plurality of components of a total execution time of each query in a workload rule is analyzed. One or more problematic queries is identified based on the analyzing.
Claims23
A method, comprising:
- performing timeseries analysis on historic metric information from completed queries according to a configurable time window, wherein the historic metric information is stored in each of one or more monitored databases;
- classifying the analyzed timeseries historic metric information into a frequent set, wherein the frequent set is a correlation of at least two queries;
- querying a graph-enabled repository database for a workload rule matching the frequent set;
- based on a matching workload rule not being found, adding the frequent set as a node to the graph-enabled repository database as a new workload rule;
- and
- performing a workload bottleneck analysis.
(canceled)
A computer program product, the computer program product comprising a non-transitory tangible storage device having program code embodied therewith, the program code executable by a processor of a computer to perform a method, the method comprising:
- performing timeseries analysis on historic metric information from completed queries according to a configurable time window, wherein the historic metric information is stored in each of one or more monitored databases;
- classifying the analyzed timeseries historic metric information into a frequent set, wherein the frequent set is a correlation of at least two queries;
- querying a graph-enabled repository database for a workload rule matching the frequent set;
- based on a matching workload rule not being found, adding the frequent set as a node to the graph-enabled repository database as a new workload rule;
- and
- performing a workload bottleneck analysis.
(canceled)
A computer system, comprising:
- one or more processors;
- a memory coupled to at least one of the processors;
- a set of computer program instructions stored in the memory and executed by at least one of the processors in order to perform actions of:
- performing timeseries analysis on historic metric information from completed queries according to a configurable time window, wherein the historic metric information is stored in each of one or more monitored databases;
- classifying the analyzed timeseries historic metric information into a frequent set, wherein the frequent set is a correlation of at least two queries;
- querying a graph-enabled repository database for a workload rule matching the frequent set;
- based on a matching workload rule not being found, adding the frequent set as a node to the graph-enabled repository database as a new workload rule;
- and
- performing a workload bottleneck analysis.
(canceled)
Dependencies are inferred from the claim text.