本文選題：能源數(shù)據(jù)　切入點：數(shù)據(jù)采集存儲　出處：《華南理工大學》2013年碩士論文　論文類型：學位論文

【摘要】：隨著經(jīng)濟的發(fā)展、人類對能源的依賴、地球資源枯竭的同時，節(jié)能減排越來越受到人們的關注。如何對能源進行有效的節(jié)約，并對已經(jīng)消耗的能源數(shù)據(jù)進行正確的管理與分析變的越來越重要了。能源數(shù)據(jù)采集存儲作為節(jié)能減排工作的數(shù)據(jù)來源、耗能度量、節(jié)能方案的決策以及節(jié)能體系的組成部分，在節(jié)能減排工作中具有重要作用。目前大多數(shù)能源數(shù)據(jù)采集存儲系統(tǒng)對數(shù)據(jù)進行集中式的管理和存儲。隨著計算機網(wǎng)絡的發(fā)展和能源采集點的日益增多，這種集中的管理模式就漸漸顯出不足的地方。由于數(shù)據(jù)是集中存放在單個數(shù)據(jù)庫中的，隨著時間的推移，數(shù)據(jù)庫中的數(shù)據(jù)越來越多，數(shù)據(jù)存取請求響應時間長已經(jīng)成為該系統(tǒng)的瓶頸。如果引入一個數(shù)據(jù)庫集群，將這些數(shù)據(jù)分布在多個數(shù)據(jù)庫服務器上，多個數(shù)據(jù)庫服務器并行處理請求，以提高數(shù)據(jù)存取速度，，在數(shù)據(jù)處理效率上這顯然比單個數(shù)據(jù)庫更加高效。于是在能源采集存儲系統(tǒng)中引入PostgreSQL集群。 本文研究的主要工作有以下幾個方面： 第一，根據(jù)能源數(shù)據(jù)采集存儲系統(tǒng)的功能要求，對華南理工大學能源數(shù)據(jù)采集存儲系統(tǒng)的數(shù)據(jù)采集存儲流程進行了模塊化修改，并增加了備份功能，實現(xiàn)了能源數(shù)據(jù)采集存儲系統(tǒng)中的數(shù)據(jù)采集、存儲、備份等功能要求。并利用緩存來臨時存儲數(shù)據(jù)，以應對通信中斷可能丟失能源數(shù)據(jù)的問題。 第二，著重研究了PostgreSQL數(shù)據(jù)庫理論知識，以及PostgreSQL數(shù)據(jù)庫實現(xiàn)數(shù)據(jù)庫集群的可行性。研究了中間件pgpool-II，通過pgpool-II中間件，配合多個PostgreSQL數(shù)據(jù)庫服務器，可以實現(xiàn)數(shù)據(jù)庫集群。研究、設計了以能源類型為劃分屬性的數(shù)據(jù)分布策略。 第三，將搭建的PostgreSQL數(shù)據(jù)庫集群引入到華南理工大學能源數(shù)據(jù)采集存儲系統(tǒng)中，將能源數(shù)據(jù)合理地分布到各個數(shù)據(jù)庫服務器節(jié)點，對華南理工大學建筑能源數(shù)據(jù)進行采集存儲測試，得到測試結果。 經(jīng)過測試運行，該系統(tǒng)達到研究目標。本文設計與實現(xiàn)的PostgreSQL數(shù)據(jù)庫集群為能源數(shù)據(jù)采集存儲系統(tǒng)的理論研究與實際應用提供一定的參考和借鑒。
[Abstract]:With the development of economy, the dependence of human beings on energy and the depletion of earth resources, more and more attention has been paid to energy conservation and emission reduction. And it is becoming more and more important to correctly manage and analyze the energy data that has been consumed. Energy data acquisition and storage is used as the data source, energy consumption measurement, energy saving scheme decision and the component of energy saving system. It plays an important role in the work of energy saving and emission reduction. At present, most energy data acquisition and storage systems manage and store data centrally. With the development of computer network and the increasing number of energy collection points, This centralized management model gradually shows its shortcomings. Because the data is centrally stored in a single database, the amount of data in the database increases over time. Long response time for data access requests has become the bottleneck of the system. If a database cluster is introduced, the data will be distributed across multiple database servers, and multiple database servers will process requests in parallel to improve the speed of data access. This is obviously more efficient than a single database in terms of data processing efficiency, so PostgreSQL clusters are introduced into energy acquisition and storage systems. The main work of this paper is as follows:. First, according to the functional requirements of the energy data acquisition and storage system, the data acquisition and storage process of the energy data acquisition and storage system of South China University of Technology is modularized, and the backup function is added. The functions of data acquisition, storage and backup in the energy data acquisition and storage system are realized, and the cache is used to store the data in order to deal with the problem that the communication interrupt may lose the energy data. Secondly, the theoretical knowledge of PostgreSQL database and the feasibility of implementing database cluster in PostgreSQL database are studied, and the middleware pgpool-II, which can realize database cluster through pgpool-II middleware and several PostgreSQL database servers, is studied. A data distribution strategy based on energy type is designed. Thirdly, the PostgreSQL database cluster is introduced into the energy data acquisition and storage system of South China University of Technology, and the energy data is distributed reasonably to each database server node. The data of building energy of South China University of Technology are collected and stored, and the test results are obtained. The PostgreSQL database cluster designed and implemented in this paper provides a reference for the theoretical research and practical application of the energy data acquisition and storage system.
【學位授予單位】：華南理工大學
【學位級別】：碩士
【學位授予年份】：2013
【分類號】：TP333

【參考文獻】

相關期刊論文 前6條

1 顧悅;王建軍;;Spring ActionScript中IoC容器注入機制研究[J];電腦知識與技術;2010年28期

2 陳付龍;李明東;汪迅寶;;通用數(shù)據(jù)庫集群服務器[J];計算機應用與軟件;2005年12期

3 彭新一;;華南理工大學節(jié)能監(jiān)管平臺建設[J];建設科技;2010年02期

4 李靜;;分布式數(shù)據(jù)庫系統(tǒng)體系結構的研究[J];網(wǎng)絡財富;2009年10期

5 歸達偉;計算機集群技術[J];西安郵電學院學報;2004年04期

6 郭廣軍,陳代武,胡玉平,李芝城;基于JDBC的數(shù)據(jù)庫訪問技術的研究[J];南華大學學報(自然科學版);2005年02期

相關博士學位論文 前1條

1 龔衛(wèi)華;數(shù)據(jù)庫集群系統(tǒng)的關鍵技術研究[D];華中科技大學;2006年

相關碩士學位論文 前7條

1 林媛媛;分布式數(shù)據(jù)庫在污染源信息管理系統(tǒng)中的應用研究[D];華南理工大學;2011年

2 李立博;能耗監(jiān)管平臺的緩存替換算法研究與改進[D];華南理工大學;2011年

3 張洪武;服務器集群與均衡技術研究[D];重慶大學;2004年

4 畢海波;分布式城市電磁環(huán)境數(shù)據(jù)庫系統(tǒng)的設計與實現(xiàn)[D];大連理工大學;2006年

5 岳莉;分布式數(shù)據(jù)庫并發(fā)控制的研究[D];長春理工大學;2006年

6 姚翌;銀行交易系統(tǒng)中高可用性技術研究與應用[D];廈門大學;2008年

7 李想;分布式數(shù)據(jù)庫數(shù)據(jù)分配策略研究[D];大連理工大學;2009年

本文編號：1613110