标题:A multiple sparse tables approach for multi-tenant data storage in SaaS
作者:Weiliang, Chen ;Shidong, Zhang ;Lanju, Kong
通讯作者:Weiliang, C
作者机构:[Weiliang, Chen ;Shidong, Zhang ;Lanju, Kong ] School of Computer Science and Technology, Shandong University, Jinan, China
会议名称:2010 2nd International Conference on Industrial and Information Systems, IIS 2010
会议日期:10 July 2010 through 11 July 2010
来源:2010 2nd International Conference on Industrial and Information Systems, IIS 2010
出版年:2010
卷:1
页码:413-416
DOI:10.1109/INDUSIS.2010.5565824
关键词:Multi-tenant; Null; Sparse table
摘要:The sparse table approach is an effective storage solution for multi-tenant data in SaaS. However in the sparse table, because of the shared data storage of different tenants that have different schemas, there are so many nulls which result in a waste of storage space and query efficiency problems. We analyze the difference between the multi-tenant sparse data and the traditional sparse one such as e-commerce data and propose a multiple sparse tables approach, in which the tables have gradient columns. We carry out experiments and the results figure out that the approach can effectively reduce the space waste and improve the query performance. © 2010 IEEE.
收录类别:EI;SCOPUS
Scopus被引频次:6
资源类型:会议论文;期刊论文
原文链接:https://www.scopus.com/inward/record.uri?eid=2-s2.0-77958474257&doi=10.1109%2fINDUSIS.2010.5565824&partnerID=40&md5=4f6364deeb69e88a50ff7ea24035b96a
TOP