loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Bruno Oliveira 1 ; Óscar Oliveira 1 and Orlando Belo 2

Affiliations: 1 CIICESI, School of Management and Technology, Porto Polytechnic, Rua do Curral, Felgueiras, Portugal ; 2 ALGORITMI R&D Centre, University of Minho, Braga, Portugal

Keyword(s): Data Warehousing, ETL, Conceptual Modelling, BPMN.

Abstract: One of the most important parts of a Data Warehousing System is the Extract-Transform-Load (ETL) component. It is responsible for extracting, transforming, conciliating, and loading data for supporting decision-making requirements. Usually, due to the complexity of managing heterogeneous data, this component is responsible for consuming most of the resources required for implementing a Data Warehousing System, representing a critical component that compromises the adequacy of the system. Despite their importance, the ETL development method is essentially ad-hoc, which does not always follow or embodies the best practices. With the emergence of Big Data and associated tools, script-based ETL became, even more, a common approach. In the last years, BPMN – Business Process Model and Notation – have been proposed and used to support ETL conceptual models. Still, as an expressive language, it provides different approaches for representing the same requirements. In this paper, we explore t he use of BPMN for ETL conceptual modelling, analyzing existing approaches, and proposing a set of guidelines for using this notation in a more consistent way. (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.236.112.101

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:
Oliveira, B.; Oliveira, Ó. and Belo, O. (2021). Using BPMN for ETL Conceptual Modelling: A Case Study. In Proceedings of the 10th International Conference on Data Science, Technology and Applications - DATA; ISBN 978-989-758-521-0; ISSN 2184-285X, SciTePress, pages 267-274. DOI: 10.5220/0010575702670274

@conference{data21,
author={Bruno Oliveira. and Óscar Oliveira. and Orlando Belo.},
title={Using BPMN for ETL Conceptual Modelling: A Case Study},
booktitle={Proceedings of the 10th International Conference on Data Science, Technology and Applications - DATA},
year={2021},
pages={267-274},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0010575702670274},
isbn={978-989-758-521-0},
issn={2184-285X},
}

TY - CONF

JO - Proceedings of the 10th International Conference on Data Science, Technology and Applications - DATA
TI - Using BPMN for ETL Conceptual Modelling: A Case Study
SN - 978-989-758-521-0
IS - 2184-285X
AU - Oliveira, B.
AU - Oliveira, Ó.
AU - Belo, O.
PY - 2021
SP - 267
EP - 274
DO - 10.5220/0010575702670274
PB - SciTePress