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

TitleValidating ETL patterns feasability using alloy
Author(s)Oliveira, Bruno
Belo, Orlando
KeywordsAlloy
BPMN
Data warehousing systems
ETL component-reuse
ETL patterns
Formal specification and validation
Software engineering
Issue date2017
PublisherSCITEPRESS – Science and Technology Publications
Abstract(s)The ETL processes can be seen as typical data-oriented workflows composed of dozens of granular tasks that are responsible for the integration of data coming from different data sources. They are one of the most important components of a data warehousing system, strongly influenced by the complexity of business requirements, their changing, and evolution. To facilitate the planning and ETL implementation, a set of patterns specially designed to map standard ETL procedures is presented. They provide a simpler and conceptual perspective that can enrich to enable the generation of execution primitives. Generic models can be built, simplifying process views and providing methods for carrying out the acquired expertise to new applications using well-proven practices. This work demonstrates the fundaments of an ETL pattern-based approach for ETL development, its configuration and validation trough a set of Alloy specifications used to express its structural constraints and behaviour.
TypeConference paper
URIhttp://hdl.handle.net/1822/54397
ISBN978-989-758-255-4
DOI10.5220/0006428002000207
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:CAlg - Artigos em livros de atas/Papers in proceedings

Files in This Item:
File Description SizeFormat 
2017-CI-DATA-Oliveira&Belo-CRP.pdf
  Restricted access
680,29 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