CN115438637A - Data verification method and device, electronic equipment and storage medium - Google Patents
Data verification method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN115438637A CN115438637A CN202211003005.0A CN202211003005A CN115438637A CN 115438637 A CN115438637 A CN 115438637A CN 202211003005 A CN202211003005 A CN 202211003005A CN 115438637 A CN115438637 A CN 115438637A
- Authority
- CN
- China
- Prior art keywords
- target
- checking
- formula
- audit
- 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.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Stored Programmes (AREA)
Abstract
The application discloses a data checking method, a device, electronic equipment and a storage medium, wherein a check parameter table is established in advance, each check formula for data checking is recorded in the check parameter table, when data checking is carried out on target data records, each target check formula corresponding to the target data records is determined from the check parameter table, then the service values of all parameters of each target check formula are obtained from the target data records according to each target check formula, and the checking of the target data records is completed according to each target check formula and the service values of all parameters. According to the scheme provided by the application, the audit parameter table is determined in advance, the audit formula of the audit parameter table and the service numerical values of all parameters in the data records are combined, data audit is completed, an independent audit module does not need to be arranged for each data report, and the problem that the content of repetition and redundancy among the audit modules is large is solved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a data verification method and apparatus, an electronic device, and a storage medium.
Background
The check and verification of the spare payment information is a key work. The non-bank payment mechanism can select a supervising mechanism to carry out data checking and verification on a series of reports. The dimension of the report is more, and the report is divided into a detailed statement of the cash-out service, a detailed statement of the cash-in service, a statistical statement of the transfer service, a statistical statement of account balance and the like according to the type of the report; according to the report stage, there are a stage initial report, a stage intermediate report, etc. With the development of various services of the pay-by-payment, the dimensionality of the verification report is gradually increased, the complexity is enhanced, and higher requirements are provided for a data verification scheme.
In the prior art, when data verification is performed, a method for performing data verification by using each report is adopted. Each report is provided with an independent verification module, and a matched input data source and an output result. And the verification module calculates according to the input data source and the verification rule to obtain a verification conclusion, and then stores the conclusion as the output of the verification module for later use.
The problem existing in the prior art is that each report is provided with an independent checking module, and the contents of repetition and redundancy among the checking modules are more.
Disclosure of Invention
The embodiment of the application provides a data verification method and device, electronic equipment and a storage medium, and aims to solve the problem that in the prior art, the content of repetition and redundancy among verification modules is more.
The application provides a data verification method, which comprises the following steps:
acquiring a target data record to be checked and a predetermined checking parameter table;
determining each target audit formula corresponding to the target data record in the audit parameter table;
and acquiring the service values of all parameters of each target checking formula based on the target data records, and checking the target data records according to the target checking formulas and the service values of all parameters.
Further, the acquiring the target data record to be verified includes:
and performing data integration on each data report to obtain an integrated data table, and acquiring a target data record to be checked based on the integrated data table.
Further, the process of determining the audit parameter list comprises:
and determining the audit checking parameter table according to the integrated data table, and establishing the corresponding relation between each audit checking formula and the data attribute mechanism in the audit checking parameter table.
Further, the determining each target audit formula corresponding to the target data record in the audit parameter table comprises:
and determining a target data attribute mechanism of the target data record, and determining each target checking formula corresponding to the target data attribute mechanism according to the corresponding relation between each checking formula and the data attribute mechanism.
Further, the obtaining of the parameters of each target audit formula includes:
and aiming at each target checking formula, acquiring a formula configuration table, a subentry configuration table and an inspection algorithm table of the target checking formula, and determining each parameter of the target checking formula according to the formula configuration table, the subentry configuration table and the inspection algorithm table.
Further, the obtaining the service values of the parameters of the target audit formulas based on the target data records includes:
and analyzing each sub item in the sub item configuration table, and acquiring the service numerical value of each parameter corresponding to each sub item from the target data record.
Further, the verifying the target data records according to the target check formulas and the service values of the parameters includes:
analyzing the checking algorithm table, determining each algorithm step of each target checking formula, and bringing the service numerical values of each parameter corresponding to each sub-item into each algorithm step of the corresponding target checking formula to obtain the checking result of the target data record.
In another aspect, the present application provides a data verification apparatus, the apparatus comprising:
the acquisition module is used for acquiring a target data record to be checked and a predetermined checking parameter table;
the determining module is used for determining each target audit formula corresponding to the target data record in the audit parameter table;
and the checking module is used for acquiring the service values of all the parameters of each target checking formula based on the target data records, and checking the target data records according to the target checking formulas and the service values of all the parameters.
The acquisition module is specifically used for integrating data of each data report to obtain an integrated data table, and acquiring a target data record to be checked based on the integrated data table.
The acquisition module is further used for determining the audit parameter table according to the integrated data table and establishing the corresponding relation between each audit formula and the data attribute mechanism in the audit parameter table.
The determining module is specifically configured to determine a target data attribute mechanism of the target data record, and determine each target checking formula corresponding to the target data attribute mechanism according to a corresponding relationship between each checking formula and the data attribute mechanism.
The checking module is specifically configured to obtain a formula configuration table, a sub-item configuration table and a checking algorithm table of the target checking formula for each target checking formula, and determine each parameter of the target checking formula according to the formula configuration table, the sub-item configuration table and the checking algorithm table.
The verification module is specifically configured to analyze each sub-item in the sub-item configuration table, and obtain a service value of each parameter corresponding to each sub-item from the target data record.
The verification module is specifically configured to parse the verification algorithm table, determine each algorithm step of each target checking formula, and bring the service numerical values of each parameter corresponding to each sub-item into each algorithm step of the corresponding target checking formula, so as to obtain a verification result recorded by the target data.
In another aspect, the present application provides an electronic device, including a processor, a communication interface, a memory and a communication bus, where the processor, the communication interface and the memory complete communication with each other through the communication bus;
a memory for storing a computer program;
a processor for implementing any of the above method steps when executing a program stored in the memory.
In another aspect, the present application provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the method steps of any of the above.
The application provides a data verification method, a data verification device, electronic equipment and a storage medium, wherein the method comprises the following steps: acquiring a target data record to be checked and a predetermined checking parameter table; determining each target audit formula corresponding to the target data record in the audit parameter table; and acquiring the service values of all parameters of each target checking formula based on the target data records, and checking the target data records according to the target checking formulas and the service values of all parameters.
The technical scheme has the following advantages or beneficial effects:
in the application, a check parameter table is established in advance, each check formula for data checking is recorded in the check parameter table, when data checking is carried out on target data records, each target check formula corresponding to the target data records is determined from the check parameter table, then the service values of all parameters of each target check formula are obtained from the target data records according to each target check formula, and the checking of the target data records is completed according to each target check formula and the service values of all parameters. According to the scheme provided by the application, the checking parameter table is determined in advance, the data check is completed by combining the checking formula of the checking parameter table and the service numerical values of all parameters in the data records, an independent check module does not need to be arranged for each data report, and the problems of more repeated and redundant contents among the check modules are solved.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings without creative efforts.
FIG. 1 is a schematic diagram of a data verification process provided herein;
FIG. 2 is a diagram of a data verification system architecture as provided herein;
FIG. 3 is a schematic diagram of another data verification process provided herein;
FIG. 4 is a schematic structural diagram of a data verification device provided in the present application;
fig. 5 is a schematic structural diagram of an electronic device provided in the present application.
Detailed Description
The present application will now be described more fully hereinafter with reference to the accompanying drawings, in which some, but not all embodiments of the invention are shown. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
Fig. 1 is a schematic diagram of a data verification process provided in the present application, where the process includes the following steps:
s101: and acquiring a target data record to be checked and a predetermined checking parameter table.
S102: and determining each target audit formula corresponding to the target data record in the audit parameter table.
S103: and acquiring the service values of all parameters of each target checking formula based on the target data records, and checking the target data records according to the target checking formulas and the service values of all parameters.
The data verification method is applied to electronic equipment, and the electronic equipment can be equipment such as a PC (personal computer), a tablet personal computer and the like, and can also be a server.
The electronic equipment determines a checking parameter table in advance, wherein the checking parameter table can be obtained according to each data report form in the data report form set, checking relations in each data report form are obtained by analyzing each data report form, the checking parameter table is determined according to the checking relations in each data report form, and each checking parameter table comprises each checking formula.
The data report set comprises dozens of data reports, each report corresponds to one service type, and a plurality of checking formulas are arranged in the reports. For an organization, the audit formulas do not participate in all audit formulas, so that the application establishes the corresponding relation between each audit formula and the data attribute organization in the audit parameter table, and determines the audit formulas participating in data audit according to the corresponding relation.
The electronic equipment acquires a target data record to be checked and a predetermined checking parameter table. When the target data record to be checked is obtained, data integration is carried out on each data report in the data report set in advance to obtain an integrated data table, and the target data record to be checked is obtained based on the integrated data table. When the audit parameter table is determined, the audit parameter table can be determined according to the integrated data table, and the corresponding relation between each audit formula and the data attribute mechanism in the audit parameter table is established.
After the electronic equipment acquires the target data records to be checked and the predetermined audit parameter table, determining each target audit formula corresponding to the target data records in the audit parameter table. Wherein, determining each target audit formula corresponding to the target data record in the audit parameter table comprises: and determining a target data attribute mechanism of the target data record, and determining each target checking formula corresponding to the target data attribute mechanism according to the corresponding relation between each checking formula and the data attribute mechanism.
The electronic equipment acquires a target data record to be checked, determines a target data attribute mechanism of the target data record to be checked according to an attribute mechanism field in the target data record to be checked, and then determines each checking formula corresponding to the target data attribute mechanism as a target checking formula according to the corresponding relation between each checking formula and the data attribute mechanism.
And acquiring the service values of all parameters of each target checking formula based on the target data records. Firstly, aiming at each target check formula, determining each parameter of the target check formula, and then acquiring the service value of each parameter from the target data record. And checking the target data records according to each target checking formula and the service values of each parameter, wherein the service values of each parameter can be brought into the corresponding target checking formula to obtain a final data checking result.
In the application, an audit parameter table is established in advance, audit formulas for data audit are recorded in the audit parameter table, when data audit is performed on target data records, the audit formulas corresponding to the target data records are determined from the audit parameter table, then service values of all parameters of the target audit formulas are obtained from the target data records according to the target audit formulas, and the audit of the target data records is completed according to the target audit formulas and the service values of all parameters. According to the scheme provided by the application, the checking parameter table is determined in advance, the data check is completed by combining the checking formula of the checking parameter table and the service numerical values of all parameters in the data records, an independent check module does not need to be arranged for each data report, and the problems of more repeated and redundant contents among the check modules are solved.
In the application, all data reports maintain one audit parameter table, when data audit is performed, after target data records to be audited are obtained, all target audit formulas corresponding to the target data records are obtained from the audit parameter table, then all the target audit formulas and service values of all parameters are obtained according to data in the target data records, and the target data records are audited according to all the target audit formulas and the service values of all parameters. When a new data report appears, the audit parameter table is maintained according to the new data report, when the new data report needs to be checked, the audit formula corresponding to the new data report is determined according to the audit parameter table after maintenance, the service values of all parameters of the audit formula are obtained from the new data report, and then the data check of the new data report is completed. Therefore, a verification module does not need to be added for a new data report, and the data verification period is reduced.
In this application, obtaining the parameters of each target checking formula includes:
and aiming at each target checking formula, acquiring a formula configuration table, a subentry configuration table and an inspection algorithm table of the target checking formula, and determining each parameter of the target checking formula according to the formula configuration table, the subentry configuration table and the inspection algorithm table.
The following describes the formula configuration table, the sub-item configuration table, and the verification algorithm table by way of example.
The formula configuration table formula is divided into two types, one type is subjected to summary calculation and is used for secondary verification; one is to perform a verification check. For example: m03= Sigma L14-Sigma L16 belongs to the summary calculation class, and Sigma L14 represents the sum of L14 of each channel; day D01= day D06 before, belonging to the category of the verification. The formula configuration table is used to describe the attributes of the check formula, taking the check formula M03= Σ L14- Σ L16 (hereinafter, abbreviated as formula 1001) as an example, and the formula configuration table is:
wherein, formula type field, 0 represents summary calculation class, and 1 represents verification class.
Sub item configuration table: each check formula is composed of a plurality of sub-items, and the sub-items are provided with business attributes. The sub-item configuration table is used for configuring all attributes of each sub-item in the audit formula, and after the sub-item configuration table is analyzed, target data records used for verification can be found from the integrated data table. Take M03 of formula 1001 and L14 of the verification channel as examples:
| chinese data name | Data name | M03 sub-item | Networking L14 subentry |
| Formula number | formula_sn | 1001 | 1001 |
| Sub-item number | item_seq | 1 | 2 |
| Sub item name | item_nm | M03 | L14 |
| Verification channel | check_chnl | 01 | 02 |
| Type of service | buss_tp | M | L |
| Amount serial number | amt_seq | 03 | 14 |
| Rules of day | date_rule | 00 | 00 |
| Whether to retain results | save_flag | 1 | 0 |
| Retention of attributes | resv_flag |
Wherein, the channel field is verified, 01 represents the first type of channel, and 02 represents the second type of channel. Date rule field, 00 denotes the data of the current day. The credit result field is reserved, 1 indicates yes, and 0 indicates no.
Checking algorithm table: the method comprises the steps of splitting a check formula into a plurality of steps, wherein each step can support four arithmetic operations, logic operations and the like, and the final calculation result of the plurality of steps is the operation result of the check formula. Taking the check formula 1001 as an example, assume that M03= Σ L14- Σ L16 channels are 01, 02. The check formula 1001 is expanded to M03= L14 (01 channel) + L14 (02 channel) -L16 (01 channel) -L16 (02 channel), and the expanded check formula has 5 sub-items, assuming that the sub-item numbers are 1,2,3,4,5 in sequence from left to right. Therefore, equation 1001 can be broken down into the following steps:
| sequence number of step | Content of step | Temporary output sequence number |
| 1 | L14 (channel 01) + L14 (channel 02) | Subentry 6 |
| 2 | Subentry 6-L16 (01 channel) | Subentry 7 |
| 3 | Subentry 7-L16 (02 channel) | Sub item 1 |
Sub-term 6 and sub-term 7 belong to intermediate results in the operation process. Step 1 translates into a parameter description, namely: sub-entry 6= sub-entry 2+ sub-entry 3. Step 2 translates into a parameter description, namely: sub-entry 7= sub-entry 6-sub-entry 4. Step 3 translates into a parameter description, namely: sub-entry 1= sub-entry 7-sub-entry 5.
And the sub-item 1 is the final output result. The checklist can be configured (operator 2 and operand 3 are all filled with 0, so they are not listed):
| formula number | Sequence number of step | Result of operation | Operand 1 | Operator 1 | Operand 2 |
| 1001 | 1 | -6 | -2 | + | -3 |
| 1001 | 2 | -7 | -6 | - | -4 |
| 1001 | 3 | -1 | -7 | - | -5 |
The filling rules of the operation result, operand 1 and operand 2 are as follows: negative numbers represent sub-items, i.e., -6 represents sub-item 6; an operand is a positive number, indicating a specific value, and logical operations, constant calculations, etc. involving values are used for this function.
Examples of logical operations are illustrated. Assume check formula 1002: b01= (a 01>0.5 × a 02)? A01:0.5 × a02, i.e., B01 takes the larger of a01 and 0.5 × a 02. Assuming that B01, A02 are subentry 1, subentry 2, and subentry 3, respectively, equation 1002 can be broken down into the following steps:
| sequence number of step | Content of step | Temporary output sequence number |
| 1 | A02*0.5 | Sub item 4 |
| 2 | Greater value of A01 and sub-term 4 | Sub item 1 |
Where sub-term 4 is an intermediate result in the operation. Step 1 translates into a parameter description, namely: sub-entry 4= sub-entry 3 × 0.5. Step 2 translates into a parameter description, namely: sub-term 1= the larger of sub-term 2 and sub-term 4. Step 3 translates into a parameter description, namely: sub-entry 1= sub-entry 7-sub-entry 5.
And the sub-item 1 is the final output result. The checklist can be configured (operator 2 and operand 3 are all filled with 0, so they are not listed):
| formula number | Sequence number of step | Result of operation | Operand 1 | Operator 1 | Operand 2 |
| 1002 | 1 | -4 | -3 | * | 0.5 |
| 1002 | 2 | -1 | -2 | > | -4 |
By the above example, it can be found that, when the parameters of each target checking formula are obtained, the parameters are obtained according to the formula configuration table, the sub-item configuration table and the verification algorithm table of each target checking formula. Acquiring the service values of all parameters of each target audit formula based on the target data records comprises the following steps: and analyzing each sub item in the sub item configuration table, and acquiring the service numerical value of each parameter corresponding to each sub item from the target data record. After the sub-item configuration table is analyzed, the verification channel, the service type, the money amount serial number and the date rule of each sub-item are obtained, and the affiliated organization code is added, so that the actual service numerical value can be found in the integrated data table.
According to the target audit formulas and the service values of the parameters, the verification of the target data records comprises the following steps: analyzing the checking algorithm table, determining each algorithm step of each target checking formula, and bringing the service numerical values of each parameter corresponding to each sub-item into each algorithm step of the corresponding target checking formula to obtain the checking result of the target data record.
Fig. 2 is an architecture diagram of the data verification system provided in the present application, and as shown in fig. 2, includes a unified input module 11, a relationship verification module 22, and a unified output module 33.
And checking a frame based on the checking relation of the parameter configuration. The whole checking process of the checking relationship is abstracted into three modules: the system comprises a unified input module, a relation verification module and a unified output module. The unified input module is used for integrating data, extracting and converting the data in various formats and putting the data into an integrated data table. The relation checking module analyzes the contents in the check parameter table based on the parameterized configuration to obtain a checking result. And the unified output module stores the verification result data according to each dimension and provides data support for a module for subsequently generating a service result.
A parameterized audit formula checks the verification scheme. Designing a formula matching table, a formula configuration table and a sub-item configuration table for describing the check formula; and designing a check algorithm table for describing the algorithm. And analyzing the 4 parameter tables at the relation checking module, and carrying out formula checking by combining input data to obtain a checking result.
The unified input module is used for integrating data, various data reports are input in actual service, the unified input module analyzes and refines various source data, and the source data are stored in the integrated data table by taking the dimensions such as organization codes, verification dates, verification channels, service types and the like as main keys, and each piece of data (the minimum subdivision dimension) has a plurality of numerical values and corresponds to the actual service data of the piece of data.
The relationship verification module is responsible for calculation and has two types of input: integrating the service data in the data table, and configuring the audit formula and the audit algorithm in the audit parameter table. Analyzing the parameters of each mechanism participating in the verification to obtain a check formula and an algorithm needing verification; and then the data in the integrated data table is nested in the audit formula for calculation to obtain a result.
And the unified output module processes the calculation result of the relation checking module. For the intermediate data needing secondary verification, writing the intermediate data back to the unified input module; and writing the generated actual output result into the unified output table, and storing the actual output result by taking the organization code, the verification date, the verification channel, the formula number and the like as main keys, wherein each data record corresponds to the verification result of the check formula.
Whether the calculation result of the relation check module is intermediate data is determined according to a formula type (formula _ type) field of the formula configuration table, for example, a formula _ type field of 0 represents that the intermediate data belongs to, and a formula _ type field of 1 represents that the intermediate data does not belong to.
If the formula type format _ type field of a certain formula is 0, it indicates that the output result of the formula is intermediate data and needs to be saved. Taking the 1002 formula (B01 = (a 01>0.5 × a 02). The process is as follows:
the first step is as follows: and extracting the attributes of the B01. For example, the verification date = the current day, the service type = B, the amount of money 01= the calculation result of b01, the organization code = the current organization code, the verification channel = the current verification channel, and so on.
The second step is that: and writing the integrated data table. And splicing the key fields extracted in the first step into a record, and writing the record into an integrated data table.
Formula matching table: the check of the backup payment check relates to dozens of reports, each report corresponds to one service type, and a plurality of check formulas are arranged in the reports. For an organization, the organization does not participate in all check formula check, so the design formula matching table can set organization attributes according to multiple dimensions such as whether the check and the transaction channel are supported, and each type of attribute organization corresponds to a formula bitmap, namely, the check formula set required to be checked by the organization.
Fig. 3 is a schematic diagram of a data verification process provided in the present application, where the process includes the following steps:
s201: and performing data integration on each data report to obtain an integrated data table, and acquiring a target data record to be checked based on the integrated data table.
S202: acquiring a predetermined audit parameter table, wherein the audit parameter table is determined according to the integrated data table, and establishing the corresponding relation between each audit formula in the audit parameter table and the data attribute mechanism.
S203: and determining a target data attribute mechanism of the target data record, and determining each target checking formula corresponding to the target data attribute mechanism according to the corresponding relation between each checking formula and the data attribute mechanism.
S204: and aiming at each target checking formula, acquiring a formula configuration table, a subentry configuration table and an inspection algorithm table of the target checking formula, and determining each parameter of the target checking formula according to the formula configuration table, the subentry configuration table and the inspection algorithm table.
S205: and analyzing each sub item in the sub item configuration table, and acquiring the service numerical value of each parameter corresponding to each sub item from the target data record.
S206: analyzing the checking algorithm table, determining each algorithm step of each target checking formula, and bringing the service numerical values of each parameter corresponding to each sub-item into each algorithm step of the corresponding target checking formula to obtain the checking result of the target data record.
Fig. 4 is a schematic structural diagram of a data verification apparatus provided in the present application, including:
an obtaining module 41, configured to obtain a target data record to be checked and a predetermined checking parameter table;
a determining module 42, configured to determine each target audit formula corresponding to the target data record in the audit parameter table;
and the checking module 43 is configured to obtain the service values of the parameters of each target checking formula based on the target data record, and check the target data record according to the target checking formula and the service values of the parameters.
The obtaining module 41 is specifically configured to perform data integration on each data report to obtain an integrated data table, and obtain a target data record to be verified based on the integrated data table.
The obtaining module 41 is further configured to determine the audit parameter table according to the integrated data table, and establish a corresponding relationship between each audit formula in the audit parameter table and the data attribute mechanism.
The determining module 42 is specifically configured to determine a target data attribute mechanism of the target data record, and determine each target checking formula corresponding to the target data attribute mechanism according to a corresponding relationship between each checking formula and the data attribute mechanism.
The checking module 43 is specifically configured to, for each target checking formula, obtain a formula configuration table, a sub-item configuration table, and a checking algorithm table of the target checking formula, and determine each parameter of the target checking formula according to the formula configuration table, the sub-item configuration table, and the checking algorithm table.
The verification module 43 is specifically configured to analyze each sub-item in the sub-item configuration table, and obtain a service value of each parameter corresponding to each sub-item from the target data record.
The checking module 43 is specifically configured to analyze the checking algorithm table, determine each algorithm step of each target checking formula, and bring the service numerical values of each parameter corresponding to each sub-item into each algorithm step of the corresponding target checking formula, so as to obtain a checking result recorded by the target data.
The present application also provides an electronic device, as shown in fig. 5, including: the system comprises a processor 501, a communication interface 502, a memory 503 and a communication bus 504, wherein the processor 501, the communication interface 502 and the memory 503 are communicated with each other through the communication bus 504;
the memory 503 has stored therein a computer program which, when executed by the processor 501, causes the processor 501 to perform any of the above method steps.
The communication bus mentioned in the electronic device may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The communication bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown, but this is not intended to represent only one bus or type of bus.
The communication interface 502 is used for communication between the above-described electronic apparatus and other apparatuses.
The Memory may include a Random Access Memory (RAM) or a Non-Volatile Memory (NVM), such as at least one disk Memory. Alternatively, the memory may be at least one memory device located remotely from the processor.
The Processor may be a general-purpose Processor, including a central processing unit, a Network Processor (NP), and the like; but may also be a Digital Signal Processor (DSP), an application specific integrated circuit, a field programmable gate array or other programmable logic device, discrete gate or transistor logic, discrete hardware components, or the like.
The present application further provides a computer-readable storage medium having stored therein a computer program executable by an electronic device, the program, when run on the electronic device, causing the electronic device to perform any of the above method steps.
While the preferred embodiments of the present application have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including the preferred embodiment and all changes and modifications that fall within the scope of the present application.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present application without departing from the spirit and scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is intended to include such modifications and variations as well.
Claims (10)
1. A method of data verification, the method comprising:
acquiring a target data record to be checked and a predetermined checking parameter table;
determining each target audit formula corresponding to the target data record in the audit parameter table;
and acquiring the service values of all parameters of each target checking formula based on the target data records, and checking the target data records according to the target checking formulas and the service values of all parameters.
2. The method of claim 1, wherein said obtaining a target data record to be verified comprises:
and integrating the data of each data report to obtain an integrated data table, and acquiring a target data record to be checked based on the integrated data table.
3. The method of claim 2, wherein the determining the audit parameter list comprises:
and determining the checking parameter table according to the integrated data table, and establishing the corresponding relation between each checking formula in the checking parameter table and the data attribute mechanism.
4. The method of claim 3, wherein the determining each target audit formula in the audit parameter table corresponding to the target data record comprises:
and determining a target data attribute mechanism of the target data record, and determining each target checking formula corresponding to the target data attribute mechanism according to the corresponding relation between each checking formula and the data attribute mechanism.
5. The method of claim 1, wherein obtaining parameters of the respective objective audit formulas comprises:
and aiming at each target checking formula, acquiring a formula configuration table, a subentry configuration table and an inspection algorithm table of the target checking formula, and determining each parameter of the target checking formula according to the formula configuration table, the subentry configuration table and the inspection algorithm table.
6. The method as claimed in claim 5, wherein said obtaining the service values of the parameters of the respective target audit formulas based on the target data records comprises:
and analyzing each sub item in the sub item configuration table, and acquiring the service numerical value of each parameter corresponding to each sub item from the target data record.
7. The method of claim 6, wherein the verifying the goal data records according to the goal colluding formulas and the business values of the parameters comprises:
analyzing the checking algorithm table, determining each algorithm step of each target checking formula, and bringing the service numerical values of each parameter corresponding to each sub-item into each algorithm step of the corresponding target checking formula to obtain the checking result of the target data record.
8. A data verification apparatus, the apparatus comprising:
the acquisition module is used for acquiring a target data record to be checked and a predetermined audit parameter table;
the determining module is used for determining each target audit formula corresponding to the target data record in the audit parameter table;
and the checking module is used for acquiring the service values of all the parameters of each target checking formula based on the target data records, and checking the target data records according to the target checking formulas and the service values of all the parameters.
9. The electronic equipment is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor and the communication interface are used for realizing the communication between the processor and the memory through the communication bus;
a memory for storing a computer program;
a processor for implementing the method steps of any one of claims 1 to 7 when executing a program stored in the memory.
10. A computer-readable storage medium, characterized in that a computer program is stored in the computer-readable storage medium, which computer program, when being executed by a processor, carries out the method steps of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211003005.0A CN115438637A (en) | 2022-08-19 | 2022-08-19 | Data verification method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211003005.0A CN115438637A (en) | 2022-08-19 | 2022-08-19 | Data verification method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115438637A true CN115438637A (en) | 2022-12-06 |
Family
ID=84242326
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211003005.0A Pending CN115438637A (en) | 2022-08-19 | 2022-08-19 | Data verification method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115438637A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115983223A (en) * | 2023-03-21 | 2023-04-18 | 中信证券股份有限公司 | Report document auditing method, report document auditing device, electronic equipment and computer readable medium |
-
2022
- 2022-08-19 CN CN202211003005.0A patent/CN115438637A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115983223A (en) * | 2023-03-21 | 2023-04-18 | 中信证券股份有限公司 | Report document auditing method, report document auditing device, electronic equipment and computer readable medium |
| CN115983223B (en) * | 2023-03-21 | 2023-07-18 | 中信证券股份有限公司 | Report document auditing method, report document auditing device, electronic equipment and computer readable medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8768976B2 (en) | Operational-related data computation engine | |
| CN109359277B (en) | Data monitoring method, device and computer storage medium | |
| CN111612040B (en) | Financial data anomaly detection method and related device based on isolated forest algorithm | |
| CN115438637A (en) | Data verification method and device, electronic equipment and storage medium | |
| CN113034046A (en) | Data risk metering method and device, electronic equipment and storage medium | |
| CN114048129A (en) | Automatic testing method, device, equipment and system for software function change | |
| CN112579621A (en) | Data display method and device, electronic equipment and computer storage medium | |
| CN111199308A (en) | Client prediction method and device for different overdue stages and electronic equipment | |
| CN109324963B (en) | Method for automatically testing profit result and terminal equipment | |
| CN112905677A (en) | Data processing method and device, service processing system and computer equipment | |
| CN111400187A (en) | Parameter dynamic verification system and method based on customized data source | |
| CN116346662A (en) | Test message generation method, device, equipment and storage medium | |
| CN114971637A (en) | Risk early warning method, device, equipment and medium | |
| CN114860305A (en) | Data processing method and device | |
| CN112241392A (en) | Intelligent examination and verification method and system for survey data, storage medium and electronic equipment | |
| CN112380321A (en) | Primary and secondary database distribution method based on bill knowledge graph and related equipment | |
| CN113825162A (en) | Method and device for positioning fault reason of telecommunication network | |
| CN112416904A (en) | Electric power data standardization processing method and device | |
| CN111859985A (en) | AI customer service model testing method, device, electronic equipment and storage medium | |
| CN111223000A (en) | Bill processing method and device, computer equipment and storage medium | |
| CN112907009B (en) | Standardized model construction method and device, storage medium and equipment | |
| CN115391438A (en) | Method, device, equipment and storage medium for generating data warehouse configuration document | |
| CN113505077A (en) | Method, device and equipment for testing data table and storage medium | |
| CN117149165A (en) | Service code generation method, device and server | |
| CN118152384A (en) | Data auditing method, device, electronic equipment, storage medium and program product |
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 |