Realizing a Multi-Tenant SaaS Platform Based on Universal Table Schema Layout

• Main Authors: Tan Deik Hoong, 陳德泓
• Other Authors: 廖峻鋒
• Format: Others
• Language: en_US
• Published: 2014
• Online Access: http://ndltd.ncl.edu.tw/handle/09838701801280141871

碩士 === 逢甲大學 === 資訊工程學系 === 102 === Over the past few years, cloud computing has become one of the hottest topics in information technology. Governmental organizations, academic research institutes and related technology industries, have expressed a high degree of interest in the research and development of cloud computing technologies. SaaS (Software as a Service) is an emerging model of cloud computing which can provide business software applications through the network by shared resources with each tenants. In the traditional enterprise applications, each user has a separate enterprise application , it can be very easy to save and load any custom configuration. However in a multi-tenant how to support different tenants independent custom configurations for the same application instance is the fundamental challenge facing in multi-tenant technology. This thesis focuses on the databases level and aims to provide a multi-tenant data schema as well as schema customization. The proposed approach facilitates developers to convert private table SQL statements to fulfill statement of multi-tenant schema efficiently. The main contribution of this work is twofold: 1) First part is to develop a multi-tenant platform and multi-tenant database schema will implement by Universal Table Layout. Allows developers to manage or customize database for each tenants effectively through the platform. 2) To develop an adapter that enables existing web site transfers the storing method of multi-tenant database without modifying a lot of code and to enhance the speed of multi-tenant systems development and resource utilization.