JSON技术在电力业务系统数据库监控工具中的应用

基于电力业务系统数据库所面临的运维问题,采用JSON技术实现分布式系统数据库统一监控的目的。通过分析数据库监控的共性技术问题,设计一种C/S模式的数据库监控工具,将JSON技术应用于关键的消息构造机制,实现监控技术的配置化管理,把异地的数字化监控信息采用图形化的方式进行统一展现。自动化的监控方式,改变了以往运维工作的事后响应模式,定时采集数据库的基础信息,并对其进行展示、分析及告警,事前可做预防,事后可缩短故障的排查周期。目前数据库监控工具已实现了对生产MIS的Oracle数据库进行统一监控,降低了数据库统一运维的工作量以及技术难度,进一步提升数据库管理员的工作效率,保障了电力业务系统的稳定运行。

Application of JSON Technology in the Database Monitoring Tool of Electric Power Business System

Considering operation and maintenance problems faced by the database of electric power business system,the JSON technology is applied to realize the purpose of unified monitoring of distributed system database. By analyzing common technical problems in database monitoring,a database monitoring tool based on C/S mode is designed which applies the JSON technology in the mechanism of key information construction and realizes the configuration management of monitoring technology and the unified display of remote digital monitoring information by the way of graph. The automatic monitoring mode,which changes the afterwards response mode in the past operation and maintenance work,collects basic information of database at regular time,then displays and analyzes them and reports warnings so that preventive measures can be made beforehand,and the troubleshooting time can be shorten afterwards. Now the database monitoring tool has been realize the unified monitoring of Oracle database of production MIS,which reduced the amount of work and the technical difficulty in the unified operation and maintenance of database,and further improved the working efficiency of database manager,and guaranteed the stable operation of electric power business system.