Font Size: a A A

Research On Schema Mapping Mechanism Optimization Technique In Multi-Tenant Database For SAAS Application

Posted on:2014-01-05Degree:MasterType:Thesis
Country:ChinaCandidate:L QiuFull Text:PDF
GTID:2248330398959202Subject:Computer software and theory
Abstract/Summary:PDF Full Text Request
As a new computing paradigm, cloud computing has achieved great success in business. Software as a service has become an important form of cloud computing. The data storage schema mapping mechanism is one of the key technologies to support multi-tenant SaaS application. In extension table schema mapping mechanism, the public portion of the SaaS application data is stored in the basic table, which allows the higher efficiency of data access. At the same time, the extended portion of the SaaS application data is stored in the extension table, which allows the higher extensibility, but the complexity of data query and update operations reduces the performance of the SaaS application. Therefore, the data storage schema mapping mechanism still exists some optimization space.No matter how excellent the Independent Software Vendor is, the design of the SaaS applications can not be done overnight. The SaaS application needs some necessary upgrades according to the actual needs of the tenants after long-term use. Once the new version SaaS application is on-line, the tenant can flexibly choose to use the old version or the new version of SaaS application. The upgrades of the SaaS application should occur while the system is in operation. It should be possible to run at least two simultaneous versions of the application, to support rolling upgrades, however ideally more versions should be provided. So that, the SaaS application data storage schema mapping mechanism should also support version evolution.In this paper, a new data storage schema mapping mechanism named clustering extension table is proposed. In this mechanism, we use the similarity of schema and data between tenants to optimize the extension table schema mapping mechanism in order to improve the storage efficiency and performance of the SaaS application.How to make the schema mapping mechanism to support multi-version SaaS application is also studied and discussed in this paper.The main work of the paper include:(1) We carry out related research on the SaaS application data storage schema mapping mechanism and make some improvements based on the extension table mapping mechanism. We propose a new data storage schema mapping mechanism named clustering extension table through in-depth analysis. In this mechanism, we use the similarity of schema and data between tenants to optimize the extension table schema mapping mechanism and improve the storage efficiency and performance of tne saas application on the premise of extensibility and scalability.(2) The SaaS application needs some necessary upgrades according to the actual needs of the tenants after long-term use. We analysis the requirements and the new problems brought about by the SaaS application upgrade. Then we discuss about how to make the clustering extension table schema mapping mechanism to support multi-version SaaS application.
Keywords/Search Tags:SaaS Applications, Multi-Tenant, Data Storage, Schema Mapping, Optimization Technique
PDF Full Text Request
Related items