Chen Liu, Taewoo Kim, Baowei Zheng , Jeongmo Yeo

KIPS Transactions on Software and Data Engineering, Vol. 5, No. 5, pp. 203-208, May. 2016
10.3745/KTSDE.2016.5.5.203,   PDF Download:
Keywords: SQL Audit, Audit Tool, Database Performance, SQL Audit Tool, Database Audit
Abstract

Information system audit is the requirement to configure the information system successfully. However, there is a problem with reduction of efficiency in the audit work when the system capacity is growing up. In the subsidiary field of information system audit, there is the same problem. In this paper, we will focus on the database audit, and implement an SQL audit tool in order to improve the performance of a database. During the designing phase of the SQL audit tool which aim to improve the performance of a database, we have analyzed the requirements of SQL audit work. Based on the aforementioned them, the process of the SQL audit tool has been designed with SQL audit features in accordance with information audit process. During the implementation phase, we have implemented 3 main function modules according to the output of the design phase. The main modules we implemented are the audit job definition module, audit job executing module and result reporting module. With the implemented tool, it applied to an Electric Power Corporation project in China and compared with other tools that are able to use SQL audit. In this paper, the implemented SQL audit tool is able to perform the general SQL audit work and to reduce the cost of the audit work for database performance and to raise the accuracy of result and to apply the extended inspection rule which need to use SQL parsing.

Statistics
Cite this article