A Polystore Querying System applied to heterogeneous and horizontally distributed data - IRIT - Université Toulouse Jean Jaurès Access content directly
Conference Papers Year : 2023

A Polystore Querying System applied to heterogeneous and horizontally distributed data

Abstract

Data storage in various systems such as SQL and NoSQL leads to important problems when trying to unify data querying. Multiple storage systems conduct to heterogeneous data structures and to multiple query languages. In the context of horizontally and disjointed distributed data, this paper proposes a system that allows the user to natively query a polystore system without taking care of data distribution and heterogeneity. Our approach relies on two mechanisms: (i) mapping dictionaries to define the navigation between systems, (ii) operator rewriting mechanisms from native query operators (selection, projection, aggregation and join) to execute queries on any polystore system. Using a dataset from TPC-H benchmark and a horizontally distributed between document and relational database management system, we conduct experiments showing that the rewriting process has a minimum impact when compared to executing queries in both systems.
Fichier principal
Vignette du fichier
2023-08-28 DEXA Short paper.pdf (352.09 Ko) Télécharger le fichier
Origin : Files produced by the author(s)

Dates and versions

hal-04276556 , version 1 (09-11-2023)

Identifiers

Cite

Léa El Ahdab, Olivier Teste, Imen Megdiche, André Péninou. A Polystore Querying System applied to heterogeneous and horizontally distributed data. 34th International Conference on Database and Expert Systems Applications (DEXA 2023), Aug 2023, Penang, Malaysia. pp.437 - 442, ⟨10.1007/978-3-031-39847-6_35⟩. ⟨hal-04276556⟩
90 View
9 Download

Altmetric

Share

Gmail Facebook X LinkedIn More