Abstract
An important challenge in the design of databases that support mult i-tenant applications is to provide a platform to manage large volu mes of data collected fro m d ifferent businesses, social media networks, ema ils, news, online te xts, documents, and other data sources. To overcome this challenge we proposed in our previous work a mu lti -tenant database schema called Elastic Extension Tables (EET) that co mb ines multi -tenant relat ional tables and virtual re lational tables in a single database schema. Using this approach, the tenants’ tables can be extended to support the requirements of individual tenants. In this paper, we discuss the potentials of using EET mult i-tenant database schema, and show how it can be used for managing physical and virtual re lational data. We perform several e xperiments to measure the feasibility and effectiveness of EET by co mparing it with a comme rcia lly availab le mu lti-tenant schema mapping technique used by SalesForce.co m. We report significant performance improve ments obtained using EET when co mpared to Un iversal Tab le Sche ma Mapping (UTSM), ma king the EET schema a good candidate for the management of multitenant data in Software as a Service (SaaS) and Big Data applications.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
