research-article

Towards a scalable and robust multi-tenancy SaaS

Authors:

Xiaoying BaiAuthors Info & Claims

Internetware '10: Proceedings of the Second Asia-Pacific Symposium on Internetware

Article No.: 8, Pages 1 - 15

https://doi.org/10.1145/2020723.2020731

Published: 03 November 2010 Publication History

Abstract

Software-as-as-Service (SaaS) is a new approach for developing software, and it is characterized by its multi-tenancy architecture and its ability to provide flexible customization to individual tenant. However, the multi-tenancy architecture and customization requirements have brought up new issues in software, such as database design, database partition, scalability, recovery, and continuous testing. This paper proposes a hybrid test database design to support SaaS customization with two-layer database partitioning. The database is further extended with a new built-in redundancy with ontology so that the SaaS can recover from ontology, data or meta-data failures. Furthermore, constraints in metadata can be used either as test cases or policies to support SaaS continuous testing and policy enforcement.

References

[1]

Amazon. Amazon elastic compute cloud (amazon ec2), 2010.

[2]

K. Z. anad Xin Zhang, W. Sun, H. Liang, Y. Huang, L. Zhen, and X. Liu. A policy-driven approach for software-as-services customization. ICEBE, 0:123--130, 2007.

[3]

S. Aulbach, T. Grust, D. Jacobs, A. Kemper, and J. Rittinger. Multi-tenant databases for software as a service: Schema-mapping techniques. In SIGMOD '08, pages 1195--1206, New York, NY, USA, 2008. ACM.

Digital Library

[4]

X. Bai, S. Lee, W.-T. Tsai, and Y. Chen. Ontology-based test modeling and partition testing of web services. In ICWS '08, pages 465--472, Washington, DC, USA, 2008. IEEE Computer Society.

Digital Library

[5]

X. Bai, Y. Liu, L. Wang, W.-T. Tsai, and P. Zhong. Model-based monitoring and policy enforcement of services. In SERVICES I, pages 789--796, 2009.

Digital Library

[6]

X. Bai, Y. Wang, G. Dai, W.-T. Tsai, and Y. Chen. A framework for contract-based collaborative verification and validation of web services. In CBSE'07, pages 258--273, Berlin, Heidelberg, 2007. Springer-Verlag.

Digital Library

[7]

P. A. Boncz, M. Zukowski, and N. Nes. Monetdb/x100: Hyper-pipelining query execution. In CIDR, pages 225--237, 2005.

[8]

M. Brantner, D. Florescu, D. Graf, D. Kossmann, and T. Kraska. Building a database on s3. In SIGMOD '08, pages 251--264, New York, NY, USA, 2008. ACM.

Digital Library

[9]

S. Ceri, S. Navathe, and G. Wiederhold. Distribution design of logical database schemas. IEEE Trans. Softw. Eng., 9(4):487--504, 1983.

Digital Library

[10]

S. Ceri and G. Pelagatti. Distributed databases principles and systems. McGraw-Hill, Inc., New York, NY, USA, 1984.

Digital Library

[11]

F. Chang, J. Dean, S. Ghemawat, W. C. Hsieh, D. A. Wallach, M. Burrows, T. Chandra, A. Fikes, and R. E. Gruber. Bigtable: a distributed storage system for structured data. In OSDI '06, pages 15--15, Berkeley, CA, USA, 2006. USENIX Association.

Digital Library

[12]

F. Chong and G. Carraro. Architecture strategies for catching the long tail. 2006.

[13]

F. Chong, G. Carraro, and R. Wolter. Multi-tenant data architecture, June 2006.

[14]

B. F. Cooper, R. Ramakrishnan, U. Srivastava, A. Silberstein, P. Bohannon, H.-A. Jacobsen, N. Puz, D. Weaver, and R. Yerneni. Pnuts: Yahoo!'s hosted data serving platform. Proc. VLDB Endow., 1(2):1277--1288, 2008.

Digital Library

[15]

N. Cullot, R. Ghawi, and K. Yétongnon. DB2OWL: A Tool for Automatic Database-to-Ontology Mapping. In SEBD 2007, pages 491--494. Citeseer, 2007.

[16]

S. Das, D. Agrawal, and A. El Abbadi. G-store: a scalable data store for transactional multi key access in the cloud. In SoCC '10, pages 163--174, New York, NY, USA, 2010. ACM.

Digital Library

[17]

G. DeCandia, D. Hastorun, M. Jampani, G. Kakulapati, A. Lakshman, A. Pilchin, S. Sivasubramanian, P. Vosshall, and W. Vogels. Dynamo: amazon's highly available key-value store. In SOSP '07, pages 205--220, New York, NY, USA, 2007. ACM.

Digital Library

[18]

G. Eadon, E. I. Chong, S. Shankar, A. Raghavan, J. Srinivasan, and S. Das. Supporting table partitioning by reference in oracle. In SIGMOD '08, pages 1111--1122, New York, NY, USA, 2008. ACM.

Digital Library

[19]

M. Essaidi. Odbis: towards a platform for on-demand business intelligence services. In EDBT '10: ICDT Workshops, pages 1--6, New York, NY, USA, 2010. ACM.

Digital Library

[20]

Force.com. Force.com.

[21]

Google. Google app engine, 2010.

[22]

HBase. Hbase: Bigtable-like structured storage for hadoop hdfs, 2009.

[23]

iTKO. itko, 2010.

[24]

D. Karger, E. Lehman, T. Leighton, R. Panigrahy, M. Levine, and D. Lewin. Consistent hashing and random trees: distributed caching protocols for relieving hot spots on the world wide web. In STOC '97, pages 654--663, New York, NY, USA, 1997. ACM.

Digital Library

[25]

D. Kossmann, T. Kraska, and S. Loesing. An evaluation of alternative architectures for transaction processing in the cloud. In SIGMOD '10, pages 579--590, New York, NY, USA, 2010. ACM.

Digital Library

[26]

T. Kraska, M. Hentschel, G. Alonso, and D. Kossmann. Consistency rationing in the cloud: pay only when it matters. Proc. VLDB Endow., 2(1):253--264, 2009.

Digital Library

[27]

H. Li, Y. Shi, and Q. Li. A multi-granularity customization relationship model for saas. In WISM '09, pages 611--615, Washington, DC, USA, 2009. IEEE Computer Society.

Digital Library

[28]

M. Livny, S. Khoshafian, and H. Boral. Multi-disk management algorithms. SIGMETRICS Perform. Eval. Rev., 15(1):69--77, 1987.

Digital Library

[29]

M. Mehta and D. J. DeWitt. Data placement in shared-nothing parallel database systems. The VLDB Journal, 6(1):53--72, 1997.

Digital Library

[30]

R. Mietzner and F. Leymann. Generation of bpel customization processes for saas applications from variability descriptors. In SCC '08, pages 359--366, Washington, DC, USA, 2008. IEEE Computer Society.

Digital Library

[31]

T. Moses. extensible access control markup language tc v2.0 (xacml), February 2005.

[32]

C. Olston, B. Reed, U. Srivastava, R. Kumar, and A. Tomkins. Pig latin: a not-so-foreign language for data processing. In SIGMOD '08, pages 1099--1110, New York, NY, USA, 2008. ACM.

Digital Library

[33]

A. Pavlo, E. Paulson, A. Rasin, D. J. Abadi, D. J. DeWitt, S. Madden, and M. Stonebraker. A comparison of approaches to large-scale data analysis. In SIGMOD '09, pages 165--178, New York, NY, USA, 2009. ACM.

Digital Library

[34]

A. Rowstron and P. Druschel. Pastry: Scalable, decentralized object location, and routing for large-scale peer-to-peer systems. IN: MIDDLEWARE, pages 329--350, 2001.

Digital Library

[35]

D. Sacca and G. Wiederhold. Database partitioning in a cluster of processors. ACM Trans. Database Syst., 10(1):29--56, 1985.

Digital Library

[36]

D. Saff and M. D. Emst. Continuous testing in eclipse. In 2nd Eclipse Technology Exahcange Workshop (eTX), Barcelona, Spain, March 2004.

[37]

Salesforce.com. Salesforce, 2010.

[38]

M. Sloman. Policy driven management for distributed systems. Journal of Network and Systems Management, 2:333--360, 1994.

[39]

E. Smith. Continuous testing. In Proceedings of the 17th International Conference on Testing Computer Software, 2000.

[40]

W. Sobel, S. Subramanyam, A. Sucharitakul, J. Nguyen, H. Wong, A. Klepchukov, S. Patil, O. Fox, and D. Patterson. Cloudstone: Multi-platform, multi-language benchmark and measurement tools for web 2.0, 2008.

[41]

I. Stoica, R. Morris, D. Liben-Nowell, D. R. Karger, M. F. Kaashoek, F. Dabek, and H. Balakrishnan. Chord: a scalable peer-to-peer lookup protocol for internet applications. IEEE/ACM Trans. Netw., 11(1):17--32, 2003.

Digital Library

[42]

M. Stonebraker, D. J. Abadi, A. Batkin, X. Chen, M. Cherniack, M. Ferreira, E. Lau, A. Lin, S. R. Madden, E. J. O'Neil, P. E. O'Neil, A. Rasin, N. Tran, and S. B. Zdonik. C-store: A column-oriented dbms. In VLDB, pages 553--564, Trondheim, Norway, 2005.

Digital Library

[43]

M. Stonebraker, S. Madden, D. J. Abadi, S. Harizopoulos, N. Hachem, and P. Helland. The end of an architectural era: (it's time for a complete rewrite). In VLDB '07: Proceedings of the 33rd international conference on Very large data bases, pages 1150--1160. VLDB Endowment, 2007.

Digital Library

[44]

S. Sung and D. McLeod. Ontology-driven semantic matches between database schemas. pages 6--6, 2006.

Digital Library

[45]

M. Taylor and C. J. Guo.

[46]

W. Tsai, X. Zhou, R. A. Paul, Y. Chen, and X. Bai. A coverage relationship model for test case selection and ranking for multi-version software. HASE, 0:105--112, 2007.

Digital Library

[47]

W. T. Tsai, Y. Chen, R. Paul, X. Zhou, and C. Fan. Simulation verification and validation by dynamic policy specification and enforcement. Simulation, 82(5):295--310, 2006.

Digital Library

[48]

W.-T. Tsai, Q. Shao, and W. Li. Oic: Ontology-based intelligent customization framework for saas. In International Conference on Service Oriented Computing and Applications (SOCA '10), Perth, Australia, Dec. 2010 (To Appear), 2010.

[49]

C. D. Weissman and S. Bobrowski. The design of the force.com multitenant internet application development platform. In SIGMOD '09, pages 889--896, New York, NY, USA, 2009. ACM.

Digital Library

[50]

Wikipedia. Ontology, 2010.

[51]

Z. Xu, S. Zhang, and Y. Dong. Mapping between relational database schema and owl ontology for deep annotation. In WI '06, pages 548--552, 2006.

Digital Library

Cited By

Mangwani PTokekar V(2022)Container Based Scalability and Performance Analysis of Multitenant SaaS Applications2022 13th International Conference on Computing Communication and Networking Technologies (ICCCNT)10.1109/ICCCNT54827.2022.9984214(1-6)Online publication date: 3-Oct-2022
https://doi.org/10.1109/ICCCNT54827.2022.9984214
Wang GWang ZZhang W(2020)A SaaS Resource Authorization Management Model based on Resource Directed Tree2020 IEEE 9th Joint International Information Technology and Artificial Intelligence Conference (ITAIC)10.1109/ITAIC49862.2020.9338841(1747-1752)Online publication date: 11-Dec-2020
https://doi.org/10.1109/ITAIC49862.2020.9338841
Ali ASultan AGhani AZulzalil H(2019)A Systematic Mapping Study on the Customization Solutions of Software as a Service ApplicationsIEEE Access10.1109/ACCESS.2019.29254997(88196-88217)Online publication date: 2019
https://doi.org/10.1109/ACCESS.2019.2925499
Show More Cited By

Index Terms

Towards a scalable and robust multi-tenancy SaaS
1. General and reference
  1. Cross-computing tools and techniques
    1. Metrics

Recommendations

Cloud Multi-Tenancy: Issues and Developments
UCC '17 Companion: Companion Proceedings of the10th International Conference on Utility and Cloud Computing

Cloud Computing (CC) is a computational paradigm that provides pay-per use services to customers from a pool of networked computing resources that are provided on demand. Customers therefore does not need to worry about infrastructure or storage. Cloud ...
Deep customization of multi-tenant SaaS using intrusive microservices
ICSE-NIER '18: Proceedings of the 40th International Conference on Software Engineering: New Ideas and Emerging Results

Enterprise software needs to be customizable, and the customization needs from a customer are often beyond what the software vendor can predict in advance. In the on-premises era, customers do deep customizations beyond vendor's prediction by directly ...
SaaS Multi-Tenancy: Framework, Technology, and Case Study

SaaS Software as a Service provides new business opportunities for application providers to serve more customers in a scalable and cost-effective way. SaaS also raises new challenges and one of them is multi-tenancy. Multi-tenancy is the requirement of ...

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences

Internetware '10: Proceedings of the Second Asia-Pacific Symposium on Internetware

November 2010

159 pages

ISBN:9781450306942

DOI:10.1145/2020723

Conference Chairs:
Hong Mei,
Jian Lv,
Program Chairs:
Xuandong Li,
Zhi Jin

Copyright © 2010 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Nanjing University of Aeronautics and Astronautics
CCF: China Computer Federation

In-Cooperation

SIGSOFT: ACM Special Interest Group on Software Engineering

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 03 November 2010

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Funding Sources

Conference

Internetware 2010

Sponsor:

CCF

Internetware 2010: The Second Asia-Pacific Symposium on Internetware

November 3 - 4, 2010

Suzhou, China

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

18
Total Citations
View Citations
1,395
Total Downloads

Downloads (Last 12 months)28
Downloads (Last 6 weeks)0

Reflects downloads up to 05 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Mangwani PTokekar V(2022)Container Based Scalability and Performance Analysis of Multitenant SaaS Applications2022 13th International Conference on Computing Communication and Networking Technologies (ICCCNT)10.1109/ICCCNT54827.2022.9984214(1-6)Online publication date: 3-Oct-2022
https://doi.org/10.1109/ICCCNT54827.2022.9984214
Wang GWang ZZhang W(2020)A SaaS Resource Authorization Management Model based on Resource Directed Tree2020 IEEE 9th Joint International Information Technology and Artificial Intelligence Conference (ITAIC)10.1109/ITAIC49862.2020.9338841(1747-1752)Online publication date: 11-Dec-2020
https://doi.org/10.1109/ITAIC49862.2020.9338841
Ali ASultan AGhani AZulzalil H(2019)A Systematic Mapping Study on the Customization Solutions of Software as a Service ApplicationsIEEE Access10.1109/ACCESS.2019.29254997(88196-88217)Online publication date: 2019
https://doi.org/10.1109/ACCESS.2019.2925499
Martensson TStahl DBosch J(2017)The EMFIS Model — Enable More Frequent Integration of Software2017 43rd Euromicro Conference on Software Engineering and Advanced Applications (SEAA)10.1109/SEAA.2017.31(10-17)Online publication date: Aug-2017
https://doi.org/10.1109/SEAA.2017.31
Ahmad ABrereton PAndras P(2017)A Systematic Mapping Study of Empirical Studies on Software Cloud Testing Methods2017 IEEE International Conference on Software Quality, Reliability and Security Companion (QRS-C)10.1109/QRS-C.2017.94(555-562)Online publication date: Jul-2017
https://doi.org/10.1109/QRS-C.2017.94
Tekinerdogan BOzcan O(2017)Architectural Perspective for Design and Analysis of Scalable Software as a Service ArchitecturesManaging Trade-Offs in Adaptable Software Architectures10.1016/B978-0-12-802855-1.00010-1(223-245)Online publication date: 2017
https://doi.org/10.1016/B978-0-12-802855-1.00010-1
Al-Isma'ili SLi MShen JHe Q(2016)Cloud computing adoption decision modelling for SMEsInternational Journal of Web and Grid Services10.1504/IJWGS.2016.07915712:3(296-327)Online publication date: 1-Jan-2016
https://dl.acm.org/doi/10.1504/IJWGS.2016.079157
Fan LGao BWang ZAn WWang Y(2016)A Semi-Automatic Approach of Transforming Applications to be Multi-Tenancy EnabledIEEE Transactions on Services Computing10.1109/TSC.2014.23608609:2(227-240)Online publication date: 1-Apr-2016
https://dl.acm.org/doi/10.1109/TSC.2014.2360860
Xiong WTsai W(2014)HLA-Based SaaS-Oriented Simulation Frameworks2014 IEEE 8th International Symposium on Service Oriented System Engineering10.1109/SOSE.2014.74(376-383)Online publication date: Apr-2014
https://doi.org/10.1109/SOSE.2014.74
Tsai WZhong P(2014)Multi-tenancy and Sub-tenancy Architecture in Software-as-a-Service (SaaS)Proceedings of the 2014 IEEE 8th International Symposium on Service Oriented System Engineering10.1109/SOSE.2014.20(128-139)Online publication date: 7-Apr-2014
https://dl.acm.org/doi/10.1109/SOSE.2014.20
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten