Method for compressing SQL access log of power business system

A compression method and technology for electric power business, applied in the fields of electric digital data processing, instrumentation, calculation, etc., can solve the problems of huge amount of operation log data, difficulty in storage and analysis, etc., and achieve the effect of maintaining effectiveness, speeding up and improving efficiency.

Active Publication Date: 2016-03-02
GLOBAL ENERGY INTERCONNECTION RES INST CO LTD +2
View PDF5 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Due to the large amount of data in the SQL statement operation log of the power business system database, it is very difficult to store and analyze

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for compressing SQL access log of power business system
  • Method for compressing SQL access log of power business system
  • Method for compressing SQL access log of power business system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0034] The embodiment of the present invention is to provide a SQL access log compression method for the power business system, which is mainly used to solve the problem that the data volume of the SQL statement operation log in the power business system database is very large and difficult to store and analyze. Through this method, the power business can be effectively The system SQL access log is compressed, which is convenient for extracting useful information and improving resource utilization without losing the inherent information of the original data.

[0035] The SQL access log compression methods of the power business system include:

[0036] After lexical analysis according to the SQL statement, the user input and the main SQL statement are separated, and the user input part is extracted and replaced with a specific wildcard, so that multiple SQL st...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a method for compressing an SQL access log of a power business system. The method comprises the following steps: (1) decomposing an SQL statement of storing a period of continuous buffer zone into a word structure chain table of parts of speech and contents; (2) replacing a user input part in the word chain table, and creating an SQL pattern statement; and (3) adding a new SQL pattern statement to an SQL pattern library and building an SQL pattern matching engine. According to the method provided by the invention, the SQL access log of the power business system can be effectively compressed, so that extraction of useful information is facilitated; the utilization rate of resources is improved; and loss of internal information of original data is avoided.

Description

technical field [0001] The invention relates to a log compression method, in particular to a method for compressing SQL access logs of an electric power business system. Background technique [0002] With the development of smart grid information technology and the interactive application of SG-ERP, the trend of power business data concentration is becoming more and more obvious, and the database system has become particularly important. Advanced technologies such as big data and cloud computing are all in the database. realized on the basis of . The database system is the gathering point and key protection object of data information, and ensuring the security of the database is the prerequisite for the steady development of informatization construction. In order to be able to monitor and effectively supervise the various access behaviors of information extranet users to the information intranet in a timely manner, through the collection, preprocessing, analysis and mining ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/215
Inventor 李伟伟张涛马媛媛周诚邵志鹏时坚楚杰汪晨费稼轩何高峰黄秀丽陈璐管小娟
Owner GLOBAL ENERGY INTERCONNECTION RES INST CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap