应用在变电运检管理平台的数据库技术研究

Database Research in Substation Maintenance Management Platform

将现有的运检管理业务系统与NoSQL技术进行结合,是在互联网技术不断发展的趋势下,传统工业与大数据技术互相融合的一次探索。传统的变电运检管理系统由于需要接收、处理的数据量过大,系统的负载太大,无法对数据进行高准确率、实时、和复杂运算逻辑的处理,因此,传统的系统无法接收大量数据,或者只能接收一些但不能存储或分析它们。尤其地,受限于数据库技术,变电运检管理系统的功能和性能均受到了交大的限制。本文将通过对NoSQL中的MongoDB数据库进行研究,和传统的关系型数据库MySQL进行对比,分析出MongoDB数据库更加合适使用的业务场景,为现有的运检管理系统提供改造和优化的思路,进而逐步的利用"大云物移"技术,实现国家电网智能运检体系的建设。

The traditional substation maintenance management system has too much data to receive and process,and the system load is too high to process the data in real time,reliably and deeply.Therefore,the traditional systems cannot receive massive data,or they can only receive some but don’t store them or analyzed.Especially limited by database technology,the functions and performance of the maintenance management system are greatly limited.This paper will study the MongoDB one of a NoSQL,comparing it with the traditional relational database MySQL.We try to analyze the business scenarios that are more suitable for the MongoDB database,and provide ideas for transformation and optimization of the existing maintenance management system.This paper attempts to use the big data technology,cloud computing technology,Internet of Things technology,mobile Internet technology to help complete the construction of the national grid intelligent operation and maintenance system.