A Framework for Multi-Tenant Database Adoption based on the Influencing Factors

Full Text (PDF, 345KB), PP.1-9

Views: 0 Downloads: 0


Olumuyiwa Matthew 1,* Kevan Buckley 2 Mary Garvey 2

1. University of Wolverhampton, UK

2. School of Mathematics & Computer Science, University of Wolverhampton, UK

* Corresponding author.

DOI: https://doi.org/10.5815/ijitcs.2016.03.01

Received: 3 Jul. 2015 / Revised: 6 Oct. 2015 / Accepted: 10 Dec. 2015 / Published: 8 Mar. 2016

Index Terms

Multi-tenant, Database as a Service, Scalability, Flexibility, Factor, Framework, Adoption


Multi-tenant databases (MTD) are aspect of computing that has become one of the revolutionary technologies of recent years. This technology has helped to discard the large-scale investments in hardware and software resources, in upgrading them regularly and also in expensive licences of application software used on in-house hosted database systems. A MTD is a way of deploying a Database as a Service (DaaS) for the convenience and benefits of tenants. This concept is good for higher scalability and flexibility but it involves a lot of technicalities. The adoption of a MTD is based on some salient factors which can be grouped into four categories for easy understanding. A survey is presented in this research that involves a focus group of thirty respondents. The result shows the degree of impact each factor has on the decision to adopt a MTD. This paper also considers these factors and develops a framework that will help prospective tenants to take an informed decision about the adoption of the concept.

Cite This Paper

Olumuyiwa Matthew, Kevan Buckley, Mary Garvey, "A Framework for Multi-Tenant Database Adoption based on the Influencing Factors", International Journal of Information Technology and Computer Science(IJITCS), Vol.8, No.3, pp.1-9, 2016. DOI:10.5815/ijitcs.2016.03.01


[1]Banville, R. and Holzel, R. (2012) Openedge multi-tenancy overview: Progress software [online]. Bedford: [Accessed 23 January 2013]. Available at < http://www.progress.com>

[2]Walraven, S., Van Landuyt, D., Truyen, E., Handekyn, K. and Joosen, W. (2014) Efficient customization of multi-tenant Software-as-a-Service applications with service lines. Journal of Systems and Software [online] (0), Available at:<http://www.sciencedirect.com/science>

[3]Al-Aqrabi, H., Liu, L., Hill, R. and Antonopoulos, N. (2015) Cloud BI: Future of business intelligence in the Cloud. Journal of Computer and System Sciences [online], 81(1), pp. 85-96 Available at:<http://www.sciencedirect.com/science>. 

[4]Schiller, O., Schiller, B., Brodt, A. and Mitschang, B. (2011) Native support of multi-tenancy in RDBMS for software as a service Proceedings of the 14th International Conference on Extending Database Technology. [online]. Uppsala, Sweden New York, NY, USA: ACM, pp.117-128.

[5]Bezemer, C., Zaidman, A., Platzbeecker, B., Hurkmans, T. and Hart, A. (2010) Enabling multi-tenancy: An industrial experience report Software Maintenance (ICSM), 2010 IEEE International Conference on. [online]. pp.1-8.

[6]Gao, B., An, W., Sun, X., Wang, W., Fan, L., Guo, C et al. (2011) A Non-intrusive Multi-tenant Database Software for Large Scale SaaS Application e-Business Engineering (ICEBE), 2011 IEEE 8th International Conference on. [online]. pp.324-328. 

[7]Ni, J., Li, G., Zhang, J., Li, L. and Feng, J. (2012) Adapt: adaptive database schema design for multi-tenant applications Proceedings of the 21st ACM international conference on Information and knowledge management. [online]. Maui, Hawaii, USA New York, NY, USA: ACM, pp.2199-2203. 

[8]Ying, H., Wang, Q., Wang, Z., and Wang, N. (2011) DB2MMT: A Massive Multi-tenant Database Platform for Cloud Computing e-Business Engineering (ICEBE), 2011 IEEE 8th International Conference on. [online]. pp.335-340. 

[9]Elmore, A. J., Das, S., Agrawal, D. and Abbadi, A. (2011) Towards an elastic and autonomic multitenant database Proc. of NetDB Workshop. [online]. 

[10]Keemti, P. (2010) Multi-tenant Database Architecture [online]. [Accessed 23 August 2013]. Available at  <http://www.msdn.microsoft.com/eus/library/aa479086.aspx#mlttntda_topic1>

[11]Khan, M.F. and Ullah, M.A. (2012) an Approach Towards Customized Multi-Tenancy. International Journal of Modern Education and Computer Science (IJMECS) [online], 4(9), pp. 39. 

[12]Matthew, O., Dudley, C. and Moreton, R. (2014) A Review Of Multi-Tenant Database And Factors That Influence Its Adoption. UKAIS 2014 Conference [online]. Oxford, UK.

[13]Wang, Z., Guo, C., Gao, B., Sun, W., Zhang, Z and An, W. (2008) A Study and Performance Evaluation of the Multi-Tenant Data Tier Design Patterns for Service Oriented Computing e-Business Engineering, 2008. ICEBE '08. IEEE International Conference on. [online]. pp.94-101.

[14]Jacobs, D. and Aulbach, S. (2007) Ruminations on multi-tenant databases. BTW Proceedings [online], 103pp. 514-521. 

[15]Schaffner, J. (2013), Multi tenancy for cloud-based in-memory column databases: workload management and data placement, Springer, Wien

[16]Hui, M., Jiang, D., Li, G. and Zhou, Y. (2009) Supporting Database Applications as a Service Data Engineering, 2009. ICDE '09. IEEE 25th International Conference on. [online]. pp.832-843

[17]Aulbach, S., Jacobs, D., Kemper, A. and Seibold, M. (2009) A comparison of flexible schemas for software as a service Proceedings of the 2009 ACM SIGMOD International Conference on Management of data. [online]. Providence, Rhode Island, USA New York, NY, USA: ACM, pp.881-888.

[18]Vashistha, A and Ahmed, P. (2012)"SaaS Multi-Tenancy Isolation Testing- Challenges and Issues", International Journal of Soft Computing and Engineering,[online] 2(5), pp. 49-50 pp. 49-50 Available at:http://wlv.summon.serialssolutions.com

[19]Chong, R., Carraro, G., Wolter, R. (2006) Multi-tenant Data Architecture [online]. [Accessed 23 August 2013]. Available at :<http://www.msdn.microsoft.com/en-us/library/aa479086.aspx#mlttntda_topic3>

[20]Narasayya,V. R., Das,S., Syamala,M., Chandramouli,B. and Chaudhuri,S. (2013) SQLVM: Performance Isolation in Multi-Tenant Relational Database-as-a-Service.CIDR. [online].

[21]Yaish,H. and Goyal,M. (2013) A multi-tenant database architecture design for software applications Computational Science and Engineering (CSE), 2013 IEEE 16th International Conference on. [online]. IEEE, pp.933-940.

[22]Pippal, S.K. and Kushwaha, D.S. (2013) A simple, adaptable and efficient heterogeneous multi-tenant database architecture for ad hoc cloud. Journal of Cloud Computing [online], 2(1), pp. 1-14. 

[23]Ni, J., Li, G., Wang, L., Feng, J., Zhang, J. and Li, L. (2014) Adaptive Database Schema Design for Multi-Tenant Data Management. [online].

[24]Luo, Y., Zhou, S. and Guan, J. (2015) LAYER: A cost-efficient mechanism to support multi-tenant database as a service in cloud. Journal of Systems and Software [online], 101(0), pp. 86-96 Available at:<http://www.sciencedirect.com/science>. 

[25]Aulbach, S., Grust, T., Jacobs, D., Kemper, A. and Rittinger, J. (2008) Multi-tenant databases for software as a service: schema-mapping techniques Proceedings of the 2008 ACM SIGMOD international conference on Management of data. [online]. Vancouver, Canada New York, NY, USA: ACM, pp.1195-1206

[26]Lang, W., Shankar, S., Patel, J. M. and Kalhan, A. (2012) Towards Multi-tenant Performance SLOs Data Engineering (ICDE), 2012 IEEE 28th International Conference on. [online]. pp.702-713.

[27]Hacigümüs,H., Iyer,B. and Mehrotra,S. (2002) Providing database as a service Data Engineering, 2002. Proceedings. 18th International Conference on. [online]. IEEE, pp.29-38.

[28]Weis, J. and Alves-Foss, J. (2011) Securing database as a service: Issues and compromises. IEEE Security & Privacy [online](6), pp. 49-55 . 

[29]Gey, F., Van Landuyt, D., Joosen, W. and Jonckers, V. (2015) Continuous evolution of multi-tenant SaaS applications: A customizable dynamic adaptation approach. status: accepted [online]. 

[30]Sotto, L.J., Treacy, B.C. and McLellan, M.L. (2010) Privacy and Data Security Risks in Cloud Computing. World Communications Regulation Report [online], 5(2), pp. 38. 

[31]Mintzberg, H. (1973) The Nature of Managerial Work, Harper and Row, New York.

[32]Rea L. M. and Parker, P. A. (1997). Designing and Conducting Survey Research, 2nd Ed., Jossey-Bass Publishers, San Francisco, USA.

[33]Burns, R.B (2000) Introduction to research methods (4th Edition). SAGE Publications, London.

[34]Creswell, J. (2003) Research Design: Qualitative, Quantitative, and Mixed Methods Approaches (2nd Ed), Sage, Thousand Oaks, CA.

[35]Abeysekera, S. (2001) Analysis approaches in participatory work involving ranks or scores. DFID Theme Paper (revised).UK: Statistical Services Centre, University of Reading [online].