| 引用本文: | 王镜毓,石东源,陈金富,曾次玲.基于图数据库的继电保护整定计算数据存储与应用[J].电力自动化设备,2017,37(9): |
| WANG Jingyu,SHI Dongyuan,CHEN Jinfu,ZENG Ciling.Storage and application of relay protection setting calculation data based on graph database[J].Electric Power Automation Equipment,2017,37(9): |
|
| 摘要: |
| 电网继电保护整定计算数据涉及多个门类相互关联的信息，数据实体间的关系复杂而密集，更适合采用图数据库存储。对基于图数据库和传统关系数据库存储继电保护整定计算数据时的查询性能进行对比。将关系数据库中现存的继电保护整定计算数据准确迁移到图数据库中，既是进行对比测试前的一项准备工作，也是电力系统实际应用中升级数据存储方式的前提。在介绍图数据库和属性图模型基本概念的基础上，提出了一种利用离线交换文件实现数据迁移的通用方法，并通过2类数据库查询性能的对比测试，验证了基于图数据库存储和应用整定计算数据的可行性与高效性。 |
| 关键词: 图数据库 属性图模型 Neo4j 数据迁移 性能对比 继电保护 |
| DOI：10.16081/j.issn.1006-6047.2017.09.031 |
| 分类号:TM761 |
| 基金项目: |
|
| Storage and application of relay protection setting calculation data based on graph database |
|
WANG Jingyu1, SHI Dongyuan1, CHEN Jinfu1, ZENG Ciling2
|
|
1.State Key Laboratory of Advanced Electromagnetic Engineering and Technology, Huazhong University of Science and Technology, Wuhan 430074, China;2.State Grid Hunan Electric Power Company, Changsha 410007, China
|
| Abstract: |
| The relay protection setting calculation data of power system involve the interrelated information of multiple categories. Since the relationships among data entities are complex and dense, they are more suitable to be stored in the graph database. The query performance is compared between the protection setting calculation data storage based on graph database and that based on relational database. The relay protection setting calculation data existed in the relational database are accurately migrated to the graph database, which is not only a preparation of the comparison, but also the premise of data storage mode update for actual power system applications. The basic concepts of graph database and property graph model are introduced and a general data migration method based on the offline data exchange files is proposed. By the comparison of query performance between relational database and graph database, the feasibility and efficiency of the storage and application of relay protection setting calculation data based on graph database are verified. |
| Key words: graph database property graph model Neo4j data migration performance comparison relay protection |
