标题：An index model for multitenant data storage in SaaS
作者：Cheng, Pang ;Qingzhong, Li ;Lanju, Kong
作者机构：[Cheng, Pang ;Qingzhong, Li ;Lanju, Kong ] School of Computer Science and Technology, Shandong University, Jinan, China
会议名称：14th International Conference on Web-Age Information Management, WAIM 2013
会议日期：14 June 2013 through 16 June 2013
来源：Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
摘要：For SaaS applications which multiple tenants share sparse tables, fields of varying data types are stored in one flex column based on customization. Thus it is not practical to create native physical indices for tenants. In this paper, we put forward an indexing model for sparse table storage model based on pivot tables in multi-node environments. The core idea is copying field data to be indexed to another table and creating physical indices in that table. This model supports customization and isolation characteristics of multitenant applications, and provides load balance means in index subsystem, and controls the number of index data tables thus memory consuming reasonably. © 2013 Springer-Verlag Berlin Heidelberg.