ANALYZING DATABASE CLUSTER BEHAVIOR BY TRANSFORMING DISCRETE TIME SERIES MEASUREMENTS

摘要

A method, system, and computer program product for analyzing performance of a database cluster. Disclosed are techniques for analyzing performance of components of a database cluster by transforming many discrete event measurements into a time series to identify dominant signals. The method embodiment commences by sampling the database cluster to produce a set of timestamped events, then pre-processing the timestamped events by tagging at least some of the timestamped events with a semantic tag drawn from a semantic dictionary and formatting the set of timestamped events into a time series where a time series entry comprises a time indication and a plurality of values corresponding to signal state values. Further techniques are disclosed for identifying certain signals from the time series to which is applied various statistical measurement criteria in order to isolate a set of candidate signals which are then used to identify indicative causes of database cluster behavior.

主权项

1. A computer implemented method for analyzing performance of components of a database cluster by transforming discrete events into a time series to identify dominant signals, the method comprising:
sampling, using a measurement instrument, a plurality of discrete event measurements of the database cluster to produce a set of timestamped events, at least some of the timestamped events sampled by one or more hardware components or one or more software components of the database cluster; formatting the set of timestamped events into a time series wherein a time series entry comprises a time indication and a plurality of values, the values corresponding to a state value of the database cluster; and processing the time series to identify at least one state signal.