Design And Implementation Of Network Authentication And Accounting Query System Based On ETL

This paper is based on the network authentication and accounting system of northwestA&F university.In order to solve the problem of less-than-friendly user interface for self-inquiry, unclear information expression and a large number of user queries have became sucha burden on the authentication and accounting system etc,by studying the data extraction,transformation and loading of network authentication and accounting system based on ETL,alightweight web development framework Spring is proposed by integrating technologies ofMyBatis,Ajax and jQuery.Finally,the statistics and reports of user information,costinformation and flow information for users based on FusionCharts is actualized.The mainresearch contents and conclusions are as follows:(1) Researches the data ETL technology and Oracle data integration tool ODI.Theapplication of total extraction and incremental extraction conditions were discussed,especiallyanalyzed the advantages and disadvantages of the trigger,timestamp,full table comparison andthe Oracle CDC incremental extraction scheme.In order to provide reliable data sources forauthentication and accounting inquiry system development,describes in detail the various datatransformation and data loading method.(2) Designs an incremental data extraction scheme based on ODI.Creates a singletimestamp tables in the source database,for the time to save the data synchronization.The nextdata extraction, simply draw more than the time record, can complete the incrementalextraction.The scheme avoids intrusive operations on the source tables of productiondatabase.(3) Researches the Spring framework and displays user information, cost informationand flow information through dynamic FusionCharts chart by integrating the technologies ofMyBatis, Ajax and jQuery.It solves the problem of less-than-friendly user interface for self-inquiry. Actualizes the two application modes of campus network authentication andaccounting self-inquiry system and authentication and accounting read-writeseparation,reduces the burden of user self-inquiry of authentication and accountingsystem,improves the authentication efficiency.