电网大数据量表设计优化技术及应用

阐述了在数据库设计阶段实施大数据量表设计优化工作的必要性.介绍了电网大数据量表的概念及产生原因,并针对因大数据量表而引发的数据库性能问题,提出了大数据量表设计优化相关的关键技术.在设备状态检修系统的数据库设计阶段,以设备状态评价功能为例进行实践应用.仿真实验表明对大数据量表实施设计优化后系统性能得到了显著提升.为后续系统稳定运行提供保障,也为类似的大数据量表设计优化应用提供了参考.

Large-Scale Grid Data Table Design Optimization Technology and Application

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.