Multi-tenant elastic extension tables data management

Publication Type:
Journal Article
Procedia Computer Science, 2014, 29 pp. 2168 - 2181
Issue Date:
Filename Description Size
Thumbnail1-s2.0-S1877050914003792-main.pdfPublished Version1.08 MB
Adobe PDF
ThumbnailMulti-tenant Elastic Extension Tables Data Management _V_2.0.pdfAccepted Manuscript Version623.01 kB
Adobe PDF
Full metadata record
Multi-tenant database is a new database solution which is significant for Software as a service (SaaS) and Big Data applications in the context of cloud computing paradigm. This multi-tenant database has significant design challenges to develop a solution that ensures a high level of data quality, accessibility, and manageability for the tenants using this database. In this paper, we propose a multi-tenant data management service called Elastic Extension Tables Schema Handler Service (EETSHS), which is based on a multi-tenant database schema called Elastic Extension Tables (EET). This data management service satisfies tenants' different business requirements, by creating, managing, organizing, and administrating large volumes of structured, semi-structured, and unstructured data. Furthermore, it combines traditional relational data with virtual relational data in a single database schema and allows tenants to manage this data by calling functions from this service. We present algorithms for frequently used functions of this service, and perform several experiments to measure the feasibility and effectiveness of managing multi-tenant data using these functions. We report experimental results of query execution times for managing tenants' virtual and traditional relational data showing that EET schema is a good candidate for the management of multi-tenant data for SaaS and Big Data applications. © The Authors. Published by Elsevier B.V.
Please use this identifier to cite or link to this item: