Beta
187320

Multi-Tenant RDBMS Migration in the Cloud Environment

Article

Last updated: 22 Jan 2023

Subjects

-

Tags

-

Abstract

In a multi-tenant business environment, tenants share the same applications and databases to store their data. Due to the widespread use of a multi-tenant environment, the service providers face difficult challenges daily. These challenges are condensed in how to guarantee the quality of service provided to tenants, which are documented in a formal document known as a Service Level Agreement (SLA). In addition, SLA should consider the irregular patterns of workload of tenants which may affect the level of guarantee. In this research, an Enhanced Multi-Tenant Database Management System (EMT DBMS) is proposed. In addition, an Enhanced Multi-tenant Migration Algorithm called EMT-M is presented, which aims to migrate the violated tenants depending on both the number of SLA violations and the variance rate. Experimental results prove that the proposed EMT-M algorithm is ideal for migrating violated tenants, as it reduces the number of SLA violations compared to previous migration algorithms.

DOI

10.21608/ijicis.2021.77309.1093

Keywords

Service Level Agreements (SLA), Cloud Computing, Data Migration, Relational Database Management System (RDBMS)

Authors

First Name

ahmed

Last Name

Abdel Raouf

MiddleName

ezzat

Affiliation

Faculty of Computer and Information Sciences, Ain Shams University, Cairo, Egypt

Email

ahmed_ezzat991@yahoo.com

City

-

Orcid

-

First Name

Alshaimaa

Last Name

Abo-alian

MiddleName

-

Affiliation

Faculty of Computer and Information Sciences, Ain Shams University, Cairo, Egypt

Email

a_alian@cis.asu.edu.eg

City

-

Orcid

-

First Name

Nagwa

Last Name

Badr

MiddleName

-

Affiliation

Department of Information Systems, Faculty of Computer and Information Sciences, Ain Shams University, Cairo, 11566, Egypt

Email

nagwabadr@cis.asu.edu.eg

City

-

Orcid

0000-0002-5382-1385

Volume

21

Article Issue

2

Related Issue

25765

Issue Date

2021-07-01

Receive Date

2021-05-23

Publish Date

2021-07-31

Page Start

96

Page End

109

Print ISSN

1687-109X

Online ISSN

2535-1710

Link

https://ijicis.journals.ekb.eg/article_187320.html

Detail API

https://ijicis.journals.ekb.eg/service?article_code=187320

Order

7

Type

Original Article

Type Code

494

Publication Type

Journal

Publication Title

International Journal of Intelligent Computing and Information Sciences

Publication Link

https://ijicis.journals.ekb.eg/

MainTitle

-

Details

Type

Article

Created At

22 Jan 2023