Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

SQL sentence processing method and system

A processing method and statement technology, applied in the database field, can solve the problems of high hardware requirements for massive data, large amount of audit data, etc., and achieve the effect of convenient reference and reduction of data amount

Active Publication Date: 2016-08-31
SANGFOR TECH INC
View PDF5 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Moreover, the constant parameters of each SQL statement, the value of the conditional statement, the table name and other information are all different, resulting in a huge amount of audit data, and the processing of massive data requires high hardware requirements

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
  • SQL sentence processing method and system
  • SQL sentence processing method and system
  • SQL sentence processing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] Usually the operating framework of the database system, such as figure 1 As shown, the Web server accesses the database (Database, DB) through a core switch (or multiple switches). The Web server accesses and operates the DB to complete the basic functions of adding, deleting, modifying, and checking various information. The administrator accesses and maintains the database through the operation and maintenance server in the operation and maintenance area, such as routine inspection of the database, necessary management and operation and maintenance, etc. The database auditing device records, analyzes and reports the massive SQL statements used by users to access the database.

[0035] Generally, the web server's access and / or operation requests to the database are generated by programs, and these access and / or operation requests access the database through various middleware and the like. For example, if a website wants to judge whether a user has successfully logged...

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 relates to an SQL sentence processing method and system. The SQL sentence processing method comprises following steps: obtaining original SQL sentences; filtering redundant fields of SQL sentences in order to obtain first SQL sentences of redundant fields; replacing variable value of the first SQL sentences in order to obtain second SQL sentences; performing structured processing of the second SQL sentences in order to obtain structured SQL sentences; and relating structured SQL sentences in order to obtain SQL sentence prototypes corresponding to original SQL sentences. The above-mentioned SQL sentence processing method and system can bring convenience to users for search and reduce data amount of auditing.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a SQL statement processing method and system. Background technique [0002] At present, the common database systems are mainly relational databases. When auditing the database system, database audit products usually use SQL statements to interact with the database system. Therefore, the audited data generally comes from the SQL statements of these relational databases. [0003] However, when directly auditing SQL statements, various complex SQL commands are intertwined in various parts of the database system, which is not conducive to auditing. In addition, each SQL statement has some redundant fields such as spaces and comments. Moreover, the constant parameters of each SQL statement, the value of the conditional statement, and the table name are all different, which leads to a huge amount of audit data, and the processing of massive data requires high hardware requirements. ...

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
IPC IPC(8): G06F17/30
CPCG06F16/2433
Inventor 朱隽
Owner SANGFOR TECH INC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products