Supporting the ETL-process by Web Service technologies

  • Authors:
  • Lutz Schlesinger;Florian Irmert;Wolfgang Lehner

  • Affiliations:
  • Department of Database Systems, University of Erlangen-Nuremberg, 3 Martens str., 91058 Erlangen, Germany.;Department of Database Systems, University of Erlangen-Nuremberg, 3 Martens str., 91058 Erlangen, Germany.;Database Technology Group, Dresden University of Technology, 26 Durerstr., 01062 Dresden, Germany

  • Venue:
  • International Journal of Web and Grid Services
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

Extracting data from heterogeneous data sources and transferring data into the data warehouse system is one of the most cost intensive tasks in setting up and operating a data warehouse. Special tools may be used to connect different sources and target systems. In this paper, we propose an architecture which enables the flexible integration of data sources into any target database system. The approach is based on the idea of splitting the classical wrapping module into a source specific and a target specific part and establishing the communication between these components based on Web Service technology. We describe the general architecture, the use of Web Service technology to describe and dynamically integrate participating data sources and the deployment within a specific database system.