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

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

通信学报 ›› 2012, Vol. 33 ›› Issue (Z1): 110-120.doi: 10.3969/j.issn.1000-436x.2012.z1.015

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

李晓娜^1,²,李庆忠¹,孔兰菊¹,庞成¹

¹ 山东大学计算机科学与技术学院，山东济南 250101
² 青岛大学软件技术学院，山东青岛 266071

出版日期:2012-09-25 发布日期:2017-08-03
基金资助:
国家自然科学基金资助项目;国家科技支撑计划基金资助项目;山东省自然科学基金资助项目;山东省自然科学基金资助项目;山东省自然科学基金资助项目;山东省科技攻关计划基金资助项目;山东省科技攻关计划基金资助项目;山东省科技攻关计划基金资助项目

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

摘要：

对SaaS模式下，对共享模式的多租户数据在云中多节点环境的划分问题进行了研究，提出一种支持SaaS应用的多租户数据划分模型和算法。与目前主要面向分析型应用并且缺乏事务支持的分区技术和云数据库解决方案进行比较，理论分析和实验结果同时表明，该划分机制能有效地实现云环境中系统规模动态扩展，同时最大限度地降低分布式事务代价。

关键词: SaaS, 多租户数据库, 共享模式, 数据划分

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

李晓娜,李庆忠,孔兰菊,庞成. 基于共享模式的SaaS多租户数据划分机制研究[J]. 通信学报, 2012, 33(Z1): 110-120.

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.

图/表 10

图1

图2

图3

图4

图5

图6

图7

图8

图9

图10

参考文献 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.

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

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

在线阅读

PDF下载

可视化

被引次数

摘要/Abstract

引用本文

使用本文

图/表 10

参考文献 15

相关文章 4

Metrics

推荐阅读 0

[1]	李舟,唐聪,胡建斌,陈钟. 面向SaaS云平台的安全漏洞评分方法研究[J]. 通信学报, 2016, 37(8): 157-166.
[2]	李晓娜,李庆志,孔兰菊,闫中敏. SaaS多租户数据放置的优化调整策略研究[J]. 通信学报, 2014, 35(Z2): 63-71.
[3]	李晓娜，李庆忠，孔兰菊，闫中敏. SaaS多租户数据放置的优化调整策略研究[J]. 通信学报, 2014, 35(Z2): 10-71.
[4]	张秀伟,何克清,王健,李征. SaaS服务超市的构建模型和服务推荐方法[J]. 通信学报, 2011, 32(9A): 158-165.