The invention provides a
time sequence data compression-based
database monitoring operation and maintenance method and
system, which realize real-time monitoring of various index data of a
database platform through an efficient
data acquisition and compression technology. The
system can efficiently collect various performance data generated in the operation process of the
database, optimizes
time series data through a compression
algorithm, and reduces redundant storage of the data. In a data storage and
management process, a primary differential sequence and a secondary differential sequence are calculated, so that the stored data volume is reduced; according to the method, a trend in an
original data sequence is removed by using difference, so that a subsequent difference sequence is easier to compress, and meanwhile, for non-constant difference, by setting a dynamic threshold value and only recording a difference value greater than the threshold value, small changes are ignored and the
compression ratio is improved on the premise of ensuring that important
data information is not lost. And on the other hand, the regularity of the differential sequence is judged through Srelative, and a compression strategy can be selectively applied, so that proper compression methods can be specifically applied to
time sequence data with different characteristics, and the
processing efficiency is improved. Through the design, the storage and
processing efficiency of the compressed data is improved, the
system can decompress and analyze the data more quickly, and the running state of the database is monitored in real time.