| The data auditing of the commercial bank is a brand-new auditing model that uses computer technology to audit the electronic transaction data of business systems directly by means of the audit analysis model.The audit analysis model is a mathematical formula or a logical expression which is set up by the auditor by setting judgment and restriction conditions to analyze data.At present,the technical staff constructs audit analysis models by writing SQL query statements under the guidance of clear audit objective and data audit idea.However,the SQL statement is cumbersome and complicated when the model involves a large number of business data tables,resulting in low efficiency of constructing the model.On the background,the paper proposes a new design thinking of constructing the audit analysis model by drawing a flow chart of data auditing ideas.The paper designs and implements the construction platform of the model around the new design thinking,provides a unified environmental basis for constructing the audit analysis model.The construction platform of the audit analysis model based on the Flex technology adopts B/S architecture,provides the function of drawing the data audit idea flow diagram to achieve the effect of constructing the audit analysis model visually.Based on the process of designing,debugging,saving and running the audit analysis model,the thesis designs the functional modules of the platform,including the data acquisition module,the module of the model design,the module of the model debugging,the module of the model management,the module of the task scheduling,etc.The data acquisition module provides the data support for the construction platform by building the business data mart.The module of the model design realizes the function of constructing model by drawing the data audit idea flow chart.The module of the model debugging performs breakpoint monitoring on the step of the data audit flow chart to judge and ensure the accuracy of the model.The module of the model management manages all kinds of operations on the model and generates the model definition which can be invoked directly through the function of curing model.The module of the task scheduling runs the model.The execution result provides the decision-making dependence for the business.According to the definition of software development documents,firstly,the thesis discusses the overall requirements of the construction platform,analyzes data requirements,functional requirements and performance requirements.Then,the software architecture and data architecture of the platform are designed.The functional design and specific data structure design of each module of the platform are given.Secondly,the operating environment,technical framework and the concrete realization of each functional module of the platform are described.Finally,the thesis introduces the functional test of the construction platform,describes the test environment and test methods,and gives the test results. |