The application provides a
database monitoring operation and maintenance method and
system based on
time series data compression, which realizes real-time monitoring of various index data of a
database platform through efficient
data acquisition and compression technology. The
system can efficiently collect various performance data generated during the operation of the
database, and optimize the
time series data through a compression
algorithm to reduce the redundant storage of data. In the data storage and
management process, the first-order difference sequence and the second-order difference sequence are calculated to reduce the amount of stored data. The use of difference removes the trend in the
original data sequence, making the subsequent difference sequence easier to compress. At the same time, for non-constant difference, by setting a dynamic threshold, only the difference values greater than the threshold are recorded, and the small changes are ignored on the premise of not losing important information of the data, thereby improving the compression rate. On the other hand, by using S relation The regularity of the difference sequence is determined, and the compression strategy can be selectively applied, so that suitable compression methods can be applied to
time series data with different characteristics, thereby improving the
processing efficiency. Through the above design, the storage and
processing efficiency of the compressed data are improved, the
system can quickly decompress and analyze the data, and the real-time monitoring of the running state of the database is realized.