Audit data integration system, method and device, storage medium and program product

Abstract

The invention provides an audit data integration system, method and device, a storage medium and a program product. Relates to the technical field of data processing. The system comprises a source data integration module for receiving source data tables corresponding to a plurality of service fields and integrating the source data tables into a plurality of general field data tables and service data tables corresponding to the service fields respectively; the audit data query module is used for generating a data query model corresponding to the business field to which the business user belongs according to a model generation request input by the business user; the data query model is used for transmitting the generated audit data to the audit data integration module or outputting the audit data to the audit user when receiving a data query condition input by the audit user; and the audit data integration module is used for carrying out data integration processing on the audit data input by the audit data query module and / or the audit user, and generating a data integration report corresponding to the audit data. According to the method, the technical problem of low audit data integration efficiency is solved.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to an audit data integration system, method, device, storage medium and program product. Background Art

[0002] As enterprises develop, their businesses become more diversified and complex. As regulatory requirements for enterprises increase, internal audits need to audit all business lines within the enterprise, making the management and analysis of audit data increasingly complex and critical.

[0003] Audit data usually comes from multiple heterogeneous systems, including but not limited to the financial management system, business operation system, customer relationship management system and other related databases in the enterprise. The data formats, structures and storage methods of these systems are different, which makes the integration of audit data in the audit process complicated and time-consuming, thus leading to problems such as low efficiency of the entire audit work.

[0004] Therefore, there is an urgent need for a new audit data integration system and data integration method to solve the technical problem of low data integration efficiency. Summary of the invention

[0005] The present application provides an audit data integration system, method, device, storage medium and program product to solve the technical problem of low efficiency of audit data integration in the prior art.

[0006] In a first aspect, the present application provides an audit data integration system, the system comprising: a source data integration module, an audit data query module and an audit data integration module; the audit data query module is connected to the source data integration module and the audit data integration module respectively; wherein,

[0007] The source data integration module is used to receive source data tables corresponding to multiple business fields, and integrate each of the source data tables into multiple general field data tables and business data tables corresponding to each of the business fields;

[0008] The audit data query module is used to generate a data query model corresponding to the business field to which the business user belongs according to a model generation request input by the business user; wherein the data query model is used to perform data query operations on each of the general field data tables and / or each of the business data tables, and upon receiving the data query conditions input by the audit user, transmit the generated audit data to the audit data integration module, or output it to the audit user;

[0009] The audit data integration module is used to perform data integration processing on the audit data input by the audit data query module and / or the audit user, and generate a data integration report corresponding to the audit data.

[0010] Optionally, the audit data query module is specifically used to:

[0011] Upon receiving a model generation request input by any business user, determining the business domain to which the business user belongs;

[0012] According to the data query requirements contained in the model generation request and the data query logic corresponding to the data query requirements, a data query model corresponding to the business field is generated.

[0013] Optionally, the audit data query module is further used to:

[0014] Upon receiving the model adjustment request transmitted by the business user, determining the data query model corresponding to the model adjustment request;

[0015] The model adjustment logic of the data query model is generated according to the target data query logic included in the model adjustment request and the current data query logic of the data query model, and the data query model is adjusted according to the model adjustment logic.

[0016] Optionally, it is characterized in that

[0017] The data query model is used to perform data query operations on each of the general domain data tables and / or each of the business data tables according to the data query conditions preset in the model, obtain and store the audit data corresponding to each of the data query conditions, so that when the audit user inputs the corresponding data query condition, the audit data corresponding to the data query condition is immediately output.

[0018] Optionally, the source data query module includes a source data loading layer and a data integration layer;

[0019] The source data loading layer is used to receive source data tables transmitted by the business field using different transmission strategies, and store each source data table in the source data integration module according to the data loading method corresponding to each transmission strategy;

[0020] The data integration layer is used to integrate the source data tables into a plurality of general domain data tables and a plurality of business data tables corresponding to business domains according to data attributes corresponding to the source data tables.

[0021] In a second aspect, the present application provides an audit data integration method, which is applied to the audit data integration system described in the first aspect, and the method includes:

[0022] Determine the corresponding data query model based on the model selection operation input by the audit user;

[0023] Receiving data query conditions input by the audit user, and determining audit data corresponding to the data query conditions in the data query model;

[0024] Perform data integration processing on the audit data and generate a data integration report corresponding to the audit data.

[0025] Optionally, after determining the audit data corresponding to the data query condition in the data query model, the method further includes:

[0026] According to the data export instruction input by the audit user, the audit data is output to the audit user, so that the audit user performs data customization processing on the audit data to generate customized audit data;

[0027] Accordingly, the method further includes:

[0028] The customized audit data input by the audit user is received, data integration processing is performed on the customized audit data, and a data integration report corresponding to the customized audit data is generated.

[0029] In a third aspect, the present application provides an electronic device, comprising: a processor, and a memory communicatively connected to the processor;

[0030] The memory stores computer-executable instructions;

[0031] The processor executes the computer-executable instructions stored in the memory to implement the method according to the second aspect.

[0032] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores computer-executable instructions, and when the computer-executable instructions are executed by a processor, they are used to implement the method described in the second aspect.

[0033] In a fifth aspect, the present application provides a computer program product, including a computer program, which implements the method described in the second aspect when executed by a processor.

[0034] In the technical solution provided by the present application, the audit data integration system includes a source data integration module, an audit data query module and an audit data integration module; the audit data query module is connected to the source data integration module and the audit data integration module respectively; wherein the source data integration module is used to receive source data tables corresponding to multiple business fields, and integrate each of the source data tables into multiple general field data tables and business data tables corresponding to each of the business fields; the audit data query module is used to generate a data query model corresponding to the business field to which the business user belongs according to a model generation request input by a business user; wherein the data query model is used to perform data query operations on each of the general field data tables and / or each of the business data tables, and upon receiving the data query conditions input by the audit user, transmit the generated audit data to the audit data integration module, or output it to the audit user; the audit data integration module is used to perform data integration processing on the audit data input by the audit data query module and / or the audit user, and generate the audit data corresponding to data integration report; in the above system, when the source data integration module is used for data integration, the source data tables corresponding to each business field are received, and the metadata tables are integrated to generate general field data tables common to each business field and business data tables corresponding to each business field. Through the above integration processing, it is convenient to quickly locate the audit data corresponding to the query conditions during subsequent data queries, thereby improving the efficiency of data integration; further, in the audit data query module, a model generation request generated by each business personnel according to the data query requirements is received, and a corresponding data query model is generated to implement the data query operation preset in the model according to the model and the integrated general field data tables and / or the business data tables, so that when the data query conditions input by the audit user are received, the pre-queried audit data can be directly called out and output, thereby further improving the efficiency of data integration; on this basis, the audit data integration module also integrates the queried audit data and generates a data integration report, thereby facilitating the subsequent execution of audit operations on the audit data and improving the overall efficiency of the audit work. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.

[0036] Figure 1 An application scenario diagram of the audit data integration system provided for this application;

[0037] Figure 2 A schematic diagram of the structure of an audit data integration system provided in an embodiment of the present application;

[0038] Figure 3A schematic diagram of the structure of another audit data integration system provided in an embodiment of the present application;

[0039] Figure 4 A flowchart of an audit data integration method provided for this application;

[0040] Figure 5 It is a block diagram of an electronic device provided in an embodiment of the present application.

[0041] The above drawings have shown clear embodiments of the present application, which will be described in more detail later. These drawings and text descriptions are not intended to limit the scope of the present application in any way, but to illustrate the concept of the present application to those skilled in the art by referring to specific embodiments. DETAILED DESCRIPTION

[0042] Exemplary embodiments will be described in detail herein, examples of which are shown in the accompanying drawings. When the following description refers to the drawings, the same numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with the present application. Instead, they are merely examples of devices and methods consistent with some aspects of the present application as detailed in the appended claims.

[0043] In the technical solution of this application, the collection, storage, use, processing, transmission, provision and disclosure of information such as financial data or user data involved shall comply with the provisions of relevant laws and regulations and shall not violate public order and good morals.

[0044] It should be noted that in the embodiments of the present application, certain software, components, models and other existing solutions in the industry may be mentioned, and they should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present application, but it does not mean that the applicant has or will necessarily use the solution.

[0045] First, the terms involved in this application are explained:

[0046] Audit: refers to the independent and systematic examination and evaluation of an organization's financial statements, business activities, internal control systems, etc. to ensure their authenticity, accuracy and compliance.

[0047] Audit data: refers to the various information and evidence collected and analyzed during the audit process to support the audit conclusions and opinions. This data can come from multiple sources, including financial statements, accounting records, internal control documents, business process records, contracts, invoices, bank statements, etc.

[0048] Audit data integration: refers to the collection, cleaning, conversion and merging of audit data from different sources and formats for comprehensive analysis and evaluation.

[0049] In the development of modern enterprises, their businesses are becoming more diversified and complex. With the increase in regulatory requirements for enterprises, internal audits need to audit all business lines in the enterprise, making the management and analysis of audit data increasingly complex and critical.

[0050] When conducting an audit project, it is usually necessary to rely on big data analysis technology to find suspicious data of the audit target in massive data to ensure its authenticity, accuracy and compliance. The audit project needs to cover most of the business areas of the enterprise, with a wide coverage. In addition, during the project audit process, it is necessary to review the data of the past few years in a short period of time, which has high requirements for data throughput performance and time length.

[0051] To meet the above requirements, before the audit system reviews the audit data, it can integrate the data of each source system through the pre-built audit data integration system. When using the audit system for auditing, it is only necessary to input the corresponding data query conditions according to the audit requirements, obtain the corresponding data integration report through multiple data query models in the audit data integration system, and conduct audits based on the data integration report, which can improve the overall audit efficiency of the audit work.

[0052] However, there are still some problems with the current data integration system: First, the number of query conditions supported for different business areas is unbalanced; for example, there are more queries supported for traditional business areas such as operating channels, personal finance, and retail credit, but there are fewer queries supported for business areas such as budget finance and international business auditing.

[0053] Second, the integration function of data integration is relatively simple; for example, it can only realize the import of data from various source systems, and does not further integrate the imported data according to business areas and audit scenarios.

[0054] The audit data integration system provided by the present application is intended to solve the above technical problems of the prior art. Specifically, when the source data integration module is used for data integration, the source data tables corresponding to each business field are received, and the metadata tables are integrated to generate the general field data tables common to each business field and the business data tables corresponding to each business field. Through the above integration processing, it is convenient to quickly locate the audit data corresponding to the query conditions during subsequent data query, thereby improving the efficiency of data integration; further, in the audit data query module, the model generation request generated by each business personnel according to the data query requirements is received, and the corresponding data query model is generated, so as to realize the data query operation preset in the model according to the model and the integrated general field data tables and / or each business data table, so that when the data query conditions input by the audit user are received, the pre-queried audit data can be directly called out and output, thereby further improving the efficiency of data integration; on this basis, the audit data integration module also integrates the queried audit data and generates a data integration report, so as to facilitate the subsequent audit operation on the audit data and improve the overall efficiency of the audit work.

[0055] Figure 1 This is an application scenario diagram of the audit data integration system provided by this application. The audit data integration system provided by this application can be used to audit the internal part of a bank. Figure 1 The application scenarios to which the embodiments of the present application are applicable are described. Figure 1 The above scenario includes multiple banking business systems 11, an audit data integration system 12 and an audit system 13.

[0056] Specifically, each bank business system 11 transmits the generated business data as source data to the audit data integration system for data integration, thereby obtaining a plurality of general domain data tables and business data tables corresponding to each business domain, so as to improve the overall efficiency of the audit work.

[0057] The audit data integration system 12 generates a data query model based on the model generation request transmitted by the business user, so as to implement the data query operation corresponding to the query conditions according to each general field data table and / or each business data table to obtain the audit data; and when receiving the data query conditions input by the audit user, reads the audit data obtained by the pre-query according to the query conditions; and also integrates the queried audit data to generate a data integration report to improve the integration efficiency of the audit data; and transmits the data integration report to the audit system 13 to perform audit processing.

[0058] The audit system 13, when receiving the data integration report, quickly performs audit processing according to the data integration report, thereby improving the overall audit efficiency of the audit work.

[0059] It should be understood that the audit data integration system provided by this application is not only applicable to application scenarios of internal audits of banks, but also to scenarios of audits of other enterprises and organizations. This application does not make specific limitations on the application scenarios.

[0060] The technical solution of the present application and how the technical solution of the present application solves the above-mentioned technical problems are described in detail below with specific embodiments. The following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments. The embodiments of the present application will be described below in conjunction with the accompanying drawings.

[0061] Figure 2 The structure diagram of an audit data integration system provided in an embodiment of the present application. The system can be deployed together with the business system in the same electronic device, or in different electronic devices, and the electronic device can be a terminal device or a server, which is not specifically limited. The system in this embodiment can be implemented by software, hardware, or a combination of software and hardware, such as Figure 2 As shown, the audit data integration system 20 includes: a source data integration module 201, an audit data query module 202 and an audit data integration module 203; wherein the audit data query module 202 is connected to the source data integration module 201 and the audit data integration module 203 respectively.

[0062] Specifically, the source data integration module is used to receive source data tables corresponding to multiple business fields, and integrate each source data table into multiple general field data tables and business data tables corresponding to each business field; the audit data query module is used to generate a request based on the model input by the business user, and generate a data query model corresponding to the business field to which the business user belongs; wherein the data query model is used to perform data query operations on each general field data table and / or each business data table, and upon receiving the data query conditions input by the audit user, the generated audit data is transmitted to the audit data integration module, or output to the audit user; the audit data integration module is used to perform data integration processing on the audit data input by the audit data query module and / or the audit user, and generate a data integration report corresponding to the audit data.

[0063] In this application, the source data table is the data generated during the operation of the business system or internal management system of each business field, which may specifically include but is not limited to the generated account, transaction, customer, internal management and other data.

[0064] Each business system can transfer the source data table to the metadata integration module of the audit data integration system by batch transferring data files at preset intervals for data integration, thereby obtaining multiple general domain data tables and business data tables corresponding to each business domain.

[0065] Specifically, when each business system transfers the source data table to the audit data integration system, the source data is cleaned, formatted, and converted, and then loaded into the preset database for storage. According to the different business types corresponding to each business system, different methods can be used to transfer the source data table to the system. Incremental update and full update can be used to add, delete, and modify the data to be transferred, so as to synchronize the source data to the system and ensure the real-time and uniqueness of the data.

[0066] It should also be noted that the audit data integration system in this application is based on distributed database technology for data storage. Specifically, it can be explained as storing the received source data table, and / or the generated multiple general domain data tables and business data tables corresponding to each business field on multiple nodes to achieve data replication and ensure redundant backup of data to cope with the risk of data loss caused by failure of any node, and improve the security of data integration and data storage. On this basis, the data stored can also be dynamically expanded as needed, and nodes can be added to handle the data workload of EAI. In the case of a large increase in the amount of audit data, it can be achieved without rebuilding the entire system again, which increases the flexibility of the system.

[0067] In this application, the integrated and generated multiple general domain data tables and the business data tables corresponding to each business domain can be used as data support for the audit data query module to facilitate data query operations by the data query model constructed in the audit data query module.

[0068] Specifically, in the audit data query module, multiple data query models corresponding to each business field are pre-generated. Each data query model is used to perform data query operations based on each general field data table and / or each business data table, and data query conditions, to obtain the audit data corresponding to each data query condition, so that when the audit user inputs the data query conditions into the audit data integration model, the audit data corresponding to the data query conditions can be directly output, thereby improving the data integration efficiency.

[0069] In this application, before receiving the data query conditions input by the audit user, it is necessary to pre-build a data query model to enable the execution of data query operations. Specifically, the audit data query module receives the model generation request input by the business user, responds to the model generation request, and generates multiple data query models required by various business fields to facilitate the subsequent execution of data query operations.

[0070] It should be noted that the audit data query module generates requests based on the model generated by business users according to query requirements and generates corresponding data query models. This can achieve balanced support for data queries in various business fields, reduce the limitations of the audit data integration system in the number of queries supported in different business fields, and improve the universality of the system.

[0071] It should also be noted that the data query model can pre-execute data query operations and obtain the audit data corresponding to each query condition in advance based on the data query conditions pre-set in its model, as well as multiple general domain data tables and business data tables corresponding to each business field integrated and generated by the source data integration module. In this way, when the audit user enters the data query conditions, the queried audit data can be directly called and output, thereby improving the integration efficiency of data integration.

[0072] Furthermore, when the audit data query module obtains the audit data corresponding to the query conditions, it can directly output the audit data to the audit data integration module for data integration processing to generate the audit data, that is, the data integration report corresponding to the data query conditions.

[0073] Optionally, if the audit data query module receives a data export instruction input by the audit user, the audit data may also be output to the audit user, so that the audit user may customize the audit data according to needs.

[0074] Furthermore, if the audit user transmits the customized audit data to the audit data integration module, the module integrates the received audit data and generates a data integration report corresponding to the audit data, so as to facilitate the subsequent rapid audit processing based on the data integration report and improve the overall audit efficiency of the audit work.

[0075] The audit data integration system provided by the present application includes a source data integration module, an audit data query module and an audit data integration module; the audit data query module is connected to the source data integration module and the audit data integration module respectively; wherein the source data integration module is used to receive source data tables corresponding to multiple business fields, and integrate each source data table into multiple general field data tables and business data tables corresponding to each business field; the audit data query module is used to generate a data query model corresponding to the business field to which the business user belongs according to a model generation request input by a business user; wherein the data query model is used to perform data query operations on each general field data table and / or each business data table, and upon receiving the data query conditions input by the audit user, transmit the generated audit data to the audit data integration module, or output it to the audit user; the audit data integration module is used to perform data integration processing on the audit data input by the audit data query module and / or the audit user, and generate a data integration report corresponding to the audit data; in the above system, when using When the source data integration module performs data integration, it receives the source data tables corresponding to each business field, and integrates the metadata tables to generate general domain data tables common to each business field and business data tables corresponding to each business field. Through the above integration processing, it is convenient to quickly locate the audit data corresponding to the query conditions during subsequent data queries, thereby improving the efficiency of data integration. Furthermore, in the audit data query module, it receives the model generation request generated by each business personnel according to the data query requirements, and generates the corresponding data query model, so as to implement the data query operations preset in the model according to the model and the integrated general domain data tables and / or business data tables, so that when the data query conditions input by the audit user are received, the pre-queried audit data can be directly called out and output, thereby further improving the efficiency of data integration. On this basis, the audit data integration module also integrates the queried audit data and generates a data integration report, so as to facilitate the subsequent audit operations on the audit data and improve the overall efficiency of the audit work.

[0076] Figure 3 This is a schematic diagram of another audit data integration system provided in the embodiment of the present application. Figure 3 The audit data integration system provided by this application is introduced in detail.

[0077] See also Figure 3 In this application, the source data query module includes a source data loading layer and a data integration layer; wherein the input of the source data loading layer is used as the input of the source data query module, and the output of the source data integration layer is used as the output of the source data query module.

[0078] Specifically, the source data loading layer is used to receive source data tables transmitted by business fields using different transmission strategies, and store each source data table in the source data integration module according to the data loading method corresponding to each transmission strategy; the data integration layer is used to integrate each source data table into multiple general domain data tables and business data tables corresponding to multiple business fields according to the data attributes corresponding to each source data table.

[0079] In this application, the source data loading layer loads the data files generated by the business systems and internal management systems in various business areas into the distributed database of the audit data integration system to achieve data backup storage.

[0080] Specifically, a preset loading tool may be used to load data using different loading methods according to different types corresponding to each system.

[0081] For example, if the data in the transaction system are all newly added data every day, that is, the data is fully updated, the full load method can be used to load the data; in addition, if the data in the accounting system and the customer system are partially updated every day, that is, the data is incrementally updated, the primary key update or flow incremental update method can be used to load the data.

[0082] When loading data, all data in a source data table can be processed in batches. Specifically, all data are initialized in batches, such as controlling the start of daily batches, including detecting whether the batch data of T-1 day is completed; among them, date partitions of some special tables are established; further, a loop detection mechanism is used to determine whether the data file of the day has arrived; if so, the data is loaded; specifically, the text can be formatted according to the standard first, which can be specific to processing illegal field delimiters in the file. Field delimiters, line breaks, etc.; and then the batch data is fully loaded into the database for storage through the loading tool; optionally, in the database, the data can also be checked for job legitimacy, SQL format standardization, SQL segmentation and segmentation, and SQL exception handling to improve data storage performance.

[0083] Of course, the above-mentioned loading method is only an exemplary introduction to the technical solution of the present application, and is not intended to be a limitation on the technical solution of the present application. The present application may also be implemented using other data loading methods, and no limitation is made to this.

[0084] The source data loading layer also provides a unified view for subsequent data processing, so that users only have query functions when reading data, but not modification functions. This can prevent the data loaded into the audit data integration system from being tampered with, protect the security of audit data, ensure the accuracy of data integration results, and thus ensure the accuracy of audit results.

[0085] On the basis of loading the source data tables into the audit data integration system, the data integration layer also integrates the loaded data to obtain multiple general domain data tables and business data tables corresponding to multiple business fields.

[0086] Specifically, the data integration layer uniformly processes the basic tables used in all business fields to obtain general domain data tables; wherein, the general domain data tables are associated with each business field, and thus can be used for data query by the data query model of any business field; specifically, the general domain data tables include but are not limited to public data such as accounting flows, customer information, and employee data.

[0087] The generation of a general domain data table in this application, on the one hand, eliminates the need for separate processing in each business field, reduces the system workload and the amount of data stored; on the other hand, it can define a unified data format and standard for data in each business field, facilitate data integration, and further improve integration efficiency.

[0088] On this basis, data integration further integrates the data of each business field separately to obtain business data tables corresponding to each business field; so that the data query model corresponding to each business field can quickly locate the required audit data when performing data query, reduce data query processing time and system performance overhead, and further improve data integration efficiency.

[0089] Before using the data query model to perform query operations, a data query model corresponding to each business field is pre-constructed in the audit data query module.

[0090] Optionally, when generating a data query model, the audit data query module of the present application can be specifically used to: determine the business domain to which the business user belongs when receiving a model generation request input by any business user; and generate a data query model corresponding to the business domain based on the data query requirements contained in the model generation request and the data query logic corresponding to the data query requirements.

[0091] In this application, the business user generates corresponding data query requirements based on the audit data required in the audit process, and generates corresponding data query logic for the data query requirements, so as to obtain the desired audit data according to the data query logic.

[0092] Furthermore, the business user generates a model generation request according to the business data query requirements and the corresponding data query logic, and inputs the model generation request into the audit data integration model to realize the generation of the corresponding data query model.

[0093] Correspondingly, when the audit data query module in the audit data integration model receives the model generation request, it first parses the request and determines the business field to which it belongs based on the analysis result, and then generates the corresponding data query model in the corresponding business field based on the data query requirements obtained through the analysis and the corresponding data query logic.

[0094] It should be noted that in any business field, multiple data query models can be generated according to different data query requirements input by business users, so that corresponding audit data can be obtained when different data query conditions are input subsequently.

[0095] For example, see Figure 3 , the audit data query module includes model layers corresponding to various business areas; for example, model layers corresponding to operation management business, model layers corresponding to corporate financial business, and model layers corresponding to business areas such as personal financial business; further, in the model layer of operation management business, models corresponding to account management and cash management are specifically included; in the model layer of corporate financial business, models corresponding to corporate bandwidth, guarantee management, and bill business are specifically included; and in the model layer of personal financial business, models corresponding to bank card business, acquiring business, and agency sales business are specifically included.

[0096] Optionally, in the present application, each data query model can be used to perform data query operations on each general domain data table and / or each business data table according to each data query condition preset in the model, obtain and store the audit data corresponding to each data query condition, so that when the audit user inputs the corresponding data query condition, the audit data corresponding to the data query condition is output immediately.

[0097] The above-mentioned data query models query the corresponding audit data in advance according to the data query conditions, so as to facilitate the rapid discovery and location of audit problems during the audit process and complete the audit project; and, by querying and storing the operation mode in advance, the audit user can directly read the audit data corresponding to the data query conditions when he wants to query the data, which can further improve the integration efficiency of the audit data and thus improve the overall audit efficiency of the audit work.

[0098] In actual application, some of the data query models constructed in the early stage are based on linear rules and empirical thresholds. However, with the increasingly complex business requirements and regulatory requirements, the accuracy of the audit data queried by their data query models is relatively reduced, which does not meet the audit users' audit needs for audit data. As a result, the frequency of subsequent use of the data query model gradually decreases, causing the above-mentioned data query model to gradually become a "zombie model."

[0099] For some of the above-mentioned data query models, the audit data query module provided in this application is also used to determine the data query model corresponding to the model adjustment request when receiving the model adjustment request transmitted by the business user; generate the model adjustment logic of the data query model according to the target data query logic contained in the model adjustment request and the current data query logic of the data query model, and adjust the data query model according to the model adjustment logic.

[0100] In this application, if business personnel repeatedly find that the audit data obtained when using a data query model in the audit data query module for data query is not accurate enough and there is a need to process the data again, the data query model can be adjusted according to the above situation.

[0101] Specifically, business personnel can generate new data query requirements and target data query logic corresponding to the new data query requirements based on the problems existing in the audit data output by the previous data query model, and generate model adjustment requests corresponding to the adjustment model based on the above content, and input the model adjustment request into the audit data integration model to adjust the corresponding data query model through the audit data query module.

[0102] Correspondingly, when receiving the model adjustment request, the audit data query module first parses the request and determines the corresponding data query model based on the parsing result, and then determines the logical content that needs to be changed based on the target data query logic obtained by the analysis and the current data query logic in the data query model, and updates the data query model according to the logical content that needs to be changed to obtain an updated data query model.

[0103] In this way, by adjusting the data query model in the audit data integration model, it is possible to avoid the emergence of "zombie models" and improve the business efficiency of the model.

[0104] Figure 4 A flowchart of an audit data integration method provided for this application. Figure 4 , the method specifically comprises:

[0105] S401. Determine a corresponding data query model according to a model selection operation input by an audit user.

[0106] S402: Receive data query conditions input by the audit user, and determine the audit data corresponding to the data query conditions in the data query model.

[0107] S403: Perform data integration processing on the audit data and generate a data integration report corresponding to the audit data.

[0108] In this application, before conducting audit work, audit users can obtain audit data integrated with business systems through the audit data integration system in advance to improve the processing efficiency of subsequent audit work.

[0109] Specifically, the audit data integration system can be pre-set with a front-end interactive interface to improve the applicability of the system. In the process of obtaining the integrated audit data through the system, the audit user determines the corresponding data query conditions according to the audit data to be obtained, and selects the corresponding business field and the corresponding data query model. Then, the data query conditions are input into the data query model to obtain the audit data.

[0110] Correspondingly, when the data query model in the system receives the input data query condition, it retrieves the audit data corresponding to the data query condition in the model.

[0111] Optionally, if the data query condition has a high real-time nature, that is, real-time data in the business field is required, a query can be performed in real time according to the data query condition, and corresponding audit data can be obtained.

[0112] On this basis, when the data query model in the system does not receive the data export instruction from the audit user, it can directly transfer the audit data to the audit result integration model in the model, realize the positive deterioration processing of the audit results through the audit result integration model, obtain the integrated data integration report, and output the report to the audit user.

[0113] Optionally, the technical solution in the present application also includes: outputting the audit data to the audit user according to the data export instruction input by the audit user, so that the audit user can customize the audit data and generate customized audit data; correspondingly, the method also includes: receiving the customized audit data input by the audit user, performing data integration processing on the customized audit data, and generating a data integration report corresponding to the customized audit data.

[0114] Specifically, after the data query model in the system determines the audit data corresponding to the data query conditions and receives the data export instruction input by the audit user, the audit data can be directly output to the audit user through the front-end interactive interface so that the audit user can customize the data.

[0115] Furthermore, if the audit user transmits the customized audit data to the audit data integration module, the module integrates the received audit data and generates a data integration report corresponding to the audit data, so as to facilitate the subsequent rapid audit processing based on the data integration report and improve the overall audit efficiency of the audit work.

[0116] The technical solution provided by the present application, when using the source data integration module for data integration, receives the source data tables corresponding to each business field, and integrates the metadata tables to generate general field data tables common to each business field and business data tables corresponding to each business field. Through the above-mentioned integration processing, it is convenient to quickly locate the audit data corresponding to the query conditions during subsequent data queries, thereby improving the efficiency of data integration; further, in the audit data query module, it receives the model generation request generated by each business personnel according to the data query requirements, and generates the corresponding data query model, and implements the data query operations preset in the model according to the model and the integrated general field data tables and / or each business data table, so that when the data query conditions input by the audit user are received, the pre-queried audit data can be directly called out and output, thereby further improving the efficiency of data integration; on this basis, the audit data integration module also integrates the queried audit data and generates a data integration report, so as to facilitate the subsequent execution of audit operations on the audit data and improve the overall efficiency of the audit work.

[0117] Figure 5 It is a block diagram of an electronic device provided in an embodiment of the present application, and the device may be a computer, a digital broadcast terminal, etc.

[0118] See also Figure 5 , the device 800 may include one or more of the following components: a processing component 802 , a memory 804 , a power component 806 , a multimedia component 808 , an audio component 810 , an input / output interface 812 , a sensor component 814 , and a communication component 816 .

[0119] The processing component 802 generally controls the overall operation of the device 800, such as operations associated with display, phone calls, data communications, camera operations, and recording operations. The processing component 802 may include one or more processors 820 to execute instructions to complete all or part of the steps of the above-mentioned method. In addition, the processing component 802 may include one or more modules to facilitate the interaction between the processing component 802 and other components. For example, the processing component 802 may include a multimedia module to facilitate the interaction between the multimedia component 808 and the processing component 802.

[0120] The memory 804 is configured to store various types of data to support operations on the device 800. Examples of such data include instructions for any application or method operating on the device 800, contact data, phone book data, messages, pictures, videos, etc. The memory 804 can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk or optical disk.

[0121] The power supply component 806 provides power to the various components of the device 800. The power supply component 806 can include a power management system, one or more power supplies, and other components associated with generating, managing, and distributing power for the device 800.

[0122] The multimedia component 808 includes a screen that provides an output interface between the device 800 and the user. In some embodiments, the screen may include a liquid crystal display (LCD) and a touch panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive input signals from the user. The touch panel includes one or more touch sensors to sense touch, slide, and gestures on the touch panel. The touch sensor may not only sense the boundaries of the touch or slide action, but also detect the duration and pressure associated with the touch or slide operation. In some embodiments, the multimedia component 808 includes a front camera and / or a rear camera. When the device 800 is in an operating mode, such as a shooting mode or a video mode, the front camera and / or the rear camera may receive external multimedia data. Each front camera and rear camera may be a fixed optical lens system or have a focal length and optical zoom capability.

[0123] The audio component 810 is configured to output and / or input audio signals. For example, the audio component 810 includes a microphone (MIC), and when the device 800 is in an operating mode, such as a call mode, a recording mode, and a speech recognition mode, the microphone is configured to receive an external audio signal. The received audio signal can be further stored in the memory 804 or sent via the communication component 816. In some embodiments, the audio component 810 also includes a speaker for outputting audio signals.

[0124] The input / output interface 812 provides an interface between the processing component 802 and the peripheral interface modules, which may be keyboards, click wheels, buttons, etc. These buttons may include but are not limited to: a home button, a volume button, a start button, and a lock button.

[0125] The sensor assembly 814 includes one or more sensors for providing various aspects of status assessment for the device 800. For example, the sensor assembly 814 can detect the open / closed state of the device 800, the relative positioning of components, such as the display and keypad of the device 800, and the sensor assembly 814 can also detect the position change of the device 800 or a component of the device 800, the presence or absence of user contact with the device 800, the orientation or acceleration / deceleration of the device 800, and the temperature change of the device 800. The sensor assembly 814 may include a proximity sensor configured to detect the presence of nearby objects without any physical contact. The sensor assembly 814 may also include an optical sensor, such as a solid image (Complementary Metal Oxide Semiconductor, CMOS) sensor or a semiconductor image (Charge-coupled Device, CCD) sensor, for use in imaging applications. In some embodiments, the sensor assembly 814 may also include an acceleration sensor, a gyroscope sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.

[0126] The communication component 816 is configured to facilitate wired or wireless communication between the device 800 and other devices. The device 800 can access a wireless network based on a communication standard, such as WiFi, 4G or 5G, or a combination thereof. In an exemplary embodiment, the communication component 816 receives a broadcast signal or broadcast-related information from an external broadcast management system via a broadcast channel. In an exemplary embodiment, the communication component 816 also includes a near field communication (NFC) module to facilitate short-range communication. For example, the NFC module can be implemented based on radio frequency identification (RFID) technology, infrared data association (IrDA) technology, ultra-wideband (UWB) technology, Bluetooth (BT) technology and other technologies.

[0127] In an exemplary embodiment, the device 800 may be implemented by one or more application specific integrated circuits (ASIC), digital signal processors (DSP), digital signal processing devices (DSPD), programmable logic devices (PLD), field programmable gate arrays (FPGA), controllers, microcontrollers, microprocessors or other electronic components to perform the above method.

[0128] In an exemplary embodiment, a non-transitory computer-readable storage medium including instructions is also provided, such as a memory 804 including instructions, and the instructions can be executed by a processor 820 of the device 800 to perform the above method. For example, the non-transitory computer-readable storage medium can be a ROM, a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, etc.

[0129] A non-temporary computer-readable storage medium, when the instructions in the storage medium are executed by a processor of an electronic device, enables the electronic device to execute the system status detection method of the above-mentioned industrial Internet system.

[0130] An embodiment of the present application also provides a chip for running instructions, which is used to execute the technical solution of the system status detection method of the industrial Internet system in the above embodiment.

[0131] An embodiment of the present application also provides a computer-readable storage medium, which stores computer execution instructions. When the computer execution instructions are executed on a computer, the computer executes the technical solution of the system status detection method of the industrial Internet system in the above embodiment.

[0132] An embodiment of the present application also provides a computer program product, which includes a computer program stored in a computer-readable storage medium. At least one processor can read the computer program from the computer-readable storage medium. When at least one processor executes the computer program, the audit data integration technical solution in the above embodiment can be implemented.

[0133] Those skilled in the art will readily appreciate other embodiments of the present application after considering the specification and practicing the invention disclosed herein. The present application is intended to cover any modification, use or adaptation of the present application, which follows the general principles of the present application and includes common knowledge or customary techniques in the art that are not disclosed in the present application. The specification and examples are intended to be exemplary only, and the true scope and spirit of the present application are indicated by the following claims.

[0134] It should be understood that the present application is not limited to the precise structures that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present application is limited only by the appended claims.

Claims

1. An audit data integration system, characterized in that: The system comprises: a source data integration module, an audit data query module and an audit data integration module; the audit data query module is connected to the source data integration module and the audit data integration module respectively; wherein, The source data integration module is used to receive source data tables corresponding to multiple business fields, and integrate each of the source data tables into multiple general field data tables and business data tables corresponding to each of the business fields; The audit data query module is used to generate a data query model corresponding to the business field to which the business user belongs according to a model generation request input by the business user; wherein the data query model is used to perform data query operations on each of the general field data tables and / or each of the business data tables, and upon receiving the data query conditions input by the audit user, transmit the generated audit data to the audit data integration module, or output it to the audit user; The audit data integration module is used to perform data integration processing on the audit data input by the audit data query module and / or the audit user, and generate a data integration report corresponding to the audit data.

2. The system according to claim 1, characterized in that The audit data query module is specifically used for: Upon receiving a model generation request input by any business user, determining the business domain to which the business user belongs; According to the data query requirements contained in the model generation request and the data query logic corresponding to the data query requirements, a data query model corresponding to the business field is generated.

3. The system according to claim 1, characterized in that The audit data query module is also used to: Upon receiving the model adjustment request transmitted by the business user, determining the data query model corresponding to the model adjustment request; The model adjustment logic of the data query model is generated according to the target data query logic included in the model adjustment request and the current data query logic of the data query model, and the data query model is adjusted according to the model adjustment logic.

4. The system according to any one of claims 1 to 3, characterized in that: The data query model is used to perform data query operations on each of the general domain data tables and / or each of the business data tables according to the data query conditions preset in the model, obtain and store the audit data corresponding to each of the data query conditions, so that when the audit user inputs the corresponding data query condition, the audit data corresponding to the data query condition is immediately output.

5. The system according to any one of claims 1 to 3, characterized in that: The source data query module includes a source data loading layer and a data integration layer; The source data loading layer is used to receive source data tables transmitted by the business field using different transmission strategies, and store each source data table in the source data integration module according to the data loading method corresponding to each transmission strategy; The data integration layer is used to integrate the source data tables into a plurality of general domain data tables and a plurality of business data tables corresponding to business domains according to data attributes corresponding to the source data tables.

6. An audit data integration method, characterized in that: The audit data integration system applied to any one of claims 1 to 5, the method comprising: Determine the corresponding data query model based on the model selection operation input by the audit user; Receiving data query conditions input by the audit user, and determining audit data corresponding to the data query conditions in the data query model; Perform data integration processing on the audit data and generate a data integration report corresponding to the audit data.

7. The method according to claim 6, characterized in that After determining the audit data corresponding to the data query condition in the data query model, the method further includes: According to the data export instruction input by the audit user, the audit data is output to the audit user, so that the audit user performs data customization processing on the audit data to generate customized audit data; Accordingly, the method further includes: The customized audit data input by the audit user is received, data integration processing is performed on the customized audit data, and a data integration report corresponding to the customized audit data is generated.

8. An electronic device, characterized in that: include: A processor and a memory communicatively connected to the processor; The memory stores computer-executable instructions; When executing the computer-executable instructions, the processor is used to implement the audit data integration method as described in claim 6 or claim 7.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement the audit data integration method as described in claim 6 or claim 7.

10. A computer program product, characterized in that It comprises a computer program, which is used to implement the audit data integration method as claimed in claim 6 or claim 7 when executed by a processor.

Images