The Business Data Flow Analysis And The Database Design For The Technical Supervision Platform System

Transformer oil chromatography-line monitoring and management system by collecting, analyzing data oil chromatography monitoring device, and oil chromatographic data analysis and processing, equipment to detect operation of the internal latent fault and alarm transmission-related information, thus avoiding large-scale oil-filled electrical equipment run accidents, ensure the safe operation of the power grid, through the accumulation of equipment on-line monitoring of data, providing data basis for condition-based maintenance.The system uses different principles of integrated design, hierarchical distributed network architecture, research and development of a set of transformer oil chromatography data platform monitoring and management system, centralized monitoring oil chromatography monitoring device grid, with grid companies have installed or plan to install different manufacturers of monitoring devices for remote data exchange, with automatic data collection, browse query, graphical display, fault diagnosis, abnormal alarm functions, and ultimately remote, on-line, the network of high voltage equipment for each substation centralized monitoring and fault diagnosis, overcoming the line monitoring "fragmentation" of the state.System architecture based on J2 EE Java language development, database using MySQL. Transformer oil chromatography-line monitoring and management system field test data is written to the system database through WAN, or wireless communication mode, the data acquisition software are placed in the data acquisition computer, a user with a browser application server through the wide area network access, query, analysis, statistics related data, while the system SMS alarm and SMS data query by GPRS MODEM. Development of content management system contains data, data analysis, fault diagnosis, fault alarm, system management, data interface, user authentication services and other functions.By developing this system, the establishment of a large-scale grid equipment oil chromatography data management shared database, dynamic remote management and resource sharing for large hub substation filled electrical equipment oil chromatography monitoring data, and the first time was more than oil-related equipment provide fault abnormal excessive levels of gas alarm SMS and data queries..