CN111831698B - Data auditing method, system and electronic equipment - Google Patents
Data auditing method, system and electronic equipment Download PDFInfo
- Publication number
- CN111831698B CN111831698B CN202010730191.2A CN202010730191A CN111831698B CN 111831698 B CN111831698 B CN 111831698B CN 202010730191 A CN202010730191 A CN 202010730191A CN 111831698 B CN111831698 B CN 111831698B
- Authority
- CN
- China
- Prior art keywords
- platform
- auditing
- target data
- preset
- data
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 30
- 238000012550 audit Methods 0.000 claims description 82
- 239000003086 colorant Substances 0.000 claims description 4
- 230000009286 beneficial effect Effects 0.000 description 9
- 230000002159 abnormal effect Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 238000005406 washing Methods 0.000 description 2
- 206010019233 Headaches Diseases 0.000 description 1
- 230000005856 abnormality Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 231100000869 headache Toxicity 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000011282 treatment Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
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/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3089—Monitoring arrangements determined by the means or processing involved in sensing the monitored data, e.g. interfaces, connectors, sensors, probes, agents
- G06F11/3093—Configuration details thereof, e.g. installation, enabling, spatial arrangement of the probes
-
- 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/21—Design, administration or maintenance of databases
-
- 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/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/82—Solving problems relating to consistency
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Quality & Reliability (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a data auditing method, a system and electronic equipment, which are characterized in that firstly, data transmitted by each platform of an enterprise are analyzed to obtain target data corresponding to each preset auditing field of each platform, then, the target data corresponding to each preset auditing field of each platform is audited according to a preset auditing flow mode, whether the data between each platform are balanced or not can be accurately determined, and the data auditing efficiency is improved.
Description
Technical Field
The present invention relates to the field of data auditing technologies, and in particular, to a data auditing method, system, and electronic device.
Background
With the development of information industry, the business development modes of some enterprises are diversified, and platforms of systems accessed to the enterprises are more and more, for example, a certain enterprise receives orders from a treasured washing network and orders from a mobile phone APP, and then the treasured washing network and the mobile phone APP are two platforms of the enterprise, but data updating of each platform is synchronous, and is asynchronous, so that data is complicated, whether data between each platform is balanced or not is determined, and the headache problem of each enterprise manager is gradually formed.
Disclosure of Invention
The invention aims to solve the technical problem of providing a data auditing method, a system and electronic equipment aiming at the defects of the prior art.
The technical scheme of the data auditing method is as follows:
analyzing the data sent by each platform of the enterprise, and acquiring target data corresponding to each preset auditing field of each platform from the analyzed data;
and auditing the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode to obtain an auditing result.
The data auditing method has the following beneficial effects:
firstly, analyzing data sent by each platform of an enterprise to obtain target data corresponding to each preset auditing field of each platform, and then auditing the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode, so that whether the data between each platform are balanced or not can be accurately determined, and the data auditing efficiency is improved.
On the basis of the scheme, the data auditing method can be improved as follows.
Further, auditing the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode includes:
and auditing the target data corresponding to any preset audit field of any platform with the target data of the target platform corresponding to the platform, if the target data is consistent, normally marking the target data label corresponding to the preset audit field of the platform in the audit result, and if the target data label is inconsistent, abnormally marking the target data label corresponding to the preset audit field of the platform in the audit result, wherein the target platform corresponding to the platform is obtained according to the preset audit flow mode until the target data corresponding to each preset audit field of each platform is audited.
The beneficial effects of adopting the further scheme are as follows: and the normal marking or the abnormal marking is carried out on the auditing result, so that the user can visually check the auditing result.
Further, after obtaining the target data corresponding to each preset audit field of each platform from the data obtained after the parsing, the method further includes: and storing the target data corresponding to each preset auditing field of each platform into an auditing summary table.
The beneficial effects of adopting the further scheme are as follows: the target data corresponding to each preset audit field of each platform is stored in the audit summary table, so that a user can check whether the data which is normally marked or abnormally marked in the audit result is correct or not by checking the audit summary table later.
Further, the method further comprises the following steps: and displaying the auditing result to a user.
The beneficial effects of adopting the further method are as follows: and the visual check by the user is facilitated.
The technical scheme of the data auditing system is as follows:
the system comprises an analysis acquisition module and a data auditing module;
the analysis acquisition module is used for analyzing the data sent by each platform of the enterprise and acquiring target data corresponding to each preset audit field of each platform from the analyzed data;
the data auditing module is used for auditing the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode to obtain an auditing result.
The data auditing system has the following beneficial effects:
the analysis acquisition module is used for analyzing the data sent by each platform of the enterprise to acquire the target data corresponding to each preset auditing field of each platform, and the data auditing module is used for auditing the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode, so that whether the data between each platform are balanced or not can be accurately determined, and the data auditing efficiency is improved.
Based on the scheme, the data auditing system can be improved as follows.
Further, the data auditing module is specifically configured to:
and auditing the target data corresponding to any preset audit field of any platform with the target data of the target platform corresponding to the platform, if the target data is consistent, normally marking the target data label corresponding to the preset audit field of the platform in the audit result, and if the target data label is inconsistent, abnormally marking the target data label corresponding to the preset audit field of the platform in the audit result, wherein the target platform corresponding to the platform is obtained according to the preset audit flow mode until the target data corresponding to each preset audit field of each platform is audited.
The beneficial effects of adopting the further scheme are as follows: and the normal marking or the abnormal marking is carried out on the auditing result, so that the user can visually check the auditing result.
Further, the system also comprises a storage module, wherein the storage module is used for storing the target data corresponding to each preset auditing field of each platform into an auditing summary table.
The beneficial effects of adopting the further scheme are as follows: the target data corresponding to each preset audit field of each platform is stored in the audit summary table, so that a user can check whether the data which is normally marked or abnormally marked in the audit result is correct or not by checking the audit summary table later.
Further, the system also comprises a display module, wherein the display module is used for displaying the auditing result to a user.
The beneficial effects of adopting the further method are as follows: and the visual check by the user is facilitated.
The technical scheme of the electronic equipment is as follows:
the method comprises a memory, a processor and a program stored in the memory and running on the processor, wherein the processor executes the program to realize the steps of a data auditing method according to any one of the above.
The electronic equipment has the beneficial effects that:
firstly, analyzing data sent by each platform of an enterprise to obtain target data corresponding to each preset auditing field of each platform, and then auditing the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode, so that whether the data between each platform are balanced or not can be accurately determined, and the data auditing efficiency is improved.
Drawings
FIG. 1 is a flow chart of a data auditing method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a data auditing system according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of an electronic device according to an embodiment of the present invention;
Detailed Description
As shown in fig. 1, a data auditing method according to an embodiment of the present invention includes the following steps:
s1, analyzing data sent by each platform of an enterprise, and acquiring target data corresponding to each preset audit field of each platform from the analyzed data;
s2, auditing the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode to obtain auditing results.
Firstly, analyzing data sent by each platform of an enterprise to obtain target data corresponding to each preset auditing field of each platform, and then auditing the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode, so that whether the data between each platform are balanced or not can be accurately determined, and the data auditing efficiency is improved.
Taking an enterprise as an example, for example, a mobile company in China, where the mobile company in China includes a billing platform, a payment center platform, an order center platform and an order receiving platform, and the billing platform includes a Taobao network, a Beijing east mall, a mobile APP in China, and the like, specifically:
data from the list platform refers to: orders placed by users of the China mobile company on the Taobao network, the Beijing east mall and the China mobile APP, such as payment orders, flow superposition orders and the like, wherein the payment orders, the flow superposition orders and the like comprise information such as order numbers, mobile phone numbers, payment amounts and the like;
the data of the payment center platform refer to: the actual orders received by the China mobile company comprise each order number, a mobile phone number corresponding to each order number, an actual account amount and the like.
The data of the order center platform refers to: the Chinese mobile company receives orders to be accepted according to each order number, the mobile phone number corresponding to each order number, the actual account amount and the like;
the data of the order acceptance platform refers to: the order to be accepted is accepted in practice;
it can be understood that the orders placed on the order platform such as the Taobao network, the Jingdong mall and the China Mobile APP have fixed text formats, and the text formats are directly installed for programming, so that the data sent by the order platform can be analyzed, and the data sent by the payment center platform, the data sent by the payment center platform and the data sent by the order acceptance platform can be analyzed in the same way.
Wherein, the preset audit field of the order receiving platform comprises an order number, a mobile phone number and an amount of payment, the preset audit field of the payment center platform comprises an order number, a mobile phone number and an actual account amount, the preset audit field of the order center platform comprises an order number, a mobile phone number and an amount, the preset audit field of the order receiving platform comprises an order number, a mobile phone number and an amount, thereby obtaining target data corresponding to each preset audit field of each platform, for example, a mobile user in China places a payment order on the Taobao network of the order platform, the order number of the payment order is 000001, the phone number is 150 XXXXXXXXX, the payment amount is 100 yuan, and for the payment order, the target data corresponding to each preset auditing field of the order platform is the order number 000000, the mobile phone number is 150 xx, and the payment amount is 100 yuan.
The preset auditing flow mode can be understood as follows:
1) Auditing the target data corresponding to each preset auditing field in the single platform and the target data corresponding to each preset auditing field of the payment center platform, specifically:
for example, the target data corresponding to each preset audit field in the order platform includes 3 target data, which are respectively a first group of target data of the order platform, a second group of target data of the order platform and a third group of target data of the order platform, specifically:
first set of target data for a call-in platform: the order number is 000001, the mobile phone number is 150 XXXXXXXX, and the payment amount is 100 yuan;
a second set of target data for the order platform: the order number is 000002, the mobile phone number is 136, the payment amount is 50 yuan;
third set of target data for the order platform: the order number is 000003, the mobile phone number is 187, the payment amount is 30 yuan;
at this time, the target data corresponding to each preset audit field in the payment center platform includes 3 target data, which are respectively a first group of target data of the payment center platform, a second group of target data of the payment center platform, and a third group of target data of the payment center platform, specifically:
a first set of target data for a payment center platform: the order number is 000001, the mobile phone number is 150×, the actual account amount is 100 yuan;
a second set of target data for the payment center platform: the order number is 000002, the mobile phone number is 136 xx, and the actual account amount is 50 yuan;
third set of target data for payment center platform: the order number is 000003, the mobile phone number is 187, and the actual account amount is 20 yuan;
at this time, the first group of target data of the coming bill platform and the first group of target data of the payment center platform are checked, the result is consistent, the second group of target data of the coming bill platform and the second group of target data of the payment center platform are checked, the result is consistent, when the third group of target data of the coming bill platform and the third group of target data of the payment center platform are checked, as the payment amount corresponding to the order number 000003 in the third group of target data of the coming bill platform is 30 yuan, and the payment amount corresponding to the order number 000003 in the third group of target data of the payment center platform is 20 yuan, the result is inconsistent, thereby generating a checking result, when a user checks the checking result, the third group of target data of the coming bill platform and the third group of target data of the payment center platform can be visually seen, and then subsequent checking and other treatments can be carried out;
it can be understood that when the number of the sets of the target data corresponding to each preset audit field in the coming platform is different from the number of the sets of the target data corresponding to each preset audit field in the payment center platform, the first set of the target data is assumed to be missing in the payment center platform, and when the first set of the target data of the coming platform is audited, the result is inconsistent because the data corresponding to the first set of the target data of the coming platform cannot be found in the payment center platform.
2) The target data corresponding to each preset audit field in the order center platform and the target data corresponding to each preset audit field in the future single platform are audited, for example, the target data corresponding to each preset audit field in the order center platform comprises 3 target data, namely, a first group of target data of the order platform, a second group of target data of the order platform and a third group of target data of the order platform, specifically:
first set of target data for a call-in platform: the order number is 000001, the mobile phone number is 150 XXXXXXXX, and the payment amount is 100 yuan;
a second set of target data for the order platform: the order number is 000002, the mobile phone number is 136, the payment amount is 50 yuan;
third set of target data for the order platform: the order number is 000003, the mobile phone number is 187, the payment amount is 30 yuan;
at this time, the target data corresponding to each preset audit field of the order center platform includes 3 target data, which are respectively a first group of target data of the order center platform, a second group of target data of the order center platform, and a third group of target data of the order center platform, specifically:
a first set of target data for the order center platform: the order number is 000001, the mobile phone number is 150 XXXXXX, and the amount is 100 yuan;
a second set of target data for the order center platform: the order number is 000002, the mobile phone number is 136, the mobile phone number is 50 yuan;
third set of target data for order center platform: the order number is 000003, the mobile phone number is 187, the amount is 20 yuan;
at this time, the first group of target data of the order platform and the first group of target data of the order center platform are checked, the result is consistent, the second group of target data of the order platform and the second group of target data of the order center platform are checked, the result is consistent, when the third group of target data of the order platform and the third group of target data of the order center platform are checked, as the payment amount corresponding to the order number 000003 in the third group of target data of the order platform is 30 yuan, and the payment amount corresponding to the order number 000003 in the third group of target data of the order center platform is 20 yuan, the result is inconsistent, thereby generating a checking result, and when a user checks the checking result, the third group of target data of the order platform and the third group of target data of the order center platform can be visually seen, and then subsequent checking and other processes can be performed;
it can be understood that when the number of the groups of the target data corresponding to each preset audit field in the order center platform is different from the number of the groups of the target data corresponding to each preset audit field in the order center platform, the first group of the target data is supposed to be missing from the order center platform, and when the first group of the target data of the order center platform is audited, the result is inconsistent because the data corresponding to the first group of the target data of the order center platform cannot be found in the order center platform.
3) Auditing the target data corresponding to each preset auditing field in the single platform and the target data corresponding to each preset auditing field of the order acceptance platform:
the target data corresponding to each preset audit field in the order platform comprises 3 target data, namely a first group of target data of the order platform, a second group of target data of the order platform and a third group of target data of the order platform, and specifically:
first set of target data for a call-in platform: the order number is 000001, the mobile phone number is 150 XXXXXXXX, and the payment amount is 100 yuan;
a second set of target data for the order platform: the order number is 000002, the mobile phone number is 136, the payment amount is 50 yuan;
third set of target data for the order platform: the order number is 000003, the mobile phone number is 187, the payment amount is 30 yuan;
at this time, the target data corresponding to each preset audit field of the order receiving platform includes 3 target data, which are respectively a first group of target data of the order receiving platform, a second group of target data of the order receiving platform, and a third group of target data of the order receiving platform, specifically:
a first set of target data for the order acceptance platform: the order number is 000001, the mobile phone number is 150 XXXXXX, and the amount is 100 yuan;
a second set of target data for the order acceptance platform: the order number is 000002, the mobile phone number is 136, the mobile phone number is 50 yuan;
third set of target data for order acceptance platform: the order number is 000003, the mobile phone number is 187, the amount is 20 yuan;
at this time, the first group of target data of the order receiving platform and the first group of target data of the order receiving platform are checked, the result is consistent, the second group of target data of the order receiving platform and the second group of target data of the order receiving platform are checked, the result is consistent, when the third group of target data of the order receiving platform and the third group of target data of the order receiving platform are checked, the payment amount corresponding to the order number 000003 in the third group of target data of the order receiving platform is 30 yuan, and the payment amount corresponding to the order number 000003 in the third group of target data of the order receiving platform is 20 yuan, the result is inconsistent, thereby generating a checking result, and when a user checks the checking result, the third group of target data of the order receiving platform and the third group of target data of the order receiving platform can be visually seen, and then the subsequent checking and other processes can be performed;
it can be understood that when the number of the groups of the target data corresponding to each preset audit field in the order receiving platform is different from the number of the groups of the target data corresponding to each preset audit field in the order receiving platform, the order receiving platform is assumed to miss the first group of target data, and when the first group of target data of the order receiving platform is subjected to audit, the result is inconsistent because the data corresponding to the first group of target data of the order receiving platform cannot be found in the order receiving platform.
4) Auditing the target data corresponding to each preset auditing field in the payment center platform and the target data corresponding to each preset auditing field of the order center platform, wherein the specific data auditing process is referred to above and will not be described in detail herein;
5) Auditing the target data corresponding to each preset auditing field in the payment center platform and the target data corresponding to each preset auditing field of the order acceptance platform, wherein the specific data auditing process is referred to above and is not described in detail herein;
6) The target data corresponding to each preset auditing field in the order center platform and the target data corresponding to each preset auditing field of the order acceptance platform are audited, and the detailed data auditing process is referred to above and will not be described in detail herein;
it can be understood that the preset auditing flow mode can be adjusted according to actual conditions, and details are omitted herein, and the data auditing method of the application realizes end-to-end, i.e. platform-to-platform business level data auditing, effectively reduces the workload of manual accounting of financial staff, and reduces the risk of enterprise income loss.
It can be understood that, by timing tasks, data of each platform can be periodically collected and data auditing can be performed in the above manner, so that:
1) Marking the target data which is subjected to data auditing of each platform, and not auditing the target data which is subjected to data auditing in the next period;
2) A folder may be provided for each cycle for storing the audit result.
Preferably, in the above technical solution, S2 includes:
s20, auditing the target data corresponding to any preset auditing field of any platform with the target data of the target platform corresponding to the platform, if the target data is consistent, normally marking the target data corresponding to the preset auditing field of the platform in the auditing result, and if the target data is inconsistent, abnormally marking the target data corresponding to the preset auditing field of the platform in the auditing result, wherein the target platform corresponding to the platform is obtained according to the preset auditing flow mode until the target data corresponding to each preset auditing field of each platform is audited.
And the normal marking or the abnormal marking is carried out on the auditing result, so that the user can visually check the auditing result.
For example, when the preset auditing flow pattern is: when target data corresponding to each preset auditing field in the single platform and target data corresponding to each preset auditing field of the payment center platform are audited and the first group of target data of the single platform is audited, the target platform corresponding to the single platform is obtained to be the payment center platform according to a preset auditing flow mode, and then:
auditing the first group of target data of the order center platform and the first group of target data of the order center platform, if the first group of target data of the order center platform and the first group of target data of the order center platform are consistent, carrying out normal marking on the first group of target data of the order center platform, wherein the first group of target data of the order center platform can be marked with marks such as ' V ', ' 1 ', Y ', and the like, and can be also marked with colors such as green or blue, wherein Y is an abbreviation of YES and represents normal;
for example, when the preset auditing flow pattern is: when auditing the target data corresponding to each preset auditing field in the future bill platform and the target data corresponding to each preset auditing field of the order acceptance platform and auditing the third group of target data of the coming bill platform, obtaining the target platform corresponding to the coming bill platform as an order center platform according to a preset auditing flow mode, and then:
when the third group of target data of the order center platform and the third group of target data of the order center platform are subjected to auditing, as the payment amount corresponding to the order number 000003 in the third group of target data of the order center platform is 30 yuan, and the payment amount corresponding to the order number 000003 in the third group of target data of the order center platform is 20 yuan, the third group of target data of the order center platform and the third group of target data of the order center platform are inconsistent, and the third group of target data of the order center platform are subjected to abnormal marking, such as available marking signs of 'x', '0', or 'N', and the like, and also can be subjected to abnormal marking with colors of red, gray, and the like, so that a user can conveniently and intuitively observe, wherein N is an abbreviation of NO, and represents abnormality.
Preferably, in the above technical solution, after obtaining the target data corresponding to each preset audit field of each platform from the data obtained after the parsing, the method further includes: and storing the target data corresponding to each preset auditing field of each platform into an auditing summary table.
The target data corresponding to each preset audit field of each platform is stored in the audit summary table, so that a user can check whether the data which is normally marked or abnormally marked in the audit result is correct or not by checking the audit summary table later.
Preferably, in the above technical solution, the method further includes: and the auditing result is displayed to the user, so that the user can visually check the auditing result more conveniently.
The auditing result can be stored in the forms of excel forms, word documents and the like, so that the user can visually check the auditing result conveniently.
It can be understood that the auditing result can be inserted into the auditing summary table, so that the user can check and verify the auditing result only through the auditing summary table.
The auditing summary table and the auditing result can be stored in the database so as to carry out subsequent verification.
As shown in fig. 2, a data auditing system 200 according to an embodiment of the present invention includes an parsing acquisition module 210 and a data auditing module 220;
the parsing obtaining module 210 is configured to parse the data sent by each platform of the enterprise, and obtain target data corresponding to each preset audit field of each platform from the parsed data;
the data auditing module 220 is configured to audit the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode, so as to obtain an auditing result.
The analysis and acquisition module 210 analyzes the data sent by each platform of the enterprise to acquire the target data corresponding to each preset auditing field of each platform, and the data auditing module 220 performs auditing on the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode, so that whether the data between each platform are balanced can be accurately determined, and the data auditing efficiency is improved.
Preferably, in the above technical solution, the data auditing module 220 is specifically configured to:
and auditing the target data corresponding to any preset audit field of any platform with the target data of the target platform corresponding to the platform, if the target data is consistent, normally marking the target data label corresponding to the preset audit field of the platform in the audit result, and if the target data label is inconsistent, abnormally marking the target data label corresponding to the preset audit field of the platform in the audit result, wherein the target platform corresponding to the platform is obtained according to the preset audit flow mode until the target data corresponding to each preset audit field of each platform is audited.
And the normal marking or the abnormal marking is carried out on the auditing result, so that the user can visually check the auditing result.
Preferably, in the above technical solution, the system further includes a storage module, where the storage module is configured to store target data corresponding to each preset audit field of each platform into an audit summary table.
The target data corresponding to each preset audit field of each platform is stored in the audit summary table, so that a user can check whether the data which is normally marked or abnormally marked in the audit result is correct or not by checking the audit summary table later.
Preferably, in the above technical solution, the system further includes a display module, where the display module is configured to display the auditing result to a user, so that the user can more conveniently and intuitively view the auditing result.
The above steps for implementing corresponding functions by each parameter and each unit module in the data auditing system 200 according to the present invention may refer to each parameter and each step in the embodiment of a data auditing method according to the present invention, which are not described herein.
As shown in fig. 3, an electronic device 300 according to an embodiment of the present invention includes a memory 310, a processor 320, and a program 330 stored in the memory 310 and running on the processor 320, where the processor 320 implements the steps of any one of the above-implemented data auditing methods when executing the program 330.
Firstly, analyzing data sent by each platform of an enterprise to obtain target data corresponding to each preset auditing field of each platform, and then auditing the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode, so that whether the data between each platform are balanced or not can be accurately determined, and the data auditing efficiency is improved.
The electronic device 300 may be a computer, a mobile phone, or the like, and the program 330 is a computer software or a mobile phone APP, and the parameters and steps in the above embodiment of the data auditing method of the present invention may be referred to for details.
In the present disclosure, the terms "first," "second," and "second" are used for descriptive purposes only and are not to be construed as indicating or implying a relative importance or implying a number of technical features being indicated. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include at least one such feature. In the description of the present invention, the meaning of "plurality" means at least two, for example, two, three, etc., unless specifically defined otherwise.
In the description of the present specification, a description referring to terms "one embodiment," "some embodiments," "examples," "specific examples," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present invention. In this specification, schematic representations of the above terms are not necessarily directed to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, the different embodiments or examples described in this specification and the features of the different embodiments or examples may be combined and combined by those skilled in the art without contradiction.
While embodiments of the present invention have been shown and described above, it will be understood that the above embodiments are illustrative and not to be construed as limiting the invention, and that variations, modifications, alternatives and variations may be made to the above embodiments by one of ordinary skill in the art within the scope of the invention.
Claims (3)
1. A method of auditing data, comprising:
analyzing the data sent by each platform of the enterprise, and acquiring target data corresponding to each preset auditing field of each platform from the analyzed data;
according to a preset auditing flow mode, auditing the target data corresponding to each preset auditing field of each platform to obtain an auditing result;
the auditing the target data corresponding to each preset auditing field of each platform according to the preset auditing flow mode comprises the following steps: auditing target data corresponding to any preset audit field of any platform with target data of a target platform corresponding to the platform, if the target data is consistent, normally marking the target data mark corresponding to the preset audit field of the platform in the audit result, if the target data is inconsistent, abnormally marking the target data mark corresponding to the preset audit field of the platform in the audit result, wherein the target platform corresponding to the platform is obtained according to the preset audit flow mode until the target data corresponding to each preset audit field of each platform is audited, and particularly, normally marking and abnormally marking the target data mark through different marking symbols and different colors;
periodically collecting data of each platform and carrying out data auditing through a timing task, marking the target data of each platform after completing data auditing, not auditing the target data after completing data auditing in the next period, and setting a folder for each period to store auditing results of each period;
after the target data corresponding to each preset audit field of each platform is obtained from the data obtained after the analysis, the method further comprises the following steps: storing target data corresponding to each preset auditing field of each platform into an auditing summary table;
further comprises: displaying the auditing result to a user;
further comprises: inserting the auditing result into an auditing summary table.
2. The data auditing system is characterized by comprising an analysis acquisition module and a data auditing module;
the analysis acquisition module is used for analyzing the data sent by each platform of the enterprise and acquiring target data corresponding to each preset audit field of each platform from the analyzed data;
the data auditing module is used for auditing the target data corresponding to each preset auditing field of each platform according to a preset auditing flow mode to obtain an auditing result;
the data auditing module is specifically used for:
auditing target data corresponding to any preset audit field of any platform with target data of a target platform corresponding to the platform, if the target data is consistent, normally marking the target data mark corresponding to the preset audit field of the platform in the audit result, if the target data is inconsistent, abnormally marking the target data mark corresponding to the preset audit field of the platform in the audit result, wherein the target platform corresponding to the platform is obtained according to the preset audit flow mode until the target data corresponding to each preset audit field of each platform is audited, and particularly, normally marking and abnormally marking the target data mark through different marking symbols and different colors;
the storage module is used for storing target data corresponding to each preset auditing field of each platform into an auditing summary table;
the auditing module is used for displaying the auditing result to a user;
further comprises: inserting the auditing result into an auditing summary table.
3. An electronic device comprising a memory, a processor and a program stored on the memory and running on the processor, wherein the processor performs the steps of a data auditing method according to claim 1 when the program is executed by the processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010730191.2A CN111831698B (en) | 2020-07-27 | 2020-07-27 | Data auditing method, system and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010730191.2A CN111831698B (en) | 2020-07-27 | 2020-07-27 | Data auditing method, system and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111831698A CN111831698A (en) | 2020-10-27 |
| CN111831698B true CN111831698B (en) | 2024-02-06 |
Family
ID=72925477
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010730191.2A Active CN111831698B (en) | 2020-07-27 | 2020-07-27 | Data auditing method, system and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111831698B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115982665B (en) * | 2023-03-21 | 2023-07-14 | 北京东华博泰科技有限公司 | Quality anomaly auditing method and system for water turbine measurement data |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102111920A (en) * | 2009-12-23 | 2011-06-29 | 大唐移动通信设备有限公司 | Method and device for managing performance report |
| CN102609461A (en) * | 2012-01-13 | 2012-07-25 | 广州从兴电子开发有限公司 | Method and system for list audit |
| JP2016206691A (en) * | 2014-07-24 | 2016-12-08 | 株式会社プロスパークリエイティブ | Image inspection apparatus and image inspection program |
| CN106971002A (en) * | 2017-04-18 | 2017-07-21 | 北京思特奇信息技术股份有限公司 | A kind of data auditing method and system |
| CN108830705A (en) * | 2018-04-09 | 2018-11-16 | 阿里巴巴集团控股有限公司 | A kind of method of summary of transaction data, device and equipment |
| CN109408489A (en) * | 2018-09-20 | 2019-03-01 | 中国联合网络通信集团有限公司 | Data auditing method and system |
| CN110543483A (en) * | 2019-08-30 | 2019-12-06 | 北京百分点信息科技有限公司 | Data auditing method and device and electronic equipment |
-
2020
- 2020-07-27 CN CN202010730191.2A patent/CN111831698B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102111920A (en) * | 2009-12-23 | 2011-06-29 | 大唐移动通信设备有限公司 | Method and device for managing performance report |
| CN102609461A (en) * | 2012-01-13 | 2012-07-25 | 广州从兴电子开发有限公司 | Method and system for list audit |
| JP2016206691A (en) * | 2014-07-24 | 2016-12-08 | 株式会社プロスパークリエイティブ | Image inspection apparatus and image inspection program |
| CN106971002A (en) * | 2017-04-18 | 2017-07-21 | 北京思特奇信息技术股份有限公司 | A kind of data auditing method and system |
| CN108830705A (en) * | 2018-04-09 | 2018-11-16 | 阿里巴巴集团控股有限公司 | A kind of method of summary of transaction data, device and equipment |
| CN109408489A (en) * | 2018-09-20 | 2019-03-01 | 中国联合网络通信集团有限公司 | Data auditing method and system |
| CN110543483A (en) * | 2019-08-30 | 2019-12-06 | 北京百分点信息科技有限公司 | Data auditing method and device and electronic equipment |
Non-Patent Citations (2)
| Title |
|---|
| Discovering irregular periodic patterns in audit data;Janusz R.Getta;《2016 IEEE international conference on computer and communications》;第1-2页 * |
| 轨道检测数据集成存储与数据质量评价;陶凯 等;《铁道建筑》;第59卷(第9期);第116-120页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111831698A (en) | 2020-10-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107689887B (en) | Temporary control change online management system of nuclear power plant control system | |
| CN109871309B (en) | Method and system for generating test case of charging system | |
| CN106971002A (en) | A kind of data auditing method and system | |
| CN104994219B (en) | A kind of data processing method and system | |
| CN108509344B (en) | Daily cutting batch test method, equipment and readable storage medium | |
| CN111966738B (en) | System for automatically realizing back-end programming by selecting front-end configuration | |
| CN112286806A (en) | Automatic testing method and device, storage medium and electronic equipment | |
| CN111831698B (en) | Data auditing method, system and electronic equipment | |
| CN109144801A (en) | It is a kind of to be directed to the test method of MOC card, device and equipment in server | |
| US8185455B2 (en) | Auditing system with interactive rule construction user interface | |
| CN111768013B (en) | Commercial bank public account comprehensive management system and method | |
| CN104994220B (en) | A kind of data processing method and system | |
| CN111400187B (en) | Parameter dynamic verification system and method based on customized data source | |
| CN108763081A (en) | A kind of data library test method and its device, computer readable storage medium | |
| CN104504491A (en) | Meter reading control method and system | |
| CN108830549A (en) | Attendance management method, apparatus, computer readable storage medium and system | |
| CN115481116A (en) | Data quality inspection method and device | |
| CN111639478B (en) | Automatic data auditing method and system based on EXCEL document | |
| CN114356781A (en) | Software function testing method and device | |
| US7516048B2 (en) | Externalized metric calculation engine | |
| CN110807037B (en) | Data modification method and device, electronic equipment and storage medium | |
| CN107622381A (en) | Record workpoints account checking method and device | |
| CN112632247A (en) | Method and device for detecting man-hour report, computer equipment and storage medium | |
| CN112016093A (en) | Method for vulnerability marking | |
| CN112634003A (en) | Method for generating financial record from user actual operation data based on network |
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 |