A proxy service for multi-tenant elastic extension tables
- Publication Type:
- Chapter
- Citation:
- 2015, 9070
- Issue Date:
- 2015-01-01
Closed Access
| Filename | Description | Size | |||
|---|---|---|---|---|---|
 | TLDKS_SI_#8641_Camera_Ready_A Proxy Service for Multi-tenant Elastic Extension Tables.pdf | Submitted Version | 1.64 MB |
Copyright Clearance Process
- Recently Added
- In Progress
- Closed Access
This item is closed access and not available.
© Springer-Verlag Berlin Heidelberg 2015. 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: