电网大数据量表设计优化技术及应用-计算机系统应用.PDFVIP

2015 年 第 24 卷 第 1 期 计 算 机 系 统 应 用 ① 电网大数据量表设计优化技术及应用 陈 刚, 郑浩泉, 吴淑伟 ( 国网电力科学研究院, 南京 211100) 摘 要: 阐述了在数据库设计阶段实施大数据量表设计优化工作的必要性. 介绍了电网大数据量表的概念及产 生原因, 并针对因大数据量表而引发的数据库性能问题, 提出了大数据量表设计优化相关的关键技术. 在设备状 态检修系统的数据库设计阶段, 以设备状态评价功能为例进行实践应用. 仿真实验表明对大数据量表实施设计 优化后系统性能得到了显著提升. 为后续系统稳定运行提供保障, 也为类似的大数据量表设计优化应用提供了 参考. 关键词: 大数据量表; 设计优化; 状态评价; 基于反范式的表设计; 基于表分类的存储设计 Large-Scale Grid Data Table Design Optimization Technology and Application CHEN Gang, ZHENG Hao-Quan, WU Shu-Wei (State Grid Electric Power Research Institure, Nanjing 211100, China) Abstract: This paper describes the necessity of implementing design optimization for the large-scale data table in the database design stage. It introduces the concept and causes of the large-scale data grid table. And for database performance problem caused by the large-scale data table, it proposes design optimization technology of the large-scale data table. On database design stage of equipment condition-based maintenance system, it uses these technology in device status evaluation function as an example. The simulation experiment results show that system performance has been significantly improved after design optimization for the large-scale data table. To provide protection for the subsequent stability of the system, it is also referable for those large-scale data table need to be optimized. Key words: large-scale data table; design optimization; state evaluation; table design based on anti-paradigm; storage design based on classification table 随着国家电网公司企业信息化深入应用, 业务系 绍了大数据量表设计优化的相关技术. 在新建的设备 统的数据量进入了爆炸式增长. 大数据量表带来的数 状态检修系统的数据库设计阶段, 对设备状态评价功 据库性能问题已经成为业务系统面临的现实问题. 如 能中进行实践应用. 仿真实验