Colored Petri nets in the simulation of ETL standard tasks: the surrogate key pipelining case

Bibliographic Details
Main Author: Silva, Diogo
Publication Date: 2012
Other Authors: Belo, Orlando, Fernandes, João M.
Language: eng
Source: Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
Download full: http://hdl.handle.net/1822/24025
Summary: 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.
id RCAP_e5bcb8036a8558456daa5d1bd5289d84
oai_identifier_str oai:repositorium.sdum.uminho.pt:1822/24025
network_acronym_str RCAP
network_name_str Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
repository_id_str https://opendoar.ac.uk/repository/7160
spelling Colored Petri nets in the simulation of ETL standard tasks: the surrogate key pipelining caseData WarehousingETL SystemsColoured Petri NetsSimulation and Evaluation of ETL ProcessesStandard ETL TasksSurrogate Key PipeliningScience & TechnologyETL (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.EUROSIS-ETIUniversidade do MinhoSilva, DiogoBelo, OrlandoFernandes, João M.2012-102012-10-01T00:00:00Zconference paperinfo:eu-repo/semantics/publishedVersionapplication/pdfhttp://hdl.handle.net/1822/24025eng9789077381731info:eu-repo/semantics/openAccessreponame:Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)instname:FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologiainstacron:RCAAP2024-05-11T06:28:31Zoai:repositorium.sdum.uminho.pt:1822/24025Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireinfo@rcaap.ptopendoar:https://opendoar.ac.uk/repository/71602025-05-28T15:54:18.436008Repositórios Científicos de Acesso Aberto de Portugal (RCAAP) - FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologiafalse
dc.title.none.fl_str_mv Colored Petri nets in the simulation of ETL standard tasks: the surrogate key pipelining case
title Colored Petri nets in the simulation of ETL standard tasks: the surrogate key pipelining case
spellingShingle Colored Petri nets in the simulation of ETL standard tasks: the surrogate key pipelining case
Silva, Diogo
Data Warehousing
ETL Systems
Coloured Petri Nets
Simulation and Evaluation of ETL Processes
Standard ETL Tasks
Surrogate Key Pipelining
Science & Technology
title_short Colored Petri nets in the simulation of ETL standard tasks: the surrogate key pipelining case
title_full Colored Petri nets in the simulation of ETL standard tasks: the surrogate key pipelining case
title_fullStr Colored Petri nets in the simulation of ETL standard tasks: the surrogate key pipelining case
title_full_unstemmed Colored Petri nets in the simulation of ETL standard tasks: the surrogate key pipelining case
title_sort Colored Petri nets in the simulation of ETL standard tasks: the surrogate key pipelining case
author Silva, Diogo
author_facet Silva, Diogo
Belo, Orlando
Fernandes, João M.
author_role author
author2 Belo, Orlando
Fernandes, João M.
author2_role author
author
dc.contributor.none.fl_str_mv Universidade do Minho
dc.contributor.author.fl_str_mv Silva, Diogo
Belo, Orlando
Fernandes, João M.
dc.subject.por.fl_str_mv Data Warehousing
ETL Systems
Coloured Petri Nets
Simulation and Evaluation of ETL Processes
Standard ETL Tasks
Surrogate Key Pipelining
Science & Technology
topic Data Warehousing
ETL Systems
Coloured Petri Nets
Simulation and Evaluation of ETL Processes
Standard ETL Tasks
Surrogate Key Pipelining
Science & Technology
description 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.
publishDate 2012
dc.date.none.fl_str_mv 2012-10
2012-10-01T00:00:00Z
dc.type.driver.fl_str_mv conference paper
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
status_str publishedVersion
dc.identifier.uri.fl_str_mv http://hdl.handle.net/1822/24025
url http://hdl.handle.net/1822/24025
dc.language.iso.fl_str_mv eng
language eng
dc.relation.none.fl_str_mv 9789077381731
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.publisher.none.fl_str_mv EUROSIS-ETI
publisher.none.fl_str_mv EUROSIS-ETI
dc.source.none.fl_str_mv reponame:Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
instname:FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologia
instacron:RCAAP
instname_str FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologia
instacron_str RCAAP
institution RCAAP
reponame_str Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
collection Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
repository.name.fl_str_mv Repositórios Científicos de Acesso Aberto de Portugal (RCAAP) - FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologia
repository.mail.fl_str_mv info@rcaap.pt
_version_ 1833595615228985344

Similar Items