A data verification method, apparatus, equipment and medium

Abstract

This application relates to the field of data analysis, specifically to a data verification method, apparatus, device, and medium, designed to make data verification more universal and reduce maintenance difficulty. The method identifies at least one target data verification relationship group; for each target data verification relationship group, it performs the following steps: determining the target local data table and the target external data table within the target data verification relationship group; querying the data verification conditions corresponding to the target data verification relationship group; and, based on the data verification conditions, performing data verification on the target local data table and the target external data table to obtain the verification result. In this application, by configuring data verification relationships between users, it is applicable to various scenarios such as one-to-one data verification, one-to-many data verification, many-to-one data verification, and many-to-many data verification, making the application more universal. Furthermore, the data verification based on data verification conditions in this application makes it easier to maintain.

Description

Technical Field

[0001] This application relates to the field of data analysis technology, specifically to a data verification method, apparatus, device, and medium. Background Technology

[0002] With the development of big data technology, business interactions between various application platforms are becoming increasingly frequent, leading to more and more instances of data verification. Currently, many data verification systems use a one-to-one data table recording method for data verification. However, this method has limitations: low data verification efficiency, fixed and difficult-to-modify rules, high maintenance difficulty, and high development costs. Summary of the Invention

[0003] This application provides a data verification method, apparatus, device, and medium to make data verification more universal and reduce maintenance difficulty.

[0004] In a first aspect, embodiments of this application provide a data verification method, the method comprising:

[0005] In response to a data verification operation, at least one data verification relationship group is displayed; the data verification relationship group includes at least one local data table and at least one third-party data table.

[0006] In response to a selection operation on a data reconciliation group, at least one target data reconciliation group is determined;

[0007] For each of the target data verification relationship groups, perform the following operations respectively:

[0008] Determine the target local data table and the target third-party data table in the target data verification relationship group;

[0009] Query the data verification conditions corresponding to the target data verification relationship group;

[0010] Based on the data verification conditions, the target local data table and the target third-party data table are verified to obtain the verification results.

[0011] In this application embodiment, by configuring the data verification relationship between users, it is applicable to various scenarios such as one-to-one data verification, one-to-many data verification, many-to-one data verification, and many-to-many data verification, making this application more universal. Moreover, this application only requires maintenance of the data verification relationship group and the data verification conditions, which reduces the maintenance difficulty.

[0012] In some possible embodiments, after determining the target data verification group in response to the selection operation of the data verification group, the method further includes:

[0013] In response to a user's add operation triggered by a target data verification relationship group, determine the new data table corresponding to the add operation;

[0014] Determine the category of the newly added data table; the category includes: local data table, third-party data table;

[0015] Add the newly added data table to the corresponding category in the target data verification relationship group.

[0016] In this application, the method of adding new data tables allows users to add data verification relationships to the target data verification relationship group at any time, thereby improving the efficiency of data verification.

[0017] In some possible embodiments, the data verification conditions include multiple conditions, and the step of performing data verification on the target local data table and the target third-party data table based on the data verification conditions includes:

[0018] Perform the following for each data verification condition:

[0019] Determine the verification parameters for the data verification conditions;

[0020] The verification method is determined based on the verification parameters; the verification method includes one or a combination of the following: self-data verification, automatic data verification;

[0021] The target local data table and the target third-party data table are verified based on the verification method.

[0022] In this application, the data verification methods include self-data verification and automatic data verification, making this application more universal.

[0023] In some possible embodiments, if the verification method is automatic data verification, then the step of performing data verification on the target local data table and the target third-party data table based on the verification method includes:

[0024] Determine the sum of the values ​​of the same field in each target local data table, and determine the sum of the values ​​of the same field in each target third-party data table;

[0025] The sum of the field values ​​of the same field in each target local data table is compared with the sum of the field values ​​of the same field in each target third-party data table.

[0026] In this application, data verification is achieved by accumulating and comparing the data tables of both parties involved in the data verification. This enables one-to-many, many-to-one, and many-to-many data verification.

[0027] In some possible embodiments, if the verification method is a self-data verification, then the step of performing data verification on the target local data table and the target third-party data table based on the verification method includes:

[0028] Determine the category of the self-data verification; the category is either local data self-data verification or third-party data self-data verification;

[0029] If the category is local data self-data verification, then the resource data and data direction in each target local data table are compared respectively;

[0030] If the category is a self-check of other party data, then the resource data in each target other party data table is compared with the data direction.

[0031] In this application, the data verification results are made more accurate by comparing data resources and data orientation.

[0032] In some possible embodiments, after determining the target local data table and the target third-party data table in the target data verification relationship group, the method further includes:

[0033] Update the data verification status of each of the target local data tables to "data verification in progress";

[0034] Update the data verification status of each of the target third-party data tables to "data verification in progress".

[0035] In this application, by setting a data verification status, the repeated verification of the same data table is avoided, thus preventing the waste of resources.

[0036] In some possible embodiments, after performing data verification on the target local data table and the target third-party data table based on the data verification conditions to obtain the verification result, the method further includes:

[0037] Update the data verification status of each target local data table to the data verification completed status; and

[0038] Update the data verification status of each of the target third-party data tables to the data verification completed status.

[0039] In this application, after the data verification is completed, the data verification status is changed so that the user can obtain the data verification results in a timely manner.

[0040] Secondly, this application provides a data verification device, the device comprising:

[0041] The display module is used to display at least one data verification relationship group in response to a data verification operation; the data verification relationship group includes at least one local data table and at least one third-party data table;

[0042] The relationship determination module is used to determine at least one target data verification relationship group in response to a selection operation on the data verification relationship group;

[0043] The verification module is used to verify the relationship group for each of the target data and perform the following operations respectively:

[0044] Determine the target local data table and the target third-party data table in the target data verification relationship group;

[0045] Query the data verification conditions corresponding to the target data verification relationship group;

[0046] Based on the data verification conditions, the target local data table and the target third-party data table are verified to obtain the verification results.

[0047] In some possible embodiments, the relationship determination module performs a selection operation in response to a data verification relationship group, and after determining the target data verification relationship group, it is further configured to:

[0048] In response to a user's add operation triggered by a target data verification relationship group, determine the new data table corresponding to the add operation;

[0049] Determine the category of the newly added data table; the category includes: local data table, third-party data table;

[0050] Add the newly added data table to the corresponding category in the target data verification relationship group.

[0051] In some possible embodiments, the data verification conditions include multiple conditions, and the verification module is configured to perform data verification on the target local data table and the target third-party data table based on the data verification conditions as follows:

[0052] Perform the following for each data verification condition:

[0053] Determine the verification parameters for the data verification conditions;

[0054] The verification method is determined based on the verification parameters; the verification method includes one or a combination of the following: self-data verification, automatic data verification;

[0055] The target local data table and the target third-party data table are verified based on the verification method.

[0056] In some possible embodiments, if the verification method is automatic data verification, then when the verification module performs data verification on the target local data table and the target third-party data table based on the verification method, it is configured as follows:

[0057] Determine the sum of the values ​​of the same field in each target local data table, and determine the sum of the values ​​of the same field in each target third-party data table;

[0058] The sum of the field values ​​of the same field in each target local data table is compared with the sum of the field values ​​of the same field in each target third-party data table.

[0059] In some possible embodiments, if the verification method is a self-data verification, then when the verification module performs data verification on the target local data table and the target third-party data table based on the verification method, it is configured as follows:

[0060] Determine the category of the self-data verification; the category is either local data self-data verification or third-party data self-data verification;

[0061] If the category is local data self-data verification, then the resource data and data direction in each target local data table are compared respectively;

[0062] If the category is a self-check of other party data, then the resource data in each target other party data table is compared with the data direction.

[0063] In some possible embodiments, after the verification module performs the task of determining the target local data table and the target third-party data table in the target data verification relationship group, it is further configured to:

[0064] Update the data verification status of each of the target local data tables to "data verification in progress";

[0065] Update the data verification status of each of the target third-party data tables to "data verification in progress".

[0066] In some possible embodiments, the verification module performs data verification on the target local data table and the target third-party data table based on the data verification conditions, and after obtaining the verification result, it is further configured to:

[0067] Update the data verification status of each target local data table to the data verification completed status; and

[0068] Update the data verification status of each of the target third-party data tables to the data verification completed status.

[0069] Thirdly, this application provides an electronic device, comprising:

[0070] Memory, used to store program instructions;

[0071] A processor is configured to invoke program instructions stored in the memory and execute the steps of the method described in any one of the first aspects according to the obtained program instructions.

[0072] Fourthly, this application provides a computer-readable storage medium storing a computer program, the computer program including program instructions, which, when executed by a computer, cause the computer to perform the method described in any one of the first aspects.

[0073] Fifthly, this application provides a computer program product comprising: computer program code, which, when run on a computer, causes the computer to perform the method described in any one of the first aspects. Attached Figure Description

[0074] Figure 1 This is a schematic diagram illustrating an application scenario of a data verification method provided in an embodiment of this application.

[0075] Figure 2 This is a schematic diagram of the overall process of a data verification method provided in an embodiment of this application;

[0076] Figure 3 A schematic diagram illustrating the selection of target verification relationships in a data verification method provided in this application embodiment;

[0077] Figure 4 This is a schematic diagram illustrating the selection of a target data verification relationship group for a data verification method provided in an embodiment of this application.

[0078] Figure 5 A schematic diagram of a data table in a data verification relationship group provided in an embodiment of this application;

[0079] Figure 6 A schematic diagram illustrating the process of a data verification method based on a verification method provided in this application embodiment;

[0080] Figure 7 A flowchart illustrating the process of adding a new data table in a data verification method provided in this application embodiment;

[0081] Figure 8 A schematic diagram of an apparatus for a data verification method provided in an embodiment of this application;

[0082] Figure 9This is a schematic diagram of an electronic device for a data verification method provided in an embodiment of this application. Detailed Implementation

[0083] To make the objectives, technical solutions, and advantages of this application clearer, the technical solutions in the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of this application, and not all of them. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application. Unless otherwise specified, the embodiments and features in the embodiments of this application can be arbitrarily combined with each other. Furthermore, although a logical order is shown in the flowchart, in some cases, the steps shown or described may be performed in a different order than that shown here.

[0084] The terms "first" and "second" in the specification, claims, and accompanying drawings of this application are used to distinguish different objects, not to describe a specific order. Furthermore, the term "comprising" and any variations thereof are intended to cover non-exclusive protection. For example, a process, method, system, product, or device that includes a series of steps or units is not limited to the listed steps or units, but may optionally include steps or units not listed, or may optionally include other steps or units inherent to these processes, methods, products, or devices. The term "multiple" in this application can mean at least two, for example, two, three, or more, and the embodiments of this application do not impose limitations.

[0085] The data collection, dissemination, and use in this application all comply with relevant national laws and regulations.

[0086] Before introducing the data verification method provided in the embodiments of this application, for ease of understanding, the technical background of the embodiments of this application will be described in detail below.

[0087] With the development of big data technology, business interactions between various application platforms are becoming increasingly frequent, leading to more and more instances of data verification. Currently, many data verification systems use a one-to-one data table recording method for data verification. However, this method has limitations: low data verification efficiency, fixed and difficult-to-modify rules, high maintenance difficulty, and high development costs.

[0088] In view of this, this application proposes a data verification method, apparatus, electronic device, and storage medium to solve the above-mentioned problems. The inventive concept of this application can be summarized as follows: in response to a data verification operation, at least one data verification relationship group is displayed; the data verification relationship group includes at least one local data table and at least one third-party data table; in response to a selection operation on the data verification relationship group, at least one target data verification relationship group is determined; for each target data verification relationship group, the following operations are performed: determining the target local data table and the target third-party data table in the target data verification relationship group; querying the data verification conditions corresponding to the target data verification relationship group; and performing data verification on the target local data table and the target third-party data table based on the data verification conditions to obtain a verification result.

[0089] For ease of understanding, the data verification method provided in this application embodiment will be described in detail below with reference to the accompanying drawings:

[0090] like Figure 1 The diagram shown illustrates an application scenario of the data verification method in this embodiment. The diagram includes: a server 10, a storage device 20, and a terminal device 30; wherein:

[0091] In response to a data verification operation triggered by a user in terminal device 30, server 10 displays at least one data verification relationship group in terminal device 30. Each data verification relationship group includes at least one local data table and at least one third-party data table. In response to a selection operation on a data verification relationship group, server 10 determines at least one target data verification relationship group. For each target data verification relationship group, the following operations are performed: determining the target local data table and the target third-party data table within the target data verification relationship group; querying the data verification conditions corresponding to the target data verification relationship group; and performing data verification on the target local data table and the target third-party data table based on the data verification conditions to obtain the verification result. The data verification relationship groups are stored in memory 20.

[0092] The description in this application details only a single server 10, memory 20, and terminal device 30. However, those skilled in the art should understand that the illustrated server 10, memory 20, and terminal device 30 are intended to illustrate the operation of the server 10, memory 20, and terminal device 30 involved in the technical solutions of this application, and are not intended to imply any limitation on the number, type, or location of the server 10, memory 20, and terminal device 30. It should be noted that adding additional modules to or removing individual modules from the illustrated environment will not change the underlying concept of the exemplary embodiments of this application. Furthermore, although for ease of explanation... Figure 1 The diagram shows a bidirectional arrow from memory 20 to server 10, but those skilled in the art will understand that the sending and receiving of the aforementioned data also needs to be achieved through a network.

[0093] It should be noted that the memory in the embodiments of this application can be, for example, a cache system, hard disk storage, memory storage, etc. Furthermore, the data verification method proposed in this application is not only applicable to… Figure 1 The application scenarios shown can also be applied to any device that requires data verification.

[0094] like Figure 2 The diagram shown is a schematic representation of the overall process of a data verification method provided in an embodiment of this application, wherein:

[0095] In step 201: In response to the data reconciliation operation, at least one data reconciliation relationship group is displayed; the data reconciliation relationship group includes at least one local data table and at least one third-party data table;

[0096] In step 202: In response to the selection operation of the data verification relationship group, at least one target data verification relationship group is determined;

[0097] For each target data check relationship group, perform the following operations respectively:

[0098] In step 203: Determine the target local data table and the target third-party data table in the target data verification relationship group;

[0099] In step 204: Query the data verification conditions corresponding to the target data verification relationship group;

[0100] In step 205: Based on the data verification conditions, the target local data table and the target third-party data table are verified to obtain the verification results.

[0101] In this application embodiment, by configuring the data verification relationship between users, it is applicable to various scenarios such as one-to-one data verification, one-to-many data verification, many-to-one data verification, and many-to-many data verification, making this application more universal. In addition, the data verification in this application is performed through data verification conditions, which makes the development difficulty lower and easier to maintain.

[0102] For ease of understanding, the following is... Figure 2 The steps are explained in detail below:

[0103] In some possible embodiments, the user interface is first described. If the user needs to verify data, a data verification operation is triggered first, followed by a process such as... Figure 3 The data verification interface shown; in the data verification interface, users can click the data verification relationship button to enter the following... Figure 4 The interface shown is in Figure 4The interface shown displays at least one data verification relationship group. In this application, the data verification relationship group includes at least one local data table and at least one third-party data table, for example: Figure 5 As shown, for data verification relationship group A, it includes local data tables: Table 1, Table 2, Table 3, and Table 4; and also includes external data tables: Table 1, Table 2, Table 3, and Table 4.

[0104] Users can Figure 4 The interface shown triggers an operation for each data verification relationship group. For example, if verification relationship group 1 and verification relationship group 3 are selected, then verification relationship group 1 and verification relationship group 3 will be used as the target data verification relationship group.

[0105] In some possible embodiments, to avoid wasting resources due to repeated data verification for the same target data verification relationship group, and since the data tables in each target data verification relationship group are verified synchronously, the data verification status of each data table in each target data verification relationship group is the same. Based on this, in this application, after determining the target data verification relationship group, it is determined that the data verification status of each target local data table and each target third-party data table in the target data verification relationship group is a data verification completed state; or, it is determined that the time interval between the start time of the current data verification and the end time of the previous data verification is greater than a preset time interval.

[0106] For example: Target data verification relationship group 1 includes local data tables: Local Data Table 1, Local Data Table 2, Local Data Table 3, and Local Data Table 4; and also includes third-party data tables: Third-party Data Table 1, Third-party Data Table 2, Third-party Data Table 3, and Third-party Data Table 4. Since all eight tables are simultaneously verified, their data verification status, start time, and last verification end time are the same. Therefore, any table can be selected, such as Table 1. If the data verification status of Table 1 is determined to be "data verification completed," the data verification process for target data verification relationship group 1 can continue. Alternatively, if the start time of the current data verification for Table 1 is determined to be 6:01, the last data verification end time is determined to be 5:30, and the preset time interval is 30 minutes, then the time interval between the start time of the current data verification and the end time of the last data verification for target data verification relationship group 1 is greater than the preset detection time, and the data verification process for target data verification relationship group 1 can continue.

[0107] In this application embodiment, the data verification conditions include multiple factors. Based on these conditions, when performing data verification on the target local data table and the target third-party data table, it can be implemented as follows: Figure 6 The steps shown are performed for each data verification condition:

[0108] In step 601: Determine the verification parameters for the data verification conditions;

[0109] In the embodiments of this application, the verification parameters include, but are not limited to: self-data verification flag, automatic data verification flag, business number matching flag, interest accrual date matching flag, interest accrual date difference days, entry date matching flag, and entry date difference days.

[0110] Self-data verification flag: Can be either "yes" or "no". If the value is "yes", it indicates that the data verification method is self-data verification.

[0111] Automatic data verification flag: Can be either "Yes" or "No". If the value is "Yes", it indicates that the data verification method is automatic data verification.

[0112] In step 602: the verification method is determined based on the verification parameters; the verification method includes one or a combination of the following: self-data verification, automatic data verification;

[0113] In step 603: Data verification is performed on the target local data table and the target third-party data table based on the verification method.

[0114] In some possible embodiments, if the verification method is automatic data verification, then when performing data verification on the target local data table and the target external data table based on the verification method, the specific implementation is as follows: determine the sum of the field values ​​of the same field in each target local data table, and determine the sum of the field values ​​of the same field in each target external data table; compare the sum of the field values ​​of the same field in each target local data table with the sum of the field values ​​of the same field in each target external data table.

[0115] For example: Target data verification relationship group 1 includes local data tables: Table 1 and Table 2; and also includes third-party data tables: Table 3 and Table 4. The fields and values ​​of the target local data tables are shown in Table A, and the fields and values ​​of the target third-party data tables are shown in Table B.

[0116] Table No. Business Number value date difference on the interest accrual date Date of entry Enter date difference in days Table 1 0 1 0 1 0 Table 2 0 1 0 1 0

[0117] Table A

[0118] Table No. Business Number value date difference on the interest accrual date Date of entry Enter date difference in days Table 3 0 1 0 1 0 Table 4 0 1 0 1 0

[0119] Table B

[0120] In this embodiment, a binary method can be used to determine the cumulative sum. For example, for the business number field in Table 1 and Table 2 of the local data table, the cumulative sum of the field values ​​of the business number field is determined to be 0; if the cumulative sum of the field values ​​of the business number field in Table 3 and Table 4 is 0, then the comparison of this field is determined to be successful. By performing the above steps for each field, the data verification can be completed. If the cumulative sums of Table 1 and Table 2 match the cumulative sums of Table 3 and Table 4, then the result of this data verification is determined to be successful.

[0121] In some other possible embodiments, after the automatic data verification is completed, in order to further ensure the accuracy of the data verification, the result of the automatic data verification can be pushed to a technician after the result is obtained, so that the technician can further verify the result of the automatic data verification.

[0122] In some possible embodiments, if the verification method is self-data verification, then when performing data verification on the target local data table and the target third-party data table based on the verification method, the specific implementation is as follows: first, determine the category of self-data verification; the category is local data self-data verification or third-party data self-data verification;

[0123] 1. Local data self-verification

[0124] In this embodiment of the application, if the category is local data self-data verification, then the resource data in each target local data table is compared with the data direction. The data direction represents the increase or decrease of resource data.

[0125] For example: For target data verification relationship group 1, which includes local data tables: Table 1 and Table 2, and external data tables: Table 3 and Table 4; the verification method is self-data verification, and the category of self-data verification is determined to be local data self-data verification, then only Table 1 and Table 2 are verified. If it is determined that the resource data of Table 1 and Table 2 are the same and the data direction is opposite, then the verification result of self-data verification of target data verification relationship group 1 is determined to be successful.

[0126] 2. Verification of data from other sources and their own data.

[0127] In this embodiment of the application, if the category is the verification of data from another party, then the resource data in each target local data table is compared with the data direction. The data direction represents the increase or decrease of resource data.

[0128] For example: For target data verification relationship group 1, which includes local data tables: Table 1 and Table 2, and external data tables: Table 3 and Table 4; the verification method is self-data verification, and the category of self-data verification is determined to be external local data self-data verification, then only Table 3 and Table 4 are verified. If it is determined that the resource data of Table 3 and Table 4 are the same and the data direction is opposite, then the verification result of self-data verification of target data verification relationship group 1 is determined to be successful.

[0129] In this embodiment, to avoid wasting resources by repeatedly verifying the same data table, a resource verification status is established. Firstly, to prevent the target data verification relationship group from being verified again, after determining the target local data table and the target external data table in the target data verification relationship group, the data verification status of each target local data table is updated to "data verification in progress"; and the data verification status of each target external data table is also updated to "data verification in progress". After verifying the target local data table and the target external data table and obtaining the verification result, the data verification status of each target local data table is updated to "data verification completed"; and the data verification status of each target external data table is also updated to "data verification completed".

[0130] In this embodiment of the application, considering that the data verification relationship will change as the data increases, if the user modifies the data verification relationship, then after determining the target data verification relationship group, the following steps are implemented: Figure 7 The steps shown are as follows:

[0131] In step 701: In response to the user's add operation triggered by the target data verification relationship group, determine the new data table corresponding to the add operation;

[0132] In step 702: Determine the category of the new data table; the categories include: local data table, external data table;

[0133] In step 703: Add the new data table to the corresponding category in the target data verification relationship group.

[0134] For example: For target data verification relationship group 1, which includes local data tables: Table 1 and Table 2, and third-party data tables: Table 3 and Table 4; if a user wants to add a local data table, Table 5, to target data verification relationship group 1, then based on the user-triggered add operation, it can be determined that the target data verification relationship group corresponding to the add operation is target data verification relationship group 1, and the category of the newly added data table is determined to be a local data table. Therefore, Table 5 will be added to target data verification relationship group 1.

[0135] In other embodiments, the user can also perform deletion operations on data tables in the target data verification relationship group. For example, for target data verification relationship group 1, which includes local data tables: Table 1 and Table 2, and third-party data tables: Table 3 and Table 4; if the user wants to delete local data table 1 in target data verification relationship group 1, then the target data verification relationship group corresponding to the deletion operation triggered by the user is determined to be target data verification relationship group 1, and the data table corresponding to the deletion operation by the user is determined to be Table 1, then the local data table Table 1 is deleted in target data verification relationship group 1.

[0136] like Figure 8 As shown, based on the same inventive concept, a data verification device 800 is proposed, the device comprising:

[0137] The display module 8001 is used to display at least one data verification relationship group in response to a data verification operation; the data verification relationship group includes at least one local data table and at least one third-party data table.

[0138] The relation determination module 8002 is used to determine at least one target data verification relation group in response to a selection operation on a data verification relation group;

[0139] The verification module 8003 is used to verify the relationship group for each of the target data and perform the following operations respectively:

[0140] Determine the target local data table and the target third-party data table in the target data verification relationship group;

[0141] Query the data verification conditions corresponding to the target data verification relationship group;

[0142] Based on the data verification conditions, the target local data table and the target third-party data table are verified to obtain the verification results.

[0143] In some possible embodiments, the relationship determination module 8002, after performing a selection operation on the data verification relationship group and determining the target data verification relationship group, is further configured to:

[0144] In response to a user-inputted add operation, determine the new data table corresponding to the add operation and the target data verification relationship group corresponding to the add operation;

[0145] Determine the category of the newly added data table; the category includes: local data table, third-party data table;

[0146] Add the newly added data table to the corresponding category in the target data verification relationship group corresponding to the add operation.

[0147] In some possible embodiments, the data verification conditions include multiple conditions, and the verification module 8003 is configured to perform data verification on the target local data table and the target third-party data table based on the data verification conditions as follows:

[0148] Perform the following for each data verification condition:

[0149] Determine the verification parameters for the data verification conditions;

[0150] The verification method is determined based on the verification parameters; the verification method includes one or a combination of the following: self-data verification, automatic data verification;

[0151] The target local data table and the target third-party data table are verified based on the verification method.

[0152] In some possible embodiments, if the verification method is automatic data verification, then when the verification module 8003 performs data verification on the target local data table and the target third-party data table based on the verification method, it is configured as follows:

[0153] Determine the sum of the values ​​of the same field in each target local data table, and determine the sum of the values ​​of the same field in each target third-party data table;

[0154] The sum of the field values ​​of the same field in each target local data table is compared with the sum of the field values ​​of the same field in each target third-party data table.

[0155] In some possible embodiments, if the verification method is a self-data verification, then when the verification module 8003 performs data verification on the target local data table and the target third-party data table based on the verification method, it is configured as follows:

[0156] Determine the category of the self-data verification; the category is either local data self-data verification or third-party data self-data verification;

[0157] If the category is local data self-data verification, then the resource data and data direction in each target local data table are compared respectively;

[0158] If the category is a self-check of other party data, then the resource data in each target other party data table is compared with the data direction.

[0159] In some possible embodiments, after the verification module 8003 determines the target local data table and the target third-party data table in the target data verification relationship group, it is further configured to:

[0160] Update the data verification status of each of the target local data tables to "data verification in progress";

[0161] Update the data verification status of each of the target third-party data tables to "data verification in progress".

[0162] In some possible embodiments, the verification module 8003 performs data verification on the target local data table and the target third-party data table based on the data verification conditions, and after obtaining the verification result, it is further configured to:

[0163] Update the data verification status of each target local data table to the data verification completed status; and

[0164] Update the data verification status of each of the target third-party data tables to the data verification completed status.

[0165] Having described the data verification method and apparatus according to exemplary embodiments of this application, we will now describe an electronic device according to another exemplary embodiment of this application.

[0166] Those skilled in the art will understand that various aspects of this application can be implemented as a system, method, or program product. Therefore, various aspects of this application can be specifically implemented in the following forms: a completely hardware implementation, a completely software implementation (including firmware, microcode, etc.), or a combination of hardware and software implementations, collectively referred to herein as a "circuit," "module," or "system."

[0167] In some possible implementations, the electronic device according to this application may include at least one processor and at least one memory. The memory stores program code that, when executed by the processor, causes the processor to perform the steps in the data verification methods according to the various exemplary embodiments of this application described above.

[0168] The following reference Figure 9 To describe an electronic device 130 according to this embodiment of the present application. Figure 9 The electronic device 130 shown is merely an example and should not impose any limitations on the functionality and scope of use of the embodiments of this application.

[0169] like Figure 9 As shown, the electronic device 130 is presented in the form of a general-purpose electronic device. The components of the electronic device 130 may include, but are not limited to: at least one processor 131, at least one memory 132, and a bus 133 connecting different system components (including memory 132 and processor 131).

[0170] Bus 133 represents one or more of several bus structures, including a memory bus or memory controller, peripheral bus, processor, or local bus using any of the various bus structures.

[0171] The memory 132 may include a readable medium in the form of volatile memory, such as random access memory (RAM) 1321 and / or cache memory 1322, and may further include read-only memory (ROM) 1323.

[0172] The memory 132 may also include a program / utility 1325 having a set (at least one) of program modules 1324, including but not limited to: an operating system, one or more application programs, other program modules, and program data, each or some combination of these examples may include an implementation of a network environment.

[0173] Electronic device 130 can also communicate with one or more external devices 134 (e.g., keyboard, pointing device, etc.), and with one or more devices that enable a user to interact with electronic device 130, and / or with any device that enables electronic device 130 to communicate with one or more other electronic devices (e.g., router, modem, etc.). This communication can be performed via input / output (I / O) interface 135. Furthermore, electronic device 130 can also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN), and / or public networks, such as the Internet) via network adapter 136. As shown, network adapter 136 communicates with other modules used by electronic device 130 via bus 133. It should be understood that, although... Figure 9 As not shown, other hardware and / or software modules may be used in conjunction with electronic device 130, including but not limited to: microcode, device drivers, redundant processors, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0174] In some possible implementations, various aspects of the data verification method provided in this application can also be implemented in the form of a program product, which includes program code that, when the program product is run on a computer device, causes the computer device to perform the steps in the data verification method according to the various exemplary embodiments of this application described above.

[0175] The program product may employ any combination of one or more readable media. A readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples (a non-exhaustive list) of readable storage media include: electrical connections having one or more wires, portable disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof.

[0176] The program product for data verification according to the embodiments of this application can be a portable compact disc read-only memory (CD-ROM) and include program code, and can run on an electronic device. However, the program product of this application is not limited to this. In this document, the readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

[0177] A readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, carrying readable program code. This propagated data signal may take many forms, including—but not limited to—electromagnetic signals, optical signals, or any suitable combination thereof. A readable signal medium may also be any readable medium other than a readable storage medium, capable of sending, propagating, or transmitting a program for use by or in conjunction with an instruction execution system, apparatus, or device.

[0178] The program code contained on the readable medium may be transmitted using any suitable medium, including—but not limited to—wireless, wired, fiber optic, RF, etc., or any suitable combination thereof.

[0179] Program code for performing the operations of this application can be written in any combination of one or more programming languages, including object-oriented programming languages ​​such as Java and C++, and conventional procedural programming languages ​​such as C or similar languages. The program code can execute entirely on the user's electronic device, partially on the user's device, as a standalone software package, partially on the user's electronic device and partially on a remote electronic device, or entirely on a remote electronic device or server. In cases involving remote electronic devices, the remote electronic device can be connected to the user's electronic device via any type of network—including a local area network (LAN) or a wide area network (WAN)—or can be connected to an external electronic device (e.g., via the Internet using an Internet service provider).

[0180] It should be noted that although several units or sub-units of the device have been mentioned in the detailed description above, this division is merely exemplary and not mandatory. In fact, according to embodiments of this application, the features and functions of two or more units described above can be embodied in one unit. Conversely, the features and functions of one unit described above can be further divided and embodied by multiple units.

[0181] Furthermore, although the operations of the method of this application are described in a specific order in the accompanying drawings, this does not require or imply that these operations must be performed in that specific order, or that all the operations shown must be performed to achieve the desired result. Additionally or alternatively, certain steps may be omitted, multiple steps may be combined into one step, and / or one step may be broken down into multiple steps.

[0182] Those skilled in the art will understand that embodiments of this application can be provided as methods, systems, or computer program products. Therefore, this application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, this application can take the form of a computer program product embodied on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0183] This application is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to this application. It should be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0184] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0185] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0186] 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 collation method, characterized by, The method comprises: in response to a data reconciliation operation, displaying at least one data reconciliation relationship group; the data reconciliation relationship group comprises at least one local data table and at least one other party data table; in response to a selection operation on the data reconciliation relationship group, determining at least one target data reconciliation relationship group; for each target data reconciliation relationship group, the following operations are performed respectively: determine the target local data table and the target other party data table in the target data reconciliation relationship group; query the data reconciliation condition corresponding to the target data reconciliation relationship group; based on the data reconciliation condition, data reconciliation is performed on the target local data table and the target other party data table to obtain a reconciliation result; after determining the target data reconciliation relationship group in response to the selection operation on the data reconciliation relationship group, the method further comprises: in response to an addition operation triggered by the user for the target data reconciliation relationship group, determining a new data table corresponding to the addition operation; determine the category of the new data table; the category includes: local data table, other party data table; add the new data table to the corresponding category in the target data reconciliation relationship group; The data reconciliation condition comprises a plurality of, the data reconciliation condition, the target local data table and the target other party data table are reconciled based on the data reconciliation condition, comprising: for each data reconciliation condition, the following operations are performed: determine the reconciliation parameter of the data reconciliation condition; determine the reconciliation method based on the reconciliation parameter; the reconciliation method comprises one or a combination of the following: self data reconciliation, automatic data reconciliation; based on the reconciliation method, the target local data table and the target other party data table are reconciled.

2. The data collation method according to claim 1, characterized by, If the reconciliation method is automatic data reconciliation, then the target local data table and the target other party data table are reconciled based on the reconciliation method, comprising: determine the cumulative sum of the field values of the same field in each target local data table, and determine the cumulative sum of the field values of the same field in each target other party data table; compare the cumulative sum of the field values of the same field in each target local data table with the cumulative sum of the field values of the same field in each target other party data table.

3. The data collation method according to claim 1, characterized by, If the reconciliation method is self data reconciliation, then the target local data table and the target other party data table are reconciled based on the reconciliation method, comprising: determine the category of the self data reconciliation; the category is local data self data reconciliation or other party data self data reconciliation; if the category is local data self data reconciliation, compare the resource data and data direction in each target local data table respectively; if the category is other party data self data reconciliation, compare the resource data and data direction in each target other party data table respectively.

4. The data collation method of claim 1, wherein, After determining the target local data table and the target other party data table in the target data reconciliation relationship group, the method further comprises: update the data reconciliation state in each target local data table to a data reconciliation state; updating a data reconciliation state in each of the target local data table to a data reconciliation in progress state.

5. The data collation method of claim 1, wherein, after the data reconciliation between the target local data table and the target foreign data table based on the data reconciliation condition, the method further comprises: updating the data reconciliation state in each of the target local data table to a data reconciliation completed state; and updating the data reconciliation state in each of the target foreign data table to a data reconciliation completed state.

6. A data collating apparatus characterized by comprising: The apparatus comprises: a display module configured to display at least one data reconciliation relationship group in response to a data reconciliation operation, wherein the data reconciliation relationship group comprises at least one local data table and at least one foreign data table; a relationship determination module configured to determine at least one target data reconciliation relationship group in response to a selection operation on the data reconciliation relationship group; a reconciliation module configured to perform the following operations for each of the target data reconciliation relationship group: determining a target local data table and a target foreign data table in the target data reconciliation relationship group; querying a data reconciliation condition corresponding to the target data reconciliation relationship group; performing data reconciliation between the target local data table and the target foreign data table based on the data reconciliation condition to obtain a reconciliation result; after the relationship determination module determines the target data reconciliation relationship group in response to the selection operation on the data reconciliation relationship group, the relationship determination module is further configured to: determine a new data table corresponding to an addition operation triggered by a user for the target data reconciliation relationship group; determine a category of the new data table, wherein the category comprises a local data table and a foreign data table; add the new data table to a corresponding category in the target data reconciliation relationship group. The data reconciliation condition comprises a plurality of conditions, and the reconciliation module is configured to perform data reconciliation between the target local data table and the target foreign data table based on the data reconciliation condition, and perform the following operations for each data reconciliation condition: determine a reconciliation parameter of the data reconciliation condition; determine a reconciliation method based on the reconciliation parameter, wherein the reconciliation method comprises one or a combination of the following methods: self-data reconciliation and automatic data reconciliation; perform data reconciliation between the target local data table and the target foreign data table based on the reconciliation method. If the reconciliation method is automatic data reconciliation, the reconciliation module is configured to perform data reconciliation between the target local data table and the target foreign data table based on the reconciliation method, and perform the following operations:

7. The data collating apparatus according to claim 6, wherein determine a cumulative sum of field values of the same field in each target local data table and a cumulative sum of field values of the same field in each target foreign data table; compare the cumulative sum of field values of the same field in each target local data table with the cumulative sum of field values of the same field in each target foreign data table. If the reconciliation method is self-data reconciliation, the reconciliation module is configured to perform data reconciliation between the target local data table and the target foreign data table based on the reconciliation method, and perform the following operations:

8. The data collating apparatus according to claim 6, wherein ​ determining a category of the self-data check; the category is local data self-data check or other-party data self-data check; if the category is local data self-data check, comparing resource data and data direction in each target local data table respectively; if the category is other-party data self-data check, comparing resource data and data direction in each target other-party data table respectively.

9. The data collating apparatus according to claim 6, wherein The check module, after performing determining target local data tables and target other-party data tables in the target data check relationship group, is further configured to: updating data check state in each target local data table to data check in progress state; updating data check state in each target other-party data table to data check in progress state.

10. The data collating apparatus according to claim 6, wherein The check module, after performing data check on the target local data tables and the target other-party data tables based on the data check condition to obtain a check result, is further configured to: updating data check state in each target local data table to data check complete state; and updating data check state in each target other-party data table to data check complete state.

11. An electronic device, comprising: comprising: a memory for storing program instructions; a processor for invoking the program instructions stored in the memory to perform steps included in the data check method according to the obtained program instructions.

12. A computer-readable storage medium, characterized in that, The computer readable storage medium stores a computer program, the computer program includes program instructions, and the program instructions, when executed by a computer, cause the computer to perform the data check method as claimed in any one of claims 1-5.

13. A computer program product, characterised in that, The computer program product includes: computer program code, when the computer program code runs on a computer, causes the computer to perform the data check method as claimed in any one of claims 1-5.

Images