A middleware approach for combining heterogeneous data sources integration of generic query and predefined function access

With the emergence of so-called application systems which encapsulate databases and their applications, 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. The authors focus on 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). Afterwards, we concentrate on the key problems of function integration by discussing query execution planning, precedence control of function execution, and parameter handling. In this context, we develop a lightweight description language based on XML for the global-to-local mapping of functions. In addition, we consider some important aspects of the execution model, focusing on the interaction of the FDBS and the WfMS as well as the support of distributed transactions