loading
Papers

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Bruno Oliveira and Orlando Belo

Affiliation: University of Minho, Portugal

ISBN: 978-989-8565-59-4

Keyword(s): Data Warehousing Systems, ETL Conceptual Modelling, Specification, Validation, Analysis and Testing of ETL Systems, BPMN Meta-model Extensions.

Related Ontology Subjects/Areas/Topics: Data Warehouses and OLAP ; Databases and Information Systems Integration ; Enterprise Information Systems

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.

PDF ImageFull Text

Download
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 34.236.216.93

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. 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

@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},
}

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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.