A method of SQL access logs pretreatment for power business system

Weiwei LI; Tao ZHANG; Yuanyuan MA; Cheng ZHOU

doi:10.11959/j.issn.1000-0801.2015395

您当前的位置：

首页 >

文章列表页 >

A method of SQL access logs pretreatment for power business system

Network and information security | 更新时间：2024-06-05

- A method of SQL access logs pretreatment for power business system
- Telecommunications Science Vol. 31, Issue Z1, Pages: 120-124(2015)
- 作者机构：
- 作者简介：
- 基金信息：
- DOI：10.11959/j.issn.1000-0801.2015395
  CLC： TP311
- Published Online：20 December 2015，
  
  Published：20 December 2015
- 稿件说明：
移动端阅览
Weiwei LI, Tao ZHANG, Yuanyuan MA, et al. A method of SQL access logs pretreatment for power business system[J]. Telecommunications science, 2015, 31(Z1): 120-124.
DOI：

Weiwei LI, Tao ZHANG, Yuanyuan MA, et al. A method of SQL access logs pretreatment for power business system[J]. Telecommunications science, 2015, 31(Z1): 120-124. DOI： 10.11959/j.issn.1000-0801.2015395.

摘要

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

Abstract

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.

关键词

Keywords

references

方杰 , 朱京红 . 日志挖掘中的数据预处理 [J ] . 计算机技术与发展 2010 , 20 ( 4 ): 17 - 20 .

FANG J , ZHU J H . Data pretreatment of log mining [J ] . Computer Technology and Development , 2010 , 20 ( 4 ): 17 - 20 .

HELMAN P , LIEPINS G . Statistical foundations of audit trail analysis for the detection of computer misuse [J ] . IEEE Transactions on Software Engineering , 1993 , 19 ( 9 ): 886 - 901 .

BISKUP J . Recent advances in intrusion detection [M ] . Berlin : Springer , 2000 : 28 - 48 .

王渊 , 马骏 . 一种基于入侵检测的数据库安全审计 [J ] . 计算机仿真 2007 , 24 ( 2 ): 33 - 36 .

WANG Y , MA J . A method of database secure audit based on intrusion detection [J ] . Computer Simulation , 2007 , 24 ( 2 ): 33 - 36 .

张春玲 , 吕震宇 , 刘遵峰 . 基于虚拟日志压缩的数据同步方案 [J ] . 计算机工程 2010 , 18 ( 36 ): 67 - 69 .

ZHANG C L , LV Z Y , LIU Z F . Data synchronization solution based on virtual log compression [J ] . Computer Engineering , 2010 , 18 ( 36 ): 67 - 69 .

王艳峰 , 王正 , 阎保平 . 一种高效的DNS日志压缩算法 [J ] . 计算机工程 2010 , 15 ( 36 ): 32 - 35 .

WANG Y F , WANG Z , YAN B P . High-efficient DNS log compression algorithm [J ] . Computer Engineering , 2010 , 15 ( 36 ): 32 - 35 .

Views

312

下载量

CSCD

Alert me when the article has been cited

提交

Tools

Publicity Resources

No data

Related Author

No data

Related Institution

No data

⁰