Skip to content

A review of multi-tenant database and factors that influence its adoption

Research output: Chapter in Book/Report/Conference proceedingConference contribution

A Multi-tenant database (MTD) is a way of deploying a Database as a Service (DaaS). This is gaining momentum with significant increase in the number of organizations ready to take advantage of the technology. A multi-tenant database refers to a principle where a single instance of a Database Management System (DBMS) runs on a server, serving multiple clients organizations (tenants). This is a database which provides database support to a number of separate and distinct groups of users or tenants. This concept spreads the cost of hardware, software and other services to a large number of tenants, therefore significantly reducing per tenant cost. Three different approaches of implementing multi-tenant database have been identified. These methods have been shown to be increasingly better at pooling resources and also processing administrative operations in bulk. This paper reports the requirement of multi-tenant databases, challenges of implementing MTD, database migration for elasticity in MTD and factors influencing the choice of models in MTD. An insightful discussion is presented in this paper by grouping these factors into four categories. This shows that the degree of tenancy is an influence to the approach to be adopted and the capital and operational expenditure are greatly reduced in comparison with an on-premises solution.
Original languageEnglish
Title of host publicationUK Academy for Information Systems Conference Proceedings 2014
PublisherAssociation for Information Systems
Number of pages24
Publication statusPublished - 2014
EventUKAIS 2014 Conference - St Catherine's College, Oxford, United Kingdom
Duration: 7 Apr 20149 Apr 2014

Conference

ConferenceUKAIS 2014 Conference
CountryUnited Kingdom
CityOxford
Period7/04/149/04/14

Related information

Relations Get citation (various referencing formats)

ID: 8739662