摘要
监控信息规范工作量大,人工修改数据库效率低、出错率高,导致监控信息规范工作反复进行。此文根据OPEN3000系统数据库的特点,制定了3条措施以保证数据库安全。首先,利用SQL语言首先修改商用数据库;其次,通过主、备机切换,将商用数据库信息同步到实时数据库;最后,利用双重措施校验数据库修改的正确性。在保证数据库安全的前提下,大大提高了监控信息规范的效率和正确率。
The workload to standardize monitoring information is large,and manual modification to database will be with low efficiency and high error rate,which will lead to repeated work to standardize monitoring information.According to the characteristics of OPEN3000 system database,this paper has stipulated three measures to ensure the security of the database.Firstly,use SQL language to modify the commercial database.Secondly,synchronize the commercial database information to real-time database through main and standby switching.Finally,use dual measures to verify the correctness of the database modification.The efficiency and correctness to standardize monitoring information has been greatly improved under the premise of guaranteeing the safety of database.
作者
张焕玲
徐靖
宋振亚
周宗亮
杨嵘
ZHANG Huanling;XU Jing;SONG Zhenya;ZHOU Zongliang;YANG Rong(State Grid of China Xiangyang Power Supply Company,Xiangyang 441000,China)
出处
《国网技术学院学报》
2019年第1期26-29,共4页
Journal of State Grid Technology College
关键词
监控信息规范
数据库
SQL语言
安全
效率
monitoring information standardization
database
SQL language
safety
efficiency
