History data access method and apparatus

Abstract

The invention discloses a method for accessing historical data, which comprises the steps that: an original table is established; every collected piece of historical data record is divided into the original table according to collecting time so as to obtain original sub-tables; marking ID number fields are set for the original sub-tables and a non-clustered index is created on the ID number fields; information tables corresponding to the original sub-tables are generated according to the historical data records and the ID number fields in the original sub-tables; inquiry operation is carried out according to input inquiry condition and the inquiry mode of the original sub-table scanning or the information table pre-scanning chosen by the original sub-tables and the information tables; the historical data record which accords with the inquiry condition is obtained after the inquiry operation is carried out according to the inquiry mode of the original sub-table scanning or the information table pre-scanning; the invention also discloses a device for accessing the historical data, and the efficiency of inquiring the historical data can be enhanced on the basis of the method and the device.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method for accessing massive historical data in a telecommunication network management system. Background technique [0002] In a database-based communication system, the efficiency of data access has an important impact on the overall operation of the system, especially in the field of telecommunications, whether it is a business operation support (BOSS, Business & Operation Support System) system or a network management system. The application environment of massive data. The application environment of massive data has high requirements for data access efficiency. Taking transmission network management as an example, one of its important functions is to monitor the operating status of network equipment. Generally, 15 minutes or 24 hours is used as a collection cycle to collect operational performance data of network equipment. Data collection is carried out according to t...

AI Technical Summary

Problems solved by technology

[0005] However, the outstanding disadvantage of this processing method is that it does not take into account the characteristics of massive monitoring data generated during the operation of the telecommunication network and complex query conditions, but stores them as ordinary data, so there will be the following problems question:

[0006] 1. The query data command specified by the network management interface operation cannot be returned for a long time;

[0007] 2. During the query operation, the database occupies too many system resources such as the central processing unit (CPU, Central Processing Unit) and memory, which seriously interferes with other operations of the entire system

Images