| 引用本文: | 徐敏,王海俊,冯超,等.电力数据的注释式持久化技术及其重构[J].电力系统保护与控制,2014,42(9):91-95. |
| XU Min,WANG Hai-jun,FENG Chao,et al.Electric data persistence technology by annotation and reconstruction[J].Power System Protection and Control,2014,42(9):91-95 |
|
| 摘要: |
| 根据IEC61970 CIM标准最新进展，以建立完善的电力系统数据库、实现不同版本公共信息模型CIM的数据转换为目的，提出了基于CIM 3.0的电力数据存储方案。该方案采用JPA注释持久化技术与对象-关系映射技术ORM相结合设计数据库模式，用于解决国内现行CIM描述数据不精确，数据库开发过程复杂等问题。通过在电力企业实体对象中嵌入注释，简化数据库设计过程，实现了电力系统资源对象的多层继承、关联关系、复杂属性的映射。采用dom4j解析标准CIM RDF格式的电力数据，对数据重构后完成了数据导入，最后验证数据库的完整性，表明设计方案可行、有效。 |
| 关键词: 公共信息模型 JPA 注释 能量管理系统 数据库 智能电网 |
| DOI：10.7667/j.issn.1674-3415.2014.09.015 |
| 分类号: |
| 基金项目: |
|
| Electric data persistence technology by annotation and reconstruction |
|
XU Min1, WANG Hai-jun1, FENG Chao2, LING Yan2, YANG Hui2
|
|
1.School of Information Engineering, Nanchang University, Nanchang 330031, China;2.Xianning Power Supply Company of Hubei, Xianning 437000, China
|
| Abstract: |
| According to the latest advancements of IEC 61970 common information model (CIM), in order to establish perfect power system database and achieve data transformation between different versions of CIM, this paper proposes a solution of electric data storage based on CIM 3.0. The solution adopts Java persistence API (JPA) annotation combined with object-relation mapping (ORM) to design power system database, which is used to solve the current CIM describing data inaccurately in China, the complex process of database development and so on. Through annotations embedded in power system entities to simplify database design, it implements multiple inheritance, association and complex attribute mapping of the power enterprise entity object. Using dom4j to parse standard CIM RDF format electric data, it rebuilds the data and imports database, and finally verifies the integrity of database, which shows the design scheme is feasible and effective. |
| Key words: CIM JPA annotation EMS database smart grid |
