Estudo de caso sobre o processamento de consultas com a engine FederatedX

  • Samuel L. B. Bispo UEM
  • Raqueline R. M. Penteado UEM

Abstract


This article presents a case study on the federated query processing in the FederatedX engine of the MariaDB DBMS. The central focus of the study was query optimization, specifically the minimization of the execution time. The study considered two aspects: i) the definition of the logical model, and ii) the data indexing mechanism. The study’s results demonstrated that the definition of the logical model was crucial in reducing processing time, while the same was not observed about indexing.

References

Arh, M. (2022). What is data federation, and why is it important to your organization?

Azevedo, L., F. de S. Soares, E., Souza, R., and Ferreira Moreno, M. (2020). Modern federated database systems: An overview. pages 276-283.

Bispo, S., Fukace, V., Mazur, A., Penteado, R., and Teixeira, H. (2022). Integração de dados abertos em saúde com o modelo obda: Um estudo de caso na área de cirurgia bariátrica. In Anais do XXII Simpósio Brasileiro de Computação Aplicada à Saúde, pages 401-412, Porto Alegre, RS, Brasil. SBC.

Sheth, A. P. and Larson, J. A. (1990). Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Comput. Surv., 22(3):183-236.
Published
2023-04-11
BISPO, Samuel L. B.; PENTEADO, Raqueline R. M.. Estudo de caso sobre o processamento de consultas com a engine FederatedX. In: REGIONAL DATABASE SCHOOL (ERBD), 18. , 2023, Palmas/PR. Anais [...]. Porto Alegre: Sociedade Brasileira de Computação, 2023 . p. 126-129. ISSN 2595-413X. DOI: https://doi.org/10.5753/erbd.2023.229428.