A proxy service for multi-tenant elastic extension tables

Publisher:
Springer
Publication Type:
Chapter
Citation:
Special Issue on Advanced Techniques for Big Data Management, 2015, 9070 pp. 1 - 34
Issue Date:
2015
Full metadata record
Files in This Item:
An important challenge in the design of multi-tenant databases that support Software as a Service (SaaS) applications is providing a platform that manages multiple tenants’ data in single database storage. To address this challenge, we have previously proposed a multi-tenant database schema called Elastic Extension Tables (EET) that uses single shared database and shared schema for all tenants. In this paper, we extend this work with a multi-tenant database proxy service called Elastic Extension Tables Proxy Service (EETPS) that combines tenants’ relational tables with virtual relational tables into single database schema for each tenant. This service enables data access by calling functions in order to avoid writing SQL queries and backend data management code. It allows the tenants to focus on their core business and easily create SaaS, mobile, web, and desktop software applications. We present the EETPS algorithms and perform several experiments to assess their feasibility and effectiveness by comparing the performance of retrieving data from traditional physical tables, virtual tables, and integrated physical and virtual tables.
Please use this identifier to cite or link to this item: