CN110517010A - A kind of data processing method, system and storage medium - Google Patents
A kind of data processing method, system and storage medium Download PDFInfo
- Publication number
- CN110517010A CN110517010A CN201910699125.0A CN201910699125A CN110517010A CN 110517010 A CN110517010 A CN 110517010A CN 201910699125 A CN201910699125 A CN 201910699125A CN 110517010 A CN110517010 A CN 110517010A
- Authority
- CN
- China
- Prior art keywords
- data
- examination
- approval
- practical
- execute
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Mathematical Physics (AREA)
- Operations Research (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Fuzzy Systems (AREA)
- Quality & Reliability (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of data comparison method and systems, method includes: to obtain examination & approval data from problem-management system, practical execution data are obtained from database audit platform, data will be examined and be compared with the practical data that execute, judge to examine data and whether reality execution data are consistent；If examining, data are consistent with reality execution data, and to the database audit platform transmission consistent message of comparison result, the consistent message of comparison result is used to indicate database audit platform and executes the SQL script for including in practical execution data；If examination & approval data and it is practical execute that data are inconsistent, send the inconsistent message of comparison result to database audit platform, compare inconsistent message and be used to indicate database audit platform and refuse to execute the SQL script for including in practical execution data.It is compared by the examination & approval data to audit front and back with the practical data that execute, it is ensured that the compliance of audit ensure that the accuracy of database data.
Description
Technical field
The invention belongs to field of computer technology more particularly to a kind of data processing methods, system and storage medium.
Background technique
With the extensive use of computer technology, electronic office is increasingly popularized, during electronic office, employee
It is frequently necessary to modify to data in data management system, in terms of the audit that data are modified currently for employee, rely primarily on
In being accomplished manually, manual audit's result has that uncontrollable compliance, the accuracy of database cannot be guaranteed.
Summary of the invention
The present invention provides a kind of data processing method, system and storage medium, to solve in the prior art in number
Manual examination and verification have that uncontrollable compliance, database accuracy cannot protect after modifying according to management system to data
The problem of card.
In a first aspect, the present invention provides a kind of data processing method, method includes:
Examination & approval data are obtained from problem-management system, obtain practical execution data, the examination & approval from database audit platform
Data are the relevant operating data for the data to be modified that user submits；The practical data that execute are audit user to the examination & approval
After data are audited, the relevant operating data of the modification operation to actually execute determined；
The examination & approval data are compared with the practical data that execute, judge that the examination & approval data are actually held with described
Whether row data are consistent；
If the examination & approval data are consistent with the practical data that execute, sent to the database audit platform and compare knot
The consistent message of fruit, the consistent message of comparison result are used to indicate the database audit platform and execute the practical execution
The SQL script for including in data；If the examination & approval data and the practical data that execute are inconsistent, to database audit platform
The inconsistent message of comparison result is sent, the inconsistent message of the comparison is used to indicate database audit platform and not executes institute
State the SQL script for including in practical execution data.
Optionally, examination & approval data described in each group and the practical data that execute include for executing specific data modification
The SQL script of operation includes unique identification information in the SQL script.
It is optionally, described that the examination & approval data are compared with the practical data that execute, comprising:
Obtain the unique identification information for including in examination & approval data, and according to the unique identification information it is determining with it is described
Examine the practical execution data of the data unique identification information having the same；
By the examination & approval data with the practical execution number with the examination & approval data unique identification information having the same
According to being compared.
It optionally, include data call interface, the number in described problem management system and the database audit platform
It is used to obtain the examination & approval data respectively from described problem management system and database audit platform timing according to calling interface
And the practical execution data.
Optionally, described to obtain examination & approval data from problem-management system, and practical execute is obtained from database audit platform
Data, comprising:
The notification message that the database audit platform is sent is received, the notification message is in database audit platform pair
It is voluntarily generated after one group of examination & approval data completion audit, and the notification message is used to indicate and compares the examination & approval data
It is right；
The corresponding practical execution number of the examination & approval data is obtained from the database audit platform based on the notification message
According to from the described problem management system acquisition examination & approval data.
Optionally, before the examination & approval data that will acquire are compared with the practical execution data further include:
Denoising is carried out to the examination & approval data and the practical data that execute.
Optionally, the examination & approval data that will acquire are compared with the practical data that execute, comprising:
Hash processing is carried out to the examination & approval data and the practical data that execute, obtains two groups of corresponding hash values；
The character string likelihood of two groups of corresponding hash values is calculated by character string likelihood algorithm；
If the character string likelihood being calculated is greater than or equal to preset likelihood, the examination & approval data and institute are determined
It is consistent to state practical execution data；If the character string likelihood being calculated is less than preset likelihood, the examination & approval are determined
Data and the practical execution data are inconsistent.
Second aspect, the present invention provide a kind of data processing system, and system includes:
Data acquisition module is examined data for obtaining from problem-management system, and is obtained in fact from database audit platform
Border executes data, and the examination & approval data are the relevant operating data for the data to be modified that user submits；The practical execution data
After auditing for audit user to the examination & approval data, the relevant operating data of the modification operation to actually execute determined；
Data comparing module judges described examine for the examination & approval data to be compared with the practical data that execute
Whether batch data and the practical execution data are consistent；
Execution module, if consistent with the practical data that execute for the examination & approval data, to the database audit
Platform sends the consistent message of comparison result, and the consistent message of comparison result is used to indicate the database audit platform and holds
The SQL script for including in the row practical execution data；If the examination & approval data and the practical data that execute are inconsistent, to
Database audit platform sends the inconsistent message of comparison result, and the inconsistent message of the comparison is used to indicate database audit
Platform is refused to execute the SQL script for including in the practical execution data.
Optionally, the system also includes denoising module, for by the examination & approval data and the practical execution data
Before being compared, denoising is carried out to the examination & approval data and the practical data that execute.
The third aspect, the present invention provide a kind of readable storage medium storing program for executing, are stored thereon with computer program, which is characterized in that
When the computer program is executed by processor, each step in data processing method described in first aspect is realized.
It is flat from database audit from the embodiments of the present invention it is found that by obtaining examination & approval data from problem-management system
Platform obtains practical execution data, allows to examine data and is compared with the practical data that execute, judges to examine data and reality
Whether border executes data consistent；If it is consistent with the practical data that execute to examine data, is sent to database audit platform and compare knot
The consistent message of fruit, the consistent message of comparison result, which is used to indicate database audit platform and executes in practical execution data, includes
SQL script；If examining data and the practical data that execute being inconsistent, it is inconsistent that comparison result is sent to database audit platform
Message, compares inconsistent message and is used to indicate database audit platform and refuses to execute and practical execute the SQL foot for including in data
This.Therefore, in such a way that the examination & approval data to audit front and back are compared with practical execution data, irregularity can be repaired
Change and audit operation is evaded, it can be ensured that the compliance of audit ensure that the accuracy of database data.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those skilled in the art without any creative labor, can be with root
Other attached drawings are obtained according to these attached drawings.
Fig. 1 is the flow diagram of the embodiment of the present application data processing method；
Fig. 2 is the flow diagram of the embodiment of the present application comparing process；
Fig. 3 is the structural schematic diagram of the embodiment of the present application data processing system；
Fig. 4 is another structural schematic diagram of the embodiment of the present application data processing system.
Specific embodiment
In order to make the invention's purpose, features and advantages of the invention more obvious and easy to understand, below in conjunction with the present invention
Attached drawing in embodiment, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described reality
Applying example is only a part of the embodiment of the present invention, and not all embodiments.Based on the embodiments of the present invention, those skilled in the art
Member's every other embodiment obtained without making creative work, shall fall within the protection scope of the present invention.
Technical solution in for a better understanding of the invention, referring to Fig. 1, for data processing method in the embodiment of the present application
Flow diagram, comprising:
Step 101, examination & approval data are obtained from problem-management system, obtain practical execution data from database audit platform,
Examine the relevant operating data that data are the data to be modified that user submits；The practical data that execute are audit user to examination & approval data
After being audited, the relevant operating data of the modification operation to actually execute determined；
In the embodiment of the present application, user submits the relevant operating data of modification application, the correlation in problem-management system
Operation data includes but is not limited to: account, operation table, operation content and the structuring for operation and maintenance of this operation are looked into
Language (Structured Query Language, SQL) script is ask, it, can be to this operation by executing the SQL script
Account, operation table execute the operation that aforesaid operations content is directed toward.It is to be modified that data processing system from problem-management system obtains this
Relevant operating data as examination & approval data to be compared.Audit user is in database audit platform to above-mentioned correlation to be modified
Data are audited, and the relevant operating data that need to actually execute are generated after audit, which includes but is not limited to: behaviour
Make time, source IP address, account name and the corresponding SQL script actually executed.Data processing system is obtained from database audit platform
The relevant operating data that need to actually execute is taken, as practical execution data to be compared.
Step 102, examination & approval data are compared with the practical data that execute, judge that examining data and the practical data that execute is
It is no consistent；
In the embodiment of the present application, data processing system examines the examination & approval data and database obtained from problem-management system
The specific alignments that the practical execution data that meter platform obtains are compared can be described in detail in the following embodiments, herein not
It repeats again.
Step 103, if examination & approval data are consistent with the practical data that execute, it is consistent to send comparison to database audit platform
Message compares consistent message and is used to indicate the SQL script in the practical execution data of database audit platform execution included；If examining
Batch data and practical execution data are inconsistent, then send to database audit platform and compare inconsistent message, compare inconsistent
Message be used to indicate database audit platform and refuse to execute and practical execute the SQL script for including in data.
In the embodiment of the present application, when comparison result is that examination & approval data are consistent with practical operation data, output compares knot
Fruit and notification database audit platform this application and audit process are to close rule, the SQL script generated after can auditing, with
Realize the maintenance to database data；When comparison result is examination & approval data and practical execution data are inconsistent, illustrate this application
There are irregularity situation in operation and audit process, exports comparison result and notification database audit platform is refused after auditing
The SQL script of generation.
The embodiment of the present invention is compared by the data to audit front and back, and the application of pairing rule and audit operation are held
Row, avoids the application and audit work of irregularity, ensure that the compliance of Audit data, ensure that database number
According to safety.
Based on above embodiments, obtained to the examination & approval data obtained from problem-management system and from database audit platform
Audit user audit to above-mentioned examination & approval data after before obtained practical execution data are compared, to guarantee to compare logarithm
According to accuracy, examination & approval data need to be associated with corresponding practical execution data, be associated with and be mainly based upon unique identification information,
It is understood that each group of examination & approval data and the practical data that execute include the SQL for executing specific data modification operation
Script, unique identification information are located in the SQL script.Concrete mode is as follows:
The unique identification information for including in examination & approval data is obtained, and determines have with examination & approval data according to unique identification information
The practical execution data of identical unique identification information.
In the embodiment of the present application, after user submits operation data to be modified in problem-management system, issue management system
System is inserted into unique identification information in the SQL script of the operation data, and the audit user of database audit platform includes to this
After thering is the operation data of unique identification information to be audited, actually holding comprising identical unique identification information in SQL script is obtained
The operation data of capable modification operation.
Data processing system contains unique identification information when executing data processing task, from problem-management system acquisition
Operation data is as examination & approval data, and from the unique identification information obtained in its SQL script in the examination & approval data.Similarly, number
The practical operation data for containing unique identification information are obtained from database audit platform according to processing system and execute data as practical,
And the unique identification information in its SQL script is obtained from the practical execution data.Association compares this two groups of unique identification informations,
When this two groups of unique identification informations are identical, then examination & approval data organized to this and the practical data that execute being compared, otherwise then not into
Row compares.
The embodiment of the present application makes need to be compared by being inserted into unique identification information in the SQL script of examination & approval data
Data are associated according to unique identification information, are avoided the data unrelated to audit front and back from being compared, are improved comparison result
Accuracy, ensure that the safety of database.
It should be understood that executing data from problem-management system and database audit platform acquisition examination & approval data and reality
There are many methods, and it is for reference that the embodiment of the present application provides following two.It should be noted that this two kinds of acquisition methods are not made
For the limitation to the embodiment of the present application, based on the embodiments of the present invention, those skilled in the art are not making creative labor
Other data capture methods obtained under the premise of dynamic, shall fall in the protection scope of this application.
It include data call interface in method 1, problem-management system and database audit platform, data processing system passes through
The data call interface and problem-management system and database audit platform realize data interaction, are specifically used for from issue management system
Acquisition examination & approval data and reality execute data respectively for system and the timing of database audit platform.
Method 2 receives the notification message that database audit platform is sent, and notification message is in database audit platform to one group
Examination & approval data voluntarily generate after completing audit, and one group of reality of notification message direction database audit platform executes data；From
Database audit platform obtains the practical execution data that notification message is directed toward, and obtains what notification message was directed toward from problem-management system
It is practical to execute the corresponding examination & approval data of data.
In the embodiment of the present application, method 1 is data processing system in problem-management system and database audit platform
Built data call interface, the interface can be, but not limited to be: open CNC interface；By this interface, at data
Reason system periodically can obtain corresponding examination & approval data from problem-management system and database audit platform and corresponding reality executes number
According to.
Wherein, two file storages of data processing system carry, one is to examine number in storage problem management system
According to file space, another be store database audit platform generate practical execution data file space.Periodically obtain
Data deposit in the above file storage periodically to compare.
It is understood that data processing system does not limit it and obtains when obtaining examination & approval data and practical execution data
The precedence relationship taken for example, examination & approval data can be obtained from problem-management system respectively, and obtains in fact from database audit platform
Border executes data, and the unique identification information for including in the examination & approval data and practical execution data based on acquisition determines associated examine
Batch data and practical execution data, to be compared.Alternatively, practical execution data first can be obtained from database audit, and
Based on the practical unique identification information for including in data that executes from problem-management system, unique identification having the same is obtained
The examination & approval data of information, to obtain realizing associated examination & approval data and practical execution data based on unique identification information, so as into
Row compares.Alternatively, examination & approval data can first be got from problem-management system, the unique identification for including in examination & approval data is determined
Information, and from database audit platform obtain have identical unique identification information practical execution data, realize examination & approval data with
It is practical to execute association of the data based on unique identification information, to be compared.It is for having obtained but associated there is no determining
The practical examination & approval data for executing data, can continue to use its unique identification information next time again and obtain has identical unique identification letter
The practical execution data of breath, if repeat the n times operations does not get the practical execution with identical unique identification information yet
Data then send related reminder message to the auditor of database audit platform, to remind auditor to audit.
There is between data processing system and problem-management system first data transmission channel, and and database in method 2
Also there is the second data transmission channel, database audit platform triggers the instruction for completing to audit in audit user between audit platform
When, notification information is sent to data processing system by the second data transmission channel, data processing system is receiving notice letter
The practical execution data that the notification information is directed toward, and benefit are obtained from database audit platform using the second data transmission channel after breath
Examination & approval data corresponding with the practical execution data are obtained from problem-management system with first data transmission channel.
It is compared by executing data to examination & approval data and reality, avoids examination & approval data and practical execution data are different
The irregularity operation of cause causes to improve the safety of database data to Database error maintenance.
Based on Fig. 1 embodiment, it is being compared to examination & approval data and the corresponding practical data that execute in the embodiment of the present application
Before, it is advanced optimized, specifically:
Denoising is carried out to examination & approval data and the practical data that execute.
In the embodiment of the present application, it can be generated largely from triggering statement in executing operating process due to database, and
It might have line feed or space occur, to influence comparison result.Therefore before comparison, data to be compared are carried out at denoising
Reason, deletes extra line feed, space etc., to obtain more accurate comparison result.
Examination & approval data and the practical method for executing data and being denoised are made by the deletion to interference data and information
It is more accurate to obtain comparison result, further ensures the safety of database.
Further, it is based on Fig. 1 embodiment, referring to Fig. 2, be the flow chart of comparing process, including；
Step 201, Hash processing is carried out to examination & approval data and the practical data that execute, obtains two groups of corresponding hash values；
In the embodiment of the present application, data processing system is before comparison, to practical execution data to be compared and examination & approval number
According to Hash processing is carried out, two groups of corresponding hash values are obtained.Such as: the hash value of data to be compared is obtained using the close SM3 of state.
Step 202, the character string likelihood of two groups of corresponding hash values is calculated by character string likelihood algorithm；
In the embodiment of the present application, data processing system is by calculating character string likelihood algorithm to two groups of obtained correspondences
Hash value be compared.Calculating character string likelihood algorithm includes but is not limited to: editing distance calculating character string likelihood.
Wherein, whether identical editing distance exactly records each character string with a two-dimensional array, if identical be denoted as 0,
Not identical to be denoted as 1, each row and column same number is cumulative, then last number of array is different sum, thus judge this two
The similarity of a character, if similarity is greater than or equal to default similarity, it is believed that practical execute data and examination & approval data one
It causes.
Step 203, if the character string likelihood being calculated is greater than or equal to preset likelihood, determine to examine data
It is consistent with practical execution data；If the character string likelihood being calculated is less than preset likelihood, the examination & approval data determined
It is inconsistent with practical execution data.
In the embodiment of the present application, the character string likelihood method of corresponding hash value is handled and calculated by Hash to examination & approval number
It is compared according to the practical data that execute, improves the efficiency of comparing, to ensure that the timely of database data maintenance
Property, improve the safety of database data.
Referring to Fig. 3, being the structural schematic diagram of data processing system of the embodiment of the present invention, comprising:
Data acquisition module 301 obtains real for obtaining examination & approval data from problem-management system from database audit platform
Border executes data, and examination & approval data are the relevant operating data for the data to be modified that user submits；The practical data that execute are that audit is used
After family audits to examination & approval data, the relevant operating data of the modification operation to actually execute determined；
In the embodiment of the present application, the method for module acquisition data is identical as step 101, and details are not described herein again.In addition,
Two file storages of data acquisition module carry, a file space to examine data in storage problem management system,
Another is the file space for storing the practical execution data that database audit platform generates.It is deposited by the data that step 101 obtains
The two spaces are put in case data comparing module is compared.
Data comparing module 302 is compared with the practical data that execute for that will examine data, judges to examine data and reality
Whether border executes data consistent；
If execution module 303 is sent out consistent with the practical data that execute for examining data to database audit platform
Meter submit to a higher level for approval or revision by message, audit is used to indicate database audit platform execution reality by message and executes the SQL for including in data
Script；If examining data and the practical data that execute being inconsistent, sends and compare to problem-management system and database audit platform
As a result inconsistent message, compares inconsistent message and is used to indicate database audit platform and not execute practical execute in data
The SQL script for including.
It is understood that the content of above-described embodiment description, is retouched with comparison method in step 102, step 103 embodiment
The content stated is similar, specifically can be refering to the content in method described in embodiment shown in step 102,103, herein no longer
It repeats.
Data processing system provided in an embodiment of the present invention carries out the examination & approval data of examination & approval front and back and the practical data that execute
It compares, avoids the operation of irregularity from safeguarding the mistake of database data, ensure that the safety of database data.
Based on the data processing system in Fig. 3 embodiment, referring to Fig. 4, the another system for the embodiment of the present application is implemented
Example, the system include data acquisition module 301, data comparing module 302 and execution module 303, data acquisition module 301, number
According to data acquisition module 301, data comparing module 302 in comparison module 302 and execution module 303 and Fig. 3 embodiment and execute
303 function of module is identical, and details are not described herein again.
Above system further include: denoising module 401, for will examine data with actually execution data it is compared
Before, denoising is carried out to examination & approval data and the practical data that execute.
In the embodiment of the present application, data processing system denoising module concrete function in above method embodiment
Detailed description, details are not described herein again.
In the embodiment of the present application, it is obtained to the examination & approval data obtained from problem-management system and from database audit platform
Before the practical execution data that the audit user taken obtains after auditing to above-mentioned examination & approval data are compared, to guarantee to compare
The accuracy of data need to be associated examination & approval data with the corresponding practical data that execute, and association is mainly based upon unique identification letter
Breath, it is to be understood that each group of examination & approval data include for executing specific data modification operation with the practical data that execute
SQL script, unique identification information are located in the SQL script.
Above-mentioned denoising module 401 is by the deletion to interference data and information, so that comparison result is more accurate, further
Ensure the safety of database.
On the basis of Fig. 3 embodiment, above-mentioned task execution program detection device can also be comprised the following structure:
Data acquisition module 301 includes:
First data acquisition module, for fixed from problem-management system and database audit platform by data call interface
When obtain examination & approval data respectively and practical execute data；
Information receiving module, the notification message that audit platform in library is sent for receiving data；
Second data acquisition module, notification message for being sent based on database audit platform is from database audit platform
The corresponding practical execution data of notification message are obtained, obtain the corresponding examination & approval data of notification message from problem-management system.
Data comparing module 302 includes:
Hash processing module, for carrying out Hash processing to examination & approval data and the practical data that execute, obtain two groups it is corresponding
Hash value；
Character string likelihood computing module, for calculating the word of two groups of corresponding hash values by character string likelihood algorithm
Symbol string likelihood；
Determination module determines to examine if the character string likelihood for being calculated is greater than or equal to preset likelihood
Batch data is consistent with practical execution data；If the character string likelihood being calculated is less than preset likelihood, what is determined is examined
Batch data and practical execution data are inconsistent.
It is understood that the content of above-described embodiment description is retouched with data processing method in Fig. 1 and embodiment illustrated in fig. 2
The content stated is similar, the content being specifically referred in method described in Fig. 1 and embodiment shown in Fig. 2, no longer superfluous herein
It states.
Data processing system provided in an embodiment of the present invention carries out the examination & approval data of examination & approval front and back and the practical data that execute
It compares, avoids the operation of irregularity from safeguarding the mistake of database data, ensure that the safety of database data.
The present invention also provides a kind of storage mediums, are stored thereon with computer program, which is held by processor
Each step in data processing method that implementation method embodiment provides when row.
It is flat from database audit from the embodiments of the present invention it is found that by obtaining examination & approval data from problem-management system
Platform obtains practical execution data, allows to examine data and is compared with the practical data that execute, judges to examine data and reality
Whether border executes data consistent；If it is consistent with the practical data that execute to examine data, is sent to database audit platform and compare knot
The consistent message of fruit, the consistent message of comparison result, which is used to indicate database audit platform and executes in practical execution data, includes
SQL script；If examining data and the practical data that execute being inconsistent, it is inconsistent that comparison result is sent to database audit platform
Message, compares inconsistent message and is used to indicate database audit platform and refuses to execute and practical execute the SQL foot for including in data
This.Therefore, in such a way that the examination & approval data to audit front and back are compared with practical execution data, irregularity can be repaired
Change and audit operation is evaded, it can be ensured that the compliance of audit ensure that the accuracy of database data.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, there is no the portion being described in detail in some embodiment
Point, it may refer to the associated description of other embodiments.
The above are the descriptions to technical solution provided by the present invention, for those skilled in the art, according to the present invention
The thought of embodiment, there will be changes in the specific implementation manner and application range, and to sum up, the content of the present specification should not manage
Solution is limitation of the present invention.
Claims (10)
1. a kind of data processing method is applied to computer equipment, which is characterized in that the described method includes:
Examination & approval data are obtained from problem-management system, obtain practical execution data, the examination & approval data from database audit platform
For the relevant operating data for the data to be modified that user submits, the practical data that execute are audit user to the examination & approval data
After being audited, the relevant operating data of the modification operation to actually execute determined；
The examination & approval data are compared with the practical data that execute, judge the examination & approval data and the practical operation number
According to whether consistent；
If the examination & approval data are consistent with the practical data that execute, comparison result one is sent to the database audit platform
The message of cause, the consistent message of comparison result are used to indicate the database audit platform and execute the practical execution data
In include SQL script；If the examination & approval data and the practical data that execute are inconsistent, to the database audit platform
The inconsistent message of comparison result is sent, the inconsistent message of the comparison is used to indicate the database audit platform and not holds
The SQL script for including in the row practical execution data.
2. data processing method according to claim 1, which is characterized in that examination & approval data and the reality described in each group
Executing data includes the SQL script for executing specific data modification operation, is believed in the SQL script comprising unique identification
Breath.
3. data processing method according to claim 2, which is characterized in that described by the examination & approval data and the reality
Data are executed to be compared, comprising:
The unique identification information for including in examination & approval data is obtained, and according to unique identification information determination and the examination & approval
The practical execution data of the data unique identification information having the same；
By it is described examination & approval data with it is described examination & approval the data unique identification information having the same practical execution data into
Row compares.
4. data processing method according to claim 3, which is characterized in that described problem management system and the database
It include data call interface in audit platform, the data call interface is used for from described problem management system and the database
Audit platform timing obtains the examination & approval data and the practical execution data respectively.
5. data processing method according to claim 3, which is characterized in that described to obtain examination & approval number from problem-management system
According to, and obtain reality from database audit platform and execute data, comprising:
The notification message that the database audit platform is sent is received, the notification message is in database audit platform to one group
It is voluntarily generated after examination & approval data completion audit, and the notification message is used to indicate and the examination & approval data are compared；
The corresponding practical execution data of the examination & approval data are obtained from the database audit platform based on the notification message, from
Described problem management system obtains the examination & approval data.
6. any one data processing method according to claims 1 to 5, which is characterized in that it is described will acquire it is described
Before examination & approval data are compared with the practical execution data further include: to the examination & approval data and the practical execution data
Carry out denoising.
7. data processing method according to claim 6, which is characterized in that the examination & approval data that will acquire and institute
Practical execution data are stated to be compared, comprising:
Hash processing is carried out to the examination & approval data and the practical data that execute, obtains two groups of corresponding hash values；
The character string likelihood of two groups of corresponding hash values is calculated by character string likelihood algorithm；
If the character string likelihood being calculated is greater than or equal to preset likelihood, the examination & approval data and the reality are determined
It is consistent that border executes data；If the character string likelihood being calculated is less than preset likelihood, the examination & approval data are determined
It is inconsistent with the practical execution data.
8. a kind of data processing system, which is characterized in that the system comprises:
Data acquisition module obtains practical execute from database audit platform for obtaining examination & approval data from problem-management system
Data, the examination & approval data are the relevant operating data for the data to be modified that user submits, and the practical data that execute are audit
After user audits to the examination & approval data, the relevant operating data of the modification operation to actually execute determined；
The examination & approval data are compared data comparing module with the practical data that execute, judge the examination & approval data and
Whether the practical execution data are consistent；
Execution module, if consistent with the practical data that execute for the examination & approval data, to the database audit platform
It sends and audits through message, the audit is used to indicate the database audit platform by message and executes the practical execution number
The SQL script for including in；If the examination & approval data and the practical data that execute are inconsistent, sent out to database audit platform
The message that comparison result is inconsistent is sent, the inconsistent message of the comparison is used to indicate the database audit platform and not executes
The SQL script for including in the practical execution data.
9. data processing system according to claim 8, which is characterized in that the system also includes:
Denoise module, for by the examination & approval data with it is described actually execution data be compared before, to the examination & approval number
Denoising is carried out according to the practical data that execute.
10. a kind of readable storage medium storing program for executing, is stored thereon with computer program, which is characterized in that the computer program is processed
When device executes, each step in data processing method as claimed in any one of claims 1 to 7 is realized.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910699125.0A CN110517010B (en) | 2019-07-31 | 2019-07-31 | Data processing method, system and storage medium |
| PCT/CN2019/117415 WO2021017281A1 (en) | 2019-07-31 | 2019-11-12 | Data processing method and system, computer device, and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910699125.0A CN110517010B (en) | 2019-07-31 | 2019-07-31 | Data processing method, system and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110517010A true CN110517010A (en) | 2019-11-29 |
| CN110517010B CN110517010B (en) | 2023-07-11 |
Family
ID=68624049
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910699125.0A Active CN110517010B (en) | 2019-07-31 | 2019-07-31 | Data processing method, system and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN110517010B (en) |
| WO (1) | WO2021017281A1 (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112256672A (en) * | 2020-10-22 | 2021-01-22 | 中国联合网络通信集团有限公司 | Database change approval method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104391995A (en) * | 2014-12-15 | 2015-03-04 | 北京趣拿软件科技有限公司 | SQL (Structured Query Language) statement auditing method, and database operation and maintenance method and system |
| CN107908651A (en) * | 2017-10-12 | 2018-04-13 | 北京人大金仓信息技术股份有限公司 | A kind of auditing method of distributed type assemblies |
| CN109710518A (en) * | 2018-12-13 | 2019-05-03 | 中国联合网络通信集团有限公司 | Script checking method and device |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8799225B2 (en) * | 2003-11-05 | 2014-08-05 | Lumigent Technologies, Inc. | Process and system for auditing database activity |
| CN101853289B (en) * | 2010-05-26 | 2012-10-17 | 杭州华三通信技术有限公司 | Database auditing method and equipment |
| CN109271315B (en) * | 2018-08-23 | 2024-05-10 | 中国平安财产保险股份有限公司 | Script code detection method, script code detection device, computer equipment and storage medium |
-
2019
- 2019-07-31 CN CN201910699125.0A patent/CN110517010B/en active Active
- 2019-11-12 WO PCT/CN2019/117415 patent/WO2021017281A1/en active Application Filing
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104391995A (en) * | 2014-12-15 | 2015-03-04 | 北京趣拿软件科技有限公司 | SQL (Structured Query Language) statement auditing method, and database operation and maintenance method and system |
| CN107908651A (en) * | 2017-10-12 | 2018-04-13 | 北京人大金仓信息技术股份有限公司 | A kind of auditing method of distributed type assemblies |
| CN109710518A (en) * | 2018-12-13 | 2019-05-03 | 中国联合网络通信集团有限公司 | Script checking method and device |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112256672A (en) * | 2020-10-22 | 2021-01-22 | 中国联合网络通信集团有限公司 | Database change approval method and device |
| CN112256672B (en) * | 2020-10-22 | 2023-05-30 | 中国联合网络通信集团有限公司 | Database change approval method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110517010B (en) | 2023-07-11 |
| WO2021017281A1 (en) | 2021-02-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110908997A (en) | Data blood margin construction method and device, server and readable storage medium | |
| CN110162516B (en) | Data management method and system based on mass data processing | |
| CN110032568B (en) | Data structure reading and updating method and device, and electronic equipment | |
| CN111461751A (en) | Block chain-based house property information chain organization method, historical state tracing method and device | |
| CN111400170A (en) | Data permission testing method and device | |
| CN115238247A (en) | Data processing method based on zero trust data access control system | |
| CN110517010A (en) | A kind of data processing method, system and storage medium | |
| US20170344627A1 (en) | System for lightweight objects | |
| CN113342647A (en) | Test data generation method and device | |
| US9009731B2 (en) | Conversion of lightweight object to a heavyweight object | |
| CN113704123B (en) | Interface testing method, device, equipment and storage medium | |
| CN110221952B (en) | Service data processing method and device and service data processing system | |
| CN115511644A (en) | Processing method for target policy, electronic device and readable storage medium | |
| US8321844B2 (en) | Providing registration of a communication | |
| CN112835903A (en) | Sensitive data identification method and equipment | |
| CN112559331A (en) | Test method and device | |
| CN113868697B (en) | Method for real-time analysis data desensitization based on telecommunication data warehouse | |
| CN114254207B (en) | Method and device for identifying enterprise homonymy high-speed management, electronic equipment and storage medium | |
| CN116521674A (en) | Data processing method, device, equipment and storage medium | |
| US11768819B2 (en) | Data unblocking in application platforms | |
| CN116263773A (en) | Data sorting method and device | |
| CN117909318A (en) | Database compatibility optimization processing method, device, equipment and storage medium | |
| CN117194476A (en) | SQL script generation method, device, equipment and storage medium | |
| CN115687320A (en) | Data quality inspection framework method and system | |
| CN115660875A (en) | Account data processing method and device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |