智能变电站多维数据统一存储系统的设计与实现

Design and Implementation of Multi-dimensional Data Unified Storage System in Intelligent Substation

研究变电站数据存储与访问技术,针对目前变电站一体化监控系统各业务数据存储分散、访问接口不统一、不支持非结构化数据存储等问题,提出一种兼容关系和非关系型数据库的变电站历史数据分布式存储方式,可支持站内多业务数据的统一存储,也可支持区域内所有变电站监控系统历史数据的统一存储,突破关系型数据库对图形、波形、序列数据的存储和访问限制,解决大容量数据快速写库的操作效率问题,保证操作过程的原子性和数据一致性,实现对变电站全景数据的集中管理与访问。经现场测试验证,开发出的变电站多维数据统一存储系统的功能需求和性能指标完全达到预期目标。

The technology of substation data storage and access was studied.Aiming at the problems of decentralized business data storage,inconsistent access interface and non-structured data storage in the integrated substation monitoring system,a distributed storage method of substation historical data compatible with relational and non-relational databases was proposed,which could support the unified storage of multi service data in the substation,as well as the unified storage of historical data of all substation monitoring systems in the region.The limitation of storage and access to graphics,waveforms and sequence data in relational databases was break through.The operation efficiency problem of fast writing large-capacity data to the database was solved.The atomicity and data consistency of the operation process was guaranteed.The centralized management and access to the substation panoramic data was realized.After field testing and verification,the functional requirements and performance indicators of the developed multi-dimensional data unified storage system for substations had fully reached the expected goals.