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

TitleColored Petri nets in the simulation of ETL standard tasks: the surrogate key pipelining case
Author(s)Silva, Diogo
Belo, Orlando
Fernandes, João M.
KeywordsData Warehousing
ETL Systems
Coloured Petri Nets
Simulation and Evaluation of ETL Processes
Standard ETL Tasks
Surrogate Key Pipelining
Issue dateOct-2012
PublisherEUROSIS-ETI
Abstract(s)ETL (Extract-Transform-Load) systems are formed by processes responsible for the extraction of data from several sources, cleaning and transforming it in accordance with some prerequisites of a data warehouse, and finally loading it in its multidimensional structures. ETL processes are the most complex tasks involved within the development of a Data Warehousing System, being crucial to model them previously so that, during the implementation stage, the correct set of requirements is considered. Coloured Petri Nets are a graphical modelling language used in the design, specification, simulation and validation of large systems, characterized as being strongly concurrent. The objective of this manuscript is to discuss the application of Coloured Petri Nets to the specification and validation of ETL systems. To demonstrate their viability for such tasks we have selected one of the most relevant and used case in ETL systems implementation: a surrogate key pipelining.
TypeConference paper
URIhttp://hdl.handle.net/1822/24025
ISBN9789077381731
Peer-Reviewedyes
AccessOpen access
Appears in Collections:CAlg - Artigos em livros de atas/Papers in proceedings

Files in This Item:
File Description SizeFormat 
2012-ESM-SIlvaEtAL-VF.pdfArtigo591,56 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