标题：CET: Clustering Extension Table Research in Multi-tenant Database for SaaS Applications
作者：Qiu, Lei; Zheng, Yongqing; Shi, Yuliang; Sang, Chengliang
作者机构：[Qiu, Lei; Zheng, Yongqing; Shi, Yuliang; Sang, Chengliang] Shandong Univ, Sch Comp Sci & Technol, Jinan 250101, Shandong, Peoples R China.; [Qiu, L 更多
会议名称：International Conference on Information Science and Technology (ICIST)
会议日期：MAR 23-25, 2013
来源：2013 INTERNATIONAL CONFERENCE ON INFORMATION SCIENCE AND TECHNOLOGY (ICIST)
摘要：Microsoft's ET (extension table) approach makes the data model arbitrarily extensible while retaining the cost benefits of using a shared database. But it adds complexity for database querying and updating. We improve it and propose CET (Clustering Extension Table). There are several tables in CET, including BT (Basic Table), CT (Clustering Table), CMT (Metadata Table for CT), ET (Extension Table) and EMT (Metadata Table for ET). The similarity of tenants is adopted to cluster them into different groups. In the group, some data in the basic table and extension table is transformed and consolidated together into the CT (Clustering Table). In one group, CT extracts the common similarity of the tenants in the group to avoid the complexity of using ET. Then SER (Schema Efficiency Ratio) and DER (Data Efficiency Ratio) are described to control tenants' adscription into their groups. Experiments are also conducted to show the improvement of ET.