Abstract:Multi-tenant data management is a form of software as a service (SaaS), whereby a third party service provider hosts databases as a service and provides its customers with seamless mechanisms to create, store and access their databases at the host site. One of the main problems in such a system, as we shall discuss in this paper, is scalability, namely the ability to serve an increasing number of tenants without too much query performance degradation. A promising way to handle the scalability issue is to consolidate tuples from different tenants into the same shared tables. However, this approach introduces two problems: 1) The shared tables are too sparse. 2)Indexing on shared tables is not effective. To resolve the problems, we propose a multi-tenant database system called M-Store, which provides storage and indexing services for multi-tenants. To improve the scalability of the system, we develop two techniques in M-Store: bitmap interpreted tuple (BIT) and multi-separated index (MSI). BIT is efficient in that it does not store NULLs from unused attributes in the shared tables and MSI provides flexibility since it only indexes each tenant's own data on frequently accessed attributes. We extended MySQL based on our proposed design and conducted extensive experiments. The experimental results show that our proposed approach is a promising multi-tenancy storage and indexing scheme which can be easily integrated into existing DBMS.

The Distributed Storage System Based on MPP for Mass Data

Supporting Database Applications As a Service

Research on Mass Process-Planning Data Storing and Parallel Accessing in Large-Scale Manufacturing Enterprise

Research on Mass Process-Planning Data Storing and Parallel Accessing in Large-Scale Manufacturing Enterprise.

Mpdbs: A Multi-Level Parallel Database System Based on B-Tree

Research on Distributed Storage Technology Based on Mass Data

A data distribution strategy for scalable main-memory database

Research on P2P database management system

A Serie Method of Massive Information Storage, Retrieval and Sharing

A Novel Distributed Database Solution Based on Mysql

ScaMMDB: Facing Challenge of Mass Data Processing with MMDB

The Study and Implementation of an Effective Massive Data Storage Technique to OLAP

A MMDB Cluster Based Cloud Platform for Query-Intensive Web Information Systems.

Distributed Storage System for Electric Power Data Based on Hbase

Research and Design of MDS in Distributed Storage System

A Scalable Data Platform for Cloud Computing Systems

Distributed Heterogeneous Storage Based On Data Value

Mass Data Storage and Management Solution Based on Cloud Computing

Managing Large Scale Unstructured Data with RDBMS

Adaptive Data Access Optimization of High Performance Computing

MSDB: A Massive Sensor Data Processing Middleware for HBase