SQL (Structured Query Language) auditing method and system

A grammar and sentence technology, applied in the field of SQL audit method and system, can solve the problems of low audit efficiency, single audit process, laborious manual audit, etc., and achieve the effect of improving audit efficiency and reducing difficulty

Inactive Publication Date: 2018-08-17
广州市贝聊信息科技有限公司
View PDF7 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, the existing SQL review and submission system only has the function of process submission and database management, and cannot realize the automatic review function of SQL grammar, and for the unified standard of MySQL statement writing, manual review is difficult. The more standards, the more difficult manual review is. The cycle is long. Secondly, the existing SQL audit submission system has a single audit process, which cannot optimize the audit process for the current environment of SQL statements, and the audit efficiency is low.

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) auditing method and system
  • SQL (Structured Query Language) auditing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0052] see figure 1 , which is a flow chart of an SQL audit method provided in an embodiment of the present invention, the SQL audit method, executed by the SQL audit system, includes:

[0053] S1: Obtain the current SQL online order;

[0054] S2: Check whether the SQL statement of the current SQL online order conforms to the syntax specification;

[0055] S3: When the SQL statement of the current SQL online order conforms to the grammatical specification, judge ...

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) auditing method and system. The method includes: acquiring a current SQL online-bill; checking whether SQL statements of the current SQL online-bill conform to grammar specifications; judging an auditing environment of the current SQL online-bill when the SQL statements of the current SQL online-bill conform to the grammar specifications;executing the SQL statements when the current SQL online-bill is in a development environment or a test environment; when the current SQL online-bill is in an online environment, judging whether the current SQL online-bill passes SQL content auditing and DBA auditing; and executing the SQL statements when the current SQL online-bill passes SQL content auditing and DBA auditing. Through the SQL auditing method, automatic auditing of SQL grammar can be realized, difficulty of manual auditing can be reduced, and auditing efficiency of the SQL online-bill can be improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to an SQL audit method and system. Background technique [0002] In the work of the database, it is often necessary to audit the SQL (Structured Query Language, Structured Query Language) statements executed by the database, so as to prevent the SQL statements with poor performance from entering the production system, resulting in a decrease in the overall performance of the database. At present, the existing SQL review and submission system only has the function of process submission and database management, and cannot realize the automatic review function of SQL grammar, and for the unified standard of MySQL statement writing, manual review is difficult. The more standards, the more difficult manual review is. The cycle is long. Secondly, the existing SQL audit submission system has a single audit process, which cannot optimize the audit process for the current environment of SQ...

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/2433G06F16/2455
Inventor 刘汉华
Owner 广州市贝聊信息科技有限公司
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