CN108876283A - A kind of automatic auditing system and method - Google Patents
A kind of automatic auditing system and method Download PDFInfo
- Publication number
- CN108876283A CN108876283A CN201810392845.8A CN201810392845A CN108876283A CN 108876283 A CN108876283 A CN 108876283A CN 201810392845 A CN201810392845 A CN 201810392845A CN 108876283 A CN108876283 A CN 108876283A
- Authority
- CN
- China
- Prior art keywords
- sql statement
- module
- audit
- auditing
- automatic auditing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Withdrawn
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Abstract
The invention discloses a kind of automatic auditing system and method, which includes：Auditing module for obtaining the SQL statement of user's submission, and audits SQL statement；Selecting module, for selecting corresponding MYSQL server to go to execute SQL statement, to obtain the implementing result of SQL statement；Output module, for exporting and showing implementing result.The present invention passes through algorithm integration, it is long to solve traditional artificial mark Review Cycle, the big drawback of error, also greatly improve the efficiency of data audit task, and the automatic auditing system is after obtaining the data annotation results that front end uploads, Integrated Algorithm can be enabled to verify annotation results coordinate, obtain auditing result.
Description
Technical field
The present invention relates to computer fields, it particularly relates to a kind of automatic auditing system and method.
Background technique
With flourishing for AI (Artificial Intelligence, artificial intelligence) field, intelligent algorithm pair
The requirement of the quality and quantity of sample data is also higher and higher, and traditional artificial mark and audit can consume a large amount of manpower object
Power, meanwhile, manual examination and verification result can lead to check results along with various factors, and there are deviations.
For the problems in the relevant technologies, currently no effective solution has been proposed.
Summary of the invention
For the problems in the relevant technologies, the present invention proposes a kind of automatic auditing system and method, the automatic auditing system
By algorithm integration, solve that traditional artificial mark Review Cycle is long, and the big drawback of error also greatly improves data audit
The efficiency of task.
In order to solve the problems in the existing technology, the present invention provides a kind of automatic auditing system, the automatic audits
System includes：Auditing module for obtaining the SQL statement of user's submission, and audits SQL statement；Selecting module is used for
Corresponding MYSQL server is selected to go to execute SQL statement, to obtain the implementing result of SQL statement；Output module, for exporting
And show implementing result.
According to one embodiment of present invention, auditing module includes：Syntax Analysis Module, for carrying out language to SQL statement
Method analysis.
According to one embodiment of present invention, auditing module further includes：Semantic module, for being carried out to SQL statement
Semantic analysis.
According to one embodiment of present invention, auditing module further includes：Module is submitted, for SQL statement to be sent to number
According to library manager, so that database administrator completes the audit to SQL statement.
According to one embodiment of present invention, auditing module further includes：Roll-back module, in syntactic analysis, semantic point
SQL statement is carried out rolling back action in the case that the audit fails by analysis and any one of audit of SQL statement.
The present invention also provides a kind of automatic auditing methods, include the following steps：
The SQL statement that user submits is obtained, and the SQL statement is audited；
Corresponding MYSQL server is selected to go to execute the SQL statement, to obtain the implementing result of the SQL statement；
It exports and shows the implementing result.
According to one embodiment of present invention, the SQL statement that user submits is obtained, and the SQL statement is audited
Including：Syntactic analysis is carried out to the SQL statement.
According to one embodiment of present invention, the SQL statement that user submits is obtained, and the SQL statement is audited
Further include：Semantic analysis is carried out to the SQL statement.
According to one embodiment of present invention, the SQL statement that user submits is obtained, and the SQL statement is audited
Further include：The SQL statement is sent to database administrator, so that the database administrator is completed to the SQL statement
Audit.
According to one embodiment of present invention, further include：In the syntactic analysis, the semantic analysis and the SQL language
The SQL statement is carried out rolling back action in the case that the audit fails by any one of audit of sentence.
The beneficial technical effect of the present invention lies in：
1, automatic auditing system disclosed by the invention is by algorithm integration, and it is long to solve traditional artificial mark Review Cycle,
The big drawback of error also greatly improves the efficiency of data audit task；
2, automatic auditing system disclosed by the invention can enable collection preconceived plan after obtaining the data annotation results that front end uploads
Method verifies annotation results coordinate, obtains auditing result.
Detailed description of the invention
It in order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, below will be to institute in embodiment
Attached drawing to be used is needed to be briefly described, it should be apparent that, the accompanying drawings in the following description is only some implementations of the invention
Example, for those of ordinary skill in the art, without creative efforts, can also obtain according to these attached drawings
Obtain other attached drawings.
Fig. 1 is the schematic diagram of automatic auditing system according to an embodiment of the present invention；
Fig. 2 is the flow chart of data audit according to an embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art's every other embodiment obtained belong to what the present invention protected
Range.
In order to solve the problems in the existing technology, the present invention provides a kind of automatic auditing systems, as shown in Figure 1,
The automatic auditing system includes：Auditing module 11 for obtaining the SQL statement of user's submission, and audits SQL statement；
Selecting module 12, for selecting corresponding MYSQL server to go to execute SQL statement, to obtain the implementing result of SQL statement；It is defeated
Module 13 out, for exporting and showing implementing result.
Solves traditional artificial mark Review Cycle by algorithm integration by means of above-mentioned technical proposal of the invention
Long, the big drawback of error, the efficiency and the automatic auditing system for also greatly improving data audit task is obtaining front end
After the data annotation results of upload, Integrated Algorithm can be enabled, annotation results coordinate is verified, obtain auditing result.
According to one embodiment of present invention, auditing module 11 includes：Syntax Analysis Module (not shown), for SQL
Sentence carries out syntactic analysis.
In this embodiment, which can carry out syntactic analysis to all SQL statements of submission, if language
Method is problematic, all corresponding error message can be returned to auditor, in addition, of course it is to be understood that the syntax Analysis Module is adopted
Parsing method can carry out syntactic analysis using existing any parsing method.
According to one embodiment of present invention, auditing module 11 further includes：Semantic module (not shown), for pair
SQL statement carries out semantic analysis.
In this embodiment, which provides the function of semantic analysis by semantic module, thus
The object being not present is reported an error or used when the information such as table, library, a column are incorrect does not perhaps meet specification
When report an error etc., in addition, of course it is to be understood that the semantic analysis that the semantic module uses can use existing
A kind of what semantic analysis progress semantic analysis.
According to one embodiment of present invention, auditing module 11 further includes：Module (not shown) is submitted, is used for SQL language
Sentence is sent to database administrator, so that database administrator completes the audit to SQL statement.
In this embodiment, which can also be by configuring the DBA of parameter in the automatic auditing system
(Database Administrator, database administrator) is much directed to the functions of SQL normalization constraint to provide, in addition,
Its performance that a query statement can also be analyzed by DBA.
According to one embodiment of present invention, auditing module 11 further includes：Roll-back module (not shown), in grammer point
SQL statement is carried out rolling back action in the case that the audit fails by any one of analysis, semantic analysis and audit of SQL statement,
It is updated to which undesirable SQL statement can be returned to user by it.
Technical solution to facilitate the understanding of the present invention, is described in detail below by specific embodiment.
The Inception module (it includes auditing module and selecting module) of the automatic auditing system of data is collection audit, holds
In an automation operational system of one, it is come according to the code revision of MySQL, can be very bright with it for row, rollback
The SQL statement of true, detailed and accurate audit MySQL, its operating mode is identical with MySQL, can directly make
It is connected with MySQL client, but does not need verifying authorization, for its opposite application program (upper layer auditing flow system etc.),
It is a server, the port of given server address and Inception server is needed in connection, and it is wanted relatively
It is a client, it needs to connect in real time in inside on line corresponding to audit or the sentence executed for MySQL server
Database server is connect to obtain required information, or directly executing corresponding sentence on line and obtaining binlog
It is exactly the service of an intermediate property Deng, Inception.
As shown in Fig. 2, the detailed process of the data checking method includes：Firstly, user (or developer) submits SQL language
Sentence, then SQL statement is verified, i.e., to user submit SQL statement carry out syntactic analysis, SQL statement grammer not
In the case where meeting regulation (or verification failure), then refuse audit the SQL statement also returned into user to update, however,
In the case where the grammer of SQL statement meets regulation (or verifying successfully), then content auditing further is carried out to SQL statement, i.e.,
Semantic analysis further is carried out to SQL statement, it is against regulation in the semanteme of SQL statement, then refuse audit also by the SQL statement
It returns to user to update, however, continuing to be sent to by the SQL statement in situation as defined in meeting in the semanteme of SQL statement
DBA audit then refuses audit and the SQL statement is also returned to user's weight in the case where the SQL statement does not meet DBA requirement
New edited, however, the SQL statement is sent to corresponding MySQL server and is held in the case where SQL statement meets DBA requirement
Row, i.e., one MySQL server of selection executes SQL statement from multiple MySQL servers, and by the execution knot of the SQL statement
Fruit (success or failure) shows on backstage, and gives user (or party concerned) by mail CC.
In addition, the automatic auditing system can be audited automatically after picture has been infused with collimation mark, and if audit does not pass through, system meeting
Automatically the interface for returning task publication again marks picture, if audit passes through, system can also show that mark task is completed.
The embodiment of the invention also provides a kind of automatic auditing methods, specifically include following steps：
The first step：The SQL statement that user submits is obtained, and the SQL statement is audited；
Second step：Corresponding MYSQL server is selected to go to execute the SQL statement, to obtain the execution of the SQL statement
As a result；
Third step：It exports and shows the implementing result.
In conclusion, by algorithm integration, solving traditional artificial mark by means of above-mentioned technical proposal of the invention
Review Cycle is long, the big drawback of error, and the efficiency and the automatic auditing system for also greatly improving data audit task exist
After obtaining the data annotation results that front end uploads, Integrated Algorithm can be enabled, annotation results coordinate is verified, obtain audit knot
Fruit.
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the invention, all in essence of the invention
Within mind and principle, any modification, equivalent replacement, improvement and so on be should all be included in the protection scope of the present invention.
Claims (10)
1. a kind of automatic auditing system, which is characterized in that including：
Auditing module for obtaining the SQL statement of user's submission, and audits the SQL statement；
Selecting module, for selecting corresponding MYSQL server to go to execute the SQL statement, to obtain holding for the SQL statement
Row result；
Output module, for exporting and showing the implementing result.
2. automatic auditing system according to claim 1, which is characterized in that the auditing module includes：
Syntax Analysis Module, for carrying out syntactic analysis to the SQL statement.
3. automatic auditing system according to claim 2, which is characterized in that the auditing module further includes：
Semantic module, for carrying out semantic analysis to the SQL statement.
4. automatic auditing system according to claim 3, which is characterized in that the auditing module further includes：
Module is submitted, for the SQL statement to be sent to database administrator, so that the database administrator is completed to institute
State the audit of SQL statement.
5. automatic auditing system according to claim 4, which is characterized in that the auditing module further includes：
Roll-back module, for being audited in any one of the syntactic analysis, the semantic analysis and audit of the SQL statement
In unsanctioned situation, the SQL statement is subjected to rolling back action.
6. a kind of automatic auditing method, which is characterized in that include the following steps：
The SQL statement that user submits is obtained, and the SQL statement is audited；
Corresponding MYSQL server is selected to go to execute the SQL statement, to obtain the implementing result of the SQL statement；
It exports and shows the implementing result.
7. automatic auditing method according to claim 6, which is characterized in that obtain the SQL statement that user submits, and to institute
It states SQL statement and audit and include：Syntactic analysis is carried out to the SQL statement.
8. automatic auditing method according to claim 7, which is characterized in that obtain the SQL statement that user submits, and to institute
It states SQL statement and audit and further include：Semantic analysis is carried out to the SQL statement.
9. automatic auditing method according to claim 8, which is characterized in that obtain the SQL statement that user submits, and to institute
It states SQL statement and audit and further include：The SQL statement is sent to database administrator, so that the database administrator
Complete the audit to the SQL statement.
10. automatic auditing method according to claim 9, which is characterized in that further include：In the syntactic analysis, described
Any one of semantic analysis and the audit of the SQL statement carry out rollback in the case that the audit fails, by the SQL statement
Operation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810392845.8A CN108876283A (en) | 2018-04-27 | 2018-04-27 | A kind of automatic auditing system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810392845.8A CN108876283A (en) | 2018-04-27 | 2018-04-27 | A kind of automatic auditing system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108876283A true CN108876283A (en) | 2018-11-23 |
Family
ID=64326666
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810392845.8A Withdrawn CN108876283A (en) | 2018-04-27 | 2018-04-27 | A kind of automatic auditing system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108876283A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110674161A (en) * | 2019-09-20 | 2020-01-10 | 上海擎感智能科技有限公司 | Method, system, storage medium and SQL operation platform for online SQL |
| CN110716922A (en) * | 2019-10-21 | 2020-01-21 | 深圳前海环融联易信息科技服务有限公司 | Incep-based database operation and maintenance method and device, computer equipment and storage medium |
| CN111984881A (en) * | 2019-05-21 | 2020-11-24 | 北京沃东天骏信息技术有限公司 | Prompting method, prompting device, terminal, server and storage medium |
| CN113127520A (en) * | 2021-05-11 | 2021-07-16 | 中国电信股份有限公司江西分公司 | Distributed database SQL (structured query language) auditing and intercepting method and device based on agent mode |
| CN113343272A (en) * | 2021-06-30 | 2021-09-03 | 重庆富民银行股份有限公司 | Automatic data extraction system and method applied to database |
| CN114528514A (en) * | 2022-04-24 | 2022-05-24 | 飞狐信息技术（天津）有限公司 | Content processing method, system, storage medium and electronic equipment |
-
2018
- 2018-04-27 CN CN201810392845.8A patent/CN108876283A/en not_active Withdrawn
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111984881A (en) * | 2019-05-21 | 2020-11-24 | 北京沃东天骏信息技术有限公司 | Prompting method, prompting device, terminal, server and storage medium |
| CN110674161A (en) * | 2019-09-20 | 2020-01-10 | 上海擎感智能科技有限公司 | Method, system, storage medium and SQL operation platform for online SQL |
| CN110716922A (en) * | 2019-10-21 | 2020-01-21 | 深圳前海环融联易信息科技服务有限公司 | Incep-based database operation and maintenance method and device, computer equipment and storage medium |
| CN113127520A (en) * | 2021-05-11 | 2021-07-16 | 中国电信股份有限公司江西分公司 | Distributed database SQL (structured query language) auditing and intercepting method and device based on agent mode |
| CN113127520B (en) * | 2021-05-11 | 2023-07-21 | 中国电信股份有限公司江西分公司 | Agent mode-based distributed database SQL auditing and intercepting method and device |
| CN113343272A (en) * | 2021-06-30 | 2021-09-03 | 重庆富民银行股份有限公司 | Automatic data extraction system and method applied to database |
| CN114528514A (en) * | 2022-04-24 | 2022-05-24 | 飞狐信息技术（天津）有限公司 | Content processing method, system, storage medium and electronic equipment |
| CN114528514B (en) * | 2022-04-24 | 2022-07-12 | 飞狐信息技术（天津）有限公司 | Content processing method, system, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108876283A (en) | A kind of automatic auditing system and method | |
| CN110764753B (en) | Business logic code generation method, device, equipment and storage medium | |
| CN104391934B (en) | Data verification method and device | |
| CN103092761B (en) | Method and device of recognizing and checking modifying code blocks based on difference information file | |
| CN108345532A (en) | A kind of automatic test cases generation method and device | |
| CN108446223B (en) | Business scene automatic testing method based on dynamic compilation | |
| CN102521700A (en) | Electrical network informatization evaluation rapid test system | |
| CN106126528B (en) | A kind of moonlet test basic information generation method based on platform model | |
| CN111651431A (en) | Database service oriented management flow standardization method | |
| CN109063362B (en) | Avionics software interface control file design management system | |
| CN113706110B (en) | FPGA test tool integrated test management platform | |
| CN110597721A (en) | Automatic interface pressure testing method based on pressure testing script | |
| CN109558316A (en) | A kind of HTTP interface mobilism parameter test method of Test Strategy automatic configuration | |
| CN109189849B (en) | Standardized and streamlined data entry method and system | |
| Xu et al. | A requirement-based regression test selection technique in behavior-driven development | |
| Al Mahruqi et al. | A semi-automated framework for migrating web applications from SQL to document oriented NoSQL database. | |
| CN110019118A (en) | The system and method for database O&M efficiency are promoted based on DevOps | |
| Han et al. | Automated warship software testing system based on loadrunner automation API | |
| CN114911773A (en) | Universal meta-model design method | |
| CN115237469A (en) | Multi-mode architecture reverse analysis method based on cloud service source code | |
| CN114297961A (en) | Chip test case processing method and related device | |
| US20120072878A1 (en) | Automated management of verification waivers | |
| CN111966665A (en) | Data migration test method and device | |
| CN103678636A (en) | System and method for improving reliability of component software system | |
| CN105354144A (en) | Method and system for automatically testing consistency of business support system information models |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20181123 |
|
| WW01 | Invention patent application withdrawn after publication |