A Mixed Partitioning Approach for Multi - tenant Data Schema ⋆
نویسندگان
چکیده
The traditional Database partitioning has failed in multi-tenant shared scheme database; this paper proposed a mixed Partitioning Approach. By integrating vertical and horizontal partitioning, we can adaptive expand the multi-tenant database according to the number of server nodes or we can make an optimal partitioning. Experimental results show that our approach can improve the performance of multi-tenant database with heavy loads, and compared with BVP method, our approach increased less distribute transactions.
منابع مشابه
A Hybrid Multi-Tenant Database Schema for Multi-Level Quality of Service
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, a...
متن کاملA new meta-data driven data-sharing storage model for SaaS
A multi-tenant database is the primary characteristic of SaaS, it allows SaaS vendors to run a single instance application which supports multiple tenants on the same hardware and software infrastructure. This application should be highly customizable to meet tenants’ expectations and business requirements. This paper examined current solutions on multi-tenancy, and proposed a new meta-data dri...
متن کاملA Hypergraph Partition Based Approach to Dynamic Deployment for Service-Oriented Multi-tenant SaaS Applications
In a service-oriented multi-tenant SaaS application, all tenants share services and user requests of the service change dynamically. In order to provide high-quality web services, we must solve the problem of the load unbalance caused by dynamic user requests’ change. This paper proposes an approach based on hypergraph partition to keep load balance for serviceoriented multi-tenant SaaS applica...
متن کاملMulti - Tenant Customizable Databases Master ’ s
We argue that there is a need for Multi-Tenant Customizable OLTP systems. Such systems need a Multi-Tenant Customizable Database (MTC-DB) as a backing. To stimulate the development of such databases, we propose the benchmark MTCB. Benchmarks for OLTP exist and multi-tenant benchmarks exist, but no MTC-DB benchmark exists that accounts for customizability. We formulate seven requirements for the...
متن کاملResearch on Multi-tenant Replication Consistency Based on Quorum NRW System
Replication technology, such as Quorum NRW system, is the most effective technology to improve availability of SaaS. However, the variety of SaaS transaction will result in application unbalance. In this paper, we construct a new Quorum NRW system for multitenant database which is based on the method of sharing database and schema model. It can provide different R and W values for each tenant a...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2013