本文選題：能源數(shù)據(jù)　切入點(diǎn)：數(shù)據(jù)采集存儲(chǔ)　出處：《華南理工大學(xué)》2013年碩士論文　論文類(lèi)型：學(xué)位論文

【摘要】：隨著經(jīng)濟(jì)的發(fā)展、人類(lèi)對(duì)能源的依賴、地球資源枯竭的同時(shí)，節(jié)能減排越來(lái)越受到人們的關(guān)注。如何對(duì)能源進(jìn)行有效的節(jié)約，并對(duì)已經(jīng)消耗的能源數(shù)據(jù)進(jìn)行正確的管理與分析變的越來(lái)越重要了。能源數(shù)據(jù)采集存儲(chǔ)作為節(jié)能減排工作的數(shù)據(jù)來(lái)源、耗能度量、節(jié)能方案的決策以及節(jié)能體系的組成部分，在節(jié)能減排工作中具有重要作用。目前大多數(shù)能源數(shù)據(jù)采集存儲(chǔ)系統(tǒng)對(duì)數(shù)據(jù)進(jìn)行集中式的管理和存儲(chǔ)。隨著計(jì)算機(jī)網(wǎng)絡(luò)的發(fā)展和能源采集點(diǎn)的日益增多，這種集中的管理模式就漸漸顯出不足的地方。由于數(shù)據(jù)是集中存放在單個(gè)數(shù)據(jù)庫(kù)中的，隨著時(shí)間的推移，數(shù)據(jù)庫(kù)中的數(shù)據(jù)越來(lái)越多，數(shù)據(jù)存取請(qǐng)求響應(yīng)時(shí)間長(zhǎng)已經(jīng)成為該系統(tǒng)的瓶頸。如果引入一個(gè)數(shù)據(jù)庫(kù)集群，將這些數(shù)據(jù)分布在多個(gè)數(shù)據(jù)庫(kù)服務(wù)器上，多個(gè)數(shù)據(jù)庫(kù)服務(wù)器并行處理請(qǐng)求，以提高數(shù)據(jù)存取速度，，在數(shù)據(jù)處理效率上這顯然比單個(gè)數(shù)據(jù)庫(kù)更加高效。于是在能源采集存儲(chǔ)系統(tǒng)中引入PostgreSQL集群。 本文研究的主要工作有以下幾個(gè)方面： 第一，根據(jù)能源數(shù)據(jù)采集存儲(chǔ)系統(tǒng)的功能要求，對(duì)華南理工大學(xué)能源數(shù)據(jù)采集存儲(chǔ)系統(tǒng)的數(shù)據(jù)采集存儲(chǔ)流程進(jìn)行了模塊化修改，并增加了備份功能，實(shí)現(xiàn)了能源數(shù)據(jù)采集存儲(chǔ)系統(tǒng)中的數(shù)據(jù)采集、存儲(chǔ)、備份等功能要求。并利用緩存來(lái)臨時(shí)存儲(chǔ)數(shù)據(jù)，以應(yīng)對(duì)通信中斷可能丟失能源數(shù)據(jù)的問(wèn)題。 第二，著重研究了PostgreSQL數(shù)據(jù)庫(kù)理論知識(shí)，以及PostgreSQL數(shù)據(jù)庫(kù)實(shí)現(xiàn)數(shù)據(jù)庫(kù)集群的可行性。研究了中間件pgpool-II，通過(guò)pgpool-II中間件，配合多個(gè)PostgreSQL數(shù)據(jù)庫(kù)服務(wù)器，可以實(shí)現(xiàn)數(shù)據(jù)庫(kù)集群。研究、設(shè)計(jì)了以能源類(lèi)型為劃分屬性的數(shù)據(jù)分布策略。 第三，將搭建的PostgreSQL數(shù)據(jù)庫(kù)集群引入到華南理工大學(xué)能源數(shù)據(jù)采集存儲(chǔ)系統(tǒng)中，將能源數(shù)據(jù)合理地分布到各個(gè)數(shù)據(jù)庫(kù)服務(wù)器節(jié)點(diǎn)，對(duì)華南理工大學(xué)建筑能源數(shù)據(jù)進(jìn)行采集存儲(chǔ)測(cè)試，得到測(cè)試結(jié)果。 經(jīng)過(guò)測(cè)試運(yùn)行，該系統(tǒng)達(dá)到研究目標(biāo)。本文設(shè)計(jì)與實(shí)現(xiàn)的PostgreSQL數(shù)據(jù)庫(kù)集群為能源數(shù)據(jù)采集存儲(chǔ)系統(tǒng)的理論研究與實(shí)際應(yī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.
【學(xué)位授予單位】：華南理工大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2013
【分類(lèi)號(hào)】：TP333

【參考文獻(xiàn)】

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

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

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

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

4 李靜;;分布式數(shù)據(jù)庫(kù)系統(tǒng)體系結(jié)構(gòu)的研究[J];網(wǎng)絡(luò)財(cái)富;2009年10期

5 歸達(dá)偉;計(jì)算機(jī)集群技術(shù)[J];西安郵電學(xué)院學(xué)報(bào);2004年04期

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

相關(guān)博士學(xué)位論文 前1條

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

相關(guān)碩士學(xué)位論文 前7條

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

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

3 張洪武;服務(wù)器集群與均衡技術(shù)研究[D];重慶大學(xué);2004年

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

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

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

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

本文編號(hào)：1613110