Abstract
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.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: International Journal of Database Theory and Application
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
