【摘要】：自計算機(jī)誕生以來,數(shù)據(jù)的存儲和處理便是計算機(jī)信息技術(shù)領(lǐng)域的重要部分,在20世紀(jì)60年代就已經(jīng)提出了數(shù)據(jù)庫管理系統(tǒng)概念,E.F.Codd在其論文中闡述了關(guān)系模型,關(guān)系型數(shù)據(jù)庫逐漸成為主流。隨著信息技術(shù)和軟件工程的發(fā)展和大數(shù)據(jù)時代的到來,傳統(tǒng)的關(guān)系型數(shù)據(jù)庫雖然有其使用上的便利性,但在性能上存在瓶頸,難以直接應(yīng)對現(xiàn)在的數(shù)據(jù)規(guī)模和時效性要求,因此將傳統(tǒng)數(shù)據(jù)庫單點架構(gòu)轉(zhuǎn)換為分布式架構(gòu)成為一種有效的解決方法,各個不同的廠商或機(jī)構(gòu)都對這一領(lǐng)域進(jìn)行了不同的探索,也提出了一些不同的解決方案和模型。在實際部署或使用過程中,一套完整的數(shù)據(jù)分析處理系統(tǒng)或信息服務(wù)系統(tǒng)模型被細(xì)分為更多的層次模塊。往往在搭建過程中,需要負(fù)責(zé)不同部分的專業(yè)人員協(xié)同工作,增加建設(shè)成本。因此,如何能保留傳統(tǒng)關(guān)系型數(shù)據(jù)庫低使用門檻的優(yōu)點,同時又能保證其在處理大規(guī)模數(shù)據(jù)的性能具有十分重要的研究意義。與此同時,云計算由于其特有的資源彈性伸縮、集中管理、數(shù)據(jù)安全等優(yōu)點開始被廣泛使用,用戶可以根據(jù)自己的需要購買相應(yīng)資源而且在短時間內(nèi)便可直接使用,免去了自行搭建硬件平臺和網(wǎng)絡(luò)的工作,同時也省去了自行維護(hù)的任務(wù),更多的信息服務(wù)商開始將自己的平臺搭建在云計算平臺之上。因此,本論文所設(shè)計的系統(tǒng),也希望能夠充分利用云平臺的資源靈活分配的特性。綜上,本文針對在將關(guān)系型數(shù)據(jù)庫轉(zhuǎn)為分布式架構(gòu)的過程中,數(shù)據(jù)庫功能和性能上面臨的主要技術(shù)難題,例如分布式事務(wù)處理,數(shù)據(jù)快速定位等等問題,進(jìn)行了研究。本論文的主要研究目的是提供一種基于云計算平臺的分布式數(shù)據(jù)庫,通過探究相應(yīng)的數(shù)據(jù)分布策略、數(shù)據(jù)查詢使用模型、數(shù)據(jù)自動同步方法以及系統(tǒng)彈性伸縮模型,通過合理的模型設(shè)計實現(xiàn)一種低成本、易使用的、彈性可伸縮的分布式關(guān)系型數(shù)據(jù)庫系統(tǒng)。論文首先對分布式數(shù)據(jù)庫的課題背景和國內(nèi)外研究現(xiàn)狀做了綜述,并交代了論文結(jié)構(gòu)安排,然后提出了在系統(tǒng)模型設(shè)計上所存在的重點難點問題,同時根據(jù)作者的相關(guān)技術(shù)經(jīng)驗,提出了相應(yīng)的解決方法和整體的系統(tǒng)設(shè)計方式,最后進(jìn)行了部分功能和性能的測試以及總結(jié)分析。
[Abstract]:Since the birth of computer, the storage and processing of data is an important part of computer information technology. In the 1960s, the concept of database management system has been put forward, and E.F.Codd has elaborated the relational model in his thesis. Relational database has gradually become the mainstream. With the development of information technology and software engineering and the arrival of big data era, although the traditional relational database has its convenience to use, there are bottlenecks in its performance, so it is difficult to directly deal with the demand of current data scale and timeliness. Therefore, the conversion of traditional database single point architecture to distributed architecture becomes an effective solution. Different manufacturers or organizations have made different explorations in this field, and have also put forward some different solutions and models. In the actual deployment or use process, a complete data analysis and processing system or information service system model is subdivided into more hierarchical modules. Often in the process of building, need to take charge of different parts of the professionals to work together to increase the cost of construction. Therefore, it is of great significance to study how to retain the advantages of low threshold of use in traditional relational databases, and at the same time to ensure their performance in dealing with large scale data. At the same time, due to its unique advantages of flexibility, centralized management, data security and so on, cloud computing has been widely used. Users can purchase the corresponding resources according to their own needs and can use them directly in a short period of time. It eliminates the work of building hardware platform and network, and also saves the task of self-maintenance. More information service providers begin to build their own platform on cloud computing platform. Therefore, the system designed in this paper also hopes to make full use of the flexible resource allocation of cloud platform. In summary, this paper focuses on the main technical problems in the process of transforming relational database into distributed architecture, such as distributed transaction processing, fast positioning of data, and so on. The main purpose of this paper is to provide a distributed database based on cloud computing platform, through exploring the corresponding data distribution strategy, data query usage model, data automatic synchronization method and system elastic expansion model. A low cost, easy to use, flexible and scalable distributed relational database system is implemented by reasonable model design. In this paper, the background of the distributed database and the current research situation at home and abroad are summarized, and the structure of the paper is described. Then, the key and difficult problems in the design of the system model are put forward. At the same time, according to the author's relevant technical experience, the corresponding solution and the whole system design method are put forward. Finally, some function and performance tests and summary analysis are carried out.
【學(xué)位授予單位】：山東大學(xué)
【學(xué)位級別】：碩士
【學(xué)位授予年份】：2017
【分類號】：TP311.13

【參考文獻(xiàn)】

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

1 儲佳佳;郭進(jìn)偉;劉柏眾;張晨東;錢衛(wèi)寧;;高可用數(shù)據(jù)庫系統(tǒng)中的分布式一致性協(xié)議[J];華東師范大學(xué)學(xué)報(自然科學(xué)版);2016年05期

2 錢招明;王雷;余晟雋;宮學(xué)慶;;分布式系統(tǒng)中Semi-Join算法的實現(xiàn)[J];華東師范大學(xué)學(xué)報(自然科學(xué)版);2016年05期

3 李文昊;李海芳;;確定性分布式數(shù)據(jù)庫中長事務(wù)處理方法研究[J];科學(xué)技術(shù)與工程;2016年13期

4 王玨;孟曉蕊;;分布式數(shù)據(jù)庫同步中間件系統(tǒng)的設(shè)計與研究[J];現(xiàn)代電子技術(shù);2016年09期

5 張旭剛;李東輝;俞俊;朱廣新;鄭磊;;基于zookeeper和強(qiáng)一致性復(fù)制實現(xiàn)MySQL分布式數(shù)據(jù)庫集群[J];微型電腦應(yīng)用;2016年01期

6 劉國樂;何建波;李瑜;;Xen與KVM虛擬化技術(shù)原理及安全風(fēng)險[J];保密科學(xué)技術(shù);2015年04期

7 張磊;方祝和;周敏奇;黃嵐;;面向內(nèi)存計算的連接算法[J];華東師范大學(xué)學(xué)報(自然科學(xué)版);2014年05期

8 姚華超;王振宇;;基于KVM-QEMU與Libvirt的虛擬化資源池構(gòu)建[J];計算機(jī)與現(xiàn)代化;2013年07期

9 余平;;QEMU-KVM實現(xiàn)虛擬機(jī)動態(tài)負(fù)載均衡[J];電子商務(wù);2012年08期

10 黃晶晶;;基于索引的SQL語句優(yōu)化[J];硅谷;2011年01期

相關(guān)會議論文 前1條

1 李曉珍;劉迪;王孟強(qiáng);李春陽;;微應(yīng)用架構(gòu)下分布式事務(wù)的處理方法[A];2016電力行業(yè)信息化年會論文集[C];2016年

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

1 漆紹洋;基于mysql的分布式訪問中間件中sql處理模塊的設(shè)計與實現(xiàn)[D];南京大學(xué);2016年

2 劉曉光;基于MySQL的分布式SQL數(shù)據(jù)庫的設(shè)計與實現(xiàn)[D];中國科學(xué)院大學(xué)(工程管理與信息技術(shù)學(xué)院);2016年

3 李文昊;基于確定性執(zhí)行策略的分布式數(shù)據(jù)庫中間件的設(shè)計與實現(xiàn)[D];太原理工大學(xué);2016年

4 宋靜;分布式并行數(shù)據(jù)庫一致性機(jī)制研究與實現(xiàn)[D];電子科技大學(xué);2006年

5 查小科;分布式并行數(shù)據(jù)庫系統(tǒng)DPSQL中分布式查詢和分布式事務(wù)的設(shè)計與實現(xiàn)[D];電子科技大學(xué);2003年

，

本文編號：2357690