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

doi:10.11959/j.issn.1000-0801.2015395

Telecommunications Science ›› 2015, Vol. 31 ›› Issue (Z1): 120-124.doi: 10.11959/j.issn.1000-0801.2015395

• Network and information security • Previous Articles Next Articles

A method of SQL access logs pretreatment for power business system

Weiwei LI,Tao ZHANG,Yuanyuan MA,Cheng ZHOU

State Grid Smart Grid Research Institute,Nanjing 210003,China

Online:2015-12-20 Published:2017-07-03
Supported by:
The Science and Technology Project of State Grid Gorporation of China in 2015

Abstract

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.

Key words: power business, security audit, logs compression, pretreatment

Weiwei LI,Tao ZHANG,Yuanyuan MA,Cheng ZHOU. A method of SQL access logs pretreatment for power business system[J]. Telecommunications Science, 2015, 31(Z1): 120-124.

Figures/Tables 7

References 6

[1]	方杰, 朱京红 . 日志挖掘中的数据预处理[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.
[2]	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.
[3]	BISKUP J . Recent advances in intrusion detection[M]. Berlin: Springer, 2000:28-48.
[4]	王渊, 马骏 . 一种基于入侵检测的数据库安全审计[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.
[5]	张春玲, 吕震宇, 刘遵峰 . 基于虚拟日志压缩的数据同步方案[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.
[6]	王艳峰, 王正, 阎保平 . 一种高效的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.

Metrics

Recommended 0

No Suggested Reading articles found!

SQL日志数/条	SQL模式库条数/条	SQL日志库条数/条	压缩比例	失败个数
1 000	119	1 000	11.90%	0
5 000	157	5 000	3.14%	0
10 000	164	10 000	1.64%	0
15 000	261	15 000	1.74%	0
20 000	570	20 000	2.85%	0
25 000	634	25 000	2.54%	0
30 000	647	30 000	2.16%	0
35 000	850	35 000	2.43%	0
50 000	1 024	50 000	2.04%	0
75 000	1 103	75 000	1.471%	0
100 000	1 197	100 000	1.093%	0

A method of SQL access logs pretreatment for power business system

RichHTML

PDF下载

Knowledge

Abstract

Cite this article

share this article

Figures/Tables 7

References 6

Related Articles 3

Metrics

Recommended 0

[1]	Lihong Xue,Xiaojiang Liang. Key Technology About Security Audit of Mobile Network Traffic for Telecom Operator [J]. Telecommunications Science, 2015, 31(12): 111-116.
[2]	Jian Guo,Jie Shen. Discussion on Small Probability Correlation Analysis Technique of Security Audit System for Telecom Operator [J]. Telecommunications Science, 2013, 29(4): 137-140.
[3]	Ling Gai. Discussion of Carrier Network and Information System Security Management and Control Techniques [J]. Telecommunications Science, 2011, 27(1): 110-118.