Unified Models and Framework for Querying Distributed Data Across Polystores

Léa El Ahdab (1, 2, 3) , Imen Megdiche (1, 2, 4) , André Péninou (5, 1, 2, 6) , Olivier Teste (5, 2, 1, 6)

1 IRIT - Institut de recherche en informatique de Toulouse
2 IRIT-SIG - Systèmes d’Informations Généralisées
3 UT3 - Université Toulouse III - Paul Sabatier
4 INUC - Institut national universitaire Champollion [Albi]
5 IUT Toulouse 2 Blagnac
6 UT2J - Université Toulouse - Jean Jaurès

Combining data sources from NoSQL and SQL systems leads to data distribution and complexifies user queries: data is distributed among different stores having different data models. This data implementation complexifies the writing of user queries. This work proposes a querying framework of a polystore with the use of unified models as a user vision of the polystore. Unified models hides the variety of data models and data distribution to the user. Our solution uses the Entity-Relationship model of the polystore to infer unified models and to identify intermediate required operations to fulfill querying on real polystore. Using these required transformations, a rewriting framework allows to automatically rewrite the user query (against the unified model) with respect to the real data distribution over the polystore. We apply this framework with one dataset (UniBench benchmark) between a relational, a document-oriented and a graph-oriented databases. We illustrate in this work performance and the low impact of our query rewriting solution when compared to query execution time.

Keywords: Polystore; NoSQL; SQL; Data distribution; Data fragmentation; Query rewriting

Domains: Databases [cs.DB]

Léa El Ahdab, Imen Megdiche, André Péninou, Olivier Teste. Unified Models and Framework for Querying Distributed Data Across Polystores. 18th Research Challenges in Information Science (RCIS 2024), May 2024, Guimaraes, Portugal. pp.3-18, ⟨10.1007/978-3-031-59465-6_1⟩. ⟨hal-04567654⟩