How foreign function integration conquers heterogeneous query processing
Proceedings of the tenth international conference on Information and knowledge management
EDBT '02 Proceedings of the 8th International Conference on Extending Database Technology: Advances in Database Technology
Using flows in information integration
IBM Systems Journal
Hi-index | 0.00 |
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 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.