Automatic Module Detection in Data Cleaning Workflows: Enabling Transparency and Recipe Reuse

Lan Li,Nikolaus Parulian,Bertram Ludäscher,Bertram Ludäscher
DOI: https://doi.org/10.2218/ijdc.v16i1.771
2022-04-18
International Journal of Digital Curation
Abstract:Before data from multiple sources can be analyzed, data cleaning workflows (“recipes”) usually need to be employed to improve data quality. We identify a number of technical problems that make application of FAIR principles to data cleaning recipes challenging. We then demonstrate how transparency and reusability of recipes can be improved by analyzing dataflow dependencies within recipes. In particular column-level dependencies can be used to automatically detect independent subworkflows, which then can be reused individually as data cleaning modules. We have prototypically implemented this approach as part of an ongoing project to develop open-source companion tools for OpenRefine. Keywords: Data Cleaning, Provenance, Workflow Analysis
What problem does this paper attempt to address?