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

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...

Images