Wen Hao An

A Study and Performance Evaluation of the Multi-Tenant Data Tier Design Patterns for Service Oriented Computing

Multi-tenancy is one of key characteristics of the service oriented computing especially for Software as a Service (SaaS) to leverage economy of scale to drive down total cost of ownership for both service consumer and provider. This paper aims to study the technologies to build a cost-effective, secure and scalable multi-tenant infrastructure, especially in data tier. We first explore all the key implementation patterns of data tier multi-tenancy on aspects of isolation, security, customization & scalability etc. Furthermore, we mainly evaluate the performance of these design patterns on aspects of isolation and security via a series of experiments and simulations. This paper also identifies the potential performance bottlenecks, summarizes corresponding optimization approaches and best implementation practices for different multi-tenant business usage models.

A Non-intrusive Multi-tenant Database Software for Large Scale SaaS Application

Multi-tenant is a key characteristic for cost effective Software as a Service (SaaS) applications which drive down total cost of ownership for both service consumers and providers. This paper describes our research in designing & building a cost-effective, secure, customizable, scalable and non-intrusive multi-tenant database which greatly accelerates the migration and development of SaaS applications. We analyze the requirements and gaps in traditional database when supporting SaaS scenario, and then propose a novel nonintrusive multi-tenant database framework to address these challenges. Some key considerations and different implementation approaches in designing and implementation such a framework are discussed and compared. This paper also identifies some potential database performance optimization approaches in the multi-tenant scenario.