A data verification method and device, electronic equipment and storage medium

Abstract

The application discloses a data verification method and device, electronic equipment and a storage medium. In the application, a verification parameter table is established in advance, and each verification formula used for data verification is recorded in the verification parameter table. When data verification is performed on a target data record, each target verification formula corresponding to the target data record is determined from the verification parameter table, then, according to each target verification formula, a business value of each parameter of each target verification formula is obtained from the target data record, and the verification of the target data record is completed according to each target verification formula and the business value of each parameter. According to the scheme provided in the application, the verification parameter table is determined in advance, the data verification is completed by combining the verification formula of the verification parameter table and the business value of each parameter in the data record, and a separate verification module does not need to be set for each data report, so that the problem that there are more repeated and redundant contents among verification modules is solved.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and in particular to a data verification method, apparatus, electronic device and storage medium. Background Technology

[0002] Verification and validation of reserve fund information is a crucial task. Non-bank payment institutions can choose supervisory bodies to verify and validate a range of reports. These reports are multi-dimensional, categorized by type (e.g., withdrawal details, deposit details, transfer statistics, account balance statistics), and by stage (e.g., initial stage one, intermediate stage one, initial stage two, intermediate stage two). As reserve fund operations evolve, the dimensions and complexity of verification reports continue to increase, placing higher demands on data verification solutions.

[0003] Existing technologies employ a method of verifying data separately for each report. Each report has a dedicated verification module, along with corresponding input data sources and output results. The verification module calculates the verification conclusion based on the input data sources and verification rules, and then saves the conclusion as its output for later use.

[0004] The problem with existing technology is that each report has a separate verification module, resulting in a lot of duplicate and redundant content between the verification modules. Summary of the Invention

[0005] This application provides a data verification method, apparatus, electronic device, and storage medium to solve the problem of excessive duplication and redundancy among verification modules in the prior art.

[0006] This application provides a data verification method, the method comprising:

[0007] Obtain the target data records to be verified and the pre-determined reconciliation parameter table;

[0008] Determine each target reconciliation formula in the reconciliation parameter table that corresponds to the target data record;

[0009] Based on the target data record, the business values ​​of each parameter of each target reconciliation formula are obtained, and the target data record is verified according to the target reconciliation formula and the business values ​​of each parameter.

[0010] Furthermore, the acquisition of the target data record to be verified includes:

[0011] The data from various data reports are integrated to obtain an integrated data table, and the target data records to be verified are obtained based on the integrated data table.

[0012] Furthermore, the process of determining the reconciliation parameter table includes:

[0013] The cross-reference parameter table is determined based on the integrated data table, and the correspondence between each cross-reference formula and the data attribute structure in the cross-reference parameter table is established.

[0014] Further, determining the target reconciliation formulas corresponding to the target data records in the reconciliation parameter table includes:

[0015] The target data attribute structure of the target data record is determined, and the target reconciliation formulas corresponding to the target data attribute structure are determined according to the correspondence between the reconciliation formulas and the data attribute structure.

[0016] Furthermore, obtaining the parameters of each of the target reconciliation formulas includes:

[0017] For each target reconciliation formula, obtain the formula configuration table, sub-item configuration table, and verification algorithm table for that target reconciliation formula, and determine the various parameters of the target reconciliation formula based on the formula configuration table, sub-item configuration table, and verification algorithm table.

[0018] Furthermore, the process of obtaining the business values ​​of each parameter of the various target reconciliation formulas based on the target data records includes:

[0019] Parse each sub-item in the sub-item configuration table and obtain the business values ​​of each parameter corresponding to each sub-item from the target data record.

[0020] Furthermore, the verification of the target data records based on the respective target reconciliation formulas and the business values ​​of the respective parameters includes:

[0021] The verification algorithm table is parsed to determine the algorithm steps of each target reconciliation formula. The business values ​​of each parameter corresponding to each sub-item are substituted into the corresponding algorithm steps of the target reconciliation formula to obtain the verification result of the target data record.

[0022] On the other hand, this application provides a data verification device, the device comprising:

[0023] The acquisition module is used to acquire the target data records to be verified and the pre-determined reconciliation parameter table;

[0024] The determination module is used to determine each target reconciliation formula corresponding to the target data record in the reconciliation parameter table;

[0025] The verification module is used to obtain the business values ​​of each parameter of each target reconciliation formula based on the target data record, and to verify the target data record according to the target reconciliation formula and the business values ​​of each parameter.

[0026] The acquisition module is specifically used to integrate data from various data reports to obtain an integrated data table, and to obtain the target data record to be verified based on the integrated data table.

[0027] The acquisition module is further configured to determine the cross-reference parameter table based on the integrated data table, and establish the correspondence between each cross-reference formula and data attribute structure in the cross-reference parameter table.

[0028] The determining module is specifically used to determine the target data attribute structure of the target data record, and to determine the target reconciliation formulas corresponding to the target data attribute structure based on the correspondence between the reconciliation formulas and the data attribute structure.

[0029] The verification module is specifically used to obtain the formula configuration table, sub-item configuration table and verification algorithm table for each target reconciliation formula, and determine the various parameters of the target reconciliation formula based on the formula configuration table, sub-item configuration table and verification algorithm table.

[0030] The verification module is specifically used to parse each sub-item in the sub-item configuration table and obtain the business values ​​of each parameter corresponding to each sub-item from the target data record.

[0031] The verification module is specifically used to parse the verification algorithm table, determine the algorithm steps of each target reconciliation formula, substitute the business values ​​of each parameter corresponding to each sub-item into the corresponding algorithm steps of the target reconciliation formula, and obtain the verification result of the target data record.

[0032] On the other hand, this application provides an electronic device, including a processor, a communication interface, a memory, and a communication bus, wherein the processor, the communication interface, and the memory communicate with each other through the communication bus;

[0033] Memory, used to store computer programs;

[0034] When a processor executes a program stored in memory, it implements the steps of the method described in any of the preceding statements.

[0035] On the other hand, this application provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the steps of the method described in any of the above claims.

[0036] This application provides a data verification method, apparatus, electronic device, and storage medium. The method includes: acquiring a target data record to be verified and a pre-determined reconciliation parameter table; determining each target reconciliation formula in the reconciliation parameter table corresponding to the target data record; acquiring the business values ​​of each parameter of each target reconciliation formula based on the target data record; and verifying the target data record according to the target reconciliation formula and the business values ​​of each parameter.

[0037] The above technical solution has the following advantages or beneficial effects:

[0038] In this application, a reconciliation parameter table is pre-established, recording various reconciliation formulas used for data verification. When verifying target data records, the corresponding target reconciliation formulas are first determined from the reconciliation parameter table. Then, based on each target reconciliation formula, the business values ​​of each parameter of each target reconciliation formula are obtained from the target data record. The verification of the target data record is completed based on the target reconciliation formulas and the business values ​​of each parameter. The solution provided in this application pre-determines the reconciliation parameter table and completes data verification by combining the reconciliation formulas in the reconciliation parameter table with the business values ​​of each parameter in the data record. This eliminates the need to set up a separate verification module for each data report, solving the problem of excessive duplication and redundancy between verification modules. Attached Figure Description

[0039] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0040] Figure 1 A diagram illustrating the data verification process provided for this application;

[0041] Figure 2 The data verification system architecture diagram provided for this application;

[0042] Figure 3 Another data verification process diagram provided for this application;

[0043] Figure 4 A schematic diagram of the data verification device provided for this application;

[0044] Figure 5 A schematic diagram of the electronic device structure provided in this application. Detailed Implementation

[0045] The present application will now be described in further detail with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present application, and not all embodiments. Based on the embodiments of the present application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present application.

[0046] Figure 1 The data verification process provided for this application is illustrated in the following diagram, which includes the following steps:

[0047] S101: Obtain the target data record to be verified and the pre-determined reconciliation parameter table.

[0048] S102: Determine each target reconciliation formula corresponding to the target data record in the reconciliation parameter table.

[0049] S103: Based on the target data record, obtain the business values ​​of each parameter of each target reconciliation formula, and verify the target data record according to the target reconciliation formula and the business values ​​of each parameter.

[0050] The data verification method provided in this application is applied to electronic devices, which may be PCs, tablets, or servers.

[0051] The electronic device has a pre-defined reconciliation parameter table, which can be obtained from various data reports in the data report set. By analyzing each data report, the reconciliation relationships in each data report are obtained, and the reconciliation parameter table is determined based on the reconciliation relationships in each data report. The reconciliation parameter table includes various reconciliation formulas.

[0052] The data report set may include dozens of data reports, each corresponding to a business type, and contains multiple reconciliation formulas. An organization may not participate in the verification of all reconciliation formulas. Therefore, this application establishes a correspondence between each reconciliation formula in the reconciliation parameter table and the data attribute organization, and determines the reconciliation formulas participating in data verification based on this correspondence.

[0053] The electronic device acquires the target data records to be verified and a pre-determined reconciliation parameter table. When acquiring the target data records, the data from various data reports in the data report set is integrated beforehand to obtain an integrated data table. The target data records to be verified are then acquired based on this integrated data table. When determining the reconciliation parameter table, it can also be determined based on the integrated data table, and a correspondence between each reconciliation formula in the reconciliation parameter table and the data attribute structure can be established.

[0054] After acquiring the target data record to be verified and a pre-determined reconciliation parameter table, the electronic device determines each target reconciliation formula corresponding to the target data record in the reconciliation parameter table. Specifically, determining each target reconciliation formula corresponding to the target data record in the reconciliation parameter table includes: determining the target data attribute structure of the target data record, and determining each target reconciliation formula corresponding to the target data attribute structure based on the correspondence between each reconciliation formula and the data attribute structure.

[0055] The electronic device acquires the target data record to be verified, determines the target data attribute structure of the target data record to be verified based on the attribute structure field in the target data record, and then determines the target reconciliation formula based on the correspondence between each reconciliation formula and the data attribute structure.

[0056] Based on the target data records, the business values ​​of each parameter in each target reconciliation formula are obtained. First, for each target reconciliation formula, the parameters of that formula are determined, and then the business values ​​of each parameter are obtained from the target data records. Based on each target reconciliation formula and the business values ​​of each parameter, the target data records are verified. Specifically, the business values ​​of each parameter can be substituted into the corresponding target reconciliation formula to obtain the final data verification result.

[0057] In this application, a reconciliation parameter table is pre-established, recording various reconciliation formulas used for data verification. When verifying target data records, the corresponding target reconciliation formulas are first determined from the reconciliation parameter table. Then, based on each target reconciliation formula, the business values ​​of each parameter of each target reconciliation formula are obtained from the target data record. The verification of the target data record is completed based on the target reconciliation formulas and the business values ​​of each parameter. The solution provided in this application pre-determines the reconciliation parameter table and completes data verification by combining the reconciliation formulas in the reconciliation parameter table with the business values ​​of each parameter in the data record. This eliminates the need to set up a separate verification module for each data report, solving the problem of excessive duplication and redundancy between verification modules.

[0058] In this application, all data reports maintain a reconciliation parameter table. During data verification, after obtaining the target data record to be verified, the reconciliation formulas corresponding to the target data record are retrieved from the reconciliation parameter table. Then, based on the data in the target data record, the business values ​​of each target reconciliation formula and its parameters are obtained. The target data record is then verified based on these reconciliation formulas and their business values. When a new data report appears, only the reconciliation parameter table needs to be maintained for the new data report. When data verification is required for the new data report, the reconciliation formulas corresponding to the new data report are determined based on the maintained reconciliation parameter table. The business values ​​of each parameter of the reconciliation formulas are then retrieved from the new data report, thus completing the data verification for the new data report. Therefore, there is no need to add a new verification module for new data reports, reducing the data verification cycle.

[0059] In this application, the parameters for obtaining each of the target reconciliation formulas include:

[0060] For each target reconciliation formula, obtain the formula configuration table, sub-item configuration table, and verification algorithm table for that target reconciliation formula, and determine the various parameters of the target reconciliation formula based on the formula configuration table, sub-item configuration table, and verification algorithm table.

[0061] The following examples illustrate the formula configuration table, sub-item configuration table, and verification algorithm table.

[0062] The formula configuration table is divided into two types: one for summary calculations used for secondary verification, and the other for check and verification. For example, M03 = ∑L14 - ∑L16 belongs to the summary calculation type, where ∑L14 represents the sum of L14 from each channel; D01 of the current day = D06 of the previous day belongs to the verification type. The formula configuration table describes the attributes of the reconciliation formulas. Taking the reconciliation formula M03 = ∑L14 - ∑L16 (hereinafter referred to as formula 1001) as an example, its formula configuration table is as follows:

[0063]

[0064]

[0065] In the formula category field, 0 indicates a summary calculation type, and 1 indicates a verification type.

[0066] Sub-item Configuration Table: Each reconciliation formula consists of multiple sub-items, each with business attributes. The sub-item configuration table is used to configure all attributes of each sub-item in the reconciliation formula. After parsing the sub-item configuration table, the target data record used for verification can be found in the integrated data table. Taking formula 1001's M03 and verification channel L14 as an example:

[0067] Chinese data name Data Name M03 Sub-item Connected L14 Sub-item Formula number formula_sn 1001 1001 Sub-item number item_seq 1 2 Sub-item name item_nm M03 L14 Verification channels check_chnl 01 02 Business type buss_tp M L Amount Serial Number amt_seq 03 14 Date rules date_rule 00 00 Should the results be retained? save_flag 1 0 Preserved attributes resv_flag

[0068] In the verification channel field, 01 indicates the first type of channel, and 02 indicates the second type of channel. In the date rule field, 00 indicates the data for the current day. In the result retention field, 1 indicates yes, and 0 indicates no.

[0069] Verification Algorithm Table: A reconciliation formula is broken down into multiple steps. Each step supports arithmetic operations, logical operations, etc. The final calculation result of multiple steps is the result of the reconciliation formula. Taking reconciliation formula 1001 as an example, assuming that all channels in M03 = ∑L14 - ∑L16 are 01 and 02, then reconciliation formula 1001 expands to M03 = L14(channel 01) + L14(channel 02) - L16(channel 01) - L16(channel 02). The expanded reconciliation formula has 5 sub-items, assuming that the sub-item numbers from left to right are 1, 2, 3, 4, and 5. Therefore, formula 1001 can be broken down into the following steps:

[0070] Step number Steps Temporary output sequence number 1 L14 (Channel 01) + L14 (Channel 02) Sub-item 6 2 Sub-item 6-L16 (Channel 01) Sub-item 7 3 Sub-item 7-L16 (Channel 02) Sub-item 1

[0071] Among them, sub-items 6 and 7 are intermediate results in the calculation process. Step 1 is translated into parameter description, that is: sub-item 6 = sub-item 2 + sub-item 3. Step 2 is translated into parameter description, that is: sub-item 7 = sub-item 6 - sub-item 4. Step 3 is translated into parameter description, that is: sub-item 1 = sub-item 7 - sub-item 5.

[0072] Sub-item 1 is the final output result. Therefore, the verification algorithm table can be configured as follows (operator 2 and operand 3 are both filled with 0, so they are not listed):

[0073] Formula number Step number Operation results Operand 1 Operator 1 Operand 2 1001 1 -6 -2 + -3 1001 2 -7 -6 - -4 1001 3 -1 -7 - -5

[0074] The rules for filling in the operation result, operand 1, and operand 2 are as follows: negative numbers represent sub-items, i.e., -6 represents sub-item 6; if the operand is a positive number, it represents a specific numerical value. This function is used for logical operations containing numerical values, constant calculations, etc.

[0075] Example of logical operation. Assume the reconciliation formula 1002: B01 = (A01 > 0.5 * A02) ? A01 : 0.5 * A02, meaning B01 is the larger of A01 and 0.5 * A02. Assume B01, A01, and A02 are sub-item 1, sub-item 2, and sub-item 3 respectively, therefore formula 1002 can be broken down into the following steps:

[0076] Step number Steps Temporary output sequence number 1 A02*0.5 Sub-item 4 2 The larger value between A01 and sub-item 4 is taken. Sub-item 1

[0077] Here, sub-item 4 is an intermediate result in the calculation process. Step 1 is translated into parameter description as follows: Sub-item 4 = Sub-item 3 * 0.5. Step 2 is translated into parameter description as follows: Sub-item 1 = the larger value between sub-item 2 and sub-item 4. Step 3 is translated into parameter description as follows: Sub-item 1 = Sub-item 7 - Sub-item 5.

[0078] Sub-item 1 is the final output result. Therefore, the verification algorithm table can be configured as follows (operator 2 and operand 3 are both filled with 0, so they are not listed):

[0079] Formula number Step number Operation results Operand 1 Operator 1 Operand 2 1002 1 -4 -3 * 0.5 1002 2 -1 -2 > -4

[0080] The examples above demonstrate that the parameters of each target reconciliation formula are obtained based on its formula configuration table, sub-item configuration table, and verification algorithm table. Obtaining the business values ​​of each parameter in the target reconciliation formula, based on the target data records, involves parsing each sub-item in the sub-item configuration table and extracting the corresponding parameter values ​​from the target data records. After parsing the sub-item configuration table, the verification channel, business type, amount sequence number, and date rule for each sub-item are obtained. Combined with the affiliated institution code, the actual business value can then be found in the integrated data table.

[0081] The verification of target data records based on the various target reconciliation formulas and the business values ​​of each parameter includes: parsing the verification algorithm table, determining each algorithm step of each target reconciliation formula, substituting the business values ​​of each parameter corresponding to each sub-item into each algorithm step of the corresponding target reconciliation formula, and obtaining the verification result of the target data record.

[0082] Figure 2 The data verification system architecture diagram provided for this application is as follows: Figure 2 As shown, it includes a unified input module 11, a relationship verification module 22, and a unified output module 33.

[0083] This is a parameter-configurable reconciliation relationship verification framework. The entire reconciliation relationship verification process is abstracted into three modules: a unified input module, a relationship verification module, and a unified output module. The unified input module integrates data, refining and transforming data from various formats and placing it into an integrated data table. The relationship verification module, based on parameterized configuration, parses the contents of the reconciliation parameter table to obtain the verification results. The unified output module stores the verification result data according to various dimensions, providing data support for subsequent modules that generate business results.

[0084] A parameterized verification scheme for reconciliation formulas is implemented. Formula matching tables, formula configuration tables, and sub-item configuration tables are designed to describe the reconciliation formulas; a verification algorithm table is designed to describe the algorithm. In the relationship verification module, the above four parameter tables are parsed, and combined with the input data, formula verification is performed to obtain the verification result.

[0085] The unified input module is used to integrate data. The actual business input includes various data reports. The unified input module parses and extracts various source data and saves them to the integrated data table with dimensions such as organization code, verification date, verification channel, and business type as primary keys. Each data (smallest subdivision dimension) has multiple values, corresponding to the actual business data of that data.

[0086] The relationship verification module is responsible for calculations and has two types of inputs: business data from the integrated data table and the reconciliation formulas and algorithms configured in the reconciliation parameter table. For each participating organization, its parameters are parsed to obtain the reconciliation formulas and algorithms to be verified; then, the data from the integrated data table is plugged into the reconciliation formulas for calculation to obtain the results.

[0087] The unified output module processes the calculation results of the relationship verification module. For intermediate data that requires secondary verification, it is written back to the unified input module; for the results that generate the actual output, it is written to the unified output table and saved with the organization code, verification date, verification channel, formula number, etc. as primary keys. Each data record corresponds to the verification result of a reconciliation formula.

[0088] Specifically, the calculation result of the relationship verification module is determined based on the formula type (formula_type) field of the formula configuration table. For example, a formula_type field of 0 indicates that it belongs to intermediate data, and a formula_type field of 1 indicates that it does not belong to intermediate data.

[0089] If the formula_type field of a formula is 0, it means that the output of the formula is intermediate data and needs to be saved. Taking the formula 1002 (B01=(A01>0.5*A02)?A01:0.5*A02) in the example above as an example, assuming B01 is an intermediate result and needs to be written back to the unified input module, the process is as follows:

[0090] Step 1: Extract the various attributes of B01. For example, Verification Date = Today, Business Type = B, Amount 01 = Calculation result of B01, Organization Code = Current Organization Code, Verification Channel = Current Verification Channel, etc.

[0091] Step 2: Write to the integrated data table. Combine the key fields extracted in Step 1 into a single record and write it to the integrated data table.

[0092] Formula Matching Table: The verification of reserve funds involves dozens of reports, each corresponding to a business type, which contains multiple reconciliation formulas. An institution will not participate in the verification of all reconciliation formulas; therefore, a formula matching table is designed. Institutional attributes can be set from multiple dimensions such as whether verification is supported and transaction channels. Each type of attribute corresponds to a formula bitmap, which represents the set of reconciliation formulas that this type of institution needs to verify.

[0093] Figure 3 The data verification process provided for this application is illustrated in the following diagram, which includes the following steps:

[0094] S201: Integrate the data from various data reports to obtain an integrated data table, and obtain the target data records to be verified based on the integrated data table.

[0095] S202: Obtain the pre-determined cross-reference parameter table, which is determined based on the integrated data table, and establish the correspondence between each cross-reference formula and the data attribute structure in the cross-reference parameter table.

[0096] S203: Determine the target data attribute structure of the target data record, and determine the target reconciliation formulas corresponding to the target data attribute structure based on the correspondence between each reconciliation formula and the data attribute structure.

[0097] S204: For each target reconciliation formula, obtain the formula configuration table, sub-item configuration table and verification algorithm table of the target reconciliation formula, and determine the various parameters of the target reconciliation formula based on the formula configuration table, sub-item configuration table and verification algorithm table.

[0098] S205: Parse each sub-item in the sub-item configuration table and obtain the business values ​​of each parameter corresponding to each sub-item from the target data record.

[0099] S206: Parse the verification algorithm table, determine each algorithm step of each target reconciliation formula, substitute the business values ​​of each parameter corresponding to each sub-item into each algorithm step of the corresponding target reconciliation formula, and obtain the verification result of the target data record.

[0100] Figure 4 The schematic diagram of the data verification device provided for this application includes:

[0101] The acquisition module 41 is used to acquire the target data records to be verified and the pre-determined reconciliation parameter table;

[0102] The determining module 42 is used to determine each target reconciliation formula corresponding to the target data record in the reconciliation parameter table;

[0103] The verification module 43 is used to obtain the business values ​​of each parameter of each target reconciliation formula based on the target data record, and to verify the target data record according to the target reconciliation formula and the business values ​​of each parameter.

[0104] The acquisition module 41 is specifically used to integrate data from various data reports to obtain an integrated data table, and to acquire the target data record to be verified based on the integrated data table.

[0105] The acquisition module 41 is further configured to determine the cross-reference parameter table based on the integrated data table, and establish the correspondence between each cross-reference formula and data attribute structure in the cross-reference parameter table.

[0106] The determining module 42 is specifically used to determine the target data attribute structure of the target data record, and to determine the target reconciliation formulas corresponding to the target data attribute structure based on the correspondence between the reconciliation formulas and the data attribute structure.

[0107] The verification module 43 is specifically used to obtain the formula configuration table, sub-item configuration table and verification algorithm table of each target reconciliation formula, and determine the parameters of the target reconciliation formula based on the formula configuration table, sub-item configuration table and verification algorithm table.

[0108] The verification module 43 is specifically used to parse each sub-item in the sub-item configuration table and obtain the business values ​​of each parameter corresponding to each sub-item from the target data record.

[0109] The verification module 43 is specifically used to parse the verification algorithm table, determine the algorithm steps of each target reconciliation formula, substitute the business values ​​of each parameter corresponding to each sub-item into the corresponding algorithm steps of the target reconciliation formula, and obtain the verification result of the target data record.

[0110] This application also provides an electronic device, such as Figure 5 As shown, it includes: processor 501, communication interface 502, memory 503 and communication bus 504, wherein processor 501, communication interface 502 and memory 503 communicate with each other through communication bus 504.

[0111] The memory 503 stores a computer program, which, when executed by the processor 501, causes the processor 501 to perform any of the above method steps.

[0112] The communication bus mentioned in the above electronic devices can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. This communication bus can be divided into address bus, data bus, control bus, etc. For ease of illustration, only one thick line is used to represent it in the diagram, but this does not mean that there is only one bus or one type of bus.

[0113] Communication interface 502 is used for communication between the above-mentioned electronic device and other devices.

[0114] The memory may include random access memory (RAM) or non-volatile memory (NVM), such as at least one disk storage device. Optionally, the memory may also be at least one storage device located remotely from the aforementioned processor.

[0115] The processors mentioned above can be general-purpose processors, including central processing units, network processors (NPs), etc.; they can also be digital signal processors (DSPs), application-specific integrated circuits, field-programmable gate arrays or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc.

[0116] This application also provides a computer-readable storage medium storing a computer program executable by an electronic device, which, when run on the electronic device, causes the electronic device to perform any of the above method steps.

[0117] Although preferred embodiments of this application have been described, those skilled in the art, upon learning the basic inventive concept, can make other changes and modifications to these embodiments. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments as well as all changes and modifications falling within the scope of this application.

[0118] Obviously, those skilled in the art can make various modifications and variations to this application without departing from the spirit and scope of this application. Therefore, if such modifications and variations fall within the scope of the claims of this application and their equivalents, this application also intends to include such modifications and variations.

Claims

1. A data verification method, characterized in that, The method includes: Obtain the target data records to be verified and the pre-determined reconciliation parameter table; Determine each target reconciliation formula in the reconciliation parameter table that corresponds to the target data record; Based on the target data record, obtain the business values ​​of each parameter of each target reconciliation formula, and verify the target data record according to each target reconciliation formula and the business values ​​of each parameter; The parameters for obtaining each of the target reconciliation formulas include: For each target reconciliation formula, obtain the formula configuration table, sub-item configuration table and verification algorithm table for that target reconciliation formula, and determine the various parameters of the target reconciliation formula based on the formula configuration table, sub-item configuration table and verification algorithm table; The formula configuration table is divided into two types: one for summary calculation and secondary verification, and the other for check and verification. The sub-item configuration table is used to configure all attributes of each sub-item in the reconciliation formula. The verification algorithm table is used to break down a reconciliation formula into multiple steps.

2. The method as described in claim 1, characterized in that, The target data records to be verified include: The data from various data reports are integrated to obtain an integrated data table, and the target data records to be verified are obtained based on the integrated data table.

3. The method as described in claim 2, characterized in that, The process of determining the reconciliation parameter table includes: The cross-reference parameter table is determined based on the integrated data table, and the correspondence between each cross-reference formula and the data attribute structure in the cross-reference parameter table is established.

4. The method as described in claim 3, characterized in that, The step of determining each target reconciliation formula corresponding to the target data record in the reconciliation parameter table includes: The target data attribute structure of the target data record is determined, and the target reconciliation formulas corresponding to the target data attribute structure are determined according to the correspondence between the reconciliation formulas and the data attribute structure.

5. The method as described in claim 1, characterized in that, The process of obtaining the parameters of each target reconciliation formula based on the target data record includes: Parse each sub-item in the sub-item configuration table and obtain the business values ​​of each parameter corresponding to each sub-item from the target data record.

6. The method as described in claim 5, characterized in that, The verification of the target data records based on the respective target reconciliation formulas and the business values ​​of the respective parameters includes: The verification algorithm table is parsed to determine the algorithm steps of each target reconciliation formula. The business values ​​of each parameter corresponding to each sub-item are substituted into the corresponding algorithm steps of the target reconciliation formula to obtain the verification result of the target data record.

7. A data verification device, characterized in that, The device includes: The acquisition module is used to acquire the target data records to be verified and the pre-determined reconciliation parameter table; The determination module is used to determine each target reconciliation formula corresponding to the target data record in the reconciliation parameter table; The verification module is used to obtain the business values ​​of each parameter of each target reconciliation formula based on the target data record, and to verify the target data record according to the target reconciliation formula and the business values ​​of each parameter. The verification module is specifically used to obtain the formula configuration table, sub-item configuration table and verification algorithm table for each target reconciliation formula, and determine the various parameters of the target reconciliation formula based on the formula configuration table, sub-item configuration table and verification algorithm table. The formula configuration table is divided into two types: one for summary calculation and secondary verification, and the other for check and verification. The sub-item configuration table is used to configure all attributes of each sub-item in the reconciliation formula. The verification algorithm table is used to break down a reconciliation formula into multiple steps.

8. An electronic device, characterized in that, It includes a processor, a communication interface, a memory, and a communication bus, wherein the processor, the communication interface, and the memory communicate with each other through the communication bus; Memory, used to store computer programs; A processor, when executing a program stored in memory, implements the steps of the method described in any one of claims 1-6.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, implements the steps of the method described in any one of claims 1-6.

Images