A multi-agent approach for the extract-transform-load process support in data warehouses

  • Daniel Betancur-Calderón Universidad Nacional de Colombia, Medellín
  • Julián Moreno-Cadavid Universidad Nacional de Colombia, Medellín
Keywords: ETL, data warehouses, multi-agent systems, automation, heterogeneity, availability.

Abstract

In order to provide an adequate solution in terms of robustness and automation in the process of Extract-Transform-Load (ETL) in data warehouses, in this article a multi-agent model that gathers the strengths of other approaches like wrappers and ad-hoc solutions is presented. Such a model considers the heterogeneity and availability of the data sources as well as their distributed nature. For its validation an experiment was performed using simulated and real data, which demonstrated not only its technical feasibility but also its effectiveness in terms of the percentage of processed data and the time to accomplish it.

Author Biographies

Daniel Betancur-Calderón, Universidad Nacional de Colombia, Medellín
Escuela de Sistemas, Facultad de Minas,
Universidad Nacional de Colombia, Medellín
Julián Moreno-Cadavid, Universidad Nacional de Colombia, Medellín
Escuela de Sistemas, Facultad de Minas,
Universidad Nacional de Colombia, Medellín
How to Cite
Betancur-Calderón, D., & Moreno-Cadavid, J. (2012). A multi-agent approach for the extract-transform-load process support in data warehouses. TecnoLógicas, (28), 89-107. https://doi.org/10.22430/22565337.15

Downloads

Download data is not yet available.
Published
2012-06-25
Section
Research Papers

Most read articles by the same author(s)