ETL processes are difficult components of modern Data Warehousing architectures, which are gaining momentum thanks the renewed interest stirred-up by the emerging Big Data paradigm. Due to the complexity of modeling ETL processes, various alternatives appeared in the literature. But several limitations arise, such as the poor attention to the flexibility of models. Following the drawbacks of actual proposals, in this paper we argue that a novel approach based on a pattern-oriented and task-reusable framework may convey in lot of advantages for the ETL process (conceptual) modeling itself. Our proposal is thus represented by a pattern-oriented meta-model for supporting the conceptual modeling of ETL processes in next-generation Data Warehousing environments. The most distinctive characteristic of our framework consists in the reusability of task-oriented components, with clear advantages for the flexibility and the extendibility of the final ETL process model so-determined. To validate our proposal, we exploit the YAWL workflow modeling language, and develop a suitable pattern for validating target ETL processes.

Modeling and Supporting ETL Processes via a Pattern-Oriented, Task-Reusable Framework

CUZZOCREA, Alfredo Massimiliano;
2014

Abstract

ETL processes are difficult components of modern Data Warehousing architectures, which are gaining momentum thanks the renewed interest stirred-up by the emerging Big Data paradigm. Due to the complexity of modeling ETL processes, various alternatives appeared in the literature. But several limitations arise, such as the poor attention to the flexibility of models. Following the drawbacks of actual proposals, in this paper we argue that a novel approach based on a pattern-oriented and task-reusable framework may convey in lot of advantages for the ETL process (conceptual) modeling itself. Our proposal is thus represented by a pattern-oriented meta-model for supporting the conceptual modeling of ETL processes in next-generation Data Warehousing environments. The most distinctive characteristic of our framework consists in the reusability of task-oriented components, with clear advantages for the flexibility and the extendibility of the final ETL process model so-determined. To validate our proposal, we exploit the YAWL workflow modeling language, and develop a suitable pattern for validating target ETL processes.
9781479965724
9781479965724
File in questo prodotto:
Non ci sono file associati a questo prodotto.

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: http://hdl.handle.net/11368/2896362
 Attenzione

Attenzione! I dati visualizzati non sono stati sottoposti a validazione da parte dell'ateneo

Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 6
  • ???jsp.display-item.citation.isi??? 2
social impact