摘要
面向SaaS应用的多租户数据库为满足租户的数据隔离和按需定制的需求,需要提供支持隔离和易于定制的数据存储机制及索引机制.基于键值对存储方式,提出元数据驱动的映射表索引模型,该模型根据租户定制需求,为租户业务数据形成各自的索引元数据,通过元数据驱动实现了索引数据的隔离及定制效果;给出索引的维护策略,根据租户数据访问请求进行索引切片,以逐渐细化的索引切片作为数据访问的基本单位,快速返回租户结果集.实验结果表明,该方案在数据访问分布均衡的情况下,使索引维护及数据访问具有较好的总体性能.
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.
出处
《计算机学报》
EI
CSCD
北大核心
2010年第12期2239-2247,共9页
Chinese Journal of Computers
基金
国家自然科学基金(90818001
61003253)
国家科技支撑计划(2009BAH44B02
2009BAH44B04)
山东省自然科学基金(ZR2010FQ026
2009ZRB019YT
2009ZRB019RW)
山东省科技攻关计划(2010GGX10105
2009GG10001002)
山东大学自主创新基金(2009TS030)资助~~
