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.

[1]  Walid Rjaibi Label-based access control (LBAC) in DB2 LUW , 2006, PST.

[2]  Bo Gao,et al.  A Framework for Native Multi-Tenancy Application Development and Management , 2007, The 9th IEEE International Conference on E-Commerce Technology and The 4th IEEE International Conference on Enterprise Computing, E-Commerce and E-Services (CEC-EEE 2007).

[3]  Dean Jacobs,et al.  Ruminations on Multi-Tenant Databases , 2007, BTW.

[4]  Bret Waters,et al.  Software as a service: A look at the customer benefits , 2005 .

[5]  Bo Gao,et al.  A Study and Performance Evaluation of the Multi-Tenant Data Tier Design Patterns for Service Oriented Computing , 2008, 2008 IEEE International Conference on e-Business Engineering.

[6]  Hakan Hacigümüs,et al.  Executing SQL over encrypted data in the database-service-provider model , 2002, SIGMOD '02.

[7]  Torsten Grust,et al.  Multi-tenant databases for software as a service: schema-mapping techniques , 2008, SIGMOD Conference.

[8]  Wei Sun,et al.  Software as a Service: Configuration and Customization Perspectives , 2008, 2008 IEEE Congress on Services Part II (services-2 2008).