Lehrgebiet Informationssysteme

FB Informatik

LG IS

AG DBIS

(C) AG DBIS

Supporting Query Processing Across Application Systems - Aspects of Wrapper-Based Foreign Function Integration

Klaudia Hergula, Gunnar Beck, Theo Härder

Database and Information Systems Group,
University of Kaiserslautern
P.O. Box 3049,
D-67653 Kaiserslautern

Full paper ( PDF version )

Abstract

With the emergence of so-called application systems which encapsulate databases and related application components, pure data integration using, for example, a federated database system is not possible anymore. Instead, access via predefined functions is the only way to get data from an application system. As a result, the combination of generic query as well as predefined function access is needed in order to integrate heterogeneous data sources. In this paper, we present a middleware approach supporting this novel and extended kind of integration. Starting with the overall architecture, we explain the functionality and cooperation of its core components: a federated database system (FDBS) and a workflow management system (WfMS) connected via a wrapper. Afterwards, we concentrate on essential aspects of query processing across these heterogeneous components. Motivated by optimization demands for such query processing, we describe the native functionality provided by the WfMS. Moreover, we discuss how this functionality can be extended within the wrapper in order to obtain salient features for query optimization.

in: Proc. 3rd Int. Conf. on Enterprise Information Systems (ICEIS 2001), Setubal, Portugal, July 2001