Methodology and Case Tools for the Development of Federated Databases

Abstract

Due to the current technological and economical context, there is an increasing need for cooperating information systems based on federated databases. Though the technical issues of these architectures have been studied for long, the way to build them has not triggered as much effort. This paper describes a general architecture, a methodology and a CASE environment intended to address the problem of providing users and programmers with an abstract interface to independent heterogeneous and distributed databases. The architecture comprises a hierarchy of mediators and a repository that dynamically transform actual data into a virtual homogeneous database and allow client applications to query it. The InterDB approach provides a complete methodology to define this architecture, including schema recovery through reverse engineering, database integration and mapping building. The methodology is supported by the DB-MAIN CASE tool that helps developers generate the mediators and their repository.

Interactive example-driven integration and reconciliation for accessing database federations

“…[49][50][51]. However, these mainly address schema integration and the resolution of schema-level conflicts.…”

Research in database engineering at the University of Namur

“…We have proposed a new scheme of sharing responsibilities such that wrappers assume a greater part of the federation mapping in order to alleviate the tasks of the mediators. A methodology that combines reverse and forward approaches has been developed to specify and automatically build the components of a federation while taking into account the current requirements of the organization [13,21] …”