Abstract

We study existing data models for multi-tenant architectures for Software as a Service (SaaS) in the context of cloud computing, and compare them in terms of space utilization, query formulation and processing. We propose a new model called, the Index table layout (ITL), which stores data column-wise, and enjoys a simple mapping process between schemas of original data of tenants and the cloud schema, thus making the model flexible. We conducted experiments to evaluate the performance of the ITL model, for which we used three types of queries, compiled from the literature as well as new queries. The results of our numerous experiments show significant improvement over existing models.