Vista Equipo: Systematic review and comparison of modeling ETL processes in data warehouse

Systematic review and comparison of modeling ETL processes in data warehouse

Abstract: In a Data Warehouse (DW), ETL processes (Extraction, Transformation, Load) are responsible for extracting, transforming and loading data from the data sources into the DW. A good design of these processes in the early stages of a DW project is essential to avoid making bad decisions as a r...

Descripción completa

Autores Principales:	Muñoz, Lilia, Mazón, Jose Norberto, Trujillo, Juan
Formato:	Artículo
Idioma:	Inglés
Publicado:	2018
Materias:	Unified modeling language Data models Data warehouses Load modeling Data mining Libraries Silicon compounds
Acceso en línea:	https://ieeexplore.ieee.org/abstract/document/5556705/ http://ridda2.utp.ac.pa/handle/123456789/4920 http://ridda2.utp.ac.pa/handle/123456789/4920

id	RepoUTP4920
recordtype	dspace
spelling	RepoUTP49202021-07-06T15:35:09Z Systematic review and comparison of modeling ETL processes in data warehouse Muñoz, Lilia Mazón, Jose Norberto Trujillo, Juan Unified modeling language Data models Data warehouses Load modeling Data mining Libraries Silicon compounds Unified modeling language Data models Data warehouses Load modeling Data mining Libraries Silicon compounds Abstract: In a Data Warehouse (DW), ETL processes (Extraction, Transformation, Load) are responsible for extracting, transforming and loading data from the data sources into the DW. A good design of these processes in the early stages of a DW project is essential to avoid making bad decisions as a result of incorrect data. In this paper, we apply the method of systematic review to identify, extract and analyze the main proposals on modeling conceptual ETL processes for DWs. The main proposals are identified and compared based on the features, activities and notation of ETL processes. Finally we conclude the study by reflecting on the approaches being studied and providing an updated framework for future research. Abstract: In a Data Warehouse (DW), ETL processes (Extraction, Transformation, Load) are responsible for extracting, transforming and loading data from the data sources into the DW. A good design of these processes in the early stages of a DW project is essential to avoid making bad decisions as a result of incorrect data. In this paper, we apply the method of systematic review to identify, extract and analyze the main proposals on modeling conceptual ETL processes for DWs. The main proposals are identified and compared based on the features, activities and notation of ETL processes. Finally we conclude the study by reflecting on the approaches being studied and providing an updated framework for future research. 2018-06-14T14:09:57Z 2018-06-14T14:09:57Z 2018-06-14T14:09:57Z 2018-06-14T14:09:57Z 08/23/2010 08/23/2010 info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion https://ieeexplore.ieee.org/abstract/document/5556705/ 2166-0735 http://ridda2.utp.ac.pa/handle/123456789/4920 http://ridda2.utp.ac.pa/handle/123456789/4920 eng info:eu-repo/semantics/embargoedAccess application/pdf text/html
institution	Universidad Tecnológica de Panamá
collection	Repositorio UTP – Ridda2
language	Inglés
topic	Unified modeling language Data models Data warehouses Load modeling Data mining Libraries Silicon compounds Unified modeling language Data models Data warehouses Load modeling Data mining Libraries Silicon compounds
spellingShingle	Unified modeling language Data models Data warehouses Load modeling Data mining Libraries Silicon compounds Unified modeling language Data models Data warehouses Load modeling Data mining Libraries Silicon compounds Muñoz, Lilia Mazón, Jose Norberto Trujillo, Juan Systematic review and comparison of modeling ETL processes in data warehouse
description	Abstract: In a Data Warehouse (DW), ETL processes (Extraction, Transformation, Load) are responsible for extracting, transforming and loading data from the data sources into the DW. A good design of these processes in the early stages of a DW project is essential to avoid making bad decisions as a result of incorrect data. In this paper, we apply the method of systematic review to identify, extract and analyze the main proposals on modeling conceptual ETL processes for DWs. The main proposals are identified and compared based on the features, activities and notation of ETL processes. Finally we conclude the study by reflecting on the approaches being studied and providing an updated framework for future research.
format	Artículo
author	Muñoz, Lilia Mazón, Jose Norberto Trujillo, Juan
author_sort	Muñoz, Lilia
title	Systematic review and comparison of modeling ETL processes in data warehouse
title_short	Systematic review and comparison of modeling ETL processes in data warehouse
title_full	Systematic review and comparison of modeling ETL processes in data warehouse
title_fullStr	Systematic review and comparison of modeling ETL processes in data warehouse
title_full_unstemmed	Systematic review and comparison of modeling ETL processes in data warehouse
title_sort	systematic review and comparison of modeling etl processes in data warehouse
publishDate	2018
url	https://ieeexplore.ieee.org/abstract/document/5556705/ http://ridda2.utp.ac.pa/handle/123456789/4920 http://ridda2.utp.ac.pa/handle/123456789/4920
_version_	1796209855850086400
score	12.043282

Systematic review and comparison of modeling ETL processes in data warehouse

Ejemplares similares