Title
An index model for multitenant data storage in saas
Abstract
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.
Year
DOI
Venue
2013
10.1007/978-3-642-38562-9_43
WAIM
Keywords
Field
DocType
native physical index,varying data type,multitenant data storage,multiple tenants share sparse,physical index,field data,index model,index data table,pivot table,index subsystem,sparse table storage model,indexing model
Data mining,Computer science,Load balancing (computing),Computer data storage,Multitenancy,Search engine indexing,Software as a service,Data type,Storage model,Pivot table,Database
Conference
Citations 
PageRank 
References 
1
0.39
9
Authors
3
Name
Order
Citations
PageRank
Pang Cheng110.39
Li Qingzhong210.39
Kong Lanju311.40