Power Design And Implementation Of Integrated Query Analysis System For Power Information Application

With the gradual progress of the construction work of the State Grid Corporation of China SG-ERP,the requirements for information display are more visible and interactive,Existing comprehensive query and analysis systems and professional analysis systems are mostly formulated for a specific requirement,and there is no integration of a variety of requirements data,which can not reflect the overall needs of users for comprehensive information query.The existing comprehensive query and analysis system has a depth of information,multi-dimensional,fine-grained segmentation.Therefore,the original integrated query system of Meishan Power Supply Company has been unable to effectively meet the needs of comprehensive data query and intelligent decision-making.In view of this situation,this paper makes a detailed analysis of the various requirements of the company's information application comprehensive query and analysis system.According to the development status and future demand analysis of the information system of Meishan Power Supply Company of the State Grid,and on the basis of fully considering the existing comprehensive query and analysis system,this paper makes full use of the processing and analysis functions of the information technology.Combining with the actual business situation and the overall demand of the enterprise,the typical design technical framework of the "SG186" project data center is proposed.In this paper,ETL tools,Sybase IQ data warehouse,data mart technology are used to realize data acquisition from marketing,production,trading and other business applications into the data center ODS,data warehouse,data mart,and the use of FLEX,AMCHART and other technologies to achieve data analysis and display,the company's human resources,financial management,power production The security supervision,marketing service and other modules are designed to enhance the comprehensive query ability of the company's query and analysis platform to meet the needs of the strategic,management and operational levels for business comprehensive display and analysis and decision-making.The information query and analysis system designed in this paper has two characteristics.On the one hand,it can enhance the ability of comprehensive query and analysis of company information,support index fine-grained query and analysis,detailed data query and analysis,effectively support flexible expansion,standardization and rapid construction of company query and analysis application,effectively meet the needs of comprehensive query and analysis and decision-making of company business of all units,and provide intelligent analysis.Lay the foundation for decision making application construction.On the other hand,it can realize the inquiry and analysis of the production and operation indexes of each unit and the comprehensive inquiry indexes of capital construction,so that the personnel at all levels of the company can "see" the business information related to themselves within their respective jurisdiction,make business decisions in time,and provide intellectual support for the decision-making at all levels of the company.