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.

A Data Synchronization Based Single Sign-On Schema Supporting Heterogeneous Systems And Multi-Management Mode

Improvement on SAML-based Single Sign-on Model

Design And Implementation Of Interoperable Medical Information System Based On Soa

Research on SOA-oriented and Single Sign-on based System Integration Technology

Supporting Database Applications As a Service

Design and Implementation of Unified Access Control System Based on LDAP

A New SIP SSO Mechanism

Design and Realization of Distributed SSO System Supporting Multi-mode Application

The Design and Implementation of Message System-based and Customizable Single Sign out Service

Data Consistency Management in an Open Smart Home Management Platform

Multi-database Middleware System Based on SEDA

An Authentication and Authorization Solution Supporting SOA-based Distributed Systems

Comparative Analysis and Framework Evaluating Web Single Sign-on Systems

SUAA: A Secure User Authentication Scheme with Anonymity for the Single & Multi-server Environments.

Constructing authentication web in cloud computing

An Empirical Study of Security Issues in SSO Server-Side Implementations

Protecting Outsourced Data in Semi-Trustworthy Cloud: A Hierarchical System

A Novel Multiserver Authentication Scheme Using Proxy Resignature With Scalability and Strong User Anonymity

A solution for unified identity authentication based on LDAP

SLSM : An Efficient Strategy for Lazy Schema Migration on Shared-Nothing Databases

Research on Data Synchronization Consistency Comparison System Based on Computer Heterogeneous Database