Multi-Tenant Shared Storage Model Combining Sparse Tables and Block Table
CSTR:
Author:
  • Article
  • | |
  • Metrics
  • |
  • Reference [10]
  • |
  • Related [20]
  • | | |
  • 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
    [1] lfatatry A, Layzell P. Software as a service:A negotiation perspective. Proceedings of the 26th Annual International Computer Software and Applications. Oxford, UK, UK. 2002. 501-506.
    [2] Zou LD, Li QZ, Kong LJ. Isolated storage of multi-tenant data based on shared schema. Cybernetics and Information Technologies, 2016, 16(3):91-103.[doi:10.1515/cait-2016-0036
    [3] Weissman CD, Bobrowski S. The design of the force.com multitenant internet application development platform. Proceedings of 2009 ACM SIGMOD International Conference on Management of Data. Providence, Rhode Island, USA. 2009. 889-896.
    [4] Aulbach S, Jacobs D, Kemper A, et al. A comparison of flexible schemas for software as a service. Proceedings of 2009 ACM SIGMOD International Conference on Management of Data. Providence, Rhode Island, USA. 2009. 881-888.
    [5] Li XN, Zhao JL, Ma YM, et al. A partition model and strategy based on the Stoer-Wagner algorithm for SaaS multi-tenant data. Soft Computing, 2017, 21(20):6121-6132.[doi:10.1007/s00500-016-2169-z
    [6] Florescu D, Roquencourt I, Kossmann D. Storing and querying XML data using an RDMBS. Bulletin of the Technical Committee on Data Engineering, 1999, 22(3):27-34
    [7] Chen WL, Zhang SD, Kong LJ. A multiple sparse tables approach for multi-tenant data storage in SaaS. Proceedings of the 2nd International Conference on Industrial and Information Systems. Dalian, China. 2010. 413-416.
    [8] 姚金成, 张世栋, 史玉良, 等. 基于Chunk Folding的多租户数据库缓存管理机制. 计算机学报, 2011, 34(12):2319-2331
    [9] 何文哲, 范冰冰. 一种新型高效的多租户共享数据模型. 计算机应用与软件, 2017, 34(8):66-71.[doi:10.3969/j.issn.1000-386x.2017.08.012
    [10] 倪佳才. 多租户数据库设计的关键技术研究[博士学位论文]. 北京:清华大学, 2015.
    Cited by
    Comments
    Comments
    分享到微博
    Submit
Get Citation

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

Copy
Share
Article Metrics
  • Abstract:1339
  • PDF: 1823
  • HTML: 1235
  • Cited by: 0
History
  • Received:May 06,2018
  • Revised:June 04,2018
  • Online: December 05,2018
Article QR Code
You are the first990375Visitors
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