Design and Implementation of SQL Audit Tool for Database Performance

데이터베이스 성능을 위한 SQL 감리 도구의 설계 및 구현

Liu, Chen;Kim, Taewoo;Zheng, Baowei;Yeo, Jeongmo

  • Received : 2016.01.04
  • Accepted : 2016.04.04
  • Published : 2016.05.31


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.


SQL Audit;Audit Tool;Database Performance;SQL Audit Tool;Database Audit


  1. Hong-sup Jung, "Quality Improvement Plan th-rough Analysis of Information System Audit Example," Master dissertation, Konkuk University, Seoul, KOREA, 2008.
  2. Song-hae Kwak, "A Study on the Development of the Automation Tool for Improvement of Audit Productivity," Master dissertation, Konkuk University, Seoul, KOREA, 2009.
  3. Seung-ryeol Jung and Jeon-guk Kim, "A Study on Collection and Evaluation of Audit Evidence," National Computerization Agency, 1999.
  4. KoDB, "The Guide for Data Architecture Professional," KoDB, 2013.
  5. Ministry of Information and Communication, "GuideLine for Performance Management of Information System."
  6. National Computerization Agency, "The Guide for Information System Auditing," National Computerization Agency, 2013.
  7. Jong-won Kim, "System Audit Improvement Through Identifying Database Query Audit Inspection Item," Master dissertation, Incheon National University, Incheon, KOREA, 2013.
  8. Jae-Hwan Ko, Dong-soo Kim, and Ki-Joon Han, "Development of Automated Tools for Data Quality Diagnostics," KITS, Vol.11, No.4, pp.153-170, 2012.
  9. Chang-gon Kim, "The Guide for Audit Inspection," National Computerization Agency, 2008.
  10. Hwa-sik Lee, "New VLDB Solution," En-Core Consultant, 2005.
  11. KoDB, "The Guide for SQL Professional," KoDB, 2013.
  12. Hwa-sik Lee, Data Architecture solution, En-Core Consultant, 2003.
  13. Rod Johnson, Juergen Hoeller, Spring Framework Reference Documentation [Internet],
  14. T. J. Parr and R. W. Quong, "ANTLR: A Predicated-LL(k) Parser Generator," Software-practice and Experience, Vol.25, No.7, pp.789-810, 1995.
  15. T. J. PARR, "The Definitive ANTLR Reference: Building Domain-Specific languages," The Pragmatic Bookshelf, 2013.


Supported by : 부경대학교