Paper Info
Title
A Flexible Data Model for Multi-tenant Databases for Software as a Service
Abstract
We study data models for multi-tenant databases for Software as a service (SaaS), which is important for emerging big data applications. In our study we consider the shared table architecture model of SaaS for its advantages over the shared machine and shared process models. Our goal is to further improve the processing time and space utilization of shared table model. For this, we introduce a new data model, called Index table layout and compare its performance with the Chunk table layout. Our model includes an additional 'index' column in the base table that cross-references via the index across supporting tables. Not needing nulls, the proposed model enjoys quick access of the values in a column. We evaluated the performance of our model, for which we crated randomly large data for Chunk table layout and from which we then constructed the tables for the Index table layout. We also compiled 3 types of queries used in our evaluation. Our results show that Index table layout is better than the Chunk table layout in terms of expressive power, space utilization, and query processing time.
Year
DOI
Venue
2013
10.1109/CSE.2013.154
Computational Science and Engineering
Keywords
Field
DocType
flexible data model,chunk table layout,shared process model,index table layout,data model,shared table architecture model,multi-tenant databases,space utilization,new data model,base table,shared table model,database management systems,cloud computing,software architecture
Data mining,Data modeling,Decision table,Computer science,Software as a service,Database design,Software architecture,Database index,Data model,Branch table,Database
Conference
ISSN
Citations 
PageRank 
1949-0828
0
0.34
References 
Authors
9
3
Name
Order
Citations
PageRank
Indrani Gorti100.34
Nematollaah Shiri228028.31
Thiruvengadam Radhakrishnan311732.44