Apparatus and method for saving historical data

Abstract

The invention discloses a method and a device for storing historical data, and relates to the storing of network management historical data. The invention is invented to solve the problem existing in the prior art that the historical data sheet is too large to cause the locking time for the sheet to be inserted with data to be overlong and influence the user to normally inquiry the historical data. The method for storing the historical data comprises the following steps: firstly, the data quantity upper limit of the sheet is set; secondly, whether the historical data in the sheet exceeds the data quantity upper limit is judged. If the historical data in the sheet exceeds the data quantity upper limit, the historical data part which exceeds the data quantity upper limit is inserted to a dump sheet, and is deleted from the sheet. The corresponding device of the invention comprises an original sheet provided with a data appending interface and a data inquiry interface, and also comprises a dump sheet, and the dump sheet is provided with a data inquiry interface. A data transferring interface is arranged between the dump sheet and the original sheet. The invention is mainly applied to store the historical data in a network management system.

Description

technical field [0001] The invention relates to a method and a device for storing data, in particular to a method and a device for storing network management historical data. Background technique [0002] In many existing management systems, system data needs to be backed up in real time, and historical data generated by backup often takes up too much space. For example, for a DWDM (Dense Wavelength Division Multiplexing) system, each board of the network element will report 15 minutes of historical performance data to the network management every 15 minutes, even if it is kept in the database for 3 months according to the minimum requirements of the project Historical performance data, in the case of configuring all 32 waves and 100 network elements, the space occupied by historical performance data is also about 8G. Taking the 15-minute historical performance data of the transmission network management system as an example, the network element regularly reports the histor...

AI Technical Summary

Problems solved by technology

[0003] In this way, since the database table has added an index for query efficiency, the data insertion operation after the database table is too large needs to be addressed in the index, which will consume more time, and may be due to the time when the table is locked when historical data is stored. Too long will cause users to fail to query historical data on the network management interface, reducing the availability of the management system, and this situation is very common in the current network management system

The root cause of these defects is that the existing historical data is only stored in one data table, and there is no good data management for this only data table

Images