计算机科学 ›› 2013, Vol. 40 ›› Issue (10): 194-197.

• 软件与数据库技术 • 上一篇    下一篇

SaaS模式多租户数据存贮模型的研究与实现

周文琼,李庆忠,范路桥,郑述招   

  1. 广东科学技术职业学院计算机工程技术学院 珠海519080;山东大学计算机科学与技术学院 济南250000;广东科学技术职业学院计算机工程技术学院 珠海519080;广东科学技术职业学院计算机工程技术学院 珠海519080
  • 出版日期:2018-11-16 发布日期:2018-11-16
  • 基金资助:
    本文受国家自然科学基金(61003253),广东省自然科学基金项目(S2011010001841)资助

Research and Realization of Data Storage Model for Multi-tenant under SaaS Mode

ZHOU Wen-qiong,LI Qing-zhong,FAN Lu-qiao and ZHENG Shu-zhao   

  • Online:2018-11-16 Published:2018-11-16

摘要: SaaS模式引入了多租户环境特征,在新的环境下,数据库层存贮设计面临租户数据隔离问题和租户数据弹性扩展问题。主要研究了多租户环境下的数据存储模式,提出了“共享数据库共享Schema存贮数据、独立Schema访问”的多租户数据存贮与访问模型,该模型将SaaS应用的数据存贮和数据访问的Schema进行分离,有效解决了“租户数据隔离性低”的问题;同时,提出了一种以XML为基础的多租户数据扩展模型,该扩展模型很好地解决了“租户数据弹性扩展”的问题。在此基础上,详细描述了这两个模型在SQL Server数据库的实现方案,实例结果证明了所述方法的灵活性和可行性。

关键词: SaaS,多租户,数据层,数据存贮

Abstract: SaaS mode introduces the multi-tenant environment,which may cause following two concerns raised for database storage:isolation of tenant’s data and expandability of tenant’s data.With research of the data storage and access mode for multi-tenant environments,this paper pointed out the model of ‘shared schema for data storage and indepen-dent schema for data access on shared database’.This model separates the schema for data storage and access for SaaS application,which would resolve the problems of ‘isolation of tenant’s data’.Meantime,the paper pointed out another XML-based model for multi-tenant data expansion,which would resolve the problem of ‘expandability of tenant’s data’.Furthermore,the report described the detailed solutions for the two models,which are proven practical and flexible.

Key words: SaaS,Multi-tenant,Data layer,Data storage

[1] Weissman C D,Bobrowski S.The design of the force.com multitenant internet application development platform[C]∥Proceedings of the ACM SIGMOD International Conference on Management of Data,2009.Providence,Rhode Island,USA:Ugur Cetintemel,2009:889-896
[2] Frederick C,Gianpaolo C.Architecture strategies for catchingthe long tail.http://msdn2.microsoft.com/zh-n/architecture/ aa479069.aspx,2006
[3] 李晓娜,李庆忠,孔兰菊,等.基于共享模式的 SaaS 多租户数据划分机制研究[J].通信学报,2012,09:110-119
[4] 姚金成,张世栋,史玉良,等.基于Chunk Folding的多租户数据库缓存管理机制[J].计算机学报,2011,12:2319-2330
[5] Microsoft Inc.Microsoft SQL Azure[EB/OL].http://www.microsoft.com/cz- e/azure/sqlazure,2012
[6] Aulbach S,Grust T,Jacobs D,et al.Multi-tenant data- bases for Software as a Service:Schema-mapping Techniques[C]∥Proc.of ACM Conference on Management of Data.Vancouver,Canada:[s.n.],2008:1195-1206
[7] Agrawal R,Somani A,Xu Yi-rong.Storage and Querying of E-Commerce Data[C]∥VLDB.2001:149-158
[8] DeCandia G,Hastorun D,Jampani M,et al.Dynamo:Amazon’s Highly Available Key-value Store[C]∥SOSP.2007
[9] 叶伟.互联网时代的软件革命-SaaS架构设计[M].北京:电子工业出版社,2008
[10] 朱志良,苑海涛,宋杰,等.SOA与云计算:竞争还是融合[J].计算机科学,2011,2:6-11
[11] 陶新民,郝思媛,张冬雪,等.不均衡数据分类算法的综述[J].重庆邮电大学学报:自然科学版,2013,25(1):101-110

No related articles found!
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!