OATAO - Open Archive Toulouse Archive Ouverte Open Access Week

Answering GPSJ Queries in a Polystore: a Dataspace-Based Approach

Ben Hamadou, Hamdi and Gallinucci, Enrico and Golfarelli, Matteo Answering GPSJ Queries in a Polystore: a Dataspace-Based Approach. (2019) In: 38th International Conference on Conceptual Modeling (ER 2019), 4 November 2019 (Salvador de Bahia, Brazil).

(Document in English)

PDF (Author's version) - Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader

Official URL: https://doi.org/10.1007/978-3-030-33223-5_16


The discipline of data science is steering analysts away from traditional data warehousing and towards a more flexible and lightweight approach to data analysis. The idea is to perform OLAP analyses in a pay-as-you-go manner across heterogeneous schemas and data models, where the integration is progressively carried out by the user as the available data is explored. In this paper, we propose an approach to support data analysis within a polystore supporting relational, document and column data models by automatically handling both data model and schema heterogeneity through a dataspace layer on top of the underlying databases. The expressiveness we enable corresponds to GPSJ queries, which are the most common class of queries in OLAP applications. We rely on Nested Relational Algebra to define a cross-database execution plan. The plan is composed of several local plans, to be executed on the distinct databases, and a global plan, which combines and possibly aggregates inter-database data. The system has been prototyped on Apache Spark.

Item Type:Conference or Workshop Item (Paper)
Additional Information:Thanks to Springer editor. This papers appears in volume 11788 of Lecture Notes in Computer Science ISSN : 0302-9743 ISBN 978-3-030-33222-8 The original PDF is available at: https://link.springer.com/chapter/10.1007/978-3-030-33223-5_16
HAL Id:hal-02901590
Audience (conference):International conference proceedings
Uncontrolled Keywords:
Institution:French research institutions > Centre National de la Recherche Scientifique - CNRS (FRANCE)
Université de Toulouse > Institut National Polytechnique de Toulouse - Toulouse INP (FRANCE)
Other partners > Università di Bologna (ITALY)
Université de Toulouse > Université Toulouse III - Paul Sabatier - UT3 (FRANCE)
Université de Toulouse > Université Toulouse - Jean Jaurès - UT2J (FRANCE)
Université de Toulouse > Université Toulouse 1 Capitole - UT1 (FRANCE)
Laboratory name:
Deposited On:06 Jul 2020 11:56

Repository Staff Only: item control page