Please use this identifier to cite or link to this item:
Title: Supporting database applications as a service
Authors: Hui, M.
Jiang, D. 
Li, G.
Zhou, Y.
Issue Date: 2009
Citation: Hui, M.,Jiang, D.,Li, G.,Zhou, Y. (2009). Supporting database applications as a service. Proceedings - International Conference on Data Engineering : 832-843. ScholarBank@NUS Repository.
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. © 2009 IEEE.
Source Title: Proceedings - International Conference on Data Engineering
ISBN: 9780769535456
ISSN: 10844627
DOI: 10.1109/ICDE.2009.82
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.


checked on Sep 20, 2022

Page view(s)

checked on Sep 22, 2022

Google ScholarTM



Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.