Powered by OpenAIRE graph
Found an issue? Give us feedback
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/ UPCommons. Portal de...arrow_drop_down
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
versions View all 3 versions
addClaim

ETL Testing Analyzer

Authors: Murar, Claudiu-Ionut;

ETL Testing Analyzer

Abstract

ETL testing techniques are nowadays widely used into the data integration process. These techniques refer to the ability of being able to check whether the information that is loaded into the data warehouse has correctly followed all the transformations steps. Due to the errors that might occur during the extraction, transformation and load stages, there is a need to monitor and handle the errors that can cause severe data quality issues into the data warehouse. This thesis paper is based on the information gathered from a previous project that was performed at UPC. The main goal of this project was to help the professors from UPC who are teaching the ¿Database¿ course, to better analyze the performance of the students. Therefore, an ETL system was implemented with the goal of extracting student information from multiple sources, transform and load it into the data warehouse. This information can refer to the student¿s personal data, the exercises they are performing, etc. The initial ETL design was based on the creation of the data warehouse schema containing the main dimensions and fact tables. The main issue is that it did not present any monitoring and error handling functionalities, even though the system was generating several errors every time the ETL was executed. The steps I have followed while working on this thesis project have been to model the initial ETL process using a BPMN representation, include error handling and monitoring functionalities and ultimately redesign the initial ETL processes using a chosen tool. Although the initial processes were modelled using Pentaho Kettle, due to the new requirements regarding the error handling and monitoring capabilities I had to perform a comprehensive ETL tool comparison to check what is the tool that can better answer the requirements of this project.

Country
Spain
Keywords

ETL, Conceptualization, Database management, Test, Analyzer, Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació::Bases de dades, :Informàtica::Sistemes d'informació::Bases de dades [Àrees temàtiques de la UPC], Bases de dades -- Gestió, Gestor de dades, Data warehousing

  • BIP!
    Impact byBIP!
    selected citations
    These citations are derived from selected sources.
    This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    0
    popularity
    This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
    Average
    influence
    This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    Average
    impulse
    This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
    Average
    OpenAIRE UsageCounts
    Usage byUsageCounts
    visibility views 75
    download downloads 128
  • 75
    views
    128
    downloads
    Powered byOpenAIRE UsageCounts
Powered by OpenAIRE graph
Found an issue? Give us feedback
visibility
download
selected citations
These citations are derived from selected sources.
This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Citations provided by BIP!
popularity
This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
views
OpenAIRE UsageCountsViews provided by UsageCounts
downloads
OpenAIRE UsageCountsDownloads provided by UsageCounts
0
Average
Average
Average
75
128
Green