基于共享模式的SaaS多租户数据划分机制研究

doi:10.3969/j.issn.1000-436x.2012.z1.015

Journal on Communications ›› 2012, Vol. 33 ›› Issue (Z1): 110-120.doi: 10.3969/j.issn.1000-436x.2012.z1.015

• Papers • Previous Articles Next Articles

Research on multi-tenant data partition mechanism for SaaS application based on shared schema

Xiao-na LI^1,²,Qing-zhong LI¹,Lan-ju KONG¹,Cheng PANG¹

¹ School of Computer Science and Technology,Shandong University,Jinan 250101,China
² School of Software Technology,Qingdao University,Qingdao 266071,China

Online:2012-09-25 Published:2017-08-03
Supported by:
The National Natural Science Foundation of China;The National Key Technologies R＆D Program;The Natural Science Foundation of Shandong Province;The Natural Science Foundation of Shandong Province;The Natural Science Foundation of Shandong Province;The Key Technology R＆D Program of Shandong Province;The Key Technology R＆D Program of Shandong Province;The Key Technology R＆D Program of Shandong Province

Abstract

Abstract:

In SaaS model,the multi-tenant data using shared schema partitioned in multiple nodes of the cloud environment was put forward in advance.Based on this,a data partition model and algorithm for multi-tenants to support SaaS application was proposed.Through comparsion with many data partition technology and cloud database solutions mainly for analysis application and lack of transaction support,the theoretical analysis and experimental results reveal that the proposed data partition mechanism can effectively realize the dynamic scalability of the system in cloud environment,at the same time to minimize the cost of the distributed transaction.

Key words: SaaS, multi-tenant database, shared schema, data partition

Xiao-na LI,Qing-zhong LI,Lan-ju KONG,Cheng PANG. Research on multi-tenant data partition mechanism for SaaS application based on shared schema[J]. Journal on Communications, 2012, 33(Z1): 110-120.

Figures/Tables 10

References 15

[1]	CHONG F , CARRARO G . Multi-tenant data architecture[EB/OL]. , 2006.
[2]	AGRAWAL S , NARASAYYA V , YANG B . Integrating vertical and horizontal partitioning into automated physical database design[A]. Proceedings of the ACM SIGMOD International Conference on Management of Data[C]. Paris,France, 2004. 359-370.
[3]	ZILIO D C . Physical Database Design Decision Algorithms and Concurrent Recorganization for Parallel Database Systems[D]. Canada:University of Toronto, 1998.
[4]	RAO J , ZHANG C , MEGIDDO N ,et al. Automating physical database design in parallel database[A]. Proceedings of the ACM SIGMOD International Conference on Management of Data[C]. Madison,Wisconsin,USA, 2002. 558-569.
[5]	CHANG F , DEAN J , GHEMAWAT S ,et al. Bigtable:a distributed storage system for structured data[J]. ACM Transactions on Computer Systems, 2008,6(2):4.
[6]	BAKER J , BOND C , CORBETT J C ,et al. Megastore:providing scalable,highly available:storage for interactive services[A]. Proceedings of the 5th Biennial Conference on Innovative Data Systems Research,Conference[C]. Asilomar,CA,United States, 2011. 223-234.
[7]	DAS S , AGARWAL S , AGRAWAL D ,et al. ElasTraS:An Elastic,Scalable,and Self Managing Transactional Database for the Cloud[R]. http://www.cs.ucsb.edu/research/tech_reports/, 2010.
[8]	CURINO C , JONES E , ZHANG Y ,et al. Schism:a workload-driven approach to database replication and partitioning[J]. The VLDB Endowment, 2010,3(1): 48-57.
[9]	SQL azure[EB/OL]. .
[10]	CAMPBELL D G , KAKIVAYA G , ELLIS N . Extrem scale with full SQL language support in microsoft SQL azure[A]. Proceedings of the ACM SIGMOD International Conference on Management of Data[C]. Indianapolis,Indiana,USA, 2010. 1021-1023.
[11]	AGRAWAL D , ABBADI A E , ANTONY S ,et al. Data management challenges in cloud computing infrastructures[A]. Databases in Networked Information Systems the 6th International Workshop,DNIS 2010[C]. Aizu-Wakamatsu,Japan, 2010. 1-10.
[12]	AULBACH S , JACOB D , KEMPER S A ,et al. A comparison of flexible schemas for software as a service[A]. SIGMOD’09[C]. Providence,Rhode Island,USA, 2009. 881-888.
[13]	BURROWS M . The chubby lock service for loosely-coupled distributed systems[EB/OL]. , 2010.
[14]	DEAN J , GHEMAWAT S . Distributed Programming with Mapreduce[R]. 2007.
[15]	YANG F , SHANMUGASUNDARAM J , YERNENI R . A scalable data platform for a large number of small applications[A]. CIDR 2009 4th Biennal Conference on Innovative Data Systems Research[C]. Asilomar,CA,United States, 2009. 129-138.

Metrics

Recommended 0

No Suggested Reading articles found!

Research on multi-tenant data partition mechanism for SaaS application based on shared schema

RichHTML

PDF

Knowledge

Cited

Abstract

Cite this article

share this article

Figures/Tables 10

References 15

Related Articles 5

Metrics

Recommended 0

[1]	Zhou LI,Cong TANG,Jian-bin HU,Zhong CHEN. Vulnerabilities scoring approach for cloud SaaS [J]. Journal on Communications, 2016, 37(8): 157-166.
[2]	. Research on the optimization adjustment strategy for the SaaS multi-tenant data placement [J]. Journal on Communications, 2014, 35(Z2): 10-71.
[3]	Xiao-na LI,Qing-zhong LI,Lan-ju KONG,Zhong-min YAN. Research on the optimization adjustment strategy for the SaaS multi-tenant data placement [J]. Journal on Communications, 2014, 35(Z2): 63-71.
[4]	Xiu-wei ZHANG,Ke-qing HE,Jian WANG,Zheng LI. SaaS service supermarket building model and service recommendation approach [J]. Journal on Communications, 2011, 32(9A): 158-165.
[5]	Xiao-fang QIN,Da-cheng YANG,Xin ZHANG. Novel low-delay video transmission scheme based on SR-SW-HARQ [J]. Journal on Communications, 2009, 30(1): 18-24.