The Design And Implementation Of Power Information Collection And Analysis System For Wendeng Power Company

Wendeng power company adopts the way of on-site maintenance personnel manual collection and recording, doing statistical analysis of the data and electronic storage at the time of the information collection and analysis. This way can meet the storage of the information and data, but the collection and analysis of electronic information can not meet the growing demand for electricity. Thus, Wendeng power company use the advanced information technology to build a system about the collection and analysis of electronic information.The information collection and analysis system of Wendeng power company uses SSH framework, B/S network architecture,the Java programming language and the MVC framework. The technical architecture of Wendeng power company information collection and analysis system has access control layer, business layer and data access layer. Wherein, in the access control layer, the user makes a request through the JSP page and its Action or Form. Then, in the business layer,the business applications and Service methods and interface match the corresponding business application. In the data access layer, the information table filled with relevant data will retrieve and return to the user. In the access control layer, there are pages for accessing the monitoring component and controller for forwarding the request to capture the access and control of user. In the business layer, there are business applications and interfaces for receiving user access control. In the data access layer, there is a database object relational mapping component, database connection pool components, Java database connectivity components and DAO interface components, Hibernate Mapping components and persistent classes used to access and operate with the data in the database. The database design of Wendeng power company information collection and analysis system uses Microsoft SQL Server 2014.The functions that can be achieved by system include electricity information management, operation management, statistical query, data analysis and functions of system management. Among them, the functions implemented by the power of information management include the collection and management of data, ordered electricity, prepaid management. The functions implemented by the running management include records management, the state of operation management, exception handling, duty logs, on-site management. The functions implemented by statistical query include the query and analysis of data, the integrated query of collecting points, the inquiry of work order, running query about SIM card, report management. The functions implemented by data analysis include line loss analysis, key users to monitor, pass the query, statistical analysis, transformer monitoring. The functions implemented by system management include channel management, rights and password management, template configuration, code management.The realization of Wendeng power supply company information collection and analysis system makes the intelligence of the information collection and analysis as possible. It provides a good and reliable platform for the manage of power usage information and provides a solid and reliable data foundation for leadership decision-making.