원문정보
초록
영어
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.
목차
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