loading
Papers Papers/2020

Research.Publish.Connect.

Paper

Authors: Lucas F. de Oliveira ; Alessandro Elias ; Fabiola Santore ; Diego Pasqualin ; Luis Bona ; Marcos Sunyé and Marcos Didonet Del Fabro

Affiliation: C3SL Labs, Informatics Department, Federal University of Paraná, Curitiba, Brazil

Keyword(s): Analytical Querying, Open Data API, Query Generation, Relation-Free Query.

Abstract: The large availability of tabular Open Data sources with hundreds of attributes and relations makes the query development a difficult task, where analytic queries are common. When writing such queries, often called SPJG (Select-Project-Join-GroupBy), it is necessary to understand a data model and to write JOIN operations. The most common approach is to use business intelligence frameworks, or recent solutions based on keywords or examples. However, they require the utilization of specific applications and there is a lack of support for web-based APIs. We present a solution that eases the task of query development for tabular Open Data analytics through an API, using a simplified query representation where it is not allowed to specify the data relations, and consequently neither the joins over them, called Relation-Free Query. We define a single virtual schema that captures the database structure, which allows the use of relation-free queries in existent DBMS’s. The concrete queries a re exposed by a RESTful API, which is then translated into a database query language using known query generation solutions. The API is available as a microservice. We present a case study to describe solution, using a real world scenario to query in an integrated database of several Brazilian open databases with hundreds of attributes. (More)

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 3.235.176.80

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
F. de Oliveira, L.; Elias, A.; Santore, F.; Pasqualin, D.; Bona, L.; Sunyé, M. and Didonet Del Fabro, M. (2020). Open Data Analytic Querying using a Relation-Free API. In Proceedings of the 22nd International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-423-7; ISSN 2184-4992, pages 148-155. DOI: 10.5220/0009413001480155

@conference{iceis20,
author={Lucas {F. de Oliveira}. and Alessandro Elias. and Fabiola Santore. and Diego Pasqualin. and Luis Bona. and Marcos Sunyé. and Marcos {Didonet Del Fabro}.},
title={Open Data Analytic Querying using a Relation-Free API},
booktitle={Proceedings of the 22nd International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2020},
pages={148-155},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0009413001480155},
isbn={978-989-758-423-7},
issn={2184-4992},
}

TY - CONF

JO - Proceedings of the 22nd International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - Open Data Analytic Querying using a Relation-Free API
SN - 978-989-758-423-7
IS - 2184-4992
AU - F. de Oliveira, L.
AU - Elias, A.
AU - Santore, F.
AU - Pasqualin, D.
AU - Bona, L.
AU - Sunyé, M.
AU - Didonet Del Fabro, M.
PY - 2020
SP - 148
EP - 155
DO - 10.5220/0009413001480155