Research And Application Of Data Access Methods On A Networking Audit Platform

With the rapid growth of auditing service,developing the auditing by computer technology has been an important working manner as the auditing work become more complex. Networking audit platform is an integrated service platform which provides convenient audit service for numerous provincial auditors. The platform performance can improve the efficiency of auditors. Obviously,it is a great significance topic to research and optimize the data access method.This paper presents the optimization strategies of data access methods through researching the traditional data access methods and analyzing existing problems based on the networking platform data characteristic. Optimization strategies mainly include two aspects,optimizing the multi-threaded concurrent data access and database access technology.In the network auditing platform, audit sever accesses the audit data by multi-thread execute concurrence method. The author designs the adaptive thread pool to optimize the multi-thread technology, which can administrate data in the thread pool efficiently, adjust the capacity of thread pool for rapidly respond to auditor request and keep the thread pool running at efficiency status. In additional, the paper optimizes multi-threaded concurrent operation in the thread pool to reduce the consumption of system resource and achieve the goal that the system can spend less system resources to start more threads concurrent access data.This paper analyzes the problems existing in the traditional database access technology and design an adaptive database connection pool that can optimizes the database access technology. Adaptive database connection pool automatic adjusts the capacity of thread pool as the database accessing situation,improves execution efficiency through connecting the objects by optimizing management strategies of connection pool control database .Meanwhile,the author optimizes the database access technology based on the characteristics of the audit data, including data buffer strategy,results set optimization and audit doubt batch. Those optimization strategies can improve accessing efficiency and show the accessing results for auditors quickly.This paper applies the optimization strategy of data accessing method in network auditing platform, compared the results of data accessing efficiency before and after testing to verify the optimization feasibility.