Work order auditing method and device, storage medium and electronic equipment

Abstract

The invention provides a work order auditing method and device, a storage medium and electronic equipment, and the method comprises the steps: obtaining a to-be-audited work order, determining each auditing rule, corresponding to an SQL statement, in a rule base as a target auditing rule for each SQL statement in the to-be-audited work order if the state of an auditing switch corresponding to the to-be-audited work order is determined to be an on state; according to a preset score deduction value corresponding to each target auditing rule, calculating a score of the to-be-audited work order; and when the score is greater than a preset threshold value, if the rule attributes of all the target auditing rules are not the first type of rule attributes, determining that the to-be-audited work order passes the auditing. Visibly, according to the technical scheme provided by the invention, under the condition that the score of the to-be-audited work order is greater than the preset threshold value, if the rule attributes of all the target audit rules are not the first type of rule attributes, it is determined that the to-be-audited work order passes audit without manual audit, so that the work order audit efficiency is improved, and the ever-increasing work order auditing requirements are met.

Description

technical field [0001] The present application relates to the field of databases, in particular to a work order review method and device, a storage medium and electronic equipment. Background technique [0002] For the sake of database security, most enterprises use database administrators (Database Administrator, DBA) to review each SQL statement in the work order that has passed the preliminary review. Among them, the preliminary review is based on the SQL quality review platform; each SQL statement in the work order After passing the review, all SQL statements in the work order will be executed in the database. [0003] The inventor found that in most cases, the SQL statements in the work orders that passed the preliminary review can be directly executed in the database, and only a few work orders need manual review. Therefore, manual review of each SQL statement in all work orders that have passed the preliminary review is inefficient and unable to meet the growing dema...

AI Technical Summary

Problems solved by technology

[0004] This application provides a work order review method and device, storage medium and electronic equipment, the purpose is to solve the problem of manual review of each SQL statement in all work orders that have passed the preliminary review, the review efficiency is low, and the growing demand cannot be met. Questions about work order review requirements

Images