联网审计平台中数据访问方法研究及应用

发布时间：2018-07-29 05:39

【摘要】：随着审计业务快速增长,审计工作变得更加复杂。通过计算机技术完成审计工作已成为审计人员重要的工作方式。联网审计平台是审计厅提供给全省广大审计人员展开审计工作的一个综合服务型平台,审计平台的执行性能决定审计人员工作效率。因此,对联网审计平台数据访问方法的研究与优化具有重要意义。本文研究传统数据访问方法并分析存在的问题,根据联网审计平台访问的数据特点提出数据访问方法的优化策略,优化策略主要包括两个方面,分别是多线程并发数据访问的优化和数据库访问技术的优化。在联网审计平台中,审计服务端是通过多线程执行审计方法并发的访问审计数据,本文通过设计自适应线程池优化多线程技术,自适应线程池可以有效的管理线程池中线程对象,通过设计自适应线程池尺寸调整算法,能够根据审计任务请求情况动态调整线程池的尺寸,使线程池快速响应当前审计人员的请求,保证线程处于高效运行状态;同时本文对线程池中多线程并发操作进行优化,减少线程对系统资源的消耗,保证系统可以通过更少的系统资源启动更多的线程并发访问审计数据。本文分析联网审计平台数据库访问特点,并设计自适应数据库连接池优化数据库访问技术,自适应数据库连接池可以管理数据库连接对象,通过对数据库访问情况分析,利用本文设计的数据库连接池尺寸自适应调整算法动态的调整连接池的参数,提高数据库连接对象的执行效率,减少数据库访问时间。然后,本文根据审计系统库、规划库、疑点库的数据库访问特点,提出数据库访问技术优化方法,主要包括系统库的数据缓冲策略、结果集对象优化、审计疑点批处理,通过优化策略提高数据库访问效率,使审计人员更快得到数据访问的结果,提高审计人员工作效率。本文将数据访问方法优化策略应用到联网审计平台中,并通过实验测试优化前与优化后数据访问效率,通过对比测试数据验证优化方法的可行性。
[Abstract]:With the rapid growth of audit business, audit work becomes more complex. Through computer technology to complete the audit work has become an important way of auditors. The network audit platform is a comprehensive service platform provided by the Audit Office for the audit staff in the province. The performance of the audit platform determines the work efficiency of the auditors. Therefore, it is of great significance to research and optimize the data access method of network audit platform. This paper studies the traditional data access methods and analyzes the existing problems. According to the data characteristics of the network audit platform, the optimization strategy of the data access method is put forward. The optimization strategy mainly includes two aspects. It is the optimization of multi-thread concurrent data access and database access technology respectively. In the network audit platform, the audit service side accesses the audit data concurrently through the multi-thread audit method. In this paper, the multi-thread technology is optimized by designing the adaptive thread pool. The adaptive thread pool can effectively manage the thread objects in the thread pool. By designing an adaptive thread pool size adjustment algorithm, the thread pool size can be dynamically adjusted according to the audit task request. The thread pool can quickly respond to the request of the current auditor and ensure that the thread is in an efficient running state. At the same time, this paper optimizes the concurrent operation of multiple threads in the thread pool to reduce the consumption of system resources by threads. Ensure that the system can start more threads with fewer system resources to access audit data concurrently. This paper analyzes the characteristics of database access in the network audit platform, and designs an adaptive database connection pool to optimize the database access technology. The adaptive database connection pool can manage database connection objects. Using the adaptive adjustment algorithm of database connection pool size designed in this paper, the parameters of connection pool are dynamically adjusted to improve the execution efficiency of database connection object and reduce database access time. Then, according to the database access characteristics of audit system library, planning library and doubt point library, this paper puts forward the optimization method of database access technology, mainly including the data buffer strategy of system library, the object optimization of result set, the batch processing of audit doubt point, By optimizing the strategy to improve the efficiency of database access, auditors can get the results of data access more quickly, and improve the efficiency of auditors. In this paper, the optimization strategy of data access method is applied to the network audit platform, and the efficiency of data access before and after optimization is tested experimentally, and the feasibility of the optimization method is verified by comparing the test data.
【学位授予单位】：哈尔滨工程大学
【学位级别】：硕士
【学位授予年份】：2016
【分类号】：TP311.13

【参考文献】