ETL Standard Processes Modelling - A Novel BPMN Approach

Bruno Oliveira, Orlando Belo

2013

Abstract

ETL systems modelling have been a topic quite explored by researchers in Data Warehousing. However, we believe that there isn’t yet a convinced and simply approach that provides the necessary bridges to validate conceptual and logical models and testing them before its real implementation. In this work we explore the use of BPMN for ETL conceptual modelling, presenting an extension to the BPMN 2.0 meta-model and notation to support modelling and visualization of ETL activities. We intend to provide a set of BPMN meta-models especially designed to map standard ETL processes, providing the necessary bridges to translate conceptual models into their correspondent implementation testing correctness and effectiveness of its execution. For this particular work, we specially designed a standard ETL process – Change Data Capture based on log files – to demonstrate the viability and effectiveness of the approach presented.

Paper Citation

in Harvard Style

Oliveira B. and Belo O. (2013). ETL Standard Processes Modelling - A Novel BPMN Approach . In Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8565-59-4, pages 120-127. DOI: 10.5220/0004418301200127

in Bibtex Style

@conference{iceis13,
author={Bruno Oliveira and Orlando Belo},
title={ETL Standard Processes Modelling - A Novel BPMN Approach},
booktitle={Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2013},
pages={120-127},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004418301200127},
isbn={978-989-8565-59-4},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - ETL Standard Processes Modelling - A Novel BPMN Approach
SN - 978-989-8565-59-4
AU - Oliveira B.
AU - Belo O.
PY - 2013
SP - 120
EP - 127
DO - 10.5220/0004418301200127