Multi-Tenant Shared Storage Model Combining Sparse Tables and Block Table
CSTR:
Author:
Affiliation:

Clc Number:

Fund Project:

  • Article
  • |
  • Figures
  • |
  • Metrics
  • |
  • Reference
  • |
  • Related
  • |
  • Cited by
  • |
  • Materials
  • |
  • Comments
    Abstract:

    Aiming at the low utilization of storage space in traditional single-sparse storage model and the problem of more connections in reconstructing the logical relationship of tenants in the block table storage model, the combination of sparse tables and block table storage model is put forward. In the storage model, the attributes in the logic tables provided by the SaaS providers and the attributes in the custom logical tables are mapped into the corresponding sparse tables and the custom attributes of a part of the tenant common data type are stored in the block table, so as to avoid the problem of data migration caused by the number of extended columns exceeding the number of sparse tables. Finally, the query conversion and query efficiency are optimized through the query rewriter. The experimental results show that the storage model improves storage space utilization and query efficiency compared with the traditional sparse table storage model.

    Reference
    Related
    Cited by
Get Citation

刘彬,程凯,于杰.稀疏表与块表结合的多租户共享存储模型.计算机系统应用,2018,27(12):210-215

Copy
Share
Article Metrics
  • Abstract:
  • PDF:
  • HTML:
  • Cited by:
History
  • Received:May 06,2018
  • Revised:June 04,2018
  • Adopted:
  • Online: December 05,2018
  • Published:
Article QR Code
You are the firstVisitors
Copyright: Institute of Software, Chinese Academy of Sciences Beijing ICP No. 05046678-3
Address:4# South Fourth Street, Zhongguancun,Haidian, Beijing,Postal Code:100190
Phone:010-62661041 Fax: Email:csa (a) iscas.ac.cn
Technical Support:Beijing Qinyun Technology Development Co., Ltd.

Beijing Public Network Security No. 11040202500063