RAID-B2K, transforming BPMN conceptual schemas into Kettle execution primitives
by Orlando Belo; Vasco Santos; Bruno Oliveira; Cláudia Gomes; Ricardo Marques
International Journal of Information and Decision Sciences (IJIDS), Vol. 10, No. 1, 2018

Abstract: There are many tools for designing and modelling extract-transform-load (ETL) systems, covering its entire development life cycle. However, the vast majority of them use proprietary methodologies, notations and tasks, which undermine their understanding and application. In this paper, we present a translation tool for conceptual models, with the ability to reduce the 'gap' that usually exists when we need to translate a conceptual model for an equivalent physical one. We will demonstrate that it is possible to automatically translate ETL conceptual models developed in business process model and notation (BPMN) into the environment of a specific ETL implementation tool (Kettle-Pentaho data integration). The BPMN models were built to produce schemes for a specific execution environment (RAID) allowing us to demonstrate the utility of the tool in the translation, validation and generation of the physical schemas which we designated as ETL skeletons - a set of execution primitives properly orchestrated.

Online publication date: Tue, 27-Mar-2018

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Information and Decision Sciences (IJIDS):
Login with your Inderscience username and password:

    Username:        Password:         

Forgotten your password?


Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com