Supervision submission automatic test method and device, electronic equipment and storage medium

Abstract

The invention relates to a supervision submission automatic test method and device, electronic equipment and a storage medium. The supervision submission automatic test method comprises the following steps: generating a first data index set according to new-version trust industry standardized supervision data; extracting indexes, which are the same as or associated with the first data index set, of the supervision submission system, and compiling a first cross-system index cross-check table; traversing each supervision submission item in sequence to generate a plurality of cross check tables; summarizing all the cross check schemes to generate a complete cross check table; and designing a complete cross-check table according to cross-system index cross-check, selecting corresponding information of the data marts, inputting the index cross-check table, generating an index cross-check rule, and generating a data index cross-check test case. According to the supervision submission automatic test method, automatic data generation and cross verification can be carried out on the supervision submission data, and the problems of test omission and low test implementation efficiency caused by insufficient ability of testers are solved.

Description

Technical Field

[0001] The present invention relates to the field of computers, and in particular, to a method, device, electronic device and storage medium for automated testing of regulatory reporting. Background Art

[0002] In recent years, with the strong regulatory requirements of the state for the correctness, accuracy, and consistency of various financial reporting indicator data, financial supervision has shown a trend of globalization, standardization, and cross-application. Bank regulatory reporting data comes from the data mart system, and the indicator testing in data testing is to verify the detailed summary processing process of each dimension of the data.

[0003] Currently, when conducting indicator testing in data testing, testers use desensitized production data from upstream, or construct data when the data does not meet the standards, run the regulatory reporting target table script and scheduling program in the test environment, run batches, and write test verification SQL (Structured Query Language) according to the indicator processing requirements and design documents. Combining program logic with the data indicator results, verify whether the data indicator processing logic is correct one by one for gray-box verification; or, based on the system data requirements and design analysis of the regulatory reporting mart caliber, processing logic, etc., manually write test cases and verification SQL based on the analysis results, and manually compare different reporting items by combining program logic with the data results for gray-box verification.

[0004] However, if testers use production data for verification and only care about the running results and not the processing logic, some reporting item contents will not be covered; if they use manually constructed data, they need to spend a lot of time tracing the source, analyzing the data values to be constructed, and there are easily problems such as data errors and insufficient samples, resulting in inaccurate test results; or, when analyzing test verification points according to data requirements and testers' experience, it is necessary to manually write data quality verification SQL and data comparison SQL, which requires high data analysis and SQL capabilities of testers, and it is easy to miss analysis, resulting in test rework and low test efficiency.

[0005] Therefore, there is an urgent need to develop an automated testing method for regulatory reporting, which can automatically generate data for regulatory reporting data, automatically cross-verify applications within and between systems, and verify whether the data indicators are correct in the reporting system. Summary of the Invention

[0006] The technical problem to be solved by the present invention is the problem of test omission and low test implementation efficiency caused by insufficient capabilities of testers during the indicator testing of bank regulatory reporting data.

[0007] To solve the above technical problems, according to one aspect of the present invention, a method for automated testing of regulatory reporting is provided, which includes the following steps: Step 1, generate the first EAST5.0 data indicator set. According to the filling instructions, form samples, indicator source tables and scripts, and indicator design documents of the new version of the EAST5.0 regulatory data for the trust industry, sort out all data indicators and mapping relationships of the EAST5.0 reports, and generate the first EAST5.0 data indicator set; Step 2, extract the regulatory reporting systems including the banking financial institution supervision information system 1104, the second-generation credit investigation, and financial basic data, and the indicators related to the first EAST5.0 data indicator set that are the same or include the number of accounts, various deposits and loans, bonds, and credit card overdrafts, and compile the first cross-check table for cross-system indicators; Step 3, traverse each regulatory reporting item in turn to generate multiple cross-check tables including the second cross-check table and the third cross-check table; summarize all cross-check schemes to generate a complete cross-check table including 31 regulatory reporting items; Step 4, design a complete cross-check table according to the cross-system indicator cross-check, and at the same time select the information corresponding to the data mart including the library, table, field, database function, and judgment condition, enter the indicator cross-check table, generate indicator cross-check rules, and generate data indicator cross-check test cases.

[0008] According to an embodiment of the present invention, step 3 may include the following steps: S31, generate a complete cross-check table of the current state through existing indicators; S32, when a new reporting indicator is added, confirm the cross-check relationship between the new indicator and the existing indicators according to the import template, fill in the cross-check relationship, and add the new indicator to the corresponding cross-check table in multiple cross-check tables to obtain the latest complete cross-check table.

[0009] According to an embodiment of the present invention, the method for automated testing of regulatory reporting may further include: Step 5, in the test set module, select the data indicator cross-check test cases and generate different test sets as needed.

[0010] According to an embodiment of the present invention, the method for automated testing of regulatory reporting may further include: Step 6, run the data mart script scheduling job to load the generated data into the data mart target table.

[0011] According to an embodiment of the present invention, the method for automated testing of regulatory reporting may further include: Step 7, in the test job module, select the test set, configure the job execution plan, execute the job, and generate a test report.

[0012] According to a second aspect of the present invention, there is provided a device for automated testing of regulatory reporting, which includes: a data generation module for automatically generating test data that can cover all reporting items according to preset rules and algorithms; the test data includes information required for various regulatory reporting items of customer information, transaction information, and account information; the data generation module is used to generate test data of different quantities and different types as needed; a cross-check relationship management module for automatically establishing an association relationship with the original regulatory reporting items in a fixed format according to preset association rules when there are new reporting items; the association relationship includes different dimensions based on time, based on transactions, and based on customers; the cross-check relationship management module includes an association relationship generation module, and the association relationship generation module is used to analyze the test data, find out the association relationships therein, and establish corresponding association models; a test execution module for simulating user operations, inputting the generated test data and the established association relationships into the system to be tested, performing corresponding business operations, and obtaining test results; the test execution module records various information including operation steps, execution time, and test results during the test process.

[0013] According to an embodiment of the present invention, the device for automated testing of regulatory reporting may further include: a result analysis module for analyzing and evaluating the test results to determine whether the system to be tested meets the preset test requirements; if the test results do not meet the requirements, the result analysis module generates a test report and gives corresponding improvement suggestions.

[0014] According to an embodiment of the present invention, the device for automated testing of regulatory reporting may further include: a system management module for managing including account management and permission management, and controlling the access to accounts and the usage permissions of function modules.

[0015] According to a third aspect of the present invention, there is provided an electronic device, including: a memory, a processor, and a regulatory reporting automated test program stored on the memory and executable on the processor, and when the regulatory reporting automated test program is executed by the processor, the steps of the above-mentioned regulatory reporting automated test method are implemented.

[0016] According to a fourth aspect of the present invention, there is provided a computer storage medium, wherein a regulatory reporting automated test program is stored on the computer storage medium, and when the regulatory reporting automated test program is executed by the processor, the steps of the above-mentioned regulatory reporting automated test method are implemented.

[0017] Compared with the prior art, the technical solutions provided by the embodiments of the present invention can at least achieve the following beneficial effects:

[0018] The present invention provides a method and device for automated testing of regulatory reporting. Through this system, it is possible to automatically generate regulatory reporting data, perform automatic cross-verification within and between systems for applications, automatically expand new indicators, and cross-verify existing indicator relationships, so as to verify whether the data indicators are correct in the reporting system, and solve the problems of test omission and low test implementation efficiency caused by insufficient capabilities of testers.

[0019] The method and device for automated testing of regulatory reporting provided by the present invention have a high degree of automation, can automatically generate test data and automatically establish association relationships, without manual intervention, and greatly improve the test efficiency.

[0020] The method and device for automated testing of regulatory reporting provided by the present invention have a high level of intelligence, can automatically analyze test data and find out the association relationships therein, reducing the difficulty and error rate of manual analysis.

[0021] The method and device for automated testing of regulatory reporting provided by the present invention have strong flexibility, and can flexibly adjust the rules and algorithms for data generation and association relationship establishment according to different business requirements and data characteristics.

[0022] In the method and device for automated testing of regulatory reporting provided by the present invention, test cases can initiate tasks through a test plan, execute in batches and at regular intervals, and automatically output test reports, improving the test efficiency.

[0023] The method and device for automated testing of regulatory reporting provided by the present invention have high reusability of test cases. For new reporting items, they can be added to existing associations to generate a larger reporting item network structure. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings of the embodiments will be briefly introduced below. Obviously, the accompanying drawings in the following description only relate to some embodiments of the present invention and do not limit the present invention.

[0025] Figure 1 is a flowchart showing the method for automated testing of regulatory reporting according to an embodiment of the present invention;

[0026] Figure 2 is a schematic diagram showing the device for automated testing of regulatory reporting according to an embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0027] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Apparently, the described embodiments are some, but not all, of the embodiments of the present invention. All other embodiments obtained by those of ordinary skill in the art based on the described embodiments of the present invention without creative efforts shall fall within the scope of protection of the present invention.

[0028] Unless otherwise defined, the technical terms or scientific terms used herein shall have the ordinary meanings understood by those of ordinary skill in the art to which the present invention pertains. The terms "first", "second", and similar terms used in the specification and claims of this patent application for the present invention do not denote any order, quantity, or importance, but are merely used to distinguish different components. Similarly, terms such as "a" or "one" do not denote a quantity limitation, but indicate the existence of at least one.

[0029] Figure 1 is a flowchart showing the automated testing method for regulatory reporting according to an embodiment of the present invention.

[0030] As Figure 1 shown, the method for automated testing of regulatory reporting includes the following steps:

[0031] Step 1: Generate the first EAST5.0 data indicator set. According to the filling instructions, form samples, indicator source tables and scripts, and indicator design documents of the new version of the EAST5.0 regulatory data for the trust industry, sort out all data indicators and mapping relationships of the EAST5.0 reports, and generate the first EAST5.0 data indicator set.

[0032] Step 2: Extract the regulatory reporting systems including the banking financial institution supervision information system 1104, second-generation credit investigation, and financial basic data, which are the same as or related to the first EAST5.0 data indicator set and include indicators such as the number of accounts, various deposits and loans, bonds, and credit card overdrafts, and compile the first cross-check table for cross-system indicators.

[0033] Step 3: Traverse each regulatory reporting item in turn to generate multiple cross-check tables including the second cross-check table and the third cross-check table; summarize all cross-check schemes to generate a complete cross-check table including 31 regulatory reporting items.

[0034] Step 4: Design a complete cross-check table according to the cross-system indicator cross-check, and at the same time select the information corresponding to the data mart including libraries, tables, fields, database functions, and judgment conditions, enter the indicator cross-check table, generate indicator cross-check rules, and generate data indicator cross-check test cases.

[0035] The present invention provides a regulatory reporting automated testing method. Through this system, it is possible to automatically generate regulatory reporting data, automatically cross-verify applications within and between systems, automatically expand new indicators and cross-verify relationships of existing indicators, verify whether data indicators are correct in the reporting system, and solve the problems of test omission and low test implementation efficiency caused by insufficient capabilities of testers.

[0036] According to one or some embodiments of the present invention, step 3 includes the following steps:

[0037] S31. Generate a complete cross-validation table for the current state through existing indicators.

[0038] S32. When adding new reporting indicators, confirm the cross-validation relationship with existing indicators according to the new indicators, fill in the cross-validation relationship according to the import template, and add the new indicators to the corresponding cross-validation tables in multiple cross-validation tables to obtain the latest complete cross-validation table.

[0039] The regulatory reporting automated testing method provided by the present invention has a high degree of automation, can automatically generate test data and automatically establish association relationships, without manual intervention, and greatly improves the test efficiency.

[0040] According to one or some embodiments of the present invention, the method for regulatory reporting automated testing further includes: Step 5. In the test set module, select data indicator cross-validation test cases and generate different test sets as needed.

[0041] In the regulatory reporting automated testing method and device provided by the present invention, test cases can initiate jobs through a test plan, execute in batches, execute regularly, and automatically output test reports, improving the test efficiency.

[0042] According to one or some embodiments of the present invention, the method for regulatory reporting automated testing further includes: Step 6. Run the data mart script scheduling job and load the generated data into the data mart target table.

[0043] According to one or some embodiments of the present invention, the method for regulatory reporting automated testing further includes: Step 7. In the test job module, select a test set, configure the job execution plan, execute the job, and generate a test report.

[0044] The regulatory reporting automated testing method provided by the present invention has high reusability of test cases. For new reporting items, they can be added to existing associations to generate a larger reporting item network structure.

[0045] Figure 2 It is a schematic diagram showing a regulatory reporting automated testing device according to an embodiment of the present invention.

[0046] As Figure 2As shown in the figure, the device for automated testing of regulatory reporting includes: a data generation module, a cross-check relationship management module, and a test execution module.

[0047] The data generation module is used to automatically generate test data that can cover all reporting items according to preset rules and algorithms; the test data includes information required for various regulatory reporting items such as customer information, transaction information, and account information; the data generation module is used to generate different quantities and different types of test data as needed.

[0048] The cross-check relationship management module is used to automatically establish an association relationship with the original regulatory reporting items in a fixed format according to preset association rules when there are new reporting items; the association relationship includes different dimensions based on time, based on transactions, and based on customers; the cross-check relationship management module includes an association relationship generation module, and the association relationship generation module is used to analyze the test data, find out the association relationships therein, and establish corresponding association models.

[0049] The test execution module is used to simulate user operations, input the generated test data and the established association relationships into the system to be tested, execute corresponding business operations, and obtain test results; the test execution module records various information including operation steps, execution time, and test results during the test process.

[0050] The device for automated testing of regulatory reporting provided by the present invention has a high level of intelligence, can automatically analyze test data and find out the association relationships therein, reducing the difficulty and error rate of manual analysis.

[0051] According to one or some embodiments of the present invention, the device for automated testing of regulatory reporting further includes: a result analysis module.

[0052] The result analysis module is used to analyze and evaluate the test results, and judge whether the system to be tested meets the preset test requirements; if the test results do not meet the requirements, the result analysis module generates a test report and gives corresponding improvement suggestions.

[0053] The device for automated testing of regulatory reporting provided by the present invention has strong flexibility and can flexibly adjust the rules and algorithms for data generation and association relationship establishment according to different business requirements and data characteristics.

[0054] According to one or some embodiments of the present invention, the device for automated testing of regulatory reporting further includes: a system management module.

[0055] The system management module is used to manage including account management, permission management, and control the access to accounts and the usage permissions of function modules.

[0056] According to another aspect of the present invention, there is provided a device for automated testing of regulatory reporting, including: a memory, a processor, and a regulatory reporting automated testing program stored on the memory and executable on the processor. When the regulatory reporting automated testing program is executed by the processor, the steps of the above-mentioned regulatory reporting automated testing method are implemented.

[0057] The present invention also provides a computer storage medium.

[0058] A regulatory reporting automated testing program is stored on the computer storage medium. When the regulatory reporting automated testing program is executed by the processor, the steps of the above-mentioned regulatory reporting automated testing method are implemented.

[0059] Among them, the method implemented when the regulatory reporting automated testing program running on the processor is executed can refer to each embodiment of the regulatory reporting automated testing method of the present invention, which will not be elaborated here.

[0060] The present invention also provides a computer program product.

[0061] The computer program product of the present invention includes a regulatory reporting automated testing program. When the regulatory reporting automated testing program is executed by the processor, the steps of the regulatory reporting automated testing method as described above are implemented.

[0062] Among them, the method implemented when the regulatory reporting automated testing program running on the processor is executed can refer to each embodiment of the regulatory reporting automated testing method of the present invention, which will not be elaborated here.

[0063] Through the description of the above embodiments, those skilled in the art can clearly understand that the above-mentioned embodiment methods can be implemented by means of software plus a necessary general hardware platform. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium as described above (such as ROM / RAM, magnetic disk, optical disc), and includes several instructions to enable a terminal device (which can be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods described in each embodiment of the present invention.

[0064] The above is only an exemplary embodiment of the present invention and is not used to limit the protection scope of the present invention. The protection scope of the present invention is determined by the appended claims.

Claims

1. A method for automated testing of regulatory submissions, comprising the following steps: Step 1: Generate the first data indicator set of EAST5.

0. According to the new version of the trust industry standardized supervision data EAST5.0 report filling instructions, report sample, indicator source table and script, indicator design document, sort out all data indicators and mapping relationships of the EAST5.0 report, and generate the first data indicator set of EAST5.0; Step 2: Extract the indicators related to the first data indicator set of EAST5.0, including the banking financial institution supervision information system 1104, the second-generation credit reporting system, and the supervision and reporting system of financial basic data, which are the same as or include the number of accounts, various deposits and loans, bonds, and credit card overdrafts, and compile the first cross-system indicator cross-check table; Step 3: traverse each regulatory reporting item in turn to generate a cross-check table including a second cross-check table and a third cross-check table; summarize all cross-check schemes to generate a complete cross-check table including 31 regulatory reporting items; Step 4: Design a complete cross-check table based on the cross-system indicator cross-check. Select the corresponding information of the data mart including libraries, tables, fields, database functions, and judgment conditions, enter the indicator cross-check table, generate indicator cross-check rules, and generate data indicator cross-check test cases.

2. The method for automated testing of regulatory submissions as claimed in claim 1, wherein: Step 3 includes the following steps: S31, generating a complete cross-check table of the current status through existing indicators; S32. When new reporting indicators are added, confirm the cross-check relationship between the new indicators and the existing indicators, fill in the cross-check relationship according to the import template, add the new indicators to the corresponding cross-check tables in multiple cross-check tables, and obtain the latest complete cross-check table.

3. The method for automated testing of regulatory submissions as claimed in claim 1, wherein: Also includes: Step 5. In the test set module, select data indicator cross-verification test cases and generate different test sets as needed.

4. The method for automated testing of regulatory submissions as claimed in claim 3, wherein: Also includes: Step 6: Run the data mart script scheduling job to load the generated data into the data mart target table.

5. The method for automated testing of regulatory submissions as claimed in claim 3, wherein: Also includes: Step 7. In the test job module, select the test set, configure the job execution plan, execute the job, and generate a test report.

6. A device for automated testing of regulatory submissions, comprising: The data generation module is used to automatically generate test data that can cover all reporting items according to preset rules and algorithms; The test data includes information required for various regulatory reporting items such as customer information, transaction information, and account information; the data generation module is used to generate different quantities and types of test data as needed; A cross-check relationship management module is used to automatically establish a relationship between a new report item and an existing regulatory report item in a fixed format according to preset association rules when there is a new report item; the association relationship includes different dimensions based on time, transaction, and customer; the cross-check relationship management module includes an association relationship generation module, which is used to analyze the test data, find the association relationship therein, and establish a corresponding association model; The test execution module is used to simulate user operations, input the generated test data and established associations into the system under test, execute corresponding business operations, and obtain test results; The test execution module records various information during the test process, including operation steps, execution time, and test results.

7. The device for automated testing of regulatory submissions as claimed in claim 6, wherein: Also includes: The result analysis module is used to analyze and evaluate the test results to determine whether the tested system meets the preset test requirements; If the test results do not meet the requirements, the result analysis module generates a test report and gives corresponding improvement suggestions.

8. The device for automated testing of regulatory submissions as claimed in claim 6, wherein: Also includes: The system management module is used to manage account management, authority management, and control account access and usage permissions of functional modules.

9. An electronic device, comprising: A memory, a processor, and a regulatory reporting automation test program stored in the memory and executable on the processor, wherein the regulatory reporting automation test program, when executed by the processor, implements the steps of the regulatory reporting automation test method as described in any one of claims 1 to 5.

10. A computer storage medium, wherein: The computer storage medium stores an automated testing program for regulatory reporting, and when the automated testing program for regulatory reporting is executed by the processor, the steps of the automated testing method for regulatory reporting as described in any one of claims 1 to 5 are implemented.

Images