基于IEC 61850的时序数据库系统设计  

Design of time series database system based on IEC 61850

作　　者：胡鹏飞 雷电[1] Hu Pengfei;Lei Dian(School of Mechatronic Engineering and Automation,Shanghai University,Shanghai 200072,Chin)

机构地区：[1]上海大学机电工程与自动化学院

出　　处：《电子测量技术》2018年第11期51-57,共7页Electronic Measurement Technology

摘　　要：随着智能电网、能源互联网的发展,电力行业数据量成指数级增长。传统的关系型数据库已经无法满足业务需求,迫切需要解决电力大数据在容量、数据繁杂和实时性方面的难题。分析了时间序列数据特性,提出为电力大数据设计一个基于时间序列存储的时间序列数据库系统ETSDB。ETSDB基于IEC 61850标准建立元数据目录统一数据类型,采用FAST（FIX adapted for streaming）协议对时间序列数据压缩,并设计了使用REST服务的数据查询服务。实验测试表明,ETSDB系统成功为风电场数据建模,减小了数据冗余度,并能在客户端展示监测数据,验证了系统的可行性和有效性。With the development of smart grid and energy internet,the power industry data volume exponentially.The traditional relational database has been unable to meet the needs.For the character of electric power big data in capacity,data complexity and real-time,it is a problem that needs to be solved urgently.This paper analyzes the characteristics of time series data,and proposes a time series database system ETSDB based on time series storage for electric power big data.ETSDB establishes a unified metadata directory according to IEC 61850 standard,and uses FAST（FIX adapted for streaming）protocol for data compression and uses REST services for data query.Experimental results show that the ETSDB system successfully model wind farm data,reduce data redundancy,and display monitoring data on the client,which verifies the feasibility and effectiveness of the system.

关 键 词：大数据 元数据 IEC 61850 时间序列 数据压缩 数据库 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论] TN919[自动化与计算机技术—计算机科学与技术]