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

Full metadata record
DC FieldValueLanguage
dc.contributor.authorOliveira, Brunopor
dc.contributor.authorBelo, Orlandopor
dc.date.accessioned2018-04-17T13:22:19Z-
dc.date.issued2017-02-
dc.identifier.issn0266-4720-
dc.identifier.urihttp://hdl.handle.net/1822/54401-
dc.description.abstractDuring 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.por
dc.language.isoengpor
dc.publisherWileypor
dc.rightsrestrictedAccesspor
dc.subjectBPMN specification modelspor
dc.subjectData warehousing systemspor
dc.subjectDomain-specific languagepor
dc.subjectETL conceptual modelingpor
dc.subjectETL patternspor
dc.subjectETL skeletonspor
dc.titleOn the specification of extract, transform, and load patterns behavior: A domain-specific language approachpor
dc.typearticlepor
dc.peerreviewedyespor
oaire.citationIssue1por
oaire.citationVolume34por
dc.date.updated2018-04-17T12:27:03Z-
dc.identifier.essn1468-0394-
dc.identifier.doi10.1111/exsy.12168por
dc.description.publicationversioninfo:eu-repo/semantics/publishedVersionpor
dc.subject.wosScience & Technology-
sdum.export.identifier5100-
sdum.journalExpert Systemspor
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