Please use this identifier to cite or link to this item: http://hdl.handle.net/1822/54401

TitleOn the specification of extract, transform, and load patterns behavior: A domain-specific language approach
Author(s)Oliveira, Bruno
Belo, Orlando
KeywordsBPMN specification models
Data warehousing systems
Domain-specific language
ETL conceptual modeling
ETL patterns
ETL skeletons
Issue dateFeb-2017
PublisherWiley
JournalExpert Systems
Abstract(s)During the last few years, many research efforts have been done to improve the design of extract, transform, and load (ETL) models systems. Still, ETL systems are considered very time-consuming, error-prone, and complex involving several participants from different knowledge domains. The ETL processes are one of the most important components of a data warehousing system that are strongly influenced by the complexity of business requirements, their changing and evolution. These aspects influence not only the structure of the data warehouse itself but also the structures of the data sources involved with. To minimize the negative impact of such variables, we propose the use of ETL patterns to build specific ETL packages. In this paper, we formalize this approach using the BPMN for modeling more conceptual ETL workflows, mapping them to real execution primitives through the use of a domain-specific language that allows for the generation of specific instances that can be executed in an ETL commercial tool.
TypeArticle
URIhttp://hdl.handle.net/1822/54401
DOI10.1111/exsy.12168
ISSN0266-4720
e-ISSN1468-0394
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:CAlg - Artigos em revistas internacionais/Papers in international journals

Files in This Item:
File Description SizeFormat 
2017-JN-Wiley-ES-Oliveira&Belo-VF.pdf
  Restricted access
393,22 kBAdobe PDFView/Open

Partilhe no FacebookPartilhe no TwitterPartilhe no DeliciousPartilhe no LinkedInPartilhe no DiggAdicionar ao Google BookmarksPartilhe no MySpacePartilhe no Orkut
Exporte no formato BibTex mendeley Exporte no formato Endnote Adicione ao seu ORCID