Defining ETL worfklows using BPMN and BPEL

  • Authors:
  • Zineb El Akkaoui;Esteban Zimanyi

  • Affiliations:
  • Université Libre de Bruxelles, Brussels, Belgium;Université Libre de Bruxelles, Brussels, Belgium

  • Venue:
  • Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
  • Year:
  • 2009

Quantified Score

Hi-index 0.00

Visualization

Abstract

Decisional systems are crucial for enterprise improvement. They allow the consolidation of heterogeneous data from distributed enterprise data stores into strategic indicators. An essential component of this data consolidation is the Extract, Transform, and Load (ETL) process. In the research literature there has been very few work defining conceptual models for ETL processes. At the same time, there are currently many tools that manage such processes. However, each tool uses its own model, which is not necessarily able to communicate with the models of other tools. In this paper, we propose a platform-independent conceptual model of ETL processes based on the Business Process Model Notation (BPMN) standard. We also show how such a conceptual model can be implemented using Business Process Execution Language (BPEL), a standard executable language for specifying interactions with web services.