Chen Liu, Taewoo Kim, Baowei Zheng, Jeongmo Yeo

KIPS Transactions on Software and Data Engineering, Vol. 5, No. 9, pp. 425-432, Sep. 2016
10.3745/KTSDE.2016.5.9.425,   PDF Download:
Keywords: SQL Audit, Audit Tool, Database Performance, SQL Audit Tool, Database Audit
Abstract

As the importance of information audit is getting bigger, the public corporations invest many expenses at information system audit to build a high quality system. For this purpose, there are much research to proceed an audit effectively. In database audit works, it could audit utilizing a variety of monitoring tools. However, when auditing SQLs which might be affected to database performance, there are several limits related to SQL audit functionality. For this reason, most existing monitoring tools process based on meta information, it is difficult to proceed SQL audit works if there is no meta data or inaccuracy. Also, it can't detect problems by analysis of SQL's syntax structure. In this paper, we design and implement the SQL Inspector using ANTLR which is applied by syntax analysis technique. The overall conclusion is that the implemented SQL Inspector can work effectively much more than eye-checked way. Finally, The SQL inspector which we proposed can apply much more audit rules by compared with other monitoring tools. We expect the higher stability of information system to apply SQL Inspector from development phase to the operation phase.

Statistics
Cite this article