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

K. Hergula, T. Harder
Proceedings of the First International Conference on Web Information Systems Engineering  
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. In this paper, we focus on a middleware approach supporting
more » ... 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.
doi:10.1109/wise.2000.882371 dblp:conf/wise/HergulaH00 fatcat:s3oqe3bvw5eq3gu7qf4urczvce