Systematic review and comparison of modeling ETL processes in data warehouse

Simple item page
dc.contributor.authorMuñoz, Lilia
dc.contributor.authorMazón, Jose Norberto
dc.contributor.authorTrujillo, Juan
dc.date.accessioned2018-06-14T14:09:57Z
dc.date.accessioned2018-06-14T14:09:57Z
dc.date.available2018-06-14T14:09:57Z
dc.date.available2018-06-14T14:09:57Z
dc.date.issued08/23/2010
dc.date.issued08/23/2010
dc.descriptionAbstract: 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.en_US
dc.description.abstractAbstract: 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.en_US
dc.formatapplication/pdf
dc.formattext/html
dc.identifierhttps://ieeexplore.ieee.org/abstract/document/5556705/
dc.identifier.issn2166-0735
dc.identifier.urihttp://ridda2.utp.ac.pa/handle/123456789/4920
dc.identifier.urihttp://ridda2.utp.ac.pa/handle/123456789/4920
dc.languageeng
dc.rightsinfo:eu-repo/semantics/embargoedAccess
dc.subjectUnified modeling languageen_US
dc.subjectData modelsen_US
dc.subjectData warehousesen_US
dc.subjectLoad modelingen_US
dc.subjectData miningen_US
dc.subjectLibrariesen_US
dc.subjectSilicon compoundsen_US
dc.subjectUnified modeling language
dc.subjectData models
dc.subjectData warehouses
dc.subjectLoad modeling
dc.subjectData mining
dc.subjectLibraries
dc.subjectSilicon compounds
dc.titleSystematic review and comparison of modeling ETL processes in data warehouseen_US
dc.typeinfo:eu-repo/semantics/article
dc.typeinfo:eu-repo/semantics/publishedVersion

Files

License bundle

Now showing 1 - 1 of 1
Thumbnail Image
Name:
license.txt
Size:
1.71 KB
Format:
Item-specific license agreed upon to submission
Description:
Download

Collections

Facultad de Ingeniería de Sistemas Computacionales