基于分布式键值对存储技术的EMS数据库平台  

Database Platform of EMS System Based on Distributed Key-Value Pair Storage Technology

作　　者：闫湖[1] 周薇[2] 李立新[1] 戴娇[3] 韩冀中[3] 狄方春[1] 

机构地区：[1]中国电力科学研究院,北京市海淀区100192 [2]中国科学院研究生院,北京市海淀区100049 [3]中国科学院计算技术研究所,北京市海淀区100190

出　　处：《电网技术》2012年第9期162-167,共6页Power System Technology

基　　金：国家重点基础研究发展计划项目(973项目)(2010CB736204);国家电网公司科技项目"基于云计算技术的智能电网在线分析系统研究与开发"与"‘调度云’体系架构研究"的资助~~

摘　　要：为解决智能电网系统中能量管理系统(energy management system,EMS)数据指数级增长带来的海量数据存储和快速访问问题,提出一种基于分布式键值对存储EMS数据的方法,将结构化与非结构化数据统一按照键值对形式进行表达,并分布存储于集群中。以该方法为基础,设计并实现了一种新的EMS数据库平台,该平台是混合数据库平台,支持关系库与非关系型数据库一体化访问,同时针对EMS的查询特征进行了系统优化,采用混合索引策略提升多维与高维数据的查询性能。实验结果表明:与传统EMS数据库管理系统相比,新的EMS数据库平台能够满足EMS海量多业务数据的一体化存储需求,支持高效并发访问,具有良好的扩展性和容错能力。另外,该系统可以在商用计算机上运行,能够有效地降低系统成本。To solve the problems of massive data storage and fast access caused by exponential growth of energy management system（EMS） data in smart grid,a distributed key-value pair-based method for the storage of EMS data,which expresses structured and non-structured data unitedly in the form of key-value pairs and stores in distributed cluster,is proposed.Based on the proposed method,a new EMS database platform is developed and implemented.This platform is a hybrid database platform and supports integrated accessing of relational and non-relational database,in addition the data query system is optimized according to the EMS query characteristics,and a kind of mixed index strategy is introduced to enhance query performance for multi-dimensional and high-dimensional data.Experimental results show that comparing with traditional EMS database platform,not only the new EMS database platform can meet the needs of integrated storage and efficient concurrent access for massive data of multi-service,but also it has the advantage of good scalability and fault tolerance.What is more,to effectivelAbstract】 To solve the problems of massive data storage and fast access caused by exponential growth of energy management system（EMS） data in smart grid,a distributed key-value pair-based method for the storage of EMS data,which expresses structured and non-structured data unitedly in the form of key-value pairs and stores in distributed cluster,is proposed.Based on the proposed method,a new EMS database platform is developed and implemented.This platform is a hybrid database platform and supports integrated accessing of relational and non-relational database,in addition the data query system is optimized according to the EMS query characteristics,and a kind of mixed index strategy is introduced to enhance query performance for multi-dimensional and high-dimensional data.Experimental results show that comparing with traditional EMS database platform,not only the new EMS database platform can meet the needs of integrated storage an

关 键 词：EMS 智能电网 键值对 分布式存储 

分 类 号：TM743[电气工程—电力系统及自动化]