Research on Index of Multi-Tenant Based on Key-Values for SaaS Application
Kong Lan · Chinese Journal of Computers · 2010
In order to excellently support SaaS application,multi-tenant database system needs to meet the tenants requirement of isolation and on-demand customization,and then to provide data storage mechanism and index mechanism that supporting isolation and flexibility.Based on key-values model,this paper proposes a meta-data driven indexing mechanism,according to tenant customization requirements,the model constructs respective index metadata for business data of the tenants,and then achieves isolation customization effects through metadata-driven mechanism;while the index maintenance strategies are given,in response to tenants access requests,the model forms and slices the index data as the basic unit and return quickly the result sets.In this paper,detailed experimental results show that index maintenance and data access of this program work with good performance under normal conditions.