Supporting Database Applications as a Service

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-Separate...

• Type: Conference
• Year: 2009
• Where: ICDE
• Authors: Mei Hui, Dawei Jiang, Guoliang Li, Yuan Zhou
• Keywords: Database, ICDE 2009, MSI Provides Flexibility, Multi-tenant Data Management, Promising Multi-tenancy Storage, Query Performance Degradation, Scalability Issue