Financial data auditing method based on scripting language definition

Abstract

The invention discloses a financial data auditing method based on scripting language definition, and is applied to the field of data auditing. In the method, in response to a data checking operation, to-be-audited data can be obtained; according to the method, an auditing query script can be determined according to the name of the to-be-audited data, then the to-be-audited data is queried from physical databases of a plurality of service systems according to the auditing query script, and the to-be-audited data in the plurality of physical databases are counted to generate an auditing data set. And finally, according to a data auditing processing rule, performing data auditing on the auditing data set. In the process, the data auditing operation can be executed through script configuration, business personnel do not need to manually execute data auditing, one-time definition of the data auditing script and subsequent multiple execution of the data auditing operation are achieved, and therefore the efficiency and accuracy of data auditing are improved. And besides manual execution, the data checking operation can also be executed regularly, so that the data checking efficiency is further improved.

Description

Technical Field

[0001] The present application relates to the technical field of data auditing, and in particular to a financial data auditing method based on a scripting language definition. Background Art

[0002] With the continuous development of Internet technology, the business systems of enterprises are complex and the relationships between multiple business systems are complicated. For example, fund companies cannot communicate with each other due to the existence of outsourced systems. However, according to the business definition, the business system needs to keep the data consistent, so manual verification of business data is required. However, due to the cumbersome business data and many business scenarios, manual verification is not only costly, inefficient, but also inaccurate. Summary of the invention

[0003] The present application provides a financial data auditing method based on a scripting language definition. By configuring the processing script, the data to be audited in the physical databases of different business systems can be queried on the business system, and data auditing can be performed without the need for manual processing by professionals, thereby not only improving work efficiency but also improving the accuracy of data auditing.

[0004] The present application provides a financial data auditing method based on a scripting language definition, which is applied to a business system. The method includes:

[0005] In response to the multi-system data verification operation, the data to be audited is obtained from a financial data set, where the financial data set is a set of business data in multiple business systems;

[0006] Determine the multi-system audit query script according to the query name of the data to be audited, and the corresponding relationship between the query name of the data stored in the business system and the query script;

[0007] According to the multi-system audit query script, the data to be audited is queried from the physical databases of multiple business systems, and the data to be audited in multiple physical databases are statistically analyzed to generate an audit data set;

[0008] According to the data audit processing rules, the audit data set is audited, and the data audit processing rules are written by Groovy scripts.

[0009] Optionally, before responding to the data verification operation, the method further includes:

[0010] In response to the data query definition operation, query parameters of the financial data set are obtained, and the query parameters include a query name of each data, a query script, and a data source corresponding to each query script.

[0011] Optionally, according to the query name of the data to be audited, a multi-system audit query script is determined, including:

[0012] According to the query name of the data to be audited, the query script of the data to be audited is obtained from the query parameters of the data to be audited;

[0013] According to the data source to be queried, a multi-system audit query script is determined from the query script of the data to be audited, and the multi-system audit query script corresponds to the data source to be queried.

[0014] Optionally, according to the data audit processing rules, a data audit is performed on the audit data set, including:

[0015] According to the data audit processing rules, the audit data from different data sources in the audit data set are compared and processed to obtain processing results, which include the same comparison, different comparison, and execution failure.

[0016] Optionally, the method further comprises:

[0017] In response to the single system data verification operation, a query name of the data to be queried is obtained, where the data to be queried is the business data to be queried in the target system;

[0018] Determine the audit query script of the billing system based on the query name of the data to be queried;

[0019] The single system audit query script is executed according to the data audit processing rules. If the query data is queried from the physical database in the target system, the processing result is generated.

[0020] Optionally, the method further comprises:

[0021] The processing results are sent to the business personnel in the sending form in the data audit processing rules to inform the business personnel of the processing results. The sending form includes: sending reminders through SMS, email and internal messages.

[0022] Optionally, the method further comprises:

[0023] The sending time is set in the data audit processing rules so that when the current time of the business system is the sending time, the processing results will be sent to the business personnel.

[0024] Optionally, the method further comprises:

[0025] In response to the data query operation, obtaining a name of the data to be queried and verified, wherein the name of the data to be queried and verified is defined by performing a data verification operation, wherein the data query operation includes manual execution and scheduled execution;

[0026] According to the name of the data to be queried, the processing result and processing detail data of the corresponding data verification operation are obtained.

[0027] It can be seen that this application has the following beneficial effects:

[0028] The present application provides a financial data audit method based on a script language definition. In response to a data verification operation, the data to be audited can be obtained; according to the name of the data to be audited, an audit query script can be determined, and then according to the audit query script, the data to be audited can be queried from the physical databases of different business systems, and the data to be audited in the physical databases of different business systems are statistically generated to generate an audit data set. Finally, according to the data audit processing rules, the audit data set is audited. In this process, the data audit operation can be performed through script configuration, and there is no need for business personnel to manually perform data audits. It can be achieved by defining data verification related scripts once, and then performing data verification operations multiple times, thereby improving the efficiency and accuracy of data audits. In addition, the execution of data verification operations can not only be performed manually, but can also be defined as scheduled execution of data verification operations when writing scripts, without the need to perform manual execution operations each time, thereby further improving the efficiency of data audits. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present application. For ordinary technicians in this field, other drawings can also be obtained based on these drawings.

[0030] Figure 1 A flowchart of a financial data audit method defined in a scripting language in an embodiment of the present application;

[0031] Figure 2 This is a flowchart of an embodiment of a financial data audit method defined based on a scripting language in an embodiment of the present application;

[0032] Figure 3 A schematic diagram of configuring a query script for data to be audited in an embodiment of the present application;

[0033] Figure 4 A schematic diagram of configuring a query script for data to be audited in an embodiment of the present application;

[0034] Figure 5 This is a flowchart of an embodiment of a financial data audit method defined based on a scripting language in an embodiment of the present application. DETAILED DESCRIPTION

[0035] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0036] It should be noted that the business personnel information (including but not limited to business personnel equipment information, business personnel personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the business personnel or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant laws, regulations and standards of relevant countries and regions.

[0037] At present, the data of different business systems in the business system needs to be consistent, so manual verification of business data is required, but manual verification is complicated and difficult; there are also complicated business data and many business scenarios, and manual verification of data anomalies is very difficult and easy to miss. For example, business personnel will export data from different business systems into Excel tables and verify the data through functions. In this process, verification is difficult and errors are very easy. At the same time, the frequency of business scenarios and data volume increases gradually, resulting in the need to frequently modify the data verification method. In summary, the current method of manual data verification is not only inefficient, but also inaccurate.

[0038] In the embodiment of the present application, by configuring the processing script once, the data to be audited in the physical databases of different business systems can be queried on the business system, and data audit can be performed, that is, the data audit operation can be performed multiple times subsequently, without the need for professionals to perform manual processing each time, thereby not only improving work efficiency, but also improving the accuracy of data audit. In specific implementation, the method may, for example, include: in response to a multi-system data verification operation, obtaining the data to be audited from a financial data set, wherein the financial data set is a set of business data in multiple business systems; determining a multi-system audit query script based on the query name of the data to be audited; based on the multi-system audit query script, querying the data to be audited from the physical databases of multiple business systems, and statistically generating an audit data set from the data to be audited in the multiple physical databases; and performing a data audit on the audit data set according to the data audit processing rules, wherein the data audit processing rules are written in a Groovy script.

[0039] It can be seen that the method provided by the implementation of this application can obtain the data to be audited in response to the multi-system data verification operation; according to the name of the data to be audited, the multi-system audit query script can be determined, and then according to the audit query script, the data to be audited can be queried from the physical database of the business system, and the data to be audited in multiple physical databases are statistically generated to generate an audit data set. Finally, according to the data audit processing rules, the audit data set is audited. In this process, the data audit operation can be performed by defining the data verification related script once, that is, the data audit operation can be performed multiple times subsequently, without the need for business personnel to manually perform data audits, thereby improving the efficiency and accuracy of data audits.

[0040] To facilitate understanding of the specific implementation of the financial data audit method defined based on the scripting language provided in the embodiment of the present application, it will be described below with reference to the accompanying drawings.

[0041] like Figure 1 As shown, the method includes the following S101 to S104:

[0042] S101: In response to a multi-system data verification operation, determine data to be audited from a financial data set, where the financial data set is a set of business data in multiple business systems.

[0043] In order to perform data audit on data in multiple business systems, it is first necessary to respond to the multi-system data verification operation and determine the data to be audited from the financial data set; determine the multi-system audit query script according to the query name of the data to be audited; then, according to the multi-system audit query script, query the data to be audited from the physical databases in multiple business systems, and generate an audit data set by statistically analyzing the data to be audited in the multiple physical databases; finally, perform data audit on the audit data set according to the data audit processing rules. Therefore, the embodiment of the present application determines the data to be audited through S101, making preliminary preparations for the subsequent determination of the multi-system audit query script.

[0044] As an example, before executing S101, it also includes: defining a data query operation, that is, the business system can obtain the query parameters of the input financial data set in response to the data query definition operation, and the query parameters include the query name of each data, the query script, and the data source corresponding to each query script. Among them, the defined query parameters also include the returned audit data set. In this process, in order to solve the problem that data exists in multiple data sources during data verification, the definition of data query can be parameterized so that the data to be audited can be queried in the physical databases of multiple systems later. In addition, in order to ensure the uniqueness of the data query operation, it is also necessary to define the number of the data query.

[0045] S102: Determine a multi-system audit query script based on the query name of the data to be audited, and the correspondence between the query name of the data stored in the business system and the query script.

[0046] Since the data query has been defined in the above process, the multi-system audit query script can be directly determined by the query name of the data to be audited. The specific process may include: obtaining the query script of the data to be audited from the query parameters of the data to be audited according to the query name of the data to be audited; determining the multi-system audit query script from the query script of the data to be audited according to the data source to be queried, and the multi-system audit query script corresponds to the data source to be queried.

[0047] Since the query scripts are defined based on different data sources when defining the query parameters of the data above, for example, the data of xx bank is stored in the physical databases of three business systems, and three query scripts need to be defined accordingly so that they can be queried in the corresponding data sources. Based on this, when the query scripts of the data to be audited obtained in the above process are a query script set, the business personnel can determine the multi-system audit query scripts from the query scripts of the data to be audited according to the data sources to be queried. For example, the query scripts of the data to be audited obtained are query script 01, query script 02 and query script 03, which correspond to data source 01, data source 02 and data source 03 respectively. The business personnel only need to perform data audit on the data to be audited in data source 01 and data source 02 according to business needs. Therefore, query script 01 and query script 02 can be directly selected from the query script 01, query script 02 and query script 03 obtained as multi-system audit query scripts, thereby realizing multi-directional and multi-angle data audit.

[0048] S103: According to the multi-system audit query script, the data to be audited is queried from the physical databases of multiple business systems, and the data to be audited in the multiple physical databases are statistically analyzed to generate an audit data set.

[0049] According to the configured multi-system audit query script, the data to be audited can be directly queried from the physical databases of multiple business systems, and for the subsequent data audit, the data to be audited queried from multiple physical databases can be statistically generated to generate an audit data set. In this process, the data to be audited can be directly queried from the physical databases of multiple business systems according to needs through a one-time configuration script, and can be operated multiple times directly according to the script later, without the need for business personnel to log in to different business systems to export data, thereby improving the operational efficiency of data auditing.

[0050] S104: Performing data audit on the audit data set according to the data audit processing rules, wherein the data audit processing rules are written by Groovy scripts.

[0051] As an example, S104 may include: performing comparison processing on the audited data from different data sources in the audit data set according to the data audit processing rules to obtain processing results, wherein the processing results include comparison identical results, comparison different results, and execution failure results. That is, the data audit processing rules written using the Groovy script include a determination process for comparison identical, comparison different, and execution failure, and generate corresponding processing results.

[0052] Since Groovy is an agile dynamic language of the Java virtual machine, it is a mature object-oriented programming language. You don't need to write too much code when using this language, and it also has closures and other features of dynamic languages. Therefore, in the above process, using Groovy scripts to write data audit processing rules does not require high technical skills from the writers, improves the efficiency and accuracy of script writing, and further improves the efficiency and accuracy of data auditing.

[0053] The definition of the data audit processing rules can be to compare the multiple data lists obtained, and obtain the processing results of the same and different comparisons. In the process of processing, the multiple data lists can also be processed by intersection and union, and the intersection processing results and union processing results are displayed in the above processing results, so as to more intuitively see the number of identical and different items in the multiple data lists, so that business personnel can perform subsequent processing. In addition, the time can be set in the data audit processing rules to regularly perform data audits on the audit data set, thereby improving the convenience of data audit operations.

[0054] It should be noted that in addition to executing multi-system data verification operations, the embodiments of the present application can also execute single-system data verification operations. The specific process includes: in response to the single-system data verification operation, obtaining the query name of the data to be queried, and the data to be queried is the business data to be queried in the target system; according to the query name of the data to be queried, determining a single-system audit query script; finally, executing the single-system audit query script according to the data audit processing rules, if the query data is queried from the physical database in the target system, then generating a processing result. In this process, by configuring the single-system audit query script, data tracking in the target system can be achieved.

[0055] As an example, after obtaining the processing results as described above, the processing results can also be sent to business personnel. The specific process includes, for example: sending the processing results to business personnel through the sending form in the data audit processing rules to inform the business personnel of the processing results. The sending form includes: sending reminders through text messages, emails, and internal messages. That is, different sending methods can be defined in the data audit processing rules for different processing results to send the processing results to business personnel. For example, if the processing result is execution failure, it means that when executing the multi-system data verification operation, the data comparison fails due to data errors or program errors. At this time, the processing result can be sent to the business personnel via email to inform the business personnel to handle it. For another example, if the processing result is to query the query data, the queried query data can be sent to the business personnel via email so that the business personnel can track the data.

[0056] As an example, in the data audit processing rules, not only the sending method but also the sending time can be defined, that is, the sending time can be preset so that when the current time of the business system is the sending time, the processing results can be sent to the business personnel. This avoids the situation where multiple processing results are sent to the business personnel at the same time, causing "message bombardment".

[0057] In addition, in the embodiment of the present application, business personnel can also query the processing results of data audits by themselves. The specific process includes, for example: in response to the data query operation, obtaining the name of the data to be queried, the name of the data verification is defined for executing the data verification operation; according to the name of the data to be queried, obtaining the processing results and processing details of the corresponding data verification operation. Among them, when performing the data verification operation, in order to ensure the uniqueness of the data verification operation, it is first necessary to define the name and number of the data verification operation, so that the processing results and processing details of the corresponding data verification operation can be obtained according to the name and number of the data verification operation.

[0058] In addition, the embodiments of the present application can also enable business personnel to manually perform data audit operations, and can configure the scheduled execution of data audit operations to obtain processing results.

[0059] It can be seen that the embodiment of the present application responds to the data verification operation, and in response to the data verification operation, the data to be audited can be obtained; according to the name of the data to be audited, an audit query script can be determined, and then according to the audit query script, the data to be audited is queried from the physical databases of multiple business systems, and the data to be audited in the multiple physical databases are statistically generated to generate an audit data set. Finally, according to the data audit processing rules, the audit data set is audited. In this process, the data audit operation can be executed through script configuration, and there is no need for business personnel to manually perform data audits. The data verification script is defined once, and the data verification operation is performed multiple times subsequently, thereby improving the efficiency and accuracy of the data audit. In addition to manual execution, the data verification operation can also be performed regularly, further improving the efficiency of data auditing.

[0060] In order to make the method provided in the embodiment of the present application clearer and easier to understand, Figure 2 A specific example of applying this method to multi-system data verification operation is described.

[0061] like Figure 2 As shown, the implementation may include:

[0062] S201: In response to a data query definition operation, a query parameter of a financial data set is obtained.

[0063] In order to perform data audit operations, you first need to perform data query operations to query the data to be audited in the physical databases of multiple business systems. Therefore, you need to define the query parameters of the financial data set first. In response to the data query definition operation of the business personnel, the query number, query script and data source corresponding to each query script of each data in the financial data set input by the business personnel are obtained. That is, the business personnel can write the corresponding query script according to the specific data source selected, and can also define the audit data set to be returned. For example Figure 3 and Figure 4 As shown in the figure, write corresponding query scripts according to different data sources, where Figure 3 and Figure 4 The query function scripts in are all defined as "Big Data Commercial Bank Data Comparison", that is, the query script is to query big data commercial bank data. The difference is that Figure 3 The data source in corresponds to "o32", and Figure 4 The data source in corresponds to "bdapp", that is, in order to compare the big data commercial bank data in these two data sources, it is necessary to first define the query script SQL for querying the big data commercial bank data of these two data sources.

[0064] In this process, query scripts are written to query the data to be audited from multiple physical databases, eliminating the need for business personnel to log in to different business systems to export data, thereby improving the efficiency of data auditing.

[0065] S202: In response to the multi-system data verification operation, define data verification parameters of the data to be audited in the financial data set, wherein the data verification parameters include a multi-system audit query script.

[0066] After defining the data query as above, business personnel can perform multi-system data verification operations. Therefore, in response to the data verification operation, the parameters of the data verification of the data to be audited are defined, including: the name and number of the data verification of the data to be audited, and the associated multi-system audit query script.

[0067] The process of specifically defining the associated multi-system audit query script includes: obtaining the query script of the data to be audited from the query parameters of the data to be audited according to the query name of the data to be audited obtained above. Then, according to the data source to be queried, the multi-system audit query script is determined from the query script of the data to be audited, and the multi-system audit query script corresponds to the data source to be queried.

[0068] In this process, by defining the parameters of data verification, the corresponding audit query script can be associated according to business needs. It is only necessary to query in the physical database of the corresponding business system to avoid subsequent query operations on the physical databases of all business systems, thereby improving the efficiency of data auditing.

[0069] S203: According to the multi-system audit query script, the data to be audited is queried from the physical databases of multiple business systems, and the data to be audited in the multiple physical databases are statistically analyzed to generate an audit data set.

[0070] During this process, the audit query script can be used to query the data to be audited in the physical database of the corresponding business system. At the same time, in order to perform subsequent comparison processing on the data to be audited, the data to be audited obtained from multiple physical databases will be statistically analyzed to generate an audit data set.

[0071] S204: using data audit processing rules to compare and process the data to be audited from different data sources in the audit data set to obtain processing results, wherein the data audit processing rules are written using Groovy scripts.

[0072] Business personnel write data audit processing rules according to business needs, which are written in Groovy. The written content includes: comparing whether the data from different data sources in the audit data set are the same. If the judgment result of the comparison is the same, the processing result can include the comparison of the same fields, and can also include the number of data items from different data sources, as well as the number of equal items, the number of unequal items, and the number of data items that are not involved in the comparison. Based on this, if the judgment result of the comparison is different, the processing result can include the comparison of different fields, and can also include the number of data items from different data sources, as well as the number of equal items, the number of unequal items, and the number of data items that are not involved in the comparison. If the processing result of failed execution is obtained, the processing result can include the field where the execution failed.

[0073] As an example, for the operation of comparing the audited data from different data sources in the audit data set, the relevant code for timed processing can be written in the data audit processing rules to achieve the purpose of defining the operation once and executing the operation multiple times subsequently, thereby improving the convenience of data audit operations.

[0074] In this process, business personnel can complete data audit operations directly by writing code according to their needs, which can not only improve the work efficiency of data audit, but also improve the accuracy of data audit, and achieve the purpose of defining the data verification script once and executing data verification operations multiple times subsequently. In addition, data audit processing rules can be written by Groovy scripts, which does not require business personnel to have high-tech writing capabilities, further improving the universality of data audit methods.

[0075] In addition, if special circumstances occur, the embodiments of the present application can also allow business personnel to manually perform data audit operations or set up scheduled data audit operations and obtain processing results.

[0076] S205: Send the processing result to the business personnel in the sending form specified in the data audit processing rules.

[0077] The data audit processing rules define the ways in which the processing results can be sent to business personnel, which can include SMS, email, internal message, WeChat and other sending methods to inform business personnel of the processing results and conduct subsequent processing. In addition to defining the sending method, you can also define the sending time, that is, you can pre-set the sending time so that when the current time of the business system is the sending time, the processing results can be sent to business personnel. This avoids the situation of "message bombardment" caused by sending multiple processing results to business personnel at the same time.

[0078] S206: In response to the data query operation, obtain the name of the data to be queried.

[0079] The business personnel can also query the processing results of the data audit by themselves, that is, in response to the query data operation, obtain the name of the data audit entered by the business personnel. In addition to the name of the data audit, the number of the data audit can also be used to query data.

[0080] S207: According to the name of the data to be queried, the processing result and processing detail data of the corresponding data verification operation are obtained.

[0081] Since the name of the data check is defined when the above data check is defined, the processing result and processing details of the corresponding data check operation can be obtained according to the name of the data check to be queried. Similarly, the processing result and processing details of the corresponding data check operation can also be obtained according to the number of the data check to be queried. Therefore, business personnel can not only receive the processing results, but also query the processing results by themselves, so as to improve the convenience of data auditing.

[0082] This embodiment provides a financial data audit method based on the definition of a scripting language, which implements the definition of query scripts in data query. Data can be directly queried from the physical databases of different business systems through query scripts. Then, by defining data auditing, the required query scripts are associated, and the data to be audited can be queried in the required physical database of the business system. By writing data audit processing rules, data audits can be performed on the audit data set, thereby realizing data auditing through code writing. In this process, multi-system data auditing control can realize data auditing by multiple business systems, and it can be defined once and executed multiple times later, without the need for business personnel to manually perform data auditing, thereby improving the efficiency and accuracy of data auditing. In addition, feedback and query functions for execution results are also provided, which improves the convenience of data auditing.

[0083] In order to make the method provided in the embodiment of the present application clearer and easier to understand, Figure 5 A specific example of applying this method to a single system data verification operation is described.

[0084] S501: In response to a data query definition operation, a query parameter of a financial data set is obtained.

[0085] Consistent with S201 in the above embodiment, in order to perform data auditing operations, it is necessary to first define the query parameters of the financial data set, and the specific process is the same, that is, define the query number, query script, and data source corresponding to each query script for each data in the financial data set. That is, by writing a query script, the data to be queried can be queried from the target system, achieving the purpose of defining once and then performing multiple operations later, without the need for business personnel to repeatedly write query scripts, thereby improving the efficiency of data auditing.

[0086] S502: In response to a single system data verification operation, define data verification parameters of the data to be queried in the financial data set, where the data to be queried is the business data to be queried in the target system, and the data verification parameters include a single system audit query script.

[0087] When business personnel perform single-system data verification operations, they need to define the data verification parameters of the data to be queried, including: the name and number of the data verification of the data to be queried, and the corresponding single-system audit query script. Among them, since the query script of the data to be queried has been defined above, the query script of the data to be queried can be determined as a single-system audit query script according to the name of the data to be queried.

[0088] In this process, by defining the parameters of data verification, you can directly obtain the query script of the corresponding data to be queried according to the name of the data to be queried, thereby determining the corresponding single-system audit query script. By defining the query script once, you can use the query script as the corresponding single-system audit query script multiple times in the future, thereby improving the efficiency of data auditing.

[0089] S503: Execute the single system audit query script according to the data audit processing rules. If the query data is queried from the physical database in the target system, a processing result is generated. The data audit processing rules are written in Groovy scripts.

[0090] Business personnel write data audit processing rules based on business needs, using Groovy to write them. The content includes: executing a single system audit query script, and generating processing results if the query data is found from the physical database in the target system. For example, if the target system is queried for relevant data that the number of people who failed the exam exceeds 80% of the total number of people, if the relevant data is found, the processing results are generated.

[0091] In this process, business personnel can complete data audit operations directly by writing code according to their needs, which can not only improve the work efficiency of data audit, but also improve the accuracy of data audit, and achieve the purpose of defining the data verification script once and executing data verification operations multiple times subsequently. In addition, data audit processing rules can be written by Groovy scripts, which does not require business personnel to have high-tech writing capabilities, further improving the universality of data audit methods.

[0092] S504: Send the processing result to the business personnel in the sending form specified in the data audit processing rules.

[0093] As shown in S205 in the above embodiment, the processing result can be sent to the business personnel in a variety of ways to inform the business personnel of the processing result and perform subsequent processing. In addition, the sending time can be defined, that is, the sending time can be preset so that when the current time of the business system is the sending time, the processing result can be sent to the business personnel. This avoids the situation of "message bombardment" caused by sending multiple processing results to the business personnel at the same time after obtaining them.

[0094] S505: In response to the data query operation, obtain the name of the data to be queried.

[0095] As shown in S206 in the above embodiment, the business personnel can also query the processing results of the data audit by themselves, that is, in response to the data query operation, obtain the name of the data audit input by the business personnel. In addition to the name of the data audit, the number of the data audit can also be used to query data.

[0096] S506: According to the name of the data to be queried, the processing result and processing detail data of the corresponding data verification operation are obtained.

[0097] As shown in S207 in the above embodiment, since the name of the data check is defined when the above data check definition operation is performed, the processing result and processing details of the corresponding data check operation can be obtained according to the name of the data check to be queried. Similarly, the processing result and processing details of the corresponding data check operation can also be obtained according to the number of the data check to be queried. As a result, business personnel can not only receive the processing results, but also query the processing results by themselves, so as to improve the convenience of data auditing.

[0098] This embodiment provides a method for financial data audit based on script language definition, which implements the query script in the definition of data query. The query script can be used to directly query data from the physical database of the target system. Then, by defining data audit, the data to be queried is associated with the query script to obtain a single system audit query script. Moreover, by writing data audit processing rules, the single system audit query script can be executed to query whether there is data to be queried in the target system, thereby realizing data audit through code writing. In this process, the single system data audit operation can realize target data tracking, and it can be defined once and executed multiple times later, without the need for business personnel to manually perform data audit, thereby improving the efficiency and accuracy of data audit. In addition, feedback and query functions for execution results are also provided, which improves the convenience of data audit.

[0099] Through the description of the above implementation methods, it can be known that those skilled in the art can clearly understand that all or part of the steps in the above-mentioned embodiment method can be implemented by means of software plus a general hardware platform. Based on such an understanding, the technical solution of the present application can be embodied in the form of a software product, which can be stored in a storage medium, such as a read-only memory (ROM) / RAM, a magnetic disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network communication device such as a router) to execute the methods described in each embodiment of the present application or some parts of the embodiments.

[0100] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment. The device embodiment described above is only schematic, in which the modules described as separate components may or may not be physically separated, and the components displayed as modules may or may not be physical modules, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules can be selected according to actual needs to achieve the goals of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative work.

[0101] The above description is merely an exemplary embodiment of the present application and is not intended to limit the protection scope of the present application.

Claims

1. A financial data audit method based on scripting language definition, characterized in that: The method comprises: In response to the multi-system data verification operation, the data to be audited is obtained from a financial data set, where the financial data set is a set of business data in multiple business systems; Determine a multi-system audit query script based on the query name of the data to be audited, and the corresponding relationship between the query name of the data stored in the business system and the query script; According to the multi-system audit query script, the data to be audited are queried from the physical databases of the multiple business systems, and the data to be audited in the multiple physical databases are statistically analyzed to generate an audit data set; According to the data audit processing rules, the audit data set is audited, and the data audit processing rules are written by Groovy scripts.

2. The method according to claim 1, characterized in that Before the data verification operation is performed, the method further includes: In response to the data query definition operation, query parameters of the financial data set are obtained, and the query parameters include a query name of each data, a query script, and a data source corresponding to each query script.

3. The method according to claim 2, characterized in that Determining a multi-system audit query script according to the query name of the data to be audited includes: According to the query name of the data to be audited, from the query parameters of the data to be audited, obtaining the query script of the data to be audited; According to the data source to be queried, the multi-system audit query script is determined from the query script of the data to be audited, and the multi-system audit query script corresponds to the data source to be queried.

4. The method according to claim 1, characterized in that: The step of performing data audit on the audit data set according to the data audit processing rules includes: According to the data audit processing rules, the data to be audited from different data sources in the audit data set are compared and processed to obtain processing results, and the processing results include the same comparison, different comparison, and execution failure.

5. The method according to claim 1, characterized in that: The method further comprises: In response to the single system data verification operation, a query name of the data to be queried is obtained, where the data to be queried is the business data to be queried in the target system; Determine the audit query script of the order system according to the query name of the data to be queried; The single system audit query script is executed according to the data audit processing rules, and if query data is queried from the physical database in the target system, a processing result is generated.

6. The method according to claim 4 or 5, characterized in that: The method further comprises: The processing result is sent to the business personnel through the sending form in the data audit processing rules to inform the business personnel of the processing result. The sending form includes: sending reminders through text messages, emails and internal messages.

7. The method according to claim 6, characterized in that The method further comprises: The sending time is set in the data audit processing rule so that when the current time of the business system is the sending time, the processing result is sent to the business personnel.

8. The method according to claim 4 or 5, characterized in that: The method further comprises: In response to the data query operation, obtaining a name of the data to be queried and verified, wherein the name of the data to be queried and verified is defined by performing a data verification operation, wherein the data query operation includes manual execution and scheduled execution; According to the name of the data to be queried, the processing result and processing detail data of the corresponding data verification operation are obtained.

Images