E-ETL: Framework for Managing Evolving ETL Workflows release_fswtj3wbl5ckra4446ulbo5afm

by Artur Wojciechowski

Published in Foundations of Computing and Decision Sciences by Walter de Gruyter GmbH.

2013   Volume 38, p131-142

Abstract

<jats:title>Abstract</jats:title> Data warehouses integrate external data sources (EDSs), which very often change their data structures (schemas). In many cases, such changes cause an erroneous execution of an already deployed ETL workow. Structural changes of EDSs are frequent, therefore an automatic reparation of an ETL workow, after such changes, is of a high importance. This paper presents a framework, called E-ETL, for handling the evolution of an ETL layer. Detection of changes in EDSs causes a repa- ration of the fragment of ETL workow which interacts with the changed EDSs. The proposed framework was developed as a module external to a standard commercial or open-source ETL engine, accessing the engine by means of API. The innovation of this framework consists in: (1) the algorithms for semi-automatic reparation of an ETL workow and (2) its ability to interact with various ETL engines that provide API.
In application/xml+jats format

Archived Files and Locations

application/pdf  701.1 kB
file_5hvs5g6majehhiglaa6uuqdq64
web.archive.org (webarchive)
content.sciendo.com (web)
Read Archived PDF
Preserved and Accessible
Type  article-journal
Stage   published
Date   2013-06-01
Container Metadata
Open Access Publication
In DOAJ
In ISSN ROAD
In Keepers Registry
ISSN-L:  0867-6356
Work Entity
access all versions, variants, and formats of this works (eg, pre-prints)
Catalog Record
Revision: b0e8d14c-6799-4217-80bd-259a276a8959
API URL: JSON