A Polystore Querying System applied to heterogeneous and horizontally distributed data - Université Toulouse III - Paul Sabatier - Toulouse INP
Communication Dans Un Congrès Année : 2023

A Polystore Querying System applied to heterogeneous and horizontally distributed data

Résumé

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
Origine Fichiers produits par l'(les) auteur(s)

Dates et versions

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

Identifiants

Citer

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⟩
170 Consultations
49 Téléchargements

Altmetric

Partager

More