Research And Implement Of The Management System For Insulators Data Based On Java

Insulators and porcelain sets are important component of substation, it plays a supporting for wire and insulation role. It is important for the security of whole power network to manage and monitor the state of insulators effectively. As the increasing investment to the informationization of power system by the state, it becomes more important for efficient management to insulators. Therefore, developing insulator Information Management System with self-owned intellectual property has a very realistic and long-term significance.The whole insulator Information Management System consists of three major parts: UI design of system, back-end database management and design of core business.UI design of the system is mainly to improve the availability of software systems and make it easy to use for system users, it is designed to use a complete graphical interface to achieve the management and operations of information systems. System operators can know about the whole of the current state of all devices by clicking on the substation equipment, system operators can know about the distribution state of substation to the power supply bureau under the jurisdiction and other information of the substation also. The UI system is designed using Java programming language and based on a module suite providing by Netbeans development platform, this can make the development fast and stably.Back-end database management designing consists of the design of insulator database, data persistence design and so on. Legal version SQL Server 2000 database management system is provided by the company. In database design, after analyzing all the subjects which have relationship with the transformer substations in the system, an E-R graph of these entities can be easily obtained, which is especially important to the database designing. Apart from that, in according with their mapping relationships, the corresponding entities will be designed and then the omitted database system is completed. In data persistence design, during the research, firstly object-oriented technology as well as relational database theory is discussed deeply, the mapping strategy between them have been paid more attention to. The mapping principle and realization method have been sum up. The mainstream theory of the persistence technology is illustrated and the conclusion is that the Hibernate is a better selection in the persistence realization compared with other persistence technologies. The design of core business of the system consists of the design and analysis of the following parts: network function, classification authority, scalable capacity, the accounting function, the import of data function. Network function is mainly to achieve the network share function. Classification authority is to complete the classification of the users of this system. Scalable capacity is the completion of data management if new equipment or substation will be added. The completion of the accounting function is to complete accounting management of insulator devices which belong to more than 35KV substation, including retrievaling, recording, doing statistics and other operations. The import of data function is mainly to complete the exchanging between the system and ultrasonic flaw detector. The design of core business is also based on the module suit provided by Netbeans development platform, this can complete the encapsulation of all parts of core business modules.By debugging for a long time, the whole software can normally run on the Windows and Linux operating system, and it has been delivered to the company. According to the feedback from the company, the system has the main characteristics of stable operation and nice interface, and can complete the basic functions required in advance.