Utilize este identificador para referenciar este registo:
https://hdl.handle.net/1822/90741
Título: | Using BPMN for ETL conceptual modelling: A case study |
Autor(es): | Oliveira, Bruno Oliveira, Oscar Belo, Orlando |
Palavras-chave: | Data Warehousing ETL Conceptual Modelling BPMN |
Data: | 2021 |
Editora: | SCITEPRESS |
Citação: | Oliveira, B., Oliveira, Ó., & Belo, O. (2021). Using BPMN for ETL Conceptual Modelling: A Case Study. Proceedings of the 10th International Conference on Data Science, Technology and Applications. SCITEPRESS - Science and Technology Publications. http://doi.org/10.5220/0010575702670274 |
Resumo(s): | 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 the 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. |
Tipo: | Artigo em ata de conferência |
URI: | https://hdl.handle.net/1822/90741 |
ISBN: | 9789897585210 |
DOI: | 10.5220/0010575702670274 |
Versão da editora: | https://www.scitepress.org/Link.aspx?doi=10.5220/0010575702670274 |
Arbitragem científica: | yes |
Acesso: | Acesso restrito UMinho |
Aparece nas coleções: |
Ficheiros deste registo:
Ficheiro | Descrição | Tamanho | Formato | |
---|---|---|---|---|
BPMN_ETL_DATA_VF.pdf Acesso restrito! | 939,83 kB | Adobe PDF | Ver/Abrir |