Design And Implementation Of Broadband Data Analysis System

With the continuous development of network technology and the continuous updating of network applications,broadband access technology is constantly evolving in order to meet the demand.At present,FTTH(fiber to the home,FTTH)is becoming more and more popular,and all ISPs(internet service provider,ISP)need to play the role of FTTH transformation on existing x DSL access networks.However,there is no better solution to determine the areas of FTTH transformation,to locate the fiber and change the target customers,and to make fiber transformation plans except making the statistics and analysis manually,which is inefficient and easy to make mistakes.At the same time,it is difficult to supervise the construction quality of fiber transformation.Although a large number of business analysis systems have been established by local ISPs in China,which achieved the goal o f informatization on business management and analysis initially,the requirements brought by the fiber transformation to business management still cannot be satisfied.Therefore,it is urgent to build a broadband data analysis system to solve the problems mentioned before,which can liberate manpower and increase production efficiency finally.In this thesis,both domestic and abroad development trend of related technology areas are investigated,and the design direction of the broadband data analysis system is determined.Firstly,a broadband user access identification scheme based on the standard of the device name and device model,using the plaintext identification of user's physical port by a RADIUS server and the principle and characteristics of the use of PPPo E+ protocol,is established,which realizes the identification and management of broadband user access ing.A database of services is established at the same time,which can lay the foundation for the realization o f system functions.Secondly,the requirements of the broadband data analysis system are analyzed,and plans are made from the functional perspectives.The analysis is divided into three major application modules which are service analysis,user management,and system management.The business analysis mainly includes statistics on daily business management reports and user structure reports.The fiber transformation user management is the core function of the system,which helps the business managers to finish the fiber transformation work orderly.Duplicate uploading check of construction photos can be realized by MD5 encryption.The system management mainly manages the menus,permissions,and users of the broadband data.The user's access rights can be configured flexibly and are not limited by user groups.Finally,a B/S architecture solution based on SQL Server database-based online analytical processing,is found,which achieves dynamic statistical analysis of data by the database storing procedures.Applying the broadband data analysis system in Chinamobile Tietong Heilongjiang Branch,the efficiency of construction and quality control have been obviously improved,which solves the problems of fiber transformation user location and construction quality supervision of fiber transformation.