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

A work order and work order review technology, applied in the database field, can solve the problems of inability to meet work order review requirements and low review efficiency.

Pending Publication Date: 2021-05-11
MASSIVE CLOUD BEIJING DATA TECH
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 sta

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
  • Work order auditing method and device, storage medium and electronic equipment
  • Work order auditing method and device, storage medium and electronic equipment
  • Work order auditing method and device, storage medium and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some of the embodiments of the application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0042] The embodiment of this application provides a work order review method, the method flow chart of the method is as follows figure 1 shown, including:

[0043] S101. Obtain a pending work order.

[0044] The user edits the SQL statement on the text editor according to the requirement, and saves the edited SQL statement in the work order to be reviewed and uploads it to the SQL quality audit device, or the user edits the SQL statement on the text editor according to the require...

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

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
IPC IPC(8): G06F16/242G06Q10/10
CPCG06Q10/103G06F16/2433
Inventor 张泽何小栋
Owner MASSIVE CLOUD BEIJING DATA 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