Database Platform of EMS System Based on Distributed Key-Value Pair Storage Technology
YAN Hu,ZHOU Wei,LI Lixin,DAI Jiao,HAN Jizhong,DI Fangchun
DOI: https://doi.org/10.13335/j.1000-3673.pst.2012.09.008
2012-01-01
Abstract: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 effectively reduce system cost this storage system can be operated on commercial computer.