A method of SQL access logs pretreatment for power business system

摘要

With the development of smart grid interactive, the database interaction between internal and external information is increasing. In this paper, we proposed a detailed design of a method of SQL access log compression for power business system, so as to respond to the demands of database security audit of the power system. This method can achieve the compression of SQL access log and also has the function of simple classification for SQL logs. The test results show that the method can achieve a large margin compression of SQL access logs and meet the requirements of log preprocessing for the database behavior audit of power business system.