Design And Implementation Of Integrated Resource Data Collection And Audit System

As one of the standard systems required by Telecom Operators,at present each carrier provincial company has been established for many years.After nearly ten years of construction,the comprehensive resource system of some operator provincial company has managed the entire network of professional resource data,and data sources include professional network management collection,manual site survey,project new entry and other channels.During subsequent data maintenance,maintainers maintain the same data multiple times in different systems and in some cases professional network management has been adjusted,but the data of integrated resource system is not maintained in time,or the data of integrated resource system is different from that of professional network management.As a result,the resource data is inaccurate and the integrated resource system cannot provide accurate data support for front-end business applications.Taking the whole service system as an example,the service opening time is required to be within a day or even a few hours.Based on the existing data quality,the integrated resource system is difficult to accurately support.At present,the integrated resource system of operators basically has a data accuracy guarantee scheme,among which,collecting the full amount of data from various professional network management for data comparison is a relatively mature audit solution in the industry.But there are still many professional network management,for example,data processing time is long,maintenance is not timely and other problems.The data acquisition and audit system of some operator provincial company's comprehensive resources in this thesis will be improved and optimized in order to improve its execution efficiency.In audit strategies,the combination of full-volume collection and audit comparison and incremental collection and audit comparison are adopted to meet the requirements of timely and accurate data without occupying too much IT resources.In the process of data processing,the execution efficiency has been improved by means of task management,link division and concurrent execution.In data analysis,with the advantages of Perl language in file parsing,data parsing can meet the requirements of fast processing of a large number of data files in various formats.In data entry and comparison link,it can optimize the database processing efficiency with the help of Oracle partition table and other related features.Finally,the overall execution efficiency of the data collection and audit system of some operator provincial company's comprehensive resources is guaranteed,the pressure of professional network management is reduced,and the data accuracy of comprehensive resources is improved through a series of measures.Especially in the user's attention to the opening of the full service,the current data quality has been able to meet the user in a day or even a few hours to complete the service opened,and the rate of patency is up to 99.8%,which enhances the competitiveness of some operator provincial company effectively.