Management method for massive network management historical data

A technology of historical data and management methods, applied in the management field of historical data in the network management system, can solve problems such as unusable data and affecting the availability of the network management system, and achieve the effects of reducing lock competition, improving customer experience, and ensuring response efficiency

CN102867071AActive Publication Date: 2013-01-09WUHAN FIBERHOME TECHNICAL SERVICES CO LTD
5 Cites 32 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Publication Date
2013-01-09

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention relates to management of historical data in a network management system, specifically to a management method for massive network management historical data. A database can be divided into tables on the basis of a two-level table division rule, and the data saved in a single table in which the massive network management historical data are stored are stored in a plurality of divided tables in the same structure after being divided, so that the capacity of the single table can be reduced, the processing efficiency of the single table can be increased, and each of the divided tables can be managed as follows: A, management of historical data in divided tables; B, insertion management of historical data; C, query management of historical data; and D, transfer management of historical data. The management method for massive network management historical data disclosed by the invention can save massive historical data and helps to efficiently insert, inquire and transfer the data without affecting the normal use of network management software, so that the working efficiency of the network management system can be improved.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to the management of historical data in a network management system, in particular to a method for managing massive historical data in a network management system. Background technique

[0002] At present, network technology is changing with each passing day, the scale of broadband users continues to expand, and the number of devices managed by the telecom network management system is also increasing. The daily management logs of the telecom network management system, equipment alarm data and other data need to be stored in the database. The telecom network management system is responsible for these data. The way to use it is to record data, query and analyze data. After a long period of time, these data are getting bigger and bigger. If the data is not managed effectively, whether it is data insertion or data query, the performance will drop sharply, which will affect the normal use of network management software. The database u...

Examples

Embodiment Construction

[0055] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0056] The method for managing the massive historical data of the network management according to the present invention realizes the sub-table of the database through the two-level sub-table rule, and saves the data stored in a single table containing the massive historical data of the network management into multiple sub-tables with the same structure after segmentation , reduce the capacity of the single table, thereby improving the processing efficiency of the single table, and perform the following management on each sub-table:

[0057] A historical data sub-table management,

[0058] B historical data insertion management,

[0059] C historical data query management,

[0060] D Historical data transfer management.

[0061] On the basis of the above technical solutions, figure 2 The content of the data table sub-table rule file is shown, which is the...