Back to Search Start Over

Experimenting with big data computing for scaling data quality-aware query processing.

Authors :
Cisneros-Cabrera, Sonia
Michailidou, Anna-Valentini
Sampaio, Sandra
Sampaio, Pedro
Gounaris, Anastasios
Source :
Expert Systems with Applications. Sep2021, Vol. 178, pN.PAG-N.PAG. 1p.
Publication Year :
2021

Abstract

• Empirical study aimed at "scaling up" data quality (DQ) management applications. • Execution of data quality-aware queries over sensor-collected traffic data sets. • Exploration of Apache Spark and Pandas library to speed-up query execution. • Insights on choice of computational infrastructure to deploy DQ management tools. Combining query processing techniques with data quality management approaches enables enforcement of quality constraints, such as timeliness, accuracy and completeness, as part of ad-hoc query specification and execution, improving the quality of query results. Despite the emergence of novel data quality processing tools, there is a dearth of studies assessing performance and scalability in the execution of data quality assessment tasks during query processing. This paper reports on an empirical study aiming to investigate the extent to which a big data computing framework (Spark) can offer significant gains in performance and scalability when executing data quality querying tasks over a range of computational platforms including a single commodity multi-core machine and a cluster-based platform for a wide range of workloads. Our results show that substantial performance and scalability gains can be obtained by using optimized data science libraries combined with the parallel and distributed capabilities of big data computing. We also provide guidelines on choosing the appropriate computational infrastructure for executing DQ-aware queries. [ABSTRACT FROM AUTHOR]

Details

Language :
English
ISSN :
09574174
Volume :
178
Database :
Academic Search Index
Journal :
Expert Systems with Applications
Publication Type :
Academic Journal
Accession number :
150467117
Full Text :
https://doi.org/10.1016/j.eswa.2021.114858