Modelling of Data Extraction in ETL Processes Using UML 2.0

  • M. Mrunalini
  • T.V. Suresh Kumar
  • D. Evangelin Geetha
Keywords: Extraction transformation loading (ETL), Data extraction, Distributed systems, Heterogeneous data, UML, Banking system

Abstract

The topic of data warehousing encompasses architectures, algorithms, and tools for bringing together the selected data from multiple databases or other information sources into a single repository called data warehouse. Extraction-transformationloading tools are pieces of software responsible for the extraction of data from several sources, their cleaning, customisation, and insertion into a data warehouse. The paper proposes an object-oriented approach to accomplish the data extraction modelling of extraction-transformation-loading process. The data extraction scenario consists of data staging area, heterogeneous information sources, wrappers, monitors, integrator, and source identifier. All the afore mentioned entities have been modelled using Unified Modelling Language 2.0. Banking system has been used as an application to illustrate the modelling.

http://dx.doi.org/10.14429/dbit.26.5.3690

 

Published
2006-09-01
How to Cite
Mrunalini, M., Suresh Kumar, T., & Evangelin Geetha, D. (2006). Modelling of Data Extraction in ETL Processes Using UML 2.0. DESIDOC Journal of Library & Information Technology, 26(5). https://doi.org/10.14429/djlit.26.5.3690
Section
Papers