Supercharge Your Innovation With Domain-Expert AI Agents!

SQL (structured query language) statement processing method and system

A processing method and statement technology, applied in the database field, can solve the problems of non-sequential meaning and functional meaning, unable to match SQL statements in reverse, and unable to fully express the original meaning of SQL statements.

Inactive Publication Date: 2013-02-13
国都兴业信息审计系统技术(北京)有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the above-mentioned technology has the following defects: first, the operation of the SQL statement is relatively isolated from the operation object; second, it cannot reversely match the SQL statement well; Fully express the original meaning of the SQL statement under the premise of being clear and concise

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 (structured query language) statement processing method and system
  • SQL (structured query language) statement processing method and system
  • SQL (structured query language) statement processing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0024] refer to figure 1 , figure 1 It is a flow chart of the steps of the embodiment of the processing method of the SQL statement of the present invention, including the following steps: step S110, constructing the SQL syntax tree; step S120, extracting the operation type and the database object by means of lexical analysis, and each operation type and the database object form a Predicate-object pair; step S130, sort multiple predicate-object pairs according to the order of execution; step S140, based on the database operation summary, perform operations including learning user rights and merging massive SQL statements.

[0025] The above steps will be further described below.

[0026] In step S130, the execution order refers to the order in which the SQL statements are compiled and executed in the database. Refer to the following example to understand sorting.

[0027] The execution order of SELECT*FROM TABLE1 UNION SELECT * FROM TABLE2 is:

[0028] SELECT * FROM TABLE1...

Embodiment 2

[0055] refer to figure 2 , figure 2It is a flow chart of the steps of another embodiment of the processing method of the SQL statement of the present invention, including: Step S210, perform character string scanning through lexical analysis and grammatical analysis; Step S220, obtain the keyword of the database operation type, and convert the keyword As a database operation type; step S230, extract the word segment after the character string as a database object; step S240, after matching and pairing the database operation type and the database object, sort according to the execution order. Step S250, based on the database operation summary, perform operations including learning user rights and merging a large number of SQL statements. Of course, it is not limited to the above operations, and may also be other data processing performed by applying the database operation summary.

[0056] Next, an example is given to describe in detail the method for obtaining the above da...

Embodiment 3

[0060] refer to image 3 , image 3 It is a flow chart of the steps of another embodiment of the SQL statement processing method of the present invention, including: step S310, determine the source of information for extracting database SQL statement operations; step S320, analyze the SQL statement into database operation types and database objects according to the context; Step S330, after matching the database operation type with the database object, sorting according to the execution order. Step S340, based on the database operation summary, perform operations including learning user rights and merging a large number of SQL statements. Of course, it is not limited to the above operations, and may also be other data processing performed by applying the database operation summary.

[0061] The information source of the SQL statement operation here refers to three types of database logs:

[0062] 1) the database's own (file) log;

[0063] 2) SQL statements in database memo...

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 discloses an SQL (structured query language) statement processing method and system. The method comprises the following steps: an SQL statement is resolved into a database operation abstract which is an ordered set of predicate-object pairs composed of database operation types and database objects, wherein each database operation type indicates one database operation mode; and each database object indicates one entity in the database. By using the method, the understanding of the SQL statement can be better indicated by the combination of the database operations and operation objects extracted from the SQL statement, namely the ordered predicate-object pairs; the authority significance of the database operation can be indicated in a concise mode; and the indication of the structured SQL statement is provided.

Description

technical field [0001] The invention relates to database technology, in particular to a method and system for processing SQL statements. Background technique [0002] In the prior art (such as many existing database audit products), the understanding of the SQL statement is achieved by extracting objects such as the operation type of the SQL statement and the table name of the SQL statement. However, the above-mentioned technology has the following defects: first, the operation of the SQL statement is relatively isolated from the operation object; second, it cannot reversely match the SQL statement well; Fully express the original meaning of the SQL statement under the premise of being clear and concise. Contents of the invention [0003] In order to overcome the deficiencies of the prior art, the present invention provides a method and system for processing SQL statements. Based on the present invention, the understanding of SQL statements can be better expressed. [00...

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
Inventor 徐亚非于海涛陈浙一常乐杨文勃曲明张佃
Owner 国都兴业信息审计系统技术(北京)有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com