电力业务系统海量SQL访问日志预处理方法

A method of SQL access logs pretreatment for power business system

随着智能电网的互动化发展,信息内外网边界数据库交互行为日益增多。为更好地应对电力业务系统数据安全审计的需求,解决数据库审计过程中SQL语句容量过大、不易存储和分析的问题,详细设计了一种基于SQL模式分析的电力业务系统SQL访问日志压缩方法。该方法在不丢失原SQL访问语句语义的前提下,实现SQL访问日志的压缩,也具有SQL日志的简单分类的功能,为数据库的安全审计提供基础。系统测试结果表明,通过该方法可以实现SQL访问日志的大幅度压缩,满足电力业务系统数据库行为审计对日志预处理的需求。

With the development of smart grid interactive, the database interaction between the information inside and outside is increasing. A method of SQL access log compression for power business system to respond to the demand of database security audit for the power system was designed in detail. This method can realize the compression of SQL access log and have 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.