Analytical study for measuring the effects of database segregation multi-tenancy approaches on cost and performance in cloud computing

Other Title(s)

دراسة تحليلية لقياس تأثير مبادئ خاصية تعدد المستأجرين في قواعد البيانات الانفصالية على التكلفة و الأداء في الحوسبة السحابية

Dissertant

Dawud, Ala Kamal Ibrahim

Thesis advisor

Kayid, Ahmad

Comitee Members

Abu Shurayhah, Ahmad
Abu Shanab, Imad

University

Middle East University

Faculty

Faculty of Information Technology

Department

Department of Computer Information Systems

University Country

Jordan

Degree

Master

Degree Date

2015

English Abstract

Software as a Service (SaaS) service model reduces software costs and provides efficient use of applications in the internet environments.

Multitenancy is one of the most important features in cloud computing that is responsible to provide software applications for tenants in cloud computing environment.

Thus, several database segregations techniques (approaches) are available to be used in multitenant environment.

Each approach of database segregation has its own effect on the performance, cost, and security depending on the types of query that is executed.

The main aim of this thesis is to study the performance, cost, and security of the database segregation depending on the utilized database segregation approach.

To be able to meet this aim it had been outlined different types of database segregations, database sizes, and queries.

The findings of literature review have been deployed to design several experiments for this research.

Three experiments have been conducted to evaluate the response time database transaction in term of performance, evaluate the CPU's statistics and disk storage statistics in term of cost, and evaluate the effects of increasing and decreasing the security by manipulating the number of encryption over a database tables in term of cost and performance (transaction time).

The empirical findings in this study showed that selecting shared database shared schema approach give the system the chance to gain 42 % compared with selecting isolated database approach, and 71% compared with selecting shared database with separate schema from performance (transaction time) perspective.

However, selecting isolated database approach was given the system a chance to gain 33% compared with selecting B, and 69% compared with selecting shared database shared schema approach from CPU cost perspective.

Furthermore, selecting shared database with separate schema approach was given the system chance to gain 37% compared with selecting isolated database approach, and 57% compared with selecting shared database with shared schema approach from security perspective.

Main Subjects

Information Technology and Computer Science

No. of Pages

67

Table of Contents

• APA
• MLA
• AMA

Language

English

Data Type

Arab Theses

Record ID

BIM-721133