Earticle

초록

영어

Multi-tenant data storage model has multiple solutions and comparing the different storage solutions can help users improve their work efficiency. This paper proposes a query performance evaluation method based on the relational algebra. First of all, we introduce three wide table models. Secondly, we unite the format of tenant query SQL statement by analyzing structure of storage model, replace the unified format SQL with the relational algebra and evaluate the I/O cost of SQL query using relational algebra. Finally, through theoretical calculations and experimental simulations, we evaluate the performance of multi-tenant storage model according to query performance. The results show our evaluation method based on relational algebra provides new perspective for the study of performance evaluation in multi-tenant data model.

목차

Abstract
 1. Introduction
 2. Multi-Tenant Wide Table Data Storage Model
  2.1 Wide Table
  2.2 Multi Wide Table
  2.3 Multi Extension Table
 3. SQL to Relational Algebra
  3.1 View Definition
  3.2 The Basic SQL in Relational Algebra
 4. Relational Algebra Evaluation on Disk I/O Cost
 5. Evaluation and Experiment Analysis
  5.1 Qualitative Analysis
  5.2 Quantitative Evaluation
 6. Summary
 References

키워드

저자

• Dun Li [ School of Information Engineering, Zhengzhou University, Zhengzhou, China ]
• Zhenfei Wang [ School of Information Engineering, Zhengzhou University, Zhengzhou, China ]
• Zhiyun Zheng [ School of Information Engineering, Zhengzhou University, Zhengzhou, China ]
• Jin Zhao [ School of Information Engineering, Zhengzhou University, Zhengzhou, China ]

참고문헌

발행기관

간행물

표지보기 관심저널 등록

• 간행물명

  International Journal of Database Theory and Application

• 간기

  격월간

• pISSN

  2005-4270

• 수록기간

  2008~2016

• 십진분류

  KDC 505 DDC 605