A method, device, equipment and storage medium for checking supplementary data

Abstract

The present invention provides a method, device, equipment and storage medium for checking supplementary data, the method comprising: obtaining a supplementary task information table to be checked; determining control condition information corresponding to the supplementary task information table according to the supplementary task information table; and checking each supplementary task in the supplementary task information table based on the control condition information to obtain a corresponding checking result. The supplementary data checking method of the present invention, by pre-generating a supplementary task information table, determines corresponding control condition information according to the supplementary task information table when checking supplementary data, and uses the control condition information to check supplementary data, can automatically identify supplementary tasks that still need supplementary data, solves the problem of no unified supplementary data identification standard, and can also improve the accuracy and efficiency of supplementary data checking, thereby ensuring the accuracy and efficiency of data migration.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a method, device, equipment and storage medium for checking supplementary data. Background Art

[0002] In order to provide customers with high-quality and fast services, banks generally adopt an IT architecture strategy in which data and systems are centrally deployed in data centers. Currently, business data in the old system will be migrated to the new system before the new IT system is put into production. However, due to the large amount of data, data may be missed during the data migration process, such as contract details, sub-contracts, and cost information derived from the main product contract. These missed data need to be analyzed and supplemented.

[0003] In the prior art, during the data supplementation process, the control method for the data supplementation task is: technical or business personnel in various fields analyze the database tables and detailed data involved in the field, determine the tables and data that need to be supplemented, and feed back the respective analysis results to the project management personnel for unified progress control. In the prior art, there is no effective and relatively complete control method for the data supplementation process, which completely relies on the experience and ability of technical or business personnel, and there is no unified supplementation task standard, which leads to low accuracy in the identification of supplementary data, and the project management personnel cannot fully control the situation and progress of data supplementation, resulting in low efficiency and poor accuracy of data migration, and it is difficult to ensure the data integrity of the newly built IT system when it goes online. Summary of the invention

[0004] In view of the above-mentioned problems in the prior art, an object of the present invention is to provide a method, device, equipment and storage medium for checking supplementary data, which can improve the accuracy and efficiency of checking supplementary data.

[0005] In order to solve the above problems, the present invention provides a method for checking supplementary data, comprising:

[0006] Get the supplementary recording task information table to be checked;

[0007] According to the supplementary recording task information table, determining the control condition information corresponding to the supplementary recording task information table;

[0008] Based on the control condition information, each supplementary recording task in the supplementary recording task information table is checked respectively to obtain a corresponding checking result.

[0009] Further, the determining, according to the supplementary recording task information table, the control condition information corresponding to the supplementary recording task information table includes:

[0010] Determine the supplementary recording task type corresponding to the supplementary recording task information table;

[0011] The control condition information corresponding to the supplementary recording task information table is determined based on the supplementary recording task type.

[0012] Further, the determining of the control condition information corresponding to the supplementary recording task information table based on the supplementary recording task type includes:

[0013] When the supplementary recording task type is a field control type, the control condition information includes a control field name field and its corresponding control field content;

[0014] When the supplementary recording task type is a quantity control type, the control condition information includes supplementary recording quantity control information;

[0015] When the supplementary recording task type is a mixed control type, the control condition information includes supplementary recording quantity control information, a control field name field and its corresponding control field content.

[0016] Furthermore, the checking of each supplementary recording task in the supplementary recording task information table based on the control condition information to obtain corresponding checking results includes:

[0017] When the supplementary recording task type is a field control type, for each supplementary recording task in the supplementary recording task information table, obtaining the actual field content of the control field name field corresponding to the supplementary recording task;

[0018] Determining whether the actual field content matches the control field content;

[0019] If there is no match, the verification result is determined to be passed; if there is a match, it is determined whether there is supplementary recording data corresponding to the supplementary recording task in the supplementary recording log;

[0020] If it exists, the check result is determined to be passed; if it does not exist, the check result is determined to be failed.

[0021] Furthermore, the checking of each supplementary recording task in the supplementary recording task information table based on the control condition information to obtain corresponding checking results includes:

[0022] When the supplementary recording task type is a quantity control type, for each supplementary recording task in the supplementary recording task information table, obtaining a target supplementary recording quantity corresponding to the supplementary recording task based on the supplementary recording quantity control information;

[0023] Determining the amount of supplementary recording data corresponding to the supplementary recording task in the supplementary recording record log;

[0024] Determining whether the quantity of the supplementary recording data matches the target supplementary recording quantity;

[0025] If they match, the check result is determined to be passed; if they do not match, the check result is determined to be failed.

[0026] Furthermore, the checking of each supplementary recording task in the supplementary recording task information table based on the control condition information to obtain corresponding checking results includes:

[0027] When the supplementary recording task type is a mixed control type, for each supplementary recording task in the supplementary recording task information table, a first checking process and a second checking process are respectively performed; if the checking results of the first checking process and the second checking process are both passed, the checking result is determined to be passed; if the checking result of the first checking process or the second checking process is not passed, the checking result is determined to be not passed;

[0028] The first verification process includes:

[0029] Obtaining the actual field content of the control field name field corresponding to the supplementary recording task;

[0030] Determining whether the actual field content matches the control field content;

[0031] If there is no match, the verification result is determined to be passed; if there is a match, it is determined whether there is supplementary recording data corresponding to the supplementary recording task in the supplementary recording log;

[0032] If it exists, the verification result is determined to be passed; if it does not exist, the verification result is determined to be failed;

[0033] The second verification process includes:

[0034] Acquire a target supplementary recording quantity corresponding to the supplementary recording task based on the supplementary recording quantity control information;

[0035] Determining the amount of supplementary recording data corresponding to the supplementary recording task in the supplementary recording record log;

[0036] Determining whether the quantity of the supplementary recording data matches the target supplementary recording quantity;

[0037] If they match, the check result is determined to be passed; if they do not match, the check result is determined to be failed.

[0038] Furthermore, the method further comprises:

[0039] When at least one supplementary recording task has a failed verification result, the data information of the supplementary recording task with a failed verification result is saved in the supplementary recording task detail table.

[0040] And the supplementary recording verification status of the supplementary recording task information table is set to an abnormal state.

[0041] Furthermore, the method further comprises:

[0042] Constructing a supplementary recording data control table, wherein the supplementary recording data control table includes a supplementary recording task type field;

[0043] Based on the configuration instruction of the user, configure the supplementary recording task type corresponding to the supplementary recording task type field;

[0044] According to the supplementary recording task type, corresponding control condition information is configured for the supplementary recording data control table to obtain a target supplementary recording data control table;

[0045] A supplementary recording task information table is generated based on the target supplementary recording data control table.

[0046] Another aspect of the present invention provides a supplementary data checking device, comprising:

[0047] A supplementary recording task information table acquisition module is used to obtain the supplementary recording task information table to be checked;

[0048] A control condition information determination module, used to determine the control condition information corresponding to the supplementary recording task information table according to the supplementary recording task information table;

[0049] The data verification module is used to verify each supplementary recording task in the supplementary recording task information table based on the control condition information to obtain corresponding verification results.

[0050] Another aspect of the present invention provides an electronic device, including a processor and a memory, wherein the memory stores at least one instruction or at least one program, and the at least one instruction or the at least one program is loaded and executed by the processor to implement the supplementary data verification method as described above.

[0051] On the other hand, the present invention provides a computer-readable storage medium, in which at least one instruction or at least one program is stored, and the at least one instruction or the at least one program is loaded and executed by a processor to implement the supplementary data verification method as described above.

[0052] Due to the above technical solution, the present invention has the following beneficial effects:

[0053] According to the method for verifying supplementary data in an embodiment of the present invention, a supplementary recording task information table is generated in advance. When verifying supplementary recording data, corresponding control condition information is determined according to the supplementary recording task information table, and the control condition information is used to verify supplementary recording data. This can automatically identify supplementary recording tasks that still require supplementary recording of data, solve the problem of no unified supplementary recording data identification standard, and improve the accuracy and efficiency of supplementary recording data verification, thereby ensuring the accuracy and efficiency of data migration. BRIEF DESCRIPTION OF THE DRAWINGS

[0054] In order to more clearly illustrate the technical solution of the present invention, the following briefly introduces the drawings required for use in the embodiments or prior art descriptions. Obviously, the drawings described below are only some embodiments of the present invention, and for those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative work.

[0055] Figure 1 is a flow chart of a method for checking supplementary data provided by an embodiment of the present invention;

[0056] Figure 2 is a flow chart of a method for checking supplementary data provided by another embodiment of the present invention;

[0057] Figure 3 is a flow chart of a method for checking supplementary data provided by another embodiment of the present invention;

[0058] Figure 4 It is a structural schematic diagram of a supplementary data checking device provided by an embodiment of the present invention;

[0059] Figure 5 is a structural schematic diagram of a supplementary data checking device provided by another embodiment of the present invention;

[0060] Figure 6 It is a schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0061] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0062] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, device, product or equipment that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or equipment.

[0063] Some embodiments of the present invention are described in detail below in conjunction with the accompanying drawings.

[0064] Reference Manual Attached Figure 1 , which shows the process of a supplementary data verification method provided by an embodiment of the present invention, which can be applied to the scenario of IT system business data migration to manage and control the supplementary data tasks in the new system. Figure 1 As shown, the method may include the following steps:

[0065] S110: Obtaining the supplementary recording task information table to be checked.

[0066] In an embodiment of the present invention, the supplementary recording task information table includes supplementary recording task information that needs to be performed after data migration. The supplementary recording task information table can be pre-generated according to the data of the new system after data migration and stored in a database. When supplementary data verification is required, the supplementary recording task information table is obtained from the database. It should be noted that the embodiment of the present invention does not limit the specific content of the supplementary recording task. Exemplarily, the supplementary recording tasks may include the supplementary recording tasks of "Export Credit-from Contract" in the field of public credit business, the supplementary recording tasks of "Letter of Guarantee-Contract" in the field of public credit business, the supplementary recording tasks of "Export Credit-Business and Collateral Relationship" in the field of public credit business, and so on.

[0067] In an embodiment of the present invention, the supplementary recording task information table to be checked can be obtained at preset intervals to perform supplementary recording data verification, for example, the supplementary recording task information table can be checked once a day; the supplementary recording task information table to be checked can also be obtained at irregular intervals, and the supplementary recording data can be checked; or the supplementary recording task information table to be checked can be obtained based on a data verification instruction issued by a user to perform supplementary recording data verification, and the embodiment of the present invention does not limit this.

[0068] In a possible embodiment, in conjunction with the reference specification, Figure 2, the step S110 may also include a process of generating a supplementary recording task information table, specifically, as follows Figure 2 As shown, the process of generating the supplementary recording task information table may include the following steps:

[0069] S210: Constructing a supplementary recording data control table, wherein the supplementary recording data control table includes a supplementary recording task type field.

[0070] Specifically, the structure of the supplementary data control table can be pre-defined, and the supplementary data control table may include information fields and control fields. The information fields may include fields such as business product field, product name, database name, data table name, and primary key and foreign key information. The control fields may include fields such as supplementary task type and control condition information. The control condition information may include a control field name field and its corresponding control field content, or the control condition information may include supplementary quantity control information.

[0071] Optionally, the control condition information may be one or more, wherein the control field name and the corresponding control field content constitute one control condition information. Exemplarily, if considering ease of use, three control condition information may be set.

[0072] Optionally, taking scalability into consideration, a control condition sub-table may be defined and associated with the supplementary data control table, and the control condition sub-table may include at least one control condition information field.

[0073] Specifically, after the definition of the supplementary data control table is completed, the supplementary data control table can be initialized. Specifically, the data table information and database structure definition files of each business field in the new system can be imported into the supplementary data control table to ensure that the business product field information, product name information, database name, data table name, primary key and foreign key information are complete. After importing, it can be confirmed by the domain architect or expert of the corresponding business field.

[0074] S220: Based on the configuration instruction of the user, configure the supplementary recording task type corresponding to the supplementary recording task type field.

[0075] Specifically, after the initialization of the supplementary recording data control table is completed, the corresponding supplementary recording task type can be determined based on the user's configuration instructions and configured. In actual applications, the domain architects or experts in each business field can set the supplementary recording task type for the supplementary recording data control table after initialization and import. For example, a visual interface for supplementary recording data verification can be provided. When the supplementary recording task type corresponding to the supplementary recording data control table input or selected by the domain architects or experts in each business field based on the visual page is obtained, a configuration instruction is generated, and the supplementary recording task type configuration is performed based on the configuration instruction.

[0076] S230: According to the supplementary recording task type, corresponding control condition information is configured for the supplementary recording data control table to obtain a target supplementary recording data control table.

[0077] Specifically, when the supplementary recording task type of the supplementary recording data control table is a field control type (CF type task), at least one control field name and corresponding control field content can be defined and configured, for example, the control field name can be "guarantee method" and the control field content can be "mortgage and pledge method". When the supplementary recording task type of the supplementary recording data control table is a number control type (CC type task), at least one supplementary recording quantity control information can be defined and configured, for example, the supplementary recording quantity control information can be the number of stock data in the old system or the number of data of some other associated master information. When the supplementary recording task type of the supplementary recording data control table is a mixed control type (CX type task), at least one control field name and corresponding control field content, and at least one supplementary recording quantity control information can be defined and configured. When the supplementary recording task type of the supplementary recording data control table is a UC type task, there is no need to define and configure control condition information.

[0078] S240: Generate a supplementary recording task information table based on the target supplementary recording data control table.

[0079] Specifically, the structure of the supplementary recording task information table can be predefined, and the supplementary recording task information table may include fields such as supplementary recording task information (task identification information, task name, etc.), field, product information, supplementary recording task type, and supplementary recording verification status. The content of the target supplementary recording data control table can be directly brought into the structure of the supplementary recording task information table to obtain the content of the supplementary recording task information table, wherein the task identification information is the primary key, and the task name is the product field + product name + table Chinese name. When the supplementary recording task type of the target supplementary recording data control table is the UC type, there is no need to generate the supplementary recording task information table.

[0080] The embodiment of the present invention utilizes a pre-built configurable supplementary recording data control table structure to configure different supplementary recording task types and corresponding control condition information based on different configuration instructions of the user, and finally generates a supplementary recording task information table for different supplementary recording task types. Multiple supplementary recording task information tables can be generated using one supplementary recording data control table structure, which has good universality, can reduce design and development costs, and save system resources.

[0081] It should be noted that the above method for generating the supplementary recording task information table does not constitute a limitation on the embodiment of the present invention, and the supplementary recording task information table of the embodiment of the present invention may also be generated by other methods.

[0082] S120: Determine control condition information corresponding to the supplementary recording task information table according to the supplementary recording task information table.

[0083] In an embodiment of the present invention, the supplementary recording task information table can be divided into different supplementary recording task types based on the data information in the supplementary recording task information table. Different types of control condition information can be determined for the supplementary recording task information tables of different supplementary recording task types. One or more control condition information can be determined for one supplementary recording task information table. The embodiment of the present invention does not limit the number of control condition information corresponding to the supplementary recording task information table.

[0084] Specifically, determining the control condition information corresponding to the supplementary recording task information table according to the supplementary recording task information table may include:

[0085] Obtaining the supplementary recording task type corresponding to the supplementary recording task information table;

[0086] The control condition information corresponding to the supplementary recording task information table is determined based on the supplementary recording task type.

[0087] Specifically, determining the control condition information corresponding to the supplementary recording task information table based on the supplementary recording task type may include:

[0088] When the supplementary recording task type is a field control type, the control condition information includes a control field name field and its corresponding control field content;

[0089] When the supplementary recording task type is a quantity control type, the control condition information includes supplementary recording quantity control information;

[0090] When the supplementary recording task type is a mixed control type, the control condition information includes supplementary recording quantity control information, a control field name field and its corresponding control field content.

[0091] In an embodiment of the present invention, the supplementary recording task information table may include fields such as supplementary recording task information (task identification information, task name, etc.), related fields, product information, supplementary recording task type and supplementary recording verification status. The supplementary recording task type corresponding to the supplementary recording task information table can be determined by the field information corresponding to the supplementary recording task type field. The field information corresponding to the supplementary recording task type field can be pre-configured based on the user's configuration instructions.

[0092] In an embodiment of the present invention, the supplementary recording task types may include field control type (CF type task, Control-Field: controllable supplementary recording task-field control type), number control type (CC type task, Control-Count: controllable supplementary recording task-number control type), mixed control type (CX type task, Control-miX: controllable supplementary recording task-mixed control type) and UC type task (Un-Control: uncontrollable supplementary recording task).

[0093] The number of supplementary entries required for the field control type task is determined by a field value of the main information. Take the supplementary entry task of "Export Credit-Secondary Contract" in the field of public credit business as an example. If the "Guarantee Method" field of the contract is "Credit Method", then the contract does not need to supplement the secondary contract information; if the "Guarantee Method" field of the contract is "Mortgage and Pledge Method", then the contract needs to supplement at least 1 secondary contract information.

[0094] The number of supplementary entries required for number-controlled tasks is determined by the number of basic information or other master information in the old system. For example, the number of supplementary entries is determined based on the number of basic information in the old system: Taking the supplementary entry task of "Letter of Guarantee-Contract" in the field of public credit business as an example, the number of existing data in the old system determines the number of data that needs to be supplemented; for example, the number of supplementary entries is determined based on the number of other master information: Taking the supplementary entry task of "Export Credit-Business and Collateral Relationship" in the field of public credit business as an example, each contract needs to supplement at least one business and collateral relationship, so the number of supplementary entries for business and collateral relationships should be at least greater than or equal to the number of contracts.

[0095] A mixed control type task refers to a task in which both CC and CF types exist in one supplementary recording task.

[0096] UC tasks are tasks that have no basic information and require an unknown number of supplementary entries. For example, the "Trade Finance Collateral-Collective Profile Information" of short-term financing bills (Commercial Paper, CP) has no relevant basic information in the old system.

[0097] In an embodiment of the present invention, determining the control condition information corresponding to the supplementary recording task information table based on the supplementary recording task type may be determining the control condition information based on the supplementary recording task type and data in the supplementary recording task information table, or may be obtaining the control condition information corresponding to the supplementary recording task information table pre-configured according to the supplementary recording task type, and the embodiment of the present invention is not limited to this.

[0098] Exemplarily, assuming that the supplementary recording task information table is of a column control type, and the data in the table is a supplementary recording task in the field of corporate credit business "Export Finance and Credit - From Contract", then it can be determined that the control column name field of the control condition information is "Guarantee Method", and the corresponding control column content is "Mortgage and Pledge Method". Assuming that the supplementary recording task information table is of a number control type, and the data in the table is a supplementary recording task in the field of corporate credit business "Letter of Guarantee - Contract", then it can be determined that the supplementary recording quantity control information of the control condition information is "the number of existing data in the old system". Assuming that the supplementary recording task information table is of a number control type, and the data in the table is a supplementary recording task in the field of corporate credit business "Export Finance and Credit - Business and Collateral Relationship", then it can be determined that the supplementary recording quantity control information of the control condition information is "the number of associated contracts".

[0099] Exemplarily, before generating the supplementary recording task information table, the supplementary recording task type and the corresponding control condition information may be configured based on the user's configuration instructions, and when generating the supplementary recording task information table, the control condition information may be imported into the supplementary recording task information table as the corresponding control condition information.

[0100] The embodiment of the present invention divides the supplementary recording task types of the supplementary recording task information table and determines the corresponding control condition information based on the supplementary recording task types, so as to quickly and accurately determine the control condition information corresponding to each supplementary recording task information table, thereby further improving the accuracy and efficiency of the supplementary recording data verification.

[0101] S130: Checking each supplementary recording task in the supplementary recording task information table based on the control condition information to obtain corresponding checking results.

[0102] In the embodiment of the present invention, different verification strategies can be used to perform data verification for supplementary recording task information tables of different supplementary recording task types. When all supplementary recording tasks in the supplementary recording task information table are verified, the supplementary recording task information table is verified to be passed; if at least one supplementary recording task fails to be verified, the supplementary recording task information table is verified to be failed.

[0103] In an embodiment of the present invention, the supplementary recording log generated by the data supplementary recording can be used to check each supplementary recording task separately. If the data supplementary recording is performed through a supplementary recording system, the supplementary recording log of the supplementary recording system can be used for verification. If the supplementary recording is imported through a table, the supplementary recording table can be used for verification.

[0104] In the embodiment of the present invention, the checking of each supplementary recording task in the supplementary recording task information table based on the control condition information to obtain the corresponding checking result may include:

[0105] When the supplementary recording task type is a field control type, for each supplementary recording task in the supplementary recording task information table, obtaining the actual field content of the control field name field corresponding to the supplementary recording task;

[0106] Determining whether the actual field content matches the control field content;

[0107] If there is no match, the verification result is determined to be passed; if there is a match, it is determined whether there is supplementary recording data corresponding to the supplementary recording task in the supplementary recording log;

[0108] If it exists, the check result is determined to be passed; if it does not exist, the check result is determined to be failed.

[0109] Specifically, it can be determined whether the actual field content is the same as the control field content; if they are not the same, it means that the supplementary recording task does not require data supplementation, and the verification is passed; when they are the same, it means that the supplementary recording task needs data supplementation. At this time, it can be determined whether there is a corresponding record in the supplementary recording log. If so, it means that the supplementary recording task has completed the supplementary recording, and the verification is passed. If not, it means that the supplementary recording task still needs to supplement data, and the verification fails.

[0110] It should be noted that, when there are multiple control condition information, each supplementary recording task can be checked for each control condition information respectively, and if all the checks are passed, the check result of the supplementary recording task is determined to be passed.

[0111] In the embodiment of the present invention, the checking each supplementary recording task in the supplementary recording task information table based on the control condition information to obtain the corresponding checking result may also include:

[0112] When the supplementary recording task type is a quantity control type, for each supplementary recording task in the supplementary recording task information table, obtaining a target supplementary recording quantity corresponding to the supplementary recording task based on the supplementary recording quantity control information;

[0113] Determining the amount of supplementary recording data corresponding to the supplementary recording task in the supplementary recording record log;

[0114] Determining whether the quantity of the supplementary recording data matches the target supplementary recording quantity;

[0115] If they match, the check result is determined to be passed; if they do not match, the check result is determined to be failed.

[0116] Specifically, the target supplementary recording quantity corresponding to the supplementary recording task and the corresponding matching strategy can be determined according to the supplementary recording quantity control information, and the quantity of the supplementary recording record data is matched with the target supplementary recording quantity using the matching strategy to obtain a matching result.

[0117] In practical applications, multiple supplementary recording quantity control information and their corresponding matching strategies may be predefined, and after the supplementary recording quantity control information of the supplementary recording task information table is determined, the corresponding matching strategy may be determined. Alternatively, after the supplementary recording quantity control information of the supplementary recording task information table is determined, the content of the supplementary recording quantity control information may be analyzed to determine the corresponding matching strategy.

[0118] It should be noted that different supplementary recording quantity control information may correspond to different matching strategies or may correspond to the same matching strategy, which is not limited in the embodiment of the present invention.

[0119] Exemplarily, assuming that the supplementary recording quantity control information corresponding to the supplementary recording task information table is "the number of existing data in the old system", then the target supplementary recording quantity corresponding to the supplementary recording task is the number of existing data corresponding to the supplementary recording task in the old system, and the matching strategy is to determine whether the number of supplementary recording record data corresponding to the supplementary recording task is the same as the target supplementary recording quantity. If they are the same, it is considered that the two match, indicating that the supplementary recording task has completed the supplementary recording and the verification has passed. If they are not the same, it is considered that the two do not match, indicating that there is still data that needs to be supplemented in the supplementary recording task and the verification has failed. Assuming that the supplementary recording quantity control information corresponding to the supplementary recording task information table is the "number of associated contracts", then the target supplementary recording quantity corresponding to the supplementary recording task is the number of contracts associated with the supplementary recording task, and the matching strategy is to determine whether the number of supplementary recording record data corresponding to the supplementary recording task is greater than or equal to the target supplementary recording quantity. If the number of supplementary recording record data is greater than or equal to the target supplementary recording quantity, the two are considered to match, indicating that the supplementary recording task has been completed and the verification has passed; if the number of supplementary recording record data is less than the target supplementary recording quantity, the two are considered to not match, indicating that there is still data that needs to be supplemented in the supplementary recording task and the verification has failed.

[0120] It should be noted that, when there are multiple control condition information, each supplementary recording task can be checked for each control condition information respectively, and if all the checks are passed, the check result of the supplementary recording task is determined to be passed.

[0121] In the embodiment of the present invention, the checking each supplementary recording task in the supplementary recording task information table based on the control condition information to obtain the corresponding checking result may also include:

[0122] When the supplementary recording task type is a mixed control type, for each supplementary recording task in the supplementary recording task information table, a first checking process and a second checking process are respectively performed; if the checking results of the first checking process and the second checking process are both passed, the checking result is determined to be passed; if the checking result of the first checking process or the second checking process is not passed, the checking result is determined to be not passed;

[0123] The first verification process includes:

[0124] Obtaining the actual field content of the control field name field corresponding to the supplementary recording task;

[0125] Determining whether the actual field content matches the control field content;

[0126] If there is no match, the verification result is determined to be passed; if there is a match, it is determined whether there is supplementary recording data corresponding to the supplementary recording task in the supplementary recording log;

[0127] If it exists, the verification result is determined to be passed; if it does not exist, the verification result is determined to be failed;

[0128] The second verification process includes:

[0129] Acquire a target supplementary recording quantity corresponding to the supplementary recording task based on the supplementary recording quantity control information;

[0130] Determining the amount of supplementary recording data corresponding to the supplementary recording task in the supplementary recording record log;

[0131] Determining whether the quantity of the supplementary recording data matches the target supplementary recording quantity;

[0132] If they match, the check result is determined to be passed; if they do not match, the check result is determined to be failed.

[0133] Specifically, the specific content of the first verification process can refer to the verification process when the supplementary recording task type is the column control type, and the specific content of the second verification process can refer to the verification process when the supplementary recording task type is the number control type. The embodiment of the present invention will not be repeated here. It should be noted that the first verification process and the second verification process can be performed in sequence according to the above order, or can also be performed simultaneously, or can also be performed in other orders, and the embodiment of the present invention does not limit this.

[0134] In one possible embodiment, Figure 3 As shown, the method may further include the following steps:

[0135] S140: When there is at least one supplementary recording task whose verification result is failed, data information of the supplementary recording task whose verification result is failed is saved to the supplementary recording task detail table, and the supplementary recording verification status of the supplementary recording task information table is set to an abnormal status.

[0136] Specifically, the supplementary recording task details table may include detailed information related to the supplementary recording task, such as database table information, data primary key value, actual number of supplementary recording data, etc. When the verification results of all supplementary recording tasks are passed, the supplementary recording verification status of the supplementary recording task information table may be set to passed.

[0137] Specifically, when there is at least one supplementary recording task whose verification result is failed, it means that there are still supplementary recording tasks that need to perform data supplementation in the supplementary recording task information table, and the supplementary recording data task table has not passed the verification. The supplementary recording verification status of the supplementary recording task information table is set to an abnormal status, so that the user can quickly determine the status of the supplementary recording task information table, and save the data information of the supplementary recording tasks with failed verification results to the supplementary recording task details table, so that the user can perform data supplementation in a targeted manner and improve the efficiency of data supplementation. It can also enable the user to quickly understand the number and type of supplementary recording tasks and track different types of supplementary recording tasks, so as to effectively manage and control the progress of data supplementation, thereby improving the effectiveness and efficiency of data supplementary recording task management, thereby improving the efficiency of the data migration process.

[0138] Specifically, the supplementary recording task information table and the supplementary recording task details table can also be displayed in the form of an overall view, so that users can view the status of data supplementary recording work, so that users can timely and effectively control the situation and progress of data supplementary recording through a global view, and ensure the accuracy and efficiency of data migration.

[0139] To sum up, according to the method for verifying supplementary data in an embodiment of the present invention, a supplementary recording task information table is generated in advance. When verifying supplementary recording data, the corresponding control condition information is determined according to the supplementary recording task information table, and the control condition information is used to verify the supplementary recording data. This can automatically identify the supplementary recording tasks that still need supplementary recording, solve the problem of no unified supplementary recording data identification standard, and can also improve the accuracy and efficiency of supplementary recording data verification, thereby ensuring the accuracy and efficiency of data migration.

[0140] Reference Manual Attached Figure 4 , which shows the structure of a supplementary data checking device 400 provided by an embodiment of the present invention. Figure 4 As shown, the apparatus 400 may include:

[0141] The supplementary recording task information table acquisition module 410 is used to acquire the supplementary recording task information table to be checked;

[0142] A control condition information determination module 420, configured to determine the control condition information corresponding to the supplementary recording task information table according to the supplementary recording task information table;

[0143] The data checking module 430 is used to check each supplementary recording task in the supplementary recording task information table based on the control condition information to obtain corresponding checking results.

[0144] In one possible embodiment, Figure 5 As shown, the device 400 may further include:

[0145] The data processing module 440 is used to save the data information of the supplementary recording task with the failed verification result to the supplementary recording task details table when there is at least one supplementary recording task with the failed verification result, and set the supplementary recording verification status of the supplementary recording task information table to an abnormal state.

[0146] In a possible embodiment, the device 400 may further include:

[0147] A supplementary recording data control table construction module is used to construct a supplementary recording data control table, wherein the supplementary recording data control table includes a supplementary recording task type field;

[0148] A supplementary recording task type configuration module, used to configure the supplementary recording task type corresponding to the supplementary recording task type field based on the user's configuration instruction;

[0149] A control condition information configuration module, configured to configure corresponding control condition information for the supplementary recording data control table according to the supplementary recording task type, so as to obtain a target supplementary recording data control table;

[0150] The supplementary recording task information table generating module is used to generate a supplementary recording task information table based on the target supplementary recording data control table.

[0151] It should be noted that the device provided in the above embodiment, when implementing its functions, only uses the division of the above functional modules as an example. In actual applications, the above functions can be assigned to different functional modules as needed, that is, the internal structure of the device is divided into different functional modules to complete all or part of the functions described above. In addition, the device provided in the above embodiment and the corresponding method embodiment belong to the same concept, and the specific implementation process is detailed in the corresponding method embodiment, which will not be repeated here.

[0152] An embodiment of the present invention also provides an electronic device, which includes a processor and a memory, wherein the memory stores at least one instruction or at least one program, and the at least one instruction or the at least one program is loaded and executed by the processor to implement the supplementary data verification method provided in the above method embodiment.

[0153] The memory can be used to store software programs and modules. The processor executes various functional applications and data processing by running the software programs and modules stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, application programs required for functions, etc.; the data storage area can store data created according to the use of the device, etc. In addition, the memory can include a high-speed random access memory and can also include a non-volatile memory, such as at least one disk storage device, a flash memory device, or other volatile solid-state storage devices. Accordingly, the memory can also include a memory controller to provide the processor with access to the memory.

[0154] The method embodiments provided in the embodiments of the present invention may be executed in a terminal, a server or a similar computing device, that is, the electronic device may include a terminal, a server or a similar computing device. Figure 6 As shown, it shows a schematic diagram of the structure of a server for implementing a method for checking supplementary data provided by an embodiment of the present invention. The server 600 may have relatively large differences due to different configurations or performances, and may include one or more central processing units (CPU) 610 (for example, one or more processors) and a memory 630, and one or more storage media 620 (for example, one or more mass storage devices) storing application programs 623 or data 622. Among them, the memory 630 and the storage medium 620 can be short-term storage or permanent storage. The program stored in the storage medium 620 may include one or more modules, and each module may include a series of instruction operations on the server. Furthermore, the central processing unit 610 may be configured to communicate with the storage medium 620 and execute a series of instruction operations in the storage medium 620 on the server 600. The server 600 may also include one or more power supplies 660, one or more wired or wireless network interfaces 650, one or more input and output interfaces 640, and / or one or more operating systems 621, such as Windows Server™, Mac OS X™, Unix™, Linux™, FreeBSD™, etc.

[0155] The input / output interface 640 may be used to receive or send data via a network. The specific example of the network may include a wireless network provided by a communication provider of the server 600. In one example, the input / output interface 640 includes a network adapter (Network Interface Controller, NIC), which may be connected to other network devices via a base station so as to communicate with the Internet. In one example, the input / output interface 640 may be a radio frequency (RF) module, which may be used to communicate with the Internet wirelessly, and the wireless communication may use any communication standard or protocol, including but not limited to Global System of Mobilecommunication (GSM), General Packet Radio Service (GPRS), Code Division Multiple Access (CDMA), Wideband Code Division Multiple Access (WCDMA), Long Term Evolution (LTE), email, Short Messaging Service (SMS), etc.

[0156] Those skilled in the art will understand that Figure 6 The structure shown is for illustration only. The server 600 may also include Figure 6 More or fewer components as shown, or with Figure 6 Different configurations are shown.

[0157] An embodiment of the present invention also provides a computer-readable storage medium, which can be set in an electronic device to store at least one instruction or at least one program related to implementing a supplementary data verification method. The at least one instruction or the at least one program is loaded and executed by the processor to implement the supplementary data verification method provided by the above method embodiment.

[0158] Optionally, in an embodiment of the present invention, the above-mentioned storage medium may include but is not limited to: a USB flash drive, a read-only memory (ROM), a random access memory (RAM), a mobile hard disk, a magnetic disk or an optical disk, and other media that can store program codes.

[0159] An embodiment of the present invention further provides a computer program product or a computer program, the computer program product or the computer program including computer instructions, the computer instructions being stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device executes the supplementary data verification method provided in the above-mentioned various optional implementation examples.

[0160] It should be noted that the sequence of the above embodiments of the present invention is only for description and does not represent the advantages and disadvantages of the embodiments. The above describes specific embodiments of this specification. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recorded in the claims can be performed in an order different from that in the embodiments and still achieve the desired results. In addition, the processes depicted in the drawings do not necessarily require the specific order or continuous order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0161] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0162] A person skilled in the art will understand that all or part of the steps to implement the above embodiments may be accomplished by hardware or by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a disk or an optical disk, etc.

[0163] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for checking supplementary data, characterized in that: include: Get the supplementary recording task information table to be checked; Determining the control condition information corresponding to the supplementary recording task information table according to the supplementary recording task information table includes: obtaining the supplementary recording task type corresponding to the supplementary recording task information table; when the supplementary recording task type is a field control type, the control condition information includes a control field name field and its corresponding control field content; when the supplementary recording task type is a number control type, the control condition information includes supplementary recording quantity control information; when the supplementary recording task type is a mixed control type, the control condition information includes supplementary recording quantity control information, a control field name field and its corresponding control field content; Based on the control condition information, each supplementary recording task in the supplementary recording task information table is checked respectively to obtain corresponding checking results, including: When the supplementary recording task type is a field control type, for each supplementary recording task in the supplementary recording task information table, the actual field content of the control field name field corresponding to the supplementary recording task is obtained; whether the actual field content matches the control field content is determined to be matched; if not, the verification result is determined to be passed; if matched, whether there is supplementary recording record data corresponding to the supplementary recording task in the supplementary recording record log; if so, the verification result is determined to be passed; if not, the verification result is determined to be failed; When the supplementary recording task type is a number control type, for each supplementary recording task in the supplementary recording task information table, obtaining a target supplementary recording quantity corresponding to the supplementary recording task based on the supplementary recording quantity control information; determining the number of supplementary recording record data corresponding to the supplementary recording task in the supplementary recording record log; judging whether the number of the supplementary recording record data matches the target supplementary recording quantity; if they match, determining that the verification result is passed; if they do not match, determining that the verification result is failed; When the supplementary recording task type is a mixed control type, for each supplementary recording task in the supplementary recording task information table, a first checking process and a second checking process are respectively performed; if the checking results of the first checking process and the second checking process are both passed, the checking result is determined to be passed; if the checking result of the first checking process or the second checking process is not passed, the checking result is determined to be not passed; The first verification process includes: obtaining the actual field content of the control field name field corresponding to the supplementary recording task; determining whether the actual field content matches the control field content; if not, determining that the verification result is passed; if they match, determining whether there is supplementary recording record data corresponding to the supplementary recording task in the supplementary recording record log; if so, determining that the verification result is passed; if not, determining that the verification result is failed; The second verification process includes: obtaining the target supplementary recording quantity corresponding to the supplementary recording task based on the supplementary recording quantity control information; determining the number of supplementary recording record data corresponding to the supplementary recording task in the supplementary recording record log; judging whether the number of the supplementary recording record data matches the target supplementary recording quantity; if they match, determining that the verification result is passed; if they do not match, determining that the verification result is failed.

2. The method according to claim 1, characterized in that The method further comprises: When at least one supplementary recording task has a failed verification result, the data information of the supplementary recording task with a failed verification result is saved in the supplementary recording task detail table. And the supplementary recording verification status of the supplementary recording task information table is set to an abnormal state.

3. The method according to claim 1, characterized in that The method further comprises: Constructing a supplementary recording data control table, wherein the supplementary recording data control table includes a supplementary recording task type field; Based on the configuration instruction of the user, configure the supplementary recording task type corresponding to the supplementary recording task type field; According to the supplementary recording task type, corresponding control condition information is configured for the supplementary recording data control table to obtain a target supplementary recording data control table; A supplementary recording task information table is generated based on the target supplementary recording data control table.

4. A supplementary data checking device, characterized in that: include: A supplementary recording task information table acquisition module is used to obtain the supplementary recording task information table to be checked; The control condition information determination module is used to determine the control condition information corresponding to the supplementary recording task information table according to the supplementary recording task information table, including: obtaining the supplementary recording task type corresponding to the supplementary recording task information table; when the supplementary recording task type is a field control type, the control condition information includes a control field name field and its corresponding control field content; when the supplementary recording task type is a number control type, the control condition information includes supplementary recording quantity control information; when the supplementary recording task type is a mixed control type, the control condition information includes supplementary recording quantity control information, a control field name field and its corresponding control field content; The data verification module is used to verify each supplementary recording task in the supplementary recording task information table based on the control condition information to obtain a corresponding verification result, including: when the supplementary recording task type is a field control type, for each supplementary recording task in the supplementary recording task information table, obtaining the actual field content of the control field name field corresponding to the supplementary recording task; judging whether the actual field content matches the control field content; if not, determining that the verification result is passed; if they match, judging whether there is supplementary recording record data corresponding to the supplementary recording task in the supplementary recording record log; if so, determining that the verification result is passed; if not, determining that the verification result is failed; When the supplementary recording task type is a number control type, for each supplementary recording task in the supplementary recording task information table, obtaining a target supplementary recording quantity corresponding to the supplementary recording task based on the supplementary recording quantity control information; determining the number of supplementary recording record data corresponding to the supplementary recording task in the supplementary recording record log; judging whether the number of the supplementary recording record data matches the target supplementary recording quantity; if they match, determining that the verification result is passed; if they do not match, determining that the verification result is failed; When the supplementary recording task type is a mixed control type, for each supplementary recording task in the supplementary recording task information table, a first checking process and a second checking process are respectively performed; if the checking results of the first checking process and the second checking process are both passed, the checking result is determined to be passed; if the checking result of the first checking process or the second checking process is not passed, the checking result is determined to be not passed; The first verification process includes: obtaining the actual field content of the control field name field corresponding to the supplementary recording task; determining whether the actual field content matches the control field content; if not, determining that the verification result is passed; if they match, determining whether there is supplementary recording record data corresponding to the supplementary recording task in the supplementary recording record log; if so, determining that the verification result is passed; if not, determining that the verification result is failed; The second verification process includes: obtaining the target supplementary recording quantity corresponding to the supplementary recording task based on the supplementary recording quantity control information; determining the number of supplementary recording record data corresponding to the supplementary recording task in the supplementary recording record log; judging whether the number of the supplementary recording record data matches the target supplementary recording quantity; if they match, determining that the verification result is passed; if they do not match, determining that the verification result is failed.

5. An electronic device, characterized in that: The electronic device includes a processor and a memory, wherein the memory stores at least one instruction or at least one program, and the at least one instruction or the at least one program is loaded and executed by the processor to implement the supplementary data verification method as described in any one of claims 1-3.

6. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores at least one instruction or at least one program, and the at least one instruction or at least one program is loaded and executed by the processor to implement the supplementary data verification method as described in any one of claims 1-3.

Images