• العربية
    • English
  • English 
    • العربية
    • English
  • Login
Home
Publisher PoliciesTerms of InterestHelp Videos
Submit Thesis
IntroductionIUGSpace Policies
JavaScript is disabled for your browser. Some features of this site may not work without it.
View Item 
  •   Home
  • Faculty of Information Technology
  • Staff Publications- Faculty of Information Technology
  • View Item
  •   Home
  • Faculty of Information Technology
  • Staff Publications- Faculty of Information Technology
  • View Item

Please use this identifier to cite or link to this item:

http://hdl.handle.net/20.500.12358/23861
TitleAn Efficient Approach for Supporting Multi-Tenancy Schema Inheritance in RDBMS for SaaS
Untitled
Abstract

Multi-tenancy refers to a principle in software architecture where a single instance of the software runs on a server, serving multiple client organizations (tenants). Common practice is to map multiple singletenant logical schemas in the application to one multi-tenant physical schema in the database. Such mappings are challenging to create. This is due to the flexibility of base scheme to be extended by enterprise application tenants which provides different dynamically modified versions of the application. The fundamental limitation on scalability of this approach is the number of tables of database can handle. Shared Tables Shared Instances (STSI) is a state-of-the-art approach to design the schema. However, they suffer from poor performance and high space overhead. In this paper, we propose an efficient approach for supporting multi-tenancy schema inheritance. We trade-off STSI and our approach. Experimental results show that our method achieves good scalability and high performance with low space requirement, and outperforms STSI methods at different rates depending on DML operations.

Authors
Barhoom, Tawfiq S.
Hillis, Samir S.
TypeJournal Article
Date2015
LanguageEnglish
Subjects
multi-tenant database
index terms-cloud computing
database as a service (dbaas)
schema-mapping technique
Published inJournal of Engineering Research and Technology
SeriesVolume: 2, Number: 4
Publisherالجامعة الإسلامية - غزة
Citation
License
Collections
  • Staff Publications- Faculty of Information Technology [192]
Files in this item
1660-4531-1-PB.pdf557.9Kb
Thumbnail

The institutional repository of the Islamic University of Gaza was established as part of the ROMOR project that has been co-funded with support from the European Commission under the ERASMUS + European programme. This publication reflects the views only of the author, and the Commission cannot be held responsible for any use which may be made of the information contained therein.

Contact Us | Send Feedback
 

 

Browse

All of IUGSpaceCommunities & CollectionsBy Issue DateAuthorsTitlesSubjectsSupervisorsThis CollectionBy Issue DateAuthorsTitlesSubjectsSupervisors

My Account

LoginRegister

Statistics

View Usage Statistics

The institutional repository of the Islamic University of Gaza was established as part of the ROMOR project that has been co-funded with support from the European Commission under the ERASMUS + European programme. This publication reflects the views only of the author, and the Commission cannot be held responsible for any use which may be made of the information contained therein.

Contact Us | Send Feedback