Interactive example-driven integration and reconciliation for accessing database federations

  • Authors:
  • Kai-Uwe Sattler;Stefan Conrad;Gunter Saake

  • Affiliations:
  • University of Magdeburg, Department of Computer Science, P.O. Box 4120, D-39016 Magdeburg, Germany;University of Munich, Department of Computer Science, Oettingenstr. 67, D-80538 München, Germany;University of Magdeburg, Department of Computer Science, P.O. Box 4120, D-39016 Magdeburg, Germany

  • Venue:
  • Information Systems
  • Year:
  • 2003

Quantified Score

Hi-index 0.01

Visualization

Abstract

The integration of heterogeneous databases affects two main problems: schema integration and instance integration. At both levels a mapping from local elements to global elements is specified and various conflicts caused by the heterogeneity of the sources have to be resolved. For the detection and resolution of instance-level conflicts we propose an interactive, example-driven approach The basic idea is to combine an interactive query tool similar to query-by-example with facilities for defining and applying integration operations. This integration approach is supported by a multidatabase query language, which provides special mechanisms for conflict resolution. The foundations of these mechanisms are introduced and their usage in instance integration and reconciliation is presented. In addition, we discuss basic techniques for supporting the detection of instance-level conflicts.