用电信息采集系统的数据库及服务器运维优化研究
发布时间：2018-12-21 17:41
【摘要】：数据库系统的数据集成性、共享性、独立性和统一管理控制等特点使其得以广泛应用,而且随着信息系统中功能业务不断增加、数据量逐渐增长,数据库及服务器越来越成为信息系统运维的重点。用电信息采集系统以智能电表和通信网络为基础,对各项电气量数据进行实时精确采集,为电网运营管理提供了准确的海量数据支撑,是智能电网的核心组成部分。随着智能电能表全覆盖和系统的深化应用,智能电能表快速接入,用电信息采集系统主站也承担了越来越大的调试、接入和采集等方面的压力,采集系统生产数据库服务器在使用高峰期间负荷居高不下甚至出现宕机现象,严重影响了服务器的使用寿命,给公司正在逐步上升的用电采集业务应用及指标数据造成恶劣影响。本文通过梳理用电信息采集系统物理架构、阐述出现的问题,对采集系统主站服务器日志和数据库负荷报告的日常分析和经验总结,提出系统运行指标监测和性能分析方法,从而提高系统运维效率,保证稳定运行。同时,本文从多个维度给出相应的系统性能优化方案,在降低系统负荷方面收效显著,为提升采集系统管理效率、保障系统安全和深入海量数据挖掘等方面奠定了坚实的基础。
[Abstract]:The characteristics of data integration, sharing, independence and unified management control of database system make it widely used, and with the increasing of function business in information system, the amount of data increases gradually. Database and server are becoming more and more important in information system operation and maintenance. Based on intelligent electric meter and communication network, the electric information acquisition system collects the electrical data accurately and real-time, which provides the accurate massive data support for the power network operation and management, and is the core component of the smart grid. With the full coverage of the intelligent watt-hour meter and the deepening of the application of the system, the intelligent watt-hour meter can be accessed quickly, and the main station of the electric information acquisition system is also bearing more and more pressure from the aspects of debugging, accessing and collecting, etc. The production database server of the acquisition system has a high load and even a downtime during the peak period, which seriously affects the service life of the server. To the company is gradually increasing power collection business applications and indicators caused adverse impact. By combing the physical structure of the electric information collection system, this paper expounds the problems, analyzes and summarizes the daily experience of the log of the main station server and the load report of the database, and puts forward the methods of monitoring and performance analysis of the system operation index. In order to improve the system operation and maintenance efficiency, to ensure stable operation. At the same time, this paper gives the corresponding system performance optimization scheme from multiple dimensions, which has achieved remarkable results in reducing system load, and has laid a solid foundation for improving the efficiency of collecting system management, ensuring system security and deepening mass data mining.
【学位授予单位】：华北电力大学
【学位级别】：硕士
【学位授予年份】：2017
【分类号】：TP311.13;TM76
[Abstract]:The characteristics of data integration, sharing, independence and unified management control of database system make it widely used, and with the increasing of function business in information system, the amount of data increases gradually. Database and server are becoming more and more important in information system operation and maintenance. Based on intelligent electric meter and communication network, the electric information acquisition system collects the electrical data accurately and real-time, which provides the accurate massive data support for the power network operation and management, and is the core component of the smart grid. With the full coverage of the intelligent watt-hour meter and the deepening of the application of the system, the intelligent watt-hour meter can be accessed quickly, and the main station of the electric information acquisition system is also bearing more and more pressure from the aspects of debugging, accessing and collecting, etc. The production database server of the acquisition system has a high load and even a downtime during the peak period, which seriously affects the service life of the server. To the company is gradually increasing power collection business applications and indicators caused adverse impact. By combing the physical structure of the electric information collection system, this paper expounds the problems, analyzes and summarizes the daily experience of the log of the main station server and the load report of the database, and puts forward the methods of monitoring and performance analysis of the system operation index. In order to improve the system operation and maintenance efficiency, to ensure stable operation. At the same time, this paper gives the corresponding system performance optimization scheme from multiple dimensions, which has achieved remarkable results in reducing system load, and has laid a solid foundation for improving the efficiency of collecting system management, ensuring system security and deepening mass data mining.
【学位授予单位】：华北电力大学
【学位级别】：硕士
【学位授予年份】：2017
【分类号】：TP311.13;TM76
【参考文献】
相关期刊论文 前2条
1 赵佩;王立斌;李，
本文编号：2389239
本文链接：https://www.wllwen.com/kejilunwen/dianlidianqilunwen/2389239.html
