Construction And Research Of Internal Audit Information System In Power Grid Enterprises

With the rapid development of modern economy,information has become the most important valuable assets recognized by people all over the world.The way of information generation,the mode of information dissemination and the access to information have changed with the times.The amount of information from a newspaper to see the world every day last century to hundreds of Gs data produced by information system today.People get information from the original way of mouth to mouth to see the world by electronic screen.The change of the external environment has a direct impact on all aspects of our life and work.Internal audit work of he national Power Grid Corp transfors from the original paper audit form to a form of information.Audit object,audit data are generated and preserved in the system,in order to improve the quality of the audit,the auditors often need to reinstall the system to obtain audit data required in the audit field,this audit mode for the audit and management personnel to say,not only increase the workload,but also may exist the compatibility between the system and the software version,this make auditors cannot effectively analyze data,and bring out some difficulties in the audit work.In view of the above problems,this paper puts forward the method of data integration to solve this problem,and uses the methods of field investigation,literature summary and scene experiment to establish the management and control audit system.On the basis of analyzing and summarizing the related literature at home and abroad,this paper uses the technology of data warehouse,data mart,ETL data extraction and so on.(1)Requirements analysisThis paper analyzes the current audit mode and the present situation of the audit of the national Power Grid Corp,recognizes the disadvantages of the traditional audit mode,analyzes the opportunities faced by the current audit reform,and expounds the necessity and feasibility of the audit information.From the two aspects of business needs and non functional requirements of the system needs analysis to determine the establishment of the management and control audit system which contains marketing audit,financial audit and engineering audit.(2)Key technologiesDescribes the key technologies used in the construction of management and control audit system.The main function of the management and control audit system is to collect the data of each source business system for auditors to review.According to this feature,the key technology used in this paper include data warehouse,data mart technology,and the data extraction technology,according to the application of the system data source,data extraction technology we have mainly used two kinds,respectively is ETL data extraction technology and OGG data replication technology.(3)Design and ImplementationAccording to the key technology and the demands of the management and control of business audit has been clear and used,this paper makes the overall design of the system,the system of the business architecture,data architecture,so as to guide the design and development of system.This paper also selects an function of the engineering audit to realize the data transfer and function realization.(4)Scene experimentMake the scene experiment on the established system,select a common function of marketing audit,take the data of audit in the management and control of business audit system,complete the audit process,to verify the efficiency of management and control of business audit system,.