SQL (Structured Query Language) statement auditing method, and database operation and maintenance method and system

A statement and grammar technology, applied in the field of database operation and maintenance, and SQL statement auditing, can solve the problems of low efficiency of SQL statements and low efficiency of database operation and maintenance.

Inactive Publication Date: 2015-03-04
BEIJING QUNAR SOFTWARE TECH
View PDF5 Cites 47 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical problem to be solved in this application is to provide a method for auditing SQL statements, a method and system for database operation and maintenance, which solves the problems of low efficiency of DBA auditing SQL statements and low efficiency of database operation and maintenance in the prior art

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 auditing method, and database operation and maintenance method and system
  • SQL (Structured Query Language) statement auditing method, and database operation and maintenance method and system
  • SQL (Structured Query Language) statement auditing method, and database operation and maintenance method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0082] Corresponding to the method provided in Embodiment 1 of a method for auditing SQL statements in the present application, see figure 2 , the application also provides a system embodiment 1 of SQL statement auditing system, in this embodiment, the system includes:

[0083] The determining unit 201 is configured to determine a target SQL statement.

[0084] The analyzing unit 202 is configured to perform grammatical analysis on the target SQL statement according to preset grammatical rules.

[0085] An error reporting unit 203, configured to report an error if the target SQL statement does not satisfy the preset grammatical rules.

[0086] The first storage unit 204 is configured to store the target SQL statement that does not satisfy the preset grammar rules.

[0087] The judging unit 205 is configured to judge whether the syntax analysis is completed, and if so, perform semantic analysis on the target SQL statement, and report an error if the target SQL statement does...

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 statement auditing method, a database operation and maintenance method and a database operation and maintenance system. The SQL statement auditing method provided by the invention comprises the following steps: determining a target SQL statement; respectively performing grammar and semantic analysis on the target SQL statement, and performing grammar analysis on the target SQL statement according to the preset grammar; if the target SQL statement cannot meet the preset grammar, reporting errors; saving the target SQL statement which cannot meet the preset grammar; judging whether the grammar analysis is finished or not; if yes, performing semantic analysis on the target SQL statement, and if the target SQL statement cannot meet the preset semantic analysis rule, reporting errors; saving the target SQL statement which cannot meet the preset semantic analysis rule. All that is needed is to set various preset rules for auditing in advance and the auditing algorithm, the auditing process of the SQL statement is executed according to the algorithm and the various preset rules; the process that database administrators communicate with developers about the SQL statement problems and the modification situation is avoided, so that the auditing efficiency can be increased.

Description

technical field [0001] This application relates to the field of operation and maintenance, in particular to a method for auditing SQL statements, a method and system for database operation and maintenance. Background technique [0002] With the development of technology, people have higher and higher requirements for SQL statement auditing and database operation and maintenance methods. [0003] Existing methods for auditing SQL statements generally use database administrators DBAs to audit SQL. DBAs need to invest more experience in communicating with developers about problems and modifications in SQL statements, which increases the DBA's work experience. Burden, and reduce the work efficiency of DBA, and then reduce the operation and maintenance efficiency of the database. [0004] Therefore, how to effectively audit SQL statements and improve the efficiency of database operation and maintenance is a technical problem to be solved by those skilled in the art. Contents o...

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/242G06F16/21
Inventor 周彦伟王竹峰娄帅乔婧
Owner BEIJING QUNAR SOFTWARE TECH
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