Proxy Service for Multi-tenant Database Access

Abstract : The database of multi-tenant Software as a Service (SaaS) applications has challenges in designing and developing a relational database for multi-tenant applications. In addition, combining relational tables and virtual relational tables to make them work together and act as one database for each single tenant is a hard and complex problem to solve. Based on our multi-tenant Elastic Extension Tables (EET), we are proposing in this paper a multi-tenant database proxy service to combine multi-tenant relational tables and virtual relational tables, to make them act as one database for each single tenant. This combined database is suitable to run with multi-tenant SaaS single instance applications, which allow tenants designing their database and automatically configuring its behavior during application runtime execution. In addition, these applications allow retrieving tenants data by simply calling functions from this service which spare tenants from spending money and efforts on writing SQL queries and backend data management codes, and instead allowing them to focus on their business and to create their web, mobile, and desktop applications. The feasibility and effectiveness of the proposed service are verified by using experimental data on some of this service functions.
Complete list of metadatas

Cited literature [12 references]  Display  Hide  Download

https://hal.inria.fr/hal-01506783
Contributor : Hal Ifip <>
Submitted on : Wednesday, April 12, 2017 - 11:19:12 AM
Last modification on : Monday, March 11, 2019 - 11:14:03 AM
Long-term archiving on: Thursday, July 13, 2017 - 12:31:11 PM

File

978-3-642-40511-2_8_Chapter.pd...
Files produced by the author(s)

Licence


Distributed under a Creative Commons Attribution 4.0 International License

Identifiers

  • HAL Id : hal-01506783, version 1

Citation

Haitham Yaish, Madhu Goyal, George Feuerlicht. Proxy Service for Multi-tenant Database Access. 1st Cross-Domain Conference and Workshop on Availability, Reliability, and Security in Information Systems (CD-ARES), Sep 2013, Regensburg, Germany. pp.100-117. ⟨hal-01506783⟩

Share

Metrics

Record views

140

Files downloads

292