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

Hamdi Ben Hamadou, Enrico Gallinucci, Matteo Golfarelli

Research output: Contribution to book/anthology/report/conference proceedingBook chapterResearchpeer-review

1 Citation (Scopus)


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.
Original languageEnglish
Title of host publicationInternational Conference on Conceptual Modeling
Publication date2019
ISBN (Print)978-3-030-33222-8
ISBN (Electronic)978-3-030-33223-5
Publication statusPublished - 2019
EventInternational Conference on Conceptual Modeling - Salvador, Brazil
Duration: 4 Nov 20197 Nov 2019


ConferenceInternational Conference on Conceptual Modeling

Fingerprint Dive into the research topics of 'Answering GPSJ Queries in a Polystore: A Dataspace-Based Approach'. Together they form a unique fingerprint.

  • Cite this

    Hamadou, H. B., Gallinucci, E., & Golfarelli, M. (2019). Answering GPSJ Queries in a Polystore: A Dataspace-Based Approach. In International Conference on Conceptual Modeling (Vol. 11788, pp. 189-203)