电能质量在线监测数据库的设计与优化

近年来,在线监测已经成为电能质量监测的主流趋势。数据库作为前端访问和底层数据之间的枢纽,在电能质量在线监测系统中起着重要作用。随着数据量的飞速增长,数据库已经成为整个系统的性能瓶颈,严重影响了系统的用户体验。文章先分析了电能质量在线监测系统和数据库的特点,然后对数据库模型进行了设计。在分析和设计的基础上,一系列优化操作,如表分区、缓冲池规划、数据库的跨平台迁移和行压缩等在数据库模型上得以实施。经过精心的设计和优化,数据库各方面性能均明显提升,极大地改善了系统的用户体验。

Design and Optimization of Power Quality Online Monitoring Database

Recently, online monitoring has become the main trend of power quality monitoring. As the pivot between front-end visit and underlying data, the database plays an important role in the power quality online monitoring system. With the data race up heavily, the database has become the bottleneck of the whole system, and it has severely affected the systemic user experience. This paper analyzes the features of the power quality online monitoring system and the database, then it designs database model. On the base of the analysis and the design, a series of optimized operations, such as the table partitioning, the buffer pools scheduling, the cross-platform migration of database and the row compression etc, are entered into force to the database model. Through elaborate design and optimization, the database performance has been enhanced obviously in all aspects and greatly improved the user experience.