SaaS平臺(tái)多租戶數(shù)據(jù)管理及邏輯存儲(chǔ)模型的研究
發(fā)布時(shí)間:2018-07-25 07:16
【摘要】:SaaS(Software as a Service)平臺(tái)應(yīng)用的業(yè)務(wù)領(lǐng)域千差萬(wàn)別,對(duì)應(yīng)的數(shù)據(jù)模式也各不相同,對(duì)于每一個(gè)SaaS應(yīng)用,雖然不同租戶其業(yè)務(wù)不一樣,但同一個(gè)應(yīng)用下數(shù)據(jù)模式相似。這就要求SaaS平臺(tái)在保證性能和應(yīng)用高效運(yùn)轉(zhuǎn)的前提下支持?jǐn)?shù)據(jù)存儲(chǔ)的彈性擴(kuò)展。 首先,本文總結(jié)出多租戶云數(shù)據(jù)管理需要考慮的多租戶數(shù)據(jù)的特性,結(jié)合多租戶數(shù)據(jù)存儲(chǔ)的特性,提出有效支持多租戶個(gè)性化的SaaS平臺(tái)多租戶數(shù)據(jù)管理方案。 其次,通過(guò)對(duì)現(xiàn)有的通用表、透視表等模式進(jìn)行研究比較,分析其定制能力及導(dǎo)致性能下降的關(guān)鍵因素,對(duì)透視表存儲(chǔ)模型進(jìn)行改進(jìn),提高定制能力,從而形成新的多租戶共享數(shù)據(jù)存儲(chǔ)模型;谛碌臄(shù)據(jù)存儲(chǔ)模型,實(shí)現(xiàn)租戶邏輯數(shù)據(jù)與物理存儲(chǔ)模式之間的模式映射和查詢轉(zhuǎn)換機(jī)制,達(dá)到定制能力與系統(tǒng)性能平衡的目的。通過(guò)實(shí)驗(yàn),測(cè)試數(shù)據(jù)庫(kù)中表的數(shù)量對(duì)數(shù)據(jù)庫(kù)吞吐率及緩沖池命中率的影響,并對(duì)提出的數(shù)據(jù)存儲(chǔ)模型與透視表模型的查詢轉(zhuǎn)換性能進(jìn)行對(duì)比測(cè)試,驗(yàn)證了本文提出的數(shù)據(jù)存儲(chǔ)模型的有效性。 最后,在實(shí)驗(yàn)室承擔(dān)的華為創(chuàng)新項(xiàng)目“云計(jì)算及其支撐網(wǎng)絡(luò)項(xiàng)目”的業(yè)務(wù)層子系統(tǒng)的基礎(chǔ)上,以多租戶個(gè)性化的數(shù)據(jù)管理方案及透視表改進(jìn)模型為理論基礎(chǔ),設(shè)計(jì)和實(shí)現(xiàn)SaaS平臺(tái)多租戶數(shù)據(jù)管理模塊。
[Abstract]:The business domain of SaaS (Software as a Service) platform application is very different, and the corresponding data pattern is different. For each SaaS application, although different tenants have different business, the data pattern is similar under the same application. This requires the SaaS platform to support the elastic expansion of data storage while ensuring the performance and efficient operation of the application. Firstly, this paper summarizes the characteristics of multi-tenant data management in multi-tenant cloud data management, and proposes an effective multi-tenant data management scheme for multi-tenant SaaS platform based on multi-tenant data storage. Secondly, through the research and comparison of the existing general table, perspective table and other modes, the customization ability and the key factors leading to the deterioration of the performance are analyzed, and the perspective table storage model is improved to improve the customization capability. Thus a new multi-tenant shared data storage model is formed. Based on the new data storage model, the schema mapping and query conversion mechanism between the tenant logical data and the physical storage mode is realized, which achieves the purpose of balancing the customization capability and the system performance. Through experiments, the effects of the number of tables in the database on the throughput and buffer pool hit rate of the database are tested, and the query conversion performance of the proposed data storage model and the PivotTable model is compared and tested. The validity of the proposed data storage model is verified. Finally, on the basis of the business layer subsystem of Huawei innovation project "Cloud Computing and its supporting Network Project", the paper takes the multi-tenant personalized data management scheme and the PivotTable improvement model as the theoretical basis. Design and implement multi-tenant data management module of SaaS platform.
【學(xué)位授予單位】:西北大學(xué)
【學(xué)位級(jí)別】:碩士
【學(xué)位授予年份】:2013
【分類號(hào)】:TP333;TP393.09
本文編號(hào):2143047
[Abstract]:The business domain of SaaS (Software as a Service) platform application is very different, and the corresponding data pattern is different. For each SaaS application, although different tenants have different business, the data pattern is similar under the same application. This requires the SaaS platform to support the elastic expansion of data storage while ensuring the performance and efficient operation of the application. Firstly, this paper summarizes the characteristics of multi-tenant data management in multi-tenant cloud data management, and proposes an effective multi-tenant data management scheme for multi-tenant SaaS platform based on multi-tenant data storage. Secondly, through the research and comparison of the existing general table, perspective table and other modes, the customization ability and the key factors leading to the deterioration of the performance are analyzed, and the perspective table storage model is improved to improve the customization capability. Thus a new multi-tenant shared data storage model is formed. Based on the new data storage model, the schema mapping and query conversion mechanism between the tenant logical data and the physical storage mode is realized, which achieves the purpose of balancing the customization capability and the system performance. Through experiments, the effects of the number of tables in the database on the throughput and buffer pool hit rate of the database are tested, and the query conversion performance of the proposed data storage model and the PivotTable model is compared and tested. The validity of the proposed data storage model is verified. Finally, on the basis of the business layer subsystem of Huawei innovation project "Cloud Computing and its supporting Network Project", the paper takes the multi-tenant personalized data management scheme and the PivotTable improvement model as the theoretical basis. Design and implement multi-tenant data management module of SaaS platform.
【學(xué)位授予單位】:西北大學(xué)
【學(xué)位級(jí)別】:碩士
【學(xué)位授予年份】:2013
【分類號(hào)】:TP333;TP393.09
【參考文獻(xiàn)】
相關(guān)期刊論文 前4條
1 何劍虹;白曉穎;李潤(rùn)玲;崔智社;;基于SLA的面向服務(wù)的基礎(chǔ)設(shè)施[J];電訊技術(shù);2011年09期
2 倪萍;廖建新;朱曉民;萬(wàn)里;;一種基于QoS的QoE到SLA映射方法[J];電子與信息學(xué)報(bào);2010年06期
3 昌中作;徐悅;戴鋼;;基于SaaS模式公共服務(wù)平臺(tái)多用戶數(shù)據(jù)結(jié)構(gòu)的研究[J];計(jì)算機(jī)系統(tǒng)應(yīng)用;2008年02期
4 殷康;;云計(jì)算概念、模型和關(guān)鍵技術(shù)[J];中興通訊技術(shù);2010年04期
相關(guān)博士學(xué)位論文 前1條
1 孔蘭菊;SaaS應(yīng)用交付平臺(tái)中多租戶云數(shù)據(jù)管理關(guān)鍵技術(shù)研究[D];山東大學(xué);2011年
,本文編號(hào):2143047
本文鏈接:http://sikaile.net/kejilunwen/jisuanjikexuelunwen/2143047.html
最近更新
教材專著