A Heuristic Data Allocation Method for Multi-tenant SaaS Application in Distributed Database Systems

Multi-tenant Software as a Service (aka, SaaS) applications generally run on distributed database systems for better performance and scalability. How to partition and allocate data of the application on distributed database servers is important to the efficiency of the whole system. This paper proposes a tenant data set based data partitioning method. And based on the characteristics of the data operations of each tenant, this paper put forward a heuristic data allocation method to achieve minimum data operation cost of all the tenants of the SaaS application. Experimental results show that the proposed data allocation method reduces data operation cost, thus improves the execution efficiency of the application.