变压器油光谱监测系统数据库设计  

Design of Database of Transformer Oil Spectrum Monitoring System

作　　者：曹旺 CAO Wang(Hydropower Industry Innovation Center of State Power Investment Corporation Limited,Changsha 410001,China)

机构地区：[1]国家电投水电产业创新中心,湖南长沙410001

出　　处：《电工技术》2022年第4期131-133,共3页Electric Engineering

摘　　要：针对变压器油光谱监测系统应用过程中的实时数据量大、数据类型杂及历史数据读取频繁的特点,结合系统对数据存取高效灵活、安全可靠、冗余度低的要求,设计了基于Windows系统的SQL Server综合数据库与历史数据压缩方案。实践表明,该方案有效改善了系统的综合性能,提升了数据存储能力,可为变压器的监测与诊断提供强大的数据管理支撑,促进了水电站变压设施的智能化发展。Aiming at the characteristics of large amount of real-time data,miscellaneous data types and frequent reading of historical data in the application process of transformer oil optical spectrum monitoring system,combined with the requirements of high efficiency,flexibility,safety,reliability and low redundancy of the system,a SQL Server comprehensive database and historical data compression scheme based on Windows system is designed.The practice shows that the scheme can effectively improve the comprehensive performance of the system,enhance the data storage capacity,provide strong data management support for the monitoring and diagnosis of transformer,and promote the intelligent development of transformer facilities in hydropower station.

关 键 词：变压器 光谱 数据库 监测与诊断 数据管理 

分 类 号：TP277[自动化与计算机技术—检测技术与自动化装置]