Data processing method and device and electronic equipment

Abstract

The invention relates to the technical field of data processing, in particular to a data processing method and device and electronic equipment. According to the method, an obtained data report is automatically verified based on a verification rule corresponding to a target verification item; performing verification adjustment on the data report based on the verification result to obtain a verified and updated data report; and submitting the updated data report form. The target verification item is selected from a plurality of verification items based on the type of the data report, and / or the target verification item is obtained by adjusting one or more verification items in the plurality of verification items; the plurality of verification items comprise one or more of data integrity verification, data accuracy verification and data consistency verification. And the report is verified through a computer program, so that the automation degree of data verification and checking is improved, and the efficiency is improved.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a data processing method, device and electronic device. Background Art

[0002] With the rapid development of the financial industry, higher requirements have been put forward for the quality, efficiency and accuracy of capital statements submitted by commercial banks. At present, the main method of data processing for capital statements is to verify and check the data in capital statements manually.

[0003] However, due to the large amount of data, the workload of verification and checking is large, errors often occur, and the efficiency of manual verification and checking is low, which cannot meet the reporting time limit. Therefore, how to improve the quality of report data processing has become an urgent problem to be solved. Summary of the invention

[0004] The embodiments of the present application provide a data processing method, device and electronic device for implementing flexible verification and checking in data processing, thereby improving verification efficiency and data quality.

[0005] In a first aspect, an embodiment of the present application provides a data processing method, the method comprising:

[0006] The acquired data report is automatically verified based on the verification rules corresponding to the target verification items; the data report is verified and adjusted based on the verification results to obtain the verified and updated data report; the updated data report is submitted; the target verification item is selected from multiple verification items based on the type of data report, and / or the target verification item is obtained after adjusting one or more verification items among the multiple verification items; the multiple verification items include one or more of data integrity verification, data accuracy verification and data consistency verification.

[0007] The above method, through a computer program, verifies the new capital statement between tables and within tables, greatly improves the automation of data verification and checking, reduces manual workload, improves work efficiency, and can meet the needs of the rapidly changing financial market. In addition, in the embodiment of the present application, based on different data report types or requirements, the corresponding target verification items that are more suitable for verification can be determined to verify the data report, which is more applicable. Among them, the embodiment of the present application can pre-configure a variety of verification items, so that in actual applications, based on different situations, an adapted verification item is selected from the configured multiple verification items for verification of the report, and the embodiment of the present application can also be based on the scene to be verified, or the type of data report to be verified, or the requirements of the data report to be verified, etc., flexibly adjust the verification items in the verification pool to make the verification items more suitable for the detection and verification scene of the data report, more flexible and convenient, and wider in scope of application.

[0008] As an optional implementation, the acquired data report is automatically verified based on the verification rules corresponding to the target verification items, including:

[0009] When the data integrity in the target verification item is verified, the data integrity is verified for the data report according to the first rule corresponding to the data integrity verification; the data report is verified and adjusted according to the verification result obtained by verifying the data report based on the first rule; the first rule includes that each indicator data in the data report to be verified is a required item, and the value of each required indicator data is within the allowed range.

[0010] The above method, the embodiment of the present application provides a method for automatically verifying the data integrity of a data report. For example, a verification item for data integrity verification can be selected from a verification pool as one of the target verification items for data verification of the data report, thereby verifying the data report based on the verification rules corresponding to the verification item. It has stronger applicability, realizes automatic verification of the data integrity of the data report, and is more flexible and convenient.

[0011] It should be noted that the first rule in the embodiment of the present application can be designed according to actual conditions. The above content is only an example and is not limited to determining whether the indicator data is a required item and whether the value is within the allowable range. It is not limited here.

[0012] As an optional implementation, the acquired data report is automatically verified based on the verification rules corresponding to the target verification items, including:

[0013] When verification is performed based on the data accuracy verification in the target verification project, the data accuracy of the data report is verified according to the second rule corresponding to the data accuracy verification; the data report is verified and adjusted according to the verification result obtained by verifying the data report based on the second rule; the second rule includes that the format of each indicator data in the verified data report is correct, the range of each data is within a reasonable range, and the front and back correlation of each data is accurate.

[0014] The above method, the embodiment of the present application provides a method for automatically verifying the data accuracy of a data report. For example, a verification item for data accuracy verification can be selected from a verification pool as one of the target verification items for data verification of the data report, thereby verifying the data report based on the verification rules corresponding to the verification item. It has stronger applicability, realizes automatic verification of the data accuracy of the data report, and is more flexible and convenient.

[0015] It should be noted that the second rule in the embodiment of the present application can be designed according to actual conditions. The above content is only used as an example and is not limited to judging whether the format of the indicator data is correct, whether the value is within a reasonable range, whether the connection between the data is accurate, etc. It is not limited here.

[0016] As an optional implementation, the acquired data report is automatically verified based on the verification rules corresponding to the target verification items, including:

[0017] When the data consistency in the target verification item is verified, the data consistency check is performed on the data report according to the third rule corresponding to the data consistency check; the data report is verified and adjusted according to the verification result obtained by verifying the data report based on the third rule; the third rule includes that the relevant contents of the data reports to be verified are consistent; the data reports verified based on the third rule include new reports based on the requirements of the new reporting system and old reports based on the requirements of the old reporting system.

[0018] The above method, the embodiment of the present application provides a method for automatically verifying the data consistency of a data report. For example, a verification item for data consistency verification can be selected from the verification pool as one of the target verification items for data verification of the data report, so that the data report is verified based on the verification rules corresponding to the verification item. It has stronger applicability, realizes automatic verification of data consistency of data reports, and is more flexible and convenient.

[0019] It should be noted that the third rule described in the embodiment of the present application can be designed according to actual conditions. The above content is only used as an example and is not limited to determining whether the relevant content between data reports is consistent, etc., and is not limited here.

[0020] As an example, when determining whether the relevant contents of the data reports to be verified are consistent, the embodiment of the present application may have multiple consistency judgment rules, which are not limited to the following:

[0021] For example, whether there is a logical error between the data report currently being verified and the data of the main data report, if so, it is determined that the data report has a consistency error problem and needs to be adaptively adjusted. Among them, the main report in the embodiment of the present application can be set by the user according to the actual situation, or it can be automatically determined from multiple data reports according to the importance of the report or the relevance of the data.

[0022] For another example, whether there is a logical error between the data report currently being verified and other data reports stored in the database, if so, it is determined that the data report has a consistency error problem, and the data report needs to be adaptively adjusted based on other stored data reports. Among them, in the embodiment of the present application, some or all of the stored data reports can be selected from the database for auxiliary data consistency verification.

[0023] For another example, whether there are logical errors in the data between the data report currently undergoing data verification and a threshold number of data reports that have previously undergone data verification (such as three data reports that have completed data verification before this data report); if so, it is determined that the data report has a consistency error problem, and the data report needs to be adaptively adjusted based on the threshold number of data reports that have completed data verification.

[0024] For another example, whether there is a logical error in the data between the data report currently undergoing data verification and the data report that was previously verified within a threshold time (such as a data report that was verified within 30 minutes before the data report); if so, it is determined that the data report has a consistency error problem, and the data report needs to be adaptively adjusted based on the aforementioned data report that has completed data verification within the threshold time.

[0025] For another example, an embodiment of the present application can first perform data integrity and data accuracy verification on the data report to be verified, and then, after determining that the number of data reports that have completed the data integrity and data accuracy verification has reached a threshold number, perform data consistency verification on the data reports of the threshold number together to determine whether there are logical errors, association errors and other problems in the data between the data reports of the threshold number. If so, adaptive adjustments are made to the data reports based on the threshold number.

[0026] For another example, an embodiment of the present application can first perform data integrity and data accuracy verification on the data report to be verified, and then perform data consistency verification on the data reports that are determined to have completed the data integrity and data accuracy verification within a threshold time, to determine whether there are logical errors, association errors and other problems in the data between the threshold number of data reports. If so, adaptive adjustments are made to the data reports based on the threshold number.

[0027] As an optional implementation manner, the verifying and adjusting the data report based on the verification result to obtain the verified and updated data report includes:

[0028] When the data report is determined to fail to meet the corresponding verification based on the verification results of the corresponding verification items, the corresponding page pop-up window will be automatically displayed according to the target reporting system requirements and the previously reported data; the page pop-up window includes a pop-up window prompting a verification failure error sent to the front-end report page when the system requirements are exceeded, or a pop-up window reminder sent to the front-end report page when it is within the system requirements but the previous reporting verification is normal; according to the content of the page pop-up window, the data of the data report is adjusted, and the adjusted data report is submitted.

[0029] The above method, the embodiment of the present application provides a response scenario in the process of verifying the data report. For example, the data report verification status can be displayed to the user through a pop-up window on the interface, so that the user can perform subsequent corresponding operations based on the verification status. It is more applicable and convenient for users to better perform corresponding adjustment operations based on the verification status of each data report, which is more flexible and convenient.

[0030] In addition, when there is a problem with the data report verification, the embodiment of the present application can also prompt the user through a pop-up window that there is an error in the data report, the verification failed, etc., and can further prompt the user to adjust the data report, for example, indicating how to modify the data report to make the data report more in line with the reporting requirements; or, the embodiment of the present application can automatically adjust the data report based on the existing verification problem and the adjustment rule after determining that there is a problem with the data report verification according to the preset adjustment rules. Among them, the embodiment of the present application can prompt the user of the automatic adjustment plan through a pop-up window, and after receiving the user's confirmation instruction, adjust the data report based on the adjustment plan; or, after determining that there is a problem with the data report, the embodiment of the present application can automatically adjust the data report based on the adjustment plan, and prompt the user through a pop-up window that there is a problem with the data report, that adjustments have been made, and the specific content of the adjustment.

[0031] It should be noted that the scheme of prompting through pop-up windows in the embodiment of the present application is only an example of the embodiment of the present application. The embodiment of the present application can also prompt through voice broadcast, page jump, etc., which is not limited here.

[0032] As an optional implementation, the method further includes:

[0033] By combining the backend database with the frontend report page, a corresponding business scope number is created for each report item in the frontend report page; in the backend database, the target verification items corresponding to the business report are determined through the business scope number and the target reporting system requirements corresponding to the business report; wherein, the business scope numbers of the business reports in the same group are the same, and the business logic scope similarity between the business reports in the same group meets the first threshold.

[0034] The above method, the embodiment of the present application provides a solution for how to quickly determine the verification items based on the data report, which is more applicable, more flexible and convenient, more conducive to the implementation of full-process automated data report verification, and has a higher user experience.

[0035] As an optional implementation manner, before verifying and adjusting the data report based on the verification result, the method further includes:

[0036] The verification result of the data report is compared with the verification result of the corresponding related data report; after determining that the proportion of conflicts between the verification result of the data report and the verification result of the related data report is greater than a second threshold, the verification result of the data report is analyzed and corrected.

[0037] The above method, the embodiment of the present application provides a solution for flexible analysis and correction based on the verification situation, so that the verification content can be adaptively adjusted in a timely manner, the accuracy of the verification is enhanced, and the applicability is stronger.

[0038] In a second aspect, an embodiment of the present application provides a data processing device, the device comprising:

[0039] The verification module is used to automatically verify the acquired data reports based on the verification rules corresponding to the target verification items;

[0040] A processing module, configured to perform verification and adjustment on the data report based on the verification result to obtain a verified and updated data report;

[0041] The reporting module is used to report the updated data report.

[0042] As an optional implementation manner, the verification module is specifically used for:

[0043] When the data integrity in the target verification item is verified, the data integrity is verified for the data report according to the first rule corresponding to the data integrity verification; the data report is verified and adjusted according to the verification result obtained by verifying the data report based on the first rule; the first rule includes that each indicator data in the data report to be verified is a required item, and the value of each required indicator data is within the allowed range.

[0044] As an optional implementation manner, the verification module is specifically used for:

[0045] When verification is performed based on the data accuracy verification in the target verification project, the data accuracy of the data report is verified according to the second rule corresponding to the data accuracy verification; the data report is verified and adjusted according to the verification result obtained by verifying the data report based on the second rule; the second rule includes that the format of each indicator data in the verified data report is correct, the range of each data is within a reasonable range, and the front and back correlation of each data is accurate.

[0046] As an optional implementation manner, the verification module is specifically used for:

[0047] When the data consistency in the target verification item is verified, the data consistency check is performed on the data report according to the third rule corresponding to the data consistency check; the data report is verified and adjusted according to the verification result obtained by verifying the data report based on the third rule; the third rule includes that the relevant contents of the data reports to be verified are consistent; the data reports verified based on the third rule include new reports based on the requirements of the new reporting system and old reports based on the requirements of the old reporting system.

[0048] As an optional implementation manner, the processing module is specifically used for:

[0049] When the data report is determined to fail to meet the corresponding verification based on the verification results of the corresponding verification items, the corresponding page pop-up window will be automatically displayed according to the target reporting system requirements and the previously reported data; the page pop-up window includes a pop-up window prompting a verification failure error sent to the front-end report page when the system requirements are exceeded, or a pop-up window reminder sent to the front-end report page when it is within the system requirements but the previous reporting verification is normal; according to the content of the page pop-up window, the data of the data report is adjusted, and the adjusted data report is submitted.

[0050] As an optional implementation manner, the processing module is further used for:

[0051] By combining the backend database with the frontend report page, a corresponding business scope number is created for each report item in the frontend report page; in the backend database, the target verification items corresponding to the business report are determined through the business scope number and the target reporting system requirements corresponding to the business report; wherein, the business scope numbers of the business reports in the same group are the same, and the business logic scope similarity between the business reports in the same group meets the first threshold.

[0052] As an optional implementation manner, the processing module is further used for:

[0053] The verification result of the data report is compared with the verification result of the corresponding related data report; after determining that the proportion of conflicts between the verification result of the data report and the verification result of the related data report is greater than a second threshold, the verification result of the data report is analyzed and corrected.

[0054] In a third aspect, an embodiment of the present application provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the computer program is executed by the processor, the processor implements any one of the data processing methods in the first aspect.

[0055] In a fourth aspect, an embodiment of the present application further provides a computer-readable storage medium, in which a computer program is stored. When the computer program is executed by a processor, the data processing method of any one of the first aspects is implemented.

[0056] In a fifth aspect, an embodiment of the present application further provides a computer program product, including a computer program, which is executed by a processor to implement a data processing method as described in any one of the first aspects above.

[0057] The technical effects brought about by any one of the implementation methods in the second to fifth aspects can refer to the technical effects brought about by the corresponding implementation method in the first aspect, and will not be repeated here. BRIEF DESCRIPTION OF THE DRAWINGS

[0058] Figure 1 A schematic diagram of a data processing system architecture provided in an embodiment of the present application;

[0059] Figure 2 A schematic diagram of the module structure of a data processing system provided in an embodiment of the present application;

[0060] Figure 3 A schematic diagram of a data processing method provided in an embodiment of the present application;

[0061] Figure 4 A schematic diagram of a data verification scenario provided in an embodiment of the present application;

[0062] Figure 5 An exemplary flow chart of data processing provided in an embodiment of the present application;

[0063] Figure 6 A schematic diagram of a data processing device provided in an embodiment of the present application;

[0064] Figure 7 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0065] In order to make the purpose, technical solutions and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present application.

[0066] The application scenarios described in the embodiments of the present application are intended to more clearly illustrate the technical solutions of the embodiments of the present application, and do not constitute a limitation on the technical solutions provided by the embodiments of the present application. It is known to those skilled in the art that with the emergence of new application scenarios, the technical solutions provided by the embodiments of the present application are also applicable to similar technical problems. In the description of the present application, unless otherwise specified, the meaning of "multiple" is two or more.

[0067] With the rapid development of the financial industry, higher requirements have been put forward for the quality, efficiency and accuracy of capital statements submitted by commercial banks. At present, the main method of data processing for capital statements is to verify and check the data in capital statements manually.

[0068] For example, under the current relevant technical solutions, when submitting data reports, first, the bank's reporting staff will check the new capital statement data item by item to ensure that the format and content of the data meet the requirements; then, the report will be further verified through manual or computer programs; finally, the verified data will be submitted to the regulatory authorities for subsequent review and evaluation.

[0069] However, due to the large amount of data, the workload of verification and checking is large, errors often occur, and the efficiency of manual verification and checking is low, which cannot meet the reporting time limit. Therefore, how to improve the quality of report data processing has become an urgent problem to be solved.

[0070] To solve this problem, the embodiments of the present application provide a data processing method and related devices, which use computer programs to perform inter-table and intra-table verification on new capital statements, greatly improving the degree of automation of data verification and checking, reducing manual workload, and improving work efficiency. It can meet the needs of the rapidly changing financial market, effectively avoid verification and checking errors caused by human subjective factors, ensure the accuracy and completeness of the data, and have greater flexibility.

[0071] A schematic diagram of an application scenario of an optional data processing method in an embodiment of the present application. Figure 1 As shown, it includes a front-end device 100, a back-end server 200, and a back-end database 300. The devices can be connected to each other in a communicative manner through wired or wireless means to implement the data processing method of the present application.

[0072] The front-end device 100 is used for content display and for users to perform corresponding operations based on the display page. For example, the front-end display can display data reports and corresponding pop-up windows.

[0073] The front-end device 100 may be any electronic device having a display screen and supporting user operations, including but not limited to a smart phone, a tablet computer, a desktop computer, and the like.

[0074] The backend server 200 is any device with data processing capability, such as a server or a server cluster composed of multiple servers, or may also be a chip or circuit, such as a chip or circuit disposed in a server or a server cluster. In a specific example, the server 200 may be a cloud server.

[0075] As an example, the background server 200 described in the present application may include multiple functional modules, such as Figure 2 As shown, it is not limited to the following modules:

[0076] The script writing module 210 is used to write an automated script for corresponding verification items, so that when the server runs the automated script, it can automatically perform corresponding verification on the data report.

[0077] The verification module 220 is used to perform corresponding verification on the input data report based on the target verification items to obtain the verification result.

[0078] The intelligent correction module 230 is used to automatically identify and correct verification and checking errors caused by human subjective factors based on a built-in intelligent correction algorithm, thereby improving the accuracy of the data.

[0079] The dynamic adjustment module 240 is used to dynamically adjust the verification and checking rules of the data processing software based on the system's function of dynamically adjusting the verification and checking rules according to actual conditions, thereby improving the accuracy of data verification and checking in special circumstances.

[0080] The backend database 300 is used to store information such as data reports.

[0081] The system architecture and business scenarios described in the embodiments of the present application are intended to more clearly illustrate the technical solutions of the embodiments of the present application, and do not constitute a limitation on the technical solutions provided in the embodiments of the present application. A person of ordinary skill in the art may appreciate that, with the evolution of network architecture and the emergence of new business scenarios, the technical solutions provided in the embodiments of the present application are also applicable to similar technical problems. For example, the front-end device in the embodiments of the present application may be the same device as the back-end server. For another example, in the embodiments of the present application, one front-end device may correspond to multiple back-end servers, which is not limited here.

[0082] Based on the above Figure 1-Figure 2The system architecture shown and the contents of the above-mentioned related technologies are described. In the embodiment of the present application, a data processing method is provided. The execution subject of the method is introduced by taking the front-end device and the back-end server as examples. In addition, it should be understood that the device or server can also be replaced by a chip, unit or module with corresponding functions.

[0083] like Figure 3 As shown, a flowchart of a data processing method provided in an embodiment of the present application may specifically include the following steps.

[0084] Step S301: Perform automatic verification on the acquired data report based on the verification rules corresponding to the target verification item.

[0085] As an example, the target verification item in the embodiment of the present application is selected from multiple verification items based on the type of data report, and / or the target verification item is obtained after adjusting one or more verification items among the multiple verification items.

[0086] As an example, the multiple verification items described in the embodiment of the present application include one or more of data integrity verification, data accuracy verification, and data consistency verification, which are not limited here.

[0087] As an example, an embodiment of the present application can combine a backend database with a frontend report page to create a corresponding business scope number for each report item in the frontend report page; then, in the backend database, the target verification item corresponding to the business report is determined through the business scope number and the target reporting system requirements corresponding to the business report; wherein, the business scope numbers of business reports in the same group are the same, and the business logic scope similarity between the business reports in the same group meets the first threshold.

[0088] Step S302: perform verification and adjustment on the data report based on the verification result to obtain a verified and updated data report.

[0089] As an example, before verifying and adjusting the data report based on the verification result, the embodiment of the present application may also compare the verification result of the data report with the verification result of the corresponding related data report; then, after determining that the proportion of conflicts between the verification result of the data report and the verification result of the related data report is greater than a second threshold, the verification result of the data report is analyzed and corrected.

[0090] As an example, the verification methods based on different verification items in the embodiments of the present application are also different. The following is a brief introduction based on different verification items, which is not limited to the following verifications:

[0091] Verification 1: Automated data integrity verification.

[0092] As an example, when the data integrity in the target verification project is verified, the embodiment of the present application performs a data integrity check on the data report according to the first rule corresponding to the data integrity check; then, according to the verification result obtained by verifying the data report based on the first rule, the data report is verified and adjusted; wherein the first rule includes that each indicator data in the data report to be verified is a required item, and the value of each required indicator data is within an allowed range.

[0093] Illustratively, the system of the embodiment of the present application will automatically perform integrity check on the new capital statement, specifically checking whether each indicator data in the statement is a required item and whether the value of each required indicator data is within the allowed range.

[0094] Verification 2: Automated data accuracy verification.

[0095] As an example, when the embodiment of the present application performs verification based on the data accuracy verification in the target verification project, the data accuracy verification is performed on the data report according to the second rule corresponding to the data accuracy verification; then, according to the verification result obtained by verifying the data report based on the second rule, the data report is verified and adjusted; wherein the second rule includes that the format of each indicator data in the data report to be verified is correct, the range of each data is within a reasonable range, and the front-end correlation of each data is accurate.

[0096] Exemplarily, an embodiment of the present application can be implemented by writing a set of automated scripts that can perform inter-table verification on a new capital statement, wherein the script can automatically identify each indicator data in the statement and perform logical verification on each indicator data. For example, it can specifically check whether the format of the data is correct, whether the range of the data is within a reasonable range, whether the front-end correlation of the data is correct, etc.

[0097] Verification 3: Perform a comprehensive data consistency check.

[0098] As an example, when the data consistency in the target verification project is verified, the embodiment of the present application performs a data consistency check on the data report according to the third rule corresponding to the data consistency check; then, according to the verification result obtained by verifying the data report based on the third rule, the data report is verified and adjusted; wherein the third rule includes that the relevant content between the data reports to be verified is consistent; the data reports verified based on the third rule include new reports based on the requirements of the new reporting system and old reports based on the requirements of the old reporting system.

[0099] For example, the embodiment of the present application can perform a comprehensive data consistency check, wherein, when performing consistency check, not only the data between tables of the new capital statement can be checked, but also the data between tables of the 1104 report or other submitted contents can be checked. For example, the system can check a certain indicator data in the new capital statement with the corresponding data in the 1104 report G01 to ensure the consistency and accuracy of the data.

[0100] Furthermore, the embodiment of the present application may also perform verification adjustment on the data report based on the verification result of the data report, so that the adjusted data report better meets the current demand.

[0101] Exemplarily, when the data report is determined to not meet the corresponding verification based on the verification results of the corresponding verification items, the embodiment of the present application can automatically pop up a corresponding page window according to the target reporting system requirements and previous reporting data, so that the user can make corresponding adjustments to the data report based on the content of the page pop-up window.

[0102] As an example, the page pop-up window in the embodiment of the present application may include but is not limited to the following situations:

[0103] Case 1: When the system requirements are exceeded, a pop-up window prompting a verification failure error is sent to the front-end report page.

[0104] Case 2: When it is within the scope of the system requirements, but the verification of previous reports is normal, a reminder pop-up window is sent to the front-end report page.

[0105] Step S303: submit the updated data report.

[0106] Through this method, the embodiment of the present application can effectively improve the quality of data submitted by commercial banks in accordance with the capital management regulations, and improve the efficiency and accuracy of submission.

[0107] Further, in order to better introduce the embodiments of the present application, the following are selected: Figure 4 The data processing scenario shown is used as an example. It should be noted that the following examples in the embodiments of the present application are only used as examples and do not constitute a limitation on the embodiments of the present application:

[0108] like Figure 5 As shown, an exemplary flow chart of a data processing method provided in an embodiment of the present application may include the following steps:

[0109] Step S501: Verify project initialization settings.

[0110] Exemplarily, the embodiments of the present application can combine the background database with the front-end report page, create a business caliber number for each report item on the front-end page, and divide similar caliber indicators into a group according to the specific business logic caliber, and define the same business caliber number for indicators with exactly the same caliber. The background database creates a verification formula based on the business caliber number and the requirements of the new capital reporting system.

[0111] It should be noted that, in actual application, if the business logic or reporting system requirements do not change, step S501 can be omitted.

[0112] Step S502: Performing an automated data integrity check on the data report, and updating the data report based on the check result.

[0113] For example, the system of the embodiment of the present application will automatically perform integrity check on the new capital report, for example, check whether each indicator data in the report is a required item, and whether the value of each required indicator data is within the allowed range. If errors are found in the data, the system will automatically pop up a page window according to the requirements of the new capital reporting system and the data submitted in the past. If it exceeds the system requirements, a pop-up window of a verification failure error prompt will be sent to the front-end report page. If it is within the system requirements but the verification of the previous reporting is normal, a reminder will be sent to the report page. The filling personnel will adjust the data according to the content of the pop-up window, otherwise it cannot be submitted.

[0114] Step S503: Performing automated data accuracy verification on the data report, and updating the data report based on the verification result.

[0115] Exemplarily, the embodiment of the present application automatically identifies each indicator data in the data report and performs a logical check on each indicator data, for example, checking whether the format of the data is correct, whether the range of the data is within a reasonable range, whether the before and after relevance of the data is correct, etc. The system will automatically pop up a page window according to the requirements of the new capital reporting system and the data submitted in the past. If it exceeds the system requirements, a verification failure error prompt will be sent to the front-end report page. If it is within the system requirements but the verification with the previous reporting is normal, a reminder pop-up window will be sent to the report page. The person filling in the data will correct the data according to the content of the pop-up window, otherwise it cannot be submitted.

[0116] Step S504: performing data consistency check on the data report, and updating the data report based on the check result.

[0117] Exemplarily, the embodiment of the present application not only performs data verification between tables of the new capital report, but also performs data verification between tables of the 1104 report or other submitted contents. For example, the system can verify a certain indicator data in the new capital report with the corresponding data in the 1104 report G01 to ensure the consistency and accuracy of the data, and send a pop-up window to the person filling out the report according to the requirements of the new capital reporting system. If it exceeds the system requirements, a verification failure error prompt is sent to the front-end report page. If it is within the system requirements but the verification with the previous report is normal, a reminder pop-up window is sent to the report page, and the person filling out the report corrects the data according to the content of the pop-up window, otherwise it cannot be submitted.

[0118] Step S505: Activate the intelligent correction mechanism, and update the data report based on the correction result.

[0119] The system described in the embodiment of the present application has a built-in intelligent correction algorithm that can automatically identify and correct verification and checking errors caused by human subjective factors. For example, if the system finds that the verification result of a certain data is obviously in conflict with the verification result of other data, the system will further analyze and correct the data.

[0120] Step S506: Submit the updated data report.

[0121] The above-mentioned data processing method provided in the embodiment of the present application can be widely used in application fields such as commercial bank reporting systems, data processing and analysis, and information system management. Based on the data processing method provided by the present application, the quality of commercial bank new capital management reporting data can be greatly improved, thereby improving the bank's risk control ability and capital management ability, and meeting the latest regulatory requirements. Secondly, this technical solution can improve the efficiency of data verification and checking, reduce manual workload, and reduce labor costs. Finally, this technical solution can be flexibly adjusted according to actual conditions, avoiding the problem of inaccurate verification and checking caused by fixed rules in existing data processing software.

[0122] It is understandable that in order to implement the functions in the above embodiments, the above execution device includes hardware structures and / or software modules corresponding to the execution of each function. Those skilled in the art should easily realize that, in combination with the units and method steps of each example described in the embodiments disclosed in this application, the present application can be implemented in the form of hardware or a combination of hardware and computer software. Whether a function is executed in the form of hardware or computer software driving hardware depends on the specific application scenario and design constraint rules of the technical solution.

[0123] Figure 6 and Figure 7The following is a schematic diagram of the structure of a possible data processing device provided by an embodiment of the present application. These data processing devices can be used to implement the functions of the above method embodiments, and thus can also achieve the beneficial effects of the above method embodiments. Figure 6 As shown, the data processing device 600 includes a verification module 610, a processing module 620 and a reporting module 630:

[0124] Verification module 610, used to automatically verify the acquired data report based on the verification rules corresponding to the target verification items;

[0125] The processing module 620 is used to perform verification and adjustment on the data report based on the verification result to obtain a verified and updated data report;

[0126] The reporting module 630 is used to report the updated data report.

[0127] As an optional implementation, the verification module 610 is specifically used for:

[0128] When the data integrity in the target verification item is verified, the data integrity is verified for the data report according to the first rule corresponding to the data integrity verification; the data report is verified and adjusted according to the verification result obtained by verifying the data report based on the first rule; the first rule includes that each indicator data in the data report to be verified is a required item, and the value of each required indicator data is within the allowed range.

[0129] As an optional implementation, the verification module 610 is specifically used for:

[0130] When verification is performed based on the data accuracy verification in the target verification project, the data accuracy of the data report is verified according to the second rule corresponding to the data accuracy verification; the data report is verified and adjusted according to the verification result obtained by verifying the data report based on the second rule; the second rule includes that the format of each indicator data in the verified data report is correct, the range of each data is within a reasonable range, and the front and back correlation of each data is accurate.

[0131] As an optional implementation, the verification module 610 is specifically used for:

[0132] When the data consistency in the target verification item is verified, the data consistency check is performed on the data report according to the third rule corresponding to the data consistency check; the data report is verified and adjusted according to the verification result obtained by verifying the data report based on the third rule; the third rule includes that the relevant contents of the data reports to be verified are consistent; the data reports verified based on the third rule include new reports based on the requirements of the new reporting system and old reports based on the requirements of the old reporting system.

[0133] As an optional implementation manner, the processing module 620 is specifically configured to:

[0134] When the data report is determined to fail to meet the corresponding verification based on the verification results of the corresponding verification items, the corresponding page pop-up window will be automatically displayed according to the target reporting system requirements and the previously reported data; the page pop-up window includes a pop-up window prompting a verification failure error sent to the front-end report page when the system requirements are exceeded, or a pop-up window reminder sent to the front-end report page when it is within the system requirements but the previous reporting verification is normal; according to the content of the page pop-up window, the data of the data report is adjusted, and the adjusted data report is submitted.

[0135] As an optional implementation, the processing module 620 is further configured to:

[0136] By combining the backend database with the frontend report page, a corresponding business scope number is created for each report item in the frontend report page; in the backend database, the target verification items corresponding to the business report are determined through the business scope number and the target reporting system requirements corresponding to the business report; wherein, the business scope numbers of the business reports in the same group are the same, and the business logic scope similarity between the business reports in the same group meets the first threshold.

[0137] As an optional implementation manner, the processing module 620 is further configured to:

[0138] The verification result of the data report is compared with the verification result of the corresponding related data report; after determining that the proportion of conflicts between the verification result of the data report and the verification result of the related data report is greater than a second threshold, the verification result of the data report is analyzed and corrected.

[0139] For a more detailed description of each of the above modules, please refer to the relevant description in the method embodiment shown above.

[0140] like Figure 7As shown, the data processing device 700 includes a processor 710 and an interface circuit 720. The processor 710 and the interface circuit 720 are coupled to each other. It is understood that the interface circuit 720 can be a transceiver or an input-output interface. Optionally, the data processing device 700 may also include a memory 730 for storing instructions executed by the processor 710 or storing input data required by the processor 710 to execute instructions or storing data generated after the processor 710 executes instructions.

[0141] When the data processing device 700 is used to implement the above Figure 2 to Figure 5 When the method is shown, the processor 710 is used to implement the functions of the above-mentioned verification module 610 and processing module 620, and the interface circuit 720 is used to implement the function of the above-mentioned reporting module 630.

[0142] It is understandable that the processor in the embodiments of the present application may be a central processing unit (CPU), other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field programmable gate arrays (FPGA), other programmable logic devices, transistor logic devices, hardware components, or any combination thereof. A general-purpose processor may be a microprocessor or any conventional processor.

[0143] The method steps in the embodiments of the present application can be implemented in hardware or in software instructions that can be executed by a processor. The software instructions can be composed of corresponding software modules, and the software modules can be stored in random access memory, flash memory, read-only memory, programmable read-only memory, erasable programmable read-only memory, electrically erasable programmable read-only memory, register, hard disk, mobile hard disk, CD-ROM or any other form of storage medium known in the art. An exemplary storage medium is coupled to the processor so that the processor can read information from the storage medium and write information to the storage medium. The storage medium can also be a component of the processor. The processor and the storage medium can be located in an ASIC. In addition, the ASIC can be located in an access point or a station. The processor and the storage medium can also be present in a terminal device or a gateway device as discrete components.

[0144] In the above embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. When implemented by software, it can be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer programs or instructions. When the computer program or instruction is loaded and executed on a computer, the process or function described in the embodiment of the present application is executed in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, a network device, a user device or other programmable device. The computer program or instruction may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium, for example, the computer program or instruction may be transmitted from one website site, computer, server or data center to another website site, computer, server or data center by wired or wireless means. The computer-readable storage medium may be any available medium that a computer can access or a data storage device such as a server, data center, etc. that integrates one or more available media. The available medium may be a magnetic medium, for example, a floppy disk, a hard disk, a tape; it may also be an optical medium, for example, a digital video disc; it may also be a semiconductor medium, for example, a solid-state hard disk. The computer-readable storage medium may be a volatile or nonvolatile storage medium, or may include both volatile and nonvolatile types of storage media.

[0145] In the various embodiments of the present application, unless otherwise specified or provided for in any logical conflict, the terms and / or descriptions between the different embodiments are consistent and may be referenced to each other, and the technical features in the different embodiments may be combined to form new embodiments according to their inherent logical relationships.

[0146] It is understood that the various numbers involved in the embodiments of the present application are only for the convenience of description and are not used to limit the scope of the embodiments of the present application. The size of the sequence number of the above-mentioned processes does not mean the order of execution, and the execution order of each process should be determined by its function and internal logic.

Claims

1. A data processing method, It is characterized in that The method comprises: Automatically verify the acquired data reports based on the verification rules corresponding to the target verification items; Performing verification and adjustment on the data report based on the verification result to obtain a verified and updated data report; Submitting the updated data report; The target verification item is selected from a plurality of verification items based on the type of data report, and / or the target verification item is obtained by adjusting one or more verification items among the plurality of verification items; The multiple verification items include one or more of data integrity verification, data accuracy verification and data consistency verification.

2. The method according to claim 1, It is characterized in that The obtained data report is automatically verified based on the verification rules corresponding to the target verification items, including: When the data integrity is verified based on the target verification item, the data integrity is verified on the data report according to the first rule corresponding to the data integrity verification; According to a verification result obtained by verifying the data report based on the first rule, verifying and adjusting the data report; The first rule includes that each indicator data in the data report to be verified is a mandatory item, and the value of each mandatory indicator data is within an allowed range.

3. The method according to claim 1, It is characterized in that The obtained data report is automatically verified based on the verification rules corresponding to the target verification items, including: When the verification is performed based on the data accuracy verification in the target verification item, the data accuracy verification is performed on the data report according to the second rule corresponding to the data accuracy verification; According to a verification result obtained by verifying the data report based on the second rule, performing verification adjustment on the data report; The second rule includes that the format of each indicator data in the data report to be verified is correct, the range of each data is within a reasonable range, and the previous and next correlations of each data are accurate.

4. The method according to claim 1, It is characterized in that The obtained data report is automatically verified based on the verification rules corresponding to the target verification items, including: When the data consistency check is performed based on the target check item, the data consistency check is performed on the data report according to the third rule corresponding to the data consistency check; According to the verification result obtained by verifying the data report based on the third rule, verifying and adjusting the data report; The third rule includes that the relevant contents of the data reports to be verified are consistent; The data reports verified based on the third rule include new reports based on the requirements of the new reporting system and old reports based on the requirements of the old reporting system.

5. The method according to any one of claims 1 to 4, It is characterized in that The step of verifying and adjusting the data report based on the verification result to obtain a verified and updated data report includes: When the data report is determined to not meet the corresponding verification based on the verification results of the corresponding verification items, the corresponding page pop-up window is automatically displayed according to the target reporting system requirements and the previously reported data; The page pop-up window includes a pop-up window that prompts a verification failure error when the system requirements are exceeded, or a pop-up window that reminds the front-end report page when the system requirements are met but the verification of the previous report is normal; According to the content of the pop-up window on the page, the data report is adjusted, and the adjusted data report is submitted.

6. The method according to any one of claims 2 to 4, It is characterized in that The method further comprises: By combining the backend database with the front-end report page, a corresponding business scope number is created for each report item in the front-end report page; In the background database, the target verification items corresponding to the business report are determined through the business scope number and the target reporting system requirements corresponding to the business report; Among them, the business scope numbers of the business reports in the same group are the same, and the business logic scope similarity between the business reports in the same group meets the first threshold.

7. The method according to claim 1, It is characterized in that Before the verification and adjustment of the data report based on the verification result, the method further includes: Comparing the verification result of the data report with the verification result of the corresponding related data report; After determining that the proportion of conflicts between the verification results of the data report and the verification results of the related data report is greater than a second threshold, the verification results of the data report are analyzed and corrected.

8. A data processing device, It is characterized in that The device comprises: The verification module is used to automatically verify the acquired data reports based on the verification rules corresponding to the target verification items; A processing module, configured to perform verification and adjustment on the data report based on the verification result to obtain a verified and updated data report; The reporting module is used to report the updated data report.

9. An electronic device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, It is characterized in that When the processor executes the computer program, the method according to any one of claims 1 to 7 is implemented.

10. A computer-readable storage medium, It is characterized in that The computer-readable storage medium stores a computer program, and the computer program is used to cause the computer to execute the method according to any one of claims 1 to 7.

11. A computer program product, It is characterized in that When the computer program product is called by a computer, the computer is caused to execute the method according to any one of claims 1 to 7.

Images