A multiple sparse tables approach for multi-tenant data storage in SaaS

Abstract

The sparse table approach is an effective storage solution for multi-tenant data in SaaS. However in the sparse table, because of the shared data storage of different tenants that have different schemas, there are so many nulls which result in a waste of storage space and query efficiency problems. We analyze the difference between the multi-tenant sparse data and the traditional sparse one such as e-commerce data and propose a multiple sparse tables approach, in which the tables have gradient columns. We carry out experiments and the results figure out that the approach can effectively reduce the space waste and improve the query performance.

6 Figures and Tables

Cite this paper

@article{Weiliang2010AMS, title={A multiple sparse tables approach for multi-tenant data storage in SaaS}, author={Chen Abel Weiliang and Zhang Shidong and Kong Lanju}, journal={2010 2nd International Conference on Industrial and Information Systems}, year={2010}, volume={1}, pages={413-416} }