SQL work order auditing system, auditing method and device and computer device

Abstract

The invention relates to an SQL work order auditing system, an auditing method and device and a computer device, and belongs to the technical field of databases. The system comprises a first client, a system service module and an auditing module configured in a plurality of machine rooms. The system service module is respectively in network connection with the first client and the auditing module. The first client is used for obtaining a to-be-audited SQL work order and sending the to-be-audited SQL work order to the system service module. The system service module is used for receiving the SQL work order to be audited sent by the first client and sending the SQL work order to be audited to the auditing module of the target machine room. The auditing module in the target machine room is used for auditing the SQL work order to be audited to obtain an auditing result, and returning the auditing result to the system service module. The system service module is also used for returning an audit result to the first client. The SQL work order to be audited can be automatically audited, and the auditing efficiency of the SQL work order is effectively improved.

Description

Technical field [0001] The present invention relates to the field of database technology, in particular to an auditing system of SQL work orders, an auditing method, device, computer equipment and storage medium of an auditing system based on SQL work orders. Background technique [0002] For database security, most companies manage the database through a database administrator (DBA). In order to avoid the risk of database performance caused by tasks such as database update and query, DBA needs to review and evaluate whether the SQL (Structured Query Language) work order submitted by R&D personnel is reasonable and effective. After the evaluation is passed, it can be used in the corresponding database. Safely execute the tasks corresponding to the SQL work order (add, delete, modify, check, create, batch, etc.). [0003] In the process of implementing the present invention, the inventor found the following problems in the existing SQL audit process: 1. The more SQL standards, the ...

AI Technical Summary

Problems solved by technology

[0003] In the process of realizing the present invention, the inventor finds that there are following problems in the existing SQL auditing process: 1. The more SQL standards, the more laborious the manual auditing; 2. The auditing effect depends on the personal ability and detection method of the DBA; 3. From audit to execution, it needs to be manually executed on the corresponding database (and usually in the middle of the night or on weekends). When the database is a distributed database, it is difficult to ensure the correctness and timeliness of manual operations

All of the above have resulted in the existing manual review method relying too much on the DBA, making the review of SQL work orders inefficient

Images