Cost-based Optimization of Multistore Query Plans

2023 | Information Systems Frontiers | Citations: 0

Authors: Forresi, Chiara; Francia, Matteo; Gallinucci, Enrico; Golfarelli, Matteo

Abstract: Multistores are data management systems that enable query processing across diff ... Expand

Abstract: Multistores are data management systems that enable query processing across different and heterogeneous databases; besides the distribution of data, complexity factors like schema heterogeneity and data replication must be resolved through integration and data fusion activities. Our multistore solution relies on a dataspace to provide the user with an integrated view of the available data and enables the formulation and execution of GPSJ queries. In this paper, we propose a technique to optimize the execution of GPSJ queries by formulating and evaluating different execution plans on the multistore. In particular, we outline different strategies to carry out joins and data fusion by relying on different schema representations; then, a self-learning black-box cost model is used to estimate execution times and select the most efficient plan. The experiments assess the effectiveness of the cost model in choosing the best execution plan for the given queries and exploit multiple multistore benchmarks to investigate the factors that influence the performance of different plans. Collapse

Topics: database system MongoDB PostgreSQL document database relational database

Methods: computational algorithm experiment case study regression analysis method longitudinal research