【摘要】：數(shù)據(jù)庫系統(tǒng)的數(shù)據(jù)集成性、共享性、獨(dú)立性和統(tǒng)一管理控制等特點(diǎn)使其得以廣泛應(yīng)用,而且隨著信息系統(tǒng)中功能業(yè)務(wù)不斷增加、數(shù)據(jù)量逐漸增長,數(shù)據(jù)庫及服務(wù)器越來越成為信息系統(tǒng)運(yùn)維的重點(diǎn)。用電信息采集系統(tǒng)以智能電表和通信網(wǎng)絡(luò)為基礎(chǔ),對各項(xiàng)電氣量數(shù)據(jù)進(jìn)行實(shí)時(shí)精確采集,為電網(wǎng)運(yùn)營管理提供了準(zhǔn)確的海量數(shù)據(jù)支撐,是智能電網(wǎng)的核心組成部分。隨著智能電能表全覆蓋和系統(tǒng)的深化應(yīng)用,智能電能表快速接入,用電信息采集系統(tǒng)主站也承擔(dān)了越來越大的調(diào)試、接入和采集等方面的壓力,采集系統(tǒng)生產(chǎn)數(shù)據(jù)庫服務(wù)器在使用高峰期間負(fù)荷居高不下甚至出現(xiàn)宕機(jī)現(xiàn)象,嚴(yán)重影響了服務(wù)器的使用壽命,給公司正在逐步上升的用電采集業(yè)務(wù)應(yīng)用及指標(biāo)數(shù)據(jù)造成惡劣影響。本文通過梳理用電信息采集系統(tǒng)物理架構(gòu)、闡述出現(xiàn)的問題,對采集系統(tǒng)主站服務(wù)器日志和數(shù)據(jù)庫負(fù)荷報(bào)告的日常分析和經(jīng)驗(yàn)總結(jié),提出系統(tǒng)運(yùn)行指標(biāo)監(jiān)測和性能分析方法,從而提高系統(tǒng)運(yùn)維效率,保證穩(wěn)定運(yùn)行。同時(shí),本文從多個(gè)維度給出相應(yīng)的系統(tǒng)性能優(yōu)化方案,在降低系統(tǒng)負(fù)荷方面收效顯著,為提升采集系統(tǒng)管理效率、保障系統(tǒng)安全和深入海量數(shù)據(jù)挖掘等方面奠定了堅(jiān)實(shí)的基礎(chǔ)。
[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.
【學(xué)位授予單位】：華北電力大學(xué)
【學(xué)位級別】：碩士
【學(xué)位授予年份】：2017
【分類號】：TP311.13;TM76

【參考文獻(xiàn)】

相關(guān)期刊論文 前2條

1 趙佩;王立斌;李，

本文編號：2389239