本文選題：PostgreSQL + 存儲(chǔ)引擎��； 參考：《華中科技大學(xué)》2012年碩士論文

【摘要】：一個(gè)高效的存儲(chǔ)引擎對(duì)數(shù)據(jù)庫系統(tǒng)的性能提升具有重要意義。本論文針對(duì)開源數(shù)據(jù)庫管理系統(tǒng)PostgreSQL已有存儲(chǔ)引擎的結(jié)構(gòu)上的缺陷，提出一種將多進(jìn)程結(jié)構(gòu)改造為多線程結(jié)構(gòu)的解決方法。 PostgreSQL是一個(gè)多進(jìn)程的數(shù)據(jù)庫管理系統(tǒng)，每當(dāng)有用戶連接到系統(tǒng)后，就創(chuàng)建一個(gè)新進(jìn)程處理這個(gè)用戶的連接，用戶連接斷開后該進(jìn)程被銷毀。進(jìn)程的創(chuàng)建，調(diào)度和銷毀的開銷都很大，比線程的對(duì)應(yīng)操作開銷大很多，為了合理利用系統(tǒng)資源，應(yīng)該使用多線程的結(jié)構(gòu)。 本文對(duì)存儲(chǔ)引擎多進(jìn)程結(jié)構(gòu)改造為多線程結(jié)構(gòu)所涉及的幾個(gè)方面進(jìn)行了分析與實(shí)現(xiàn)。對(duì)全局變量的改造提出線程本地存儲(chǔ)等方法并討論了方法之間的優(yōu)劣，為線程控制改造引入Boost第三方庫并設(shè)計(jì)了跨平臺(tái)的替換方案，分析了進(jìn)程通信機(jī)制采用的共享消息隊(duì)列方法的原理，討論了解決進(jìn)程資源限制所使用的虛擬文件描述符機(jī)制�；谏鲜龇治�，對(duì)存儲(chǔ)引擎多線程結(jié)構(gòu)改造的具體實(shí)現(xiàn)進(jìn)行了較為詳細(xì)的論述。使用消息隊(duì)列結(jié)合線程信息的方法實(shí)現(xiàn)了線程通信機(jī)制，將啟動(dòng)后臺(tái)服務(wù)進(jìn)程分離為啟動(dòng)存儲(chǔ)引擎主線程和啟動(dòng)后臺(tái)服務(wù)線程，把后臺(tái)寫進(jìn)程改造成以線程方式啟動(dòng)，對(duì)其正常情況和異常情況下的實(shí)現(xiàn)流程做了較詳盡的闡述。所有單線程和多線程測試用例在Windows和Linux平臺(tái)下都通過，，存儲(chǔ)引擎多線程改造基本成功。 本文研究結(jié)果表明，多線程結(jié)構(gòu)的存儲(chǔ)引擎能夠節(jié)省系統(tǒng)資源、充分發(fā)揮多核處理器的計(jì)算能力，提升數(shù)據(jù)庫系統(tǒng)整體性能，如果進(jìn)一步實(shí)現(xiàn)事務(wù)與線程脫離，還可以大幅提高分布式數(shù)據(jù)庫系統(tǒng)的吞吐量。
[Abstract]:An efficient storage engine is of great significance to improve the performance of database systems. In order to overcome the structural defects of the existing storage engine in open source database management system (PostgreSQL), this paper proposes a solution to transform the multi-process structure into multi-thread structure. PostgreSQL is a multi-process database management system. Whenever a user is connected to the system, a new process is created to handle the user's connection, and the process is destroyed after the user's connection is disconnected. The cost of process creation scheduling and destruction is much higher than the corresponding operation cost of threads. In order to make rational use of system resources the multi-thread structure should be used. This paper analyzes and implements several aspects involved in the transformation of multi-process structure of storage engine into multi-thread structure. The methods of thread local storage are put forward and the advantages and disadvantages of the methods are discussed. The Boost third-party library is introduced into the thread control transformation and a cross-platform replacement scheme is designed. This paper analyzes the principle of shared message queue method used in process communication mechanism, and discusses the virtual file descriptor mechanism used to solve process resource limitation. Based on the above analysis, the implementation of multi-thread structure reconstruction of storage engine is discussed in detail. The thread communication mechanism is realized by using message queue combined with thread information. The starting background service process is separated into the main thread of starting storage engine and the starting background service thread, and the background write process is transformed to start by thread. Its normal and abnormal conditions of the implementation of a more detailed description of the flow. All single-threaded and multi-threaded test cases are passed on Windows and Linux platforms, and the storage engine multithreading transformation is basically successful. The results show that the multi-thread storage engine can save system resources, give full play to the computing power of multi-core processors, and improve the overall performance of database system. It can also greatly improve the throughput of distributed database systems.
【學(xué)位授予單位】：華中科技大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2012
【分類號(hào)】：TP311.13;TP333

【參考文獻(xiàn)】

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

1 軒春青;王芳;;LRU算法探析[J];電腦學(xué)習(xí);2009年03期

2 陳衛(wèi)衛(wèi);吳海佳;胥光輝;;分布式存儲(chǔ)中文件分割的最優(yōu)化模型[J];解放軍理工大學(xué)學(xué)報(bào)(自然科學(xué)版);2010年04期

3 駱斌,費(fèi)翔林;多線程技術(shù)的研究與應(yīng)用[J];計(jì)算機(jī)研究與發(fā)展;2000年04期

4 趙翠;林鋼華;;淺析數(shù)據(jù)庫技術(shù)發(fā)展[J];計(jì)算機(jī)與信息技術(shù);2010年10期

5 趙慧斌;李小群;孫玉芳;葉以民;;Linux互斥鎖機(jī)制的研究及改進(jìn)[J];計(jì)算機(jī)科學(xué);2003年08期

6 林河水;程偉;孫玉芳;;PostgreSQL存儲(chǔ)管理機(jī)制研究[J];計(jì)算機(jī)科學(xué);2004年12期

7 門愛華;馮建華;周立柱;;XML數(shù)據(jù)庫存儲(chǔ)策略綜述[J];計(jì)算機(jī)科學(xué);2005年09期

8 王晶;樊曉椏;張盛兵;王海;;多核多線程結(jié)構(gòu)線程調(diào)度策略研究[J];計(jì)算機(jī)科學(xué);2007年09期

9 徐江峰;張戰(zhàn)輝;楊有;;基于VC~(++)的進(jìn)程通信技術(shù)研究[J];計(jì)算機(jī)科學(xué);2007年09期

10 周小成;孫凝暉;霍志剛;馬捷;;一種降低并行程序檢查點(diǎn)開銷的方法[J];計(jì)算機(jī)工程;2007年12期

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

1 劉波;XML數(shù)據(jù)庫事務(wù)及并發(fā)控制機(jī)制的研究[D];中國海洋大學(xué);2005年

本文編號(hào)：1961109