Quality measures for ETL processes: from goals to implementation

Extraction transformation loading (ETL) processes play an increasingly important role for the support of modern business operations. These business processes are centred around artifacts with high variability and diverse lifecycles, which correspond to key business entities. The apparent complexity...

ver descrição completa

Detalhes bibliográficos
Autores: Theodorou, Vasileios, Abelló Gamazo, Alberto|||0000-0002-3223-2186, Lehner, Wolfgang, Thiele, Maik
Tipo de documento: artigo
Data de publicação:2016
País:España
Recursos:Universitat Politècnica de Catalunya (UPC)
Repositório:UPCommons. Portal del coneixement obert de la UPC
Idioma:inglês
OAI Identifier:oai:upcommons.upc.edu:2117/100626
Acesso em linha:https://hdl.handle.net/2117/100626
https://dx.doi.org/10.1002/cpe.3729
Access Level:Acceso aberto
Palavra-chave:Business -- Data processing
Business intelligence
ETL
Business process
Quality measures
Goal modeling
Negocis -- Informàtica
Intel·ligència competitiva
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
id ES_b2ee670d6fbb64360bcedc92f867576c
oai_identifier_str oai:upcommons.upc.edu:2117/100626
network_acronym_str ES
network_name_str España
repository_id_str
spelling Quality measures for ETL processes: from goals to implementationTheodorou, VasileiosAbelló Gamazo, Alberto|||0000-0002-3223-2186Lehner, WolfgangThiele, MaikBusiness -- Data processingBusiness intelligenceETLBusiness processQuality measuresGoal modelingNegocis -- InformàticaIntel·ligència competitivaÀrees temàtiques de la UPC::Informàtica::Sistemes d'informacióExtraction transformation loading (ETL) processes play an increasingly important role for the support of modern business operations. These business processes are centred around artifacts with high variability and diverse lifecycles, which correspond to key business entities. The apparent complexity of these activities has been examined through the prism of business process management, mainly focusing on functional requirements and performance optimization. However, the quality dimension has not yet been thoroughly investigated, and there is a need for a more human-centric approach to bring them closer to business-users requirements. In this paper, we take a first step towards this direction by defining a sound model for ETL process quality characteristics and quantitative measures for each characteristic, based on existing literature. Our model shows dependencies among quality characteristics and can provide the basis for subsequent analysis using goal modeling techniques. We showcase the use of goal modeling for ETL process design through a use case, where we employ the use of a goal model that includes quantitative components (i.e., indicators) for evaluation and analysis of alternative design decisions.Peer Reviewed20162016-10-0120172017-02-07journal articlehttp://purl.org/coar/resource_type/c_6501AMhttp://purl.org/coar/version/c_ab4af688f83e57aainfo:eu-repo/semantics/articleapplication/pdfhttps://hdl.handle.net/2117/100626https://dx.doi.org/10.1002/cpe.3729reponame:UPCommons. Portal del coneixement obert de la UPCinstname:Universitat Politècnica de Catalunya (UPC)Inglésengopen accesshttp://purl.org/coar/access_right/c_abf2info:eu-repo/semantics/openAccessoai:upcommons.upc.edu:2117/1006262026-05-27T15:37:01Z
dc.title.none.fl_str_mv Quality measures for ETL processes: from goals to implementation
title Quality measures for ETL processes: from goals to implementation
spellingShingle Quality measures for ETL processes: from goals to implementation
Theodorou, Vasileios
Business -- Data processing
Business intelligence
ETL
Business process
Quality measures
Goal modeling
Negocis -- Informàtica
Intel·ligència competitiva
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
title_short Quality measures for ETL processes: from goals to implementation
title_full Quality measures for ETL processes: from goals to implementation
title_fullStr Quality measures for ETL processes: from goals to implementation
title_full_unstemmed Quality measures for ETL processes: from goals to implementation
title_sort Quality measures for ETL processes: from goals to implementation
dc.creator.none.fl_str_mv Theodorou, Vasileios
Abelló Gamazo, Alberto|||0000-0002-3223-2186
Lehner, Wolfgang
Thiele, Maik
author Theodorou, Vasileios
author_facet Theodorou, Vasileios
Abelló Gamazo, Alberto|||0000-0002-3223-2186
Lehner, Wolfgang
Thiele, Maik
author_role author
author2 Abelló Gamazo, Alberto|||0000-0002-3223-2186
Lehner, Wolfgang
Thiele, Maik
author2_role author
author
author
dc.subject.none.fl_str_mv Business -- Data processing
Business intelligence
ETL
Business process
Quality measures
Goal modeling
Negocis -- Informàtica
Intel·ligència competitiva
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
topic Business -- Data processing
Business intelligence
ETL
Business process
Quality measures
Goal modeling
Negocis -- Informàtica
Intel·ligència competitiva
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
description Extraction transformation loading (ETL) processes play an increasingly important role for the support of modern business operations. These business processes are centred around artifacts with high variability and diverse lifecycles, which correspond to key business entities. The apparent complexity of these activities has been examined through the prism of business process management, mainly focusing on functional requirements and performance optimization. However, the quality dimension has not yet been thoroughly investigated, and there is a need for a more human-centric approach to bring them closer to business-users requirements. In this paper, we take a first step towards this direction by defining a sound model for ETL process quality characteristics and quantitative measures for each characteristic, based on existing literature. Our model shows dependencies among quality characteristics and can provide the basis for subsequent analysis using goal modeling techniques. We showcase the use of goal modeling for ETL process design through a use case, where we employ the use of a goal model that includes quantitative components (i.e., indicators) for evaluation and analysis of alternative design decisions.
publishDate 2016
dc.date.none.fl_str_mv 2016
2016-10-01
2017
2017-02-07
dc.type.none.fl_str_mv journal article
http://purl.org/coar/resource_type/c_6501
AM
http://purl.org/coar/version/c_ab4af688f83e57aa
dc.type.openaire.fl_str_mv info:eu-repo/semantics/article
format article
dc.identifier.none.fl_str_mv https://hdl.handle.net/2117/100626
https://dx.doi.org/10.1002/cpe.3729
url https://hdl.handle.net/2117/100626
https://dx.doi.org/10.1002/cpe.3729
dc.language.none.fl_str_mv Inglés
eng
language_invalid_str_mv Inglés
language eng
dc.rights.none.fl_str_mv open access
http://purl.org/coar/access_right/c_abf2
dc.rights.openaire.fl_str_mv info:eu-repo/semantics/openAccess
rights_invalid_str_mv open access
http://purl.org/coar/access_right/c_abf2
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.source.none.fl_str_mv reponame:UPCommons. Portal del coneixement obert de la UPC
instname:Universitat Politècnica de Catalunya (UPC)
instname_str Universitat Politècnica de Catalunya (UPC)
reponame_str UPCommons. Portal del coneixement obert de la UPC
collection UPCommons. Portal del coneixement obert de la UPC
repository.name.fl_str_mv
repository.mail.fl_str_mv
_version_ 1869417096078688257
score 15,300719

Registros relacionados