發(fā)布時間：2018-07-29 05:39

【摘要】：隨著審計業(yè)務(wù)快速增長,審計工作變得更加復(fù)雜。通過計算機(jī)技術(shù)完成審計工作已成為審計人員重要的工作方式。聯(lián)網(wǎng)審計平臺是審計廳提供給全省廣大審計人員展開審計工作的一個綜合服務(wù)型平臺,審計平臺的執(zhí)行性能決定審計人員工作效率。因此,對聯(lián)網(wǎng)審計平臺數(shù)據(jù)訪問方法的研究與優(yōu)化具有重要意義。本文研究傳統(tǒng)數(shù)據(jù)訪問方法并分析存在的問題,根據(jù)聯(lián)網(wǎng)審計平臺訪問的數(shù)據(jù)特點(diǎn)提出數(shù)據(jù)訪問方法的優(yōu)化策略,優(yōu)化策略主要包括兩個方面,分別是多線程并發(fā)數(shù)據(jù)訪問的優(yōu)化和數(shù)據(jù)庫訪問技術(shù)的優(yōu)化。在聯(lián)網(wǎng)審計平臺中,審計服務(wù)端是通過多線程執(zhí)行審計方法并發(fā)的訪問審計數(shù)據(jù),本文通過設(shè)計自適應(yīng)線程池優(yōu)化多線程技術(shù),自適應(yīng)線程池可以有效的管理線程池中線程對象,通過設(shè)計自適應(yīng)線程池尺寸調(diào)整算法,能夠根據(jù)審計任務(wù)請求情況動態(tài)調(diào)整線程池的尺寸,使線程池快速響應(yīng)當(dāng)前審計人員的請求,保證線程處于高效運(yùn)行狀態(tài);同時本文對線程池中多線程并發(fā)操作進(jìn)行優(yōu)化,減少線程對系統(tǒng)資源的消耗,保證系統(tǒng)可以通過更少的系統(tǒng)資源啟動更多的線程并發(fā)訪問審計數(shù)據(jù)。本文分析聯(lián)網(wǎng)審計平臺數(shù)據(jù)庫訪問特點(diǎn),并設(shè)計自適應(yīng)數(shù)據(jù)庫連接池優(yōu)化數(shù)據(jù)庫訪問技術(shù),自適應(yīng)數(shù)據(jù)庫連接池可以管理數(shù)據(jù)庫連接對象,通過對數(shù)據(jù)庫訪問情況分析,利用本文設(shè)計的數(shù)據(jù)庫連接池尺寸自適應(yīng)調(diào)整算法動態(tài)的調(diào)整連接池的參數(shù),提高數(shù)據(jù)庫連接對象的執(zhí)行效率,減少數(shù)據(jù)庫訪問時間。然后,本文根據(jù)審計系統(tǒng)庫、規(guī)劃庫、疑點(diǎn)庫的數(shù)據(jù)庫訪問特點(diǎn),提出數(shù)據(jù)庫訪問技術(shù)優(yōu)化方法,主要包括系統(tǒng)庫的數(shù)據(jù)緩沖策略、結(jié)果集對象優(yōu)化、審計疑點(diǎn)批處理,通過優(yōu)化策略提高數(shù)據(jù)庫訪問效率,使審計人員更快得到數(shù)據(jù)訪問的結(jié)果,提高審計人員工作效率。本文將數(shù)據(jù)訪問方法優(yōu)化策略應(yīng)用到聯(lián)網(wǎng)審計平臺中,并通過實(shí)驗(yàn)測試優(yōu)化前與優(yōu)化后數(shù)據(jù)訪問效率,通過對比測試數(shù)據(jù)驗(yàn)證優(yōu)化方法的可行性。
[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.
【學(xué)位授予單位】：哈爾濱工程大學(xué)
【學(xué)位級別】：碩士
【學(xué)位授予年份】：2016
【分類號】：TP311.13

【參考文獻(xiàn)】

相關(guān)期刊論文 前10條

1 張翔宇;鄧仰東;;基于GPU的語義松弛非阻塞并行隊列研究[J];計算機(jī)應(yīng)用與軟件;2015年10期

2 霍占強(qiáng);張錦程;王志衡;;數(shù)據(jù)庫連接池的數(shù)學(xué)建模與性能分析[J];計算機(jī)工程;2014年10期

3 霍永華;曹毅;劉文;李文;;線程池技術(shù)在B/S 網(wǎng)絡(luò)管理軟件架構(gòu)中的應(yīng)用[J];計算機(jī)與網(wǎng)絡(luò);2014年06期

4 劉雙雙;段欣妤;;基于JDBC的數(shù)據(jù)庫連接池的煤礦安全監(jiān)控技術(shù)體系建設(shè)[J];煤炭技術(shù);2013年07期

5 黃智泉;劉正熙;;基于平均時間的線程池尺寸自適應(yīng)調(diào)整算法[J];計算機(jī)技術(shù)與發(fā)展;2013年02期

6 馮徑;徐攀;王錦洲;黃偉;;一種多策略要素的數(shù)據(jù)訪問調(diào)度算法[J];東南大學(xué)學(xué)報(自然科學(xué)版);2012年05期

7 王海文;;基于Java數(shù)組的JDBC ResultSet結(jié)果集處理的研究[J];硅谷;2011年24期

8 孫旭東;韓江洪;劉征宇;解新勝;;基于分段的線程池尺寸自適應(yīng)調(diào)整算法[J];計算機(jī)工程;2011年02期

9 陳潔;;DBCP數(shù)據(jù)庫連接池的自優(yōu)化配置[J];計算機(jī)與現(xiàn)代化;2010年12期

10 劉俊;劉志祥;;應(yīng)用Amdahl定律對多核處理器性能的分析[J];信息技術(shù);2010年06期

相關(guān)碩士學(xué)位論文 前6條

1 李成;內(nèi)存數(shù)據(jù)庫并行化查詢技術(shù)研究[D];中國科學(xué)技術(shù)大學(xué);2015年

2 聶蘭蘭;考慮外界影響因子的動態(tài)線程池優(yōu)化設(shè)計與實(shí)現(xiàn)[D];華中科技大學(xué);2014年

3 周媛;基于SaaS平臺的數(shù)據(jù)庫性能優(yōu)化研究與設(shè)計[D];北京郵電大學(xué);2013年

4 徐慶松;帶QoS需求的安全的多數(shù)據(jù)庫訪問中間件技術(shù)的研究[D];武漢理工大學(xué);2009年

5 楊開杰;基于池化技術(shù)的分布式數(shù)據(jù)緩存模型研究與實(shí)現(xiàn)[D];蘇州大學(xué);2009年

6 孟凡彥;基于線程池機(jī)制的高性能DHCP服務(wù)器研究與實(shí)現(xiàn)[D];西北工業(yè)大學(xué);2005年

，

本文編號：2151692