![](/images/graphics-bg.png)
An efficient approach for supporting multi-tenancy schema inheritance in RDBMS for SaaS
Joint Authors
Hillis, Samir A.
Barhum, Tawfiq
Source
Journal of Engineering Research and Technology
Issue
Vol. 2, Issue 4 (31 Dec. 2015), pp.209-216, 8 p.
Publisher
The Islamic University-Gaza Deanship of Research and Graduate Affairs
Publication Date
2015-12-31
Country of Publication
Palestine (Gaza Strip)
No. of Pages
8
Main Subjects
Information Technology and Computer Science
Abstract EN
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 single-tenant 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.
American Psychological Association (APA)
Barhum, Tawfiq& Hillis, Samir A.. 2015. An efficient approach for supporting multi-tenancy schema inheritance in RDBMS for SaaS. Journal of Engineering Research and Technology،Vol. 2, no. 4, pp.209-216.
https://search.emarefa.net/detail/BIM-717492
Modern Language Association (MLA)
Barhum, Tawfiq& Hillis, Samir A.. An efficient approach for supporting multi-tenancy schema inheritance in RDBMS for SaaS. Journal of Engineering Research and Technology Vol. 2, no. 4 (Dec. 2015), pp.209-216.
https://search.emarefa.net/detail/BIM-717492
American Medical Association (AMA)
Barhum, Tawfiq& Hillis, Samir A.. An efficient approach for supporting multi-tenancy schema inheritance in RDBMS for SaaS. Journal of Engineering Research and Technology. 2015. Vol. 2, no. 4, pp.209-216.
https://search.emarefa.net/detail/BIM-717492
Data Type
Journal Articles
Language
English
Notes
Includes bibliographical references : p. 215-216
Record ID
BIM-717492