Modularizing tenant-specific schema customization in SaaS applications

Liao, Chun-Feng; Chen, Kung; Chen, Jiu-Jye

doi:10.1145/2451469.2451473

Cited by 3 publications

(1 citation statement)

References 10 publications

(11 reference statements)

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Universal Table" Technique is derived from the shared tables schema, and was referred to as the most flexible technique in [7]. This technique was adopted by SalesForce.com.…”

Section: A Techniques Deploying a Single Approachmentioning

confidence: 99%

A Hybrid Multi-Tenant Database Schema for Multi-Level Quality of Service

Saleh¹,

Fouad²,

Abu-Elkheir³

2014

ijacsa

View full text Add to dashboard Cite

Abstract-Software as a Service (SaaS) providers can serve hundreds of thousands of customers using sharable resources to reduce costs. Multi-tenancy architecture allows SaaS providers to run a single application and a database instance, which support multiple tenants with various business needs and priorities. Until now, the database management systems (DBMSs) have not had the notion of multi-tenancy, and they have not been equipped to handle customization or scalability requirements, that are typical in multi-tenant applications. The multi-tenant database performance should adapt to tenants workloads and fit their special requirements. In this paper, we propose a new multitenant database schema design approach, that adapts to multitenant application requirements, in addition to tenants needs of data security, isolation, queries performance and response time speed. Our proposed methodology provides a trade-off between the performance and the storage space. This proposal caters for the diversity in tenants via defining multi-level quality of service for the different types of tenants, depending on tenant rate and system rate. The proposal presents a new technique to distribute data in a multi-tenant database horizontally to a set of allotment tables using an isolation point, and vertically to a set of extension tables using a merger point. Finally, we present a prototype implementation of our method using a real-world case study, showing that the proposed solution can achieve high scalability and increase performance for tenants who need speedy performance and economize storage space for tenants who do not have demanding quality of service.

show abstract

“…Universal Table" Technique is derived from the shared tables schema, and was referred to as the most flexible technique in [7]. This technique was adopted by SalesForce.com.…”

Section: A Techniques Deploying a Single Approachmentioning

confidence: 99%

A Hybrid Multi-Tenant Database Schema for Multi-Level Quality of Service

Saleh¹,

Fouad²,

Abu-Elkheir³

2014

ijacsa

View full text Add to dashboard Cite

show abstract

Evaluating the Performance of Multi-tenant Elastic Extension Tables

Yaish

Goyal

Feuerlicht

2014

Procedia Computer Science

View full text Add to dashboard Cite

A Systematic Mapping Study on the Customization Solutions of Software as a Service Applications

et al. 2019

View full text Add to dashboard Cite

Software as a Service (SaaS) is widely used and depended on by a wide range of applications. Considering this, the SaaS should capacitate itself to offer service to a large number of customers having their own specific requirements, without encountering software quality problems. Therefore, several researchers delved into the SaaS customization, and many customization solutions have been proposed. However, heretofore, no analysis or study explicitly classifies these proposals using different criteria, e.g., the kind of change required, the component of the software requiring changes, and the quality attributes of the SaaS considered in each proposed solution. This paper adopts the systematic mapping approach to methodically investigate the solutions recommended for the SaaS customization problems. These solutions are classified into various categories to create a classification scheme based on the customization types (personalization, configuration, composition, modification, integration, and extension), customization layer (user interfaces, workflows, services, and data), and quality attributes. Our study identified 81 primary studies reporting SaaS customization solutions. The results show that the configuration, composition, and extension received the highest consideration in the proposed solutions. In addition, the majority of the proposed solutions for the SaaS customization are connected with the workflow and service layers. Furthermore, the attributes, such as multi-tenancy, security, functionality, scalability, availability, and efficiency, are considered much more often than other attributes. The classification of the proposed solutions for the SaaS customization and results of this paper can play an important role in creating a framework for the SaaS customization assessment.

show abstract

Modularizing tenant-specific schema customization in SaaS applications

Cited by 3 publications

References 10 publications

A Hybrid Multi-Tenant Database Schema for Multi-Level Quality of Service

A Hybrid Multi-Tenant Database Schema for Multi-Level Quality of Service

Evaluating the Performance of Multi-tenant Elastic Extension Tables

A Systematic Mapping Study on the Customization Solutions of Software as a Service Applications

Contact Info

Product

Resources

About