A Framework for Multi-Tenant Database Adoption based on the Influencing Factors
Автор: Olumuyiwa Matthew, Kevan Buckley, Mary Garvey
Журнал: International Journal of Information Technology and Computer Science(IJITCS) @ijitcs
Статья в выпуске: 3 Vol. 8, 2016 года.
Бесплатный доступ
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.
Multi-tenant, Database as a Service, Scalability, Flexibility, Factor, Framework, Adoption
Короткий адрес: https://sciup.org/15012440
IDR: 15012440
Список литературы A Framework for Multi-Tenant Database Adoption based on the Influencing Factors
- Banville, R. and Holzel, R. (2012) Openedge multi-tenancy overview: Progress software [online]. Bedford: [Accessed 23 January 2013]. Available at < http://www.progress.com
- 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:
- 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:
- 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.
- 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.
- 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.
- 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.
- 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.
- Elmore, A. J., Das, S., Agrawal, D. and Abbadi, A. (2011) Towards an elastic and autonomic multitenant database Proc. of NetDB Workshop. [online].
- Keemti, P. (2010) Multi-tenant Database Architecture [online]. [Accessed 23 August 2013]. Available at
- 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.
- 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.
- 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.
- Jacobs, D. and Aulbach, S. (2007) Ruminations on multi-tenant databases. BTW Proceedings [online], 103pp. 514-521.
- Schaffner, J. (2013), Multi tenancy for cloud-based in-memory column databases: workload management and data placement, Springer, Wien
- 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
- 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.
- 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
- Chong, R., Carraro, G., Wolter, R. (2006) Multi-tenant Data Architecture [online]. [Accessed 23 August 2013]. Available at :
- 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].
- 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.
- 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.
- Ni, J., Li, G., Wang, L., Feng, J., Zhang, J. and Li, L. (2014) Adaptive Database Schema Design for Multi-Tenant Data Management. [online].
- 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:
- 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
- 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.
- 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.
- Weis, J. and Alves-Foss, J. (2011) Securing database as a service: Issues and compromises. IEEE Security & Privacy [online](6), pp. 49-55 .
- 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].
- 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.
- Mintzberg, H. (1973) The Nature of Managerial Work, Harper and Row, New York.
- Rea L. M. and Parker, P. A. (1997). Designing and Conducting Survey Research, 2nd Ed., Jossey-Bass Publishers, San Francisco, USA.
- Burns, R.B (2000) Introduction to research methods (4th Edition). SAGE Publications, London.
- Creswell, J. (2003) Research Design: Qualitative, Quantitative, and Mixed Methods Approaches (2nd Ed), Sage, Thousand Oaks, CA.
- Abeysekera, S. (2001) Analysis approaches in participatory work involving ranks or scores. DFID Theme Paper (revised).UK: Statistical Services Centre, University of Reading [online].
- 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: