Abstract
AbstractIn this paper, we investigate Data Wrangling (DW) pipelines in the form of workflows devised by data analysts with varying levels of experience to find commonalities or patterns. We propose an approach for pattern discovery based on workflow mining techniques, addressing key challenges associated with finding patterns in data preparation solutions. The findings provide insights into the most commonly used DW operations, solution patterns, redundancies, and reuse opportunities in data preparation. The findings were used to create design pattern specifications curated into a catalog in the form of a DW Design Patterns Handbook. The evaluation of the proposed handbook is performed by surveying professionals with results confirming the usefulness of discovered patterns to the construction of DW solutions and assisting data analysts/scientists via the reuse of patterns and best practices in DW.
Funder
Ministry of Education - Kingdom of Saudi Arabia
Publisher
Springer Science and Business Media LLC
Subject
Computer Networks and Communications,Information Systems,Theoretical Computer Science,Software
Reference44 articles.
1. Anaconda (2022). State of data science 2022: Paving the way for innovation. Retrieved from https://www.anaconda.com/resources/whitepapers/state-of-data-science-report-2022 Accessed 24 July 2023
2. Berthold, M.R., Cebron, N., Dill, F., Gabriel, T.R., Kötter, T., & Meinl, T., . . . Wiswedel, B. (2007). Knime: The konstanz information miner. Data analysis , machine learning and applications : Proc. of the 31st annual conference of the gesellschaft für klassifikation e. v., albert-ludwigs-universität freiburg. Springer
3. Budinsky, F. J., Finnie, M. A., Vlissides, J. M., & Yu, P. S. (1996). Automatic code generation from design patterns. IBM systems Journal, 35(2), 151–171.
4. Chandra, L., Seidel, S., & Gregor, S. (2015). Prescriptive knowledge in is research: Conceptualizing design principles in terms of materiality, action, and boundary conditions. 48th Hawaii intl. conference on system sciences pp 4039–4048
5. Coalition, W.M. (2023). Workflow management coalition - glossary. https://wfmc.org/glossary/. Accessed 31 Oct 2023