A framework for supporting interoperability of data warehouse islands

Autoren Oscar Mangisengi
Johannes Huber
Christian Hawel
Wolfgang Essmayr
Titel A framework for supporting interoperability of data warehouse islands
Buchtitel Proc. 3rd Int. Conf. on Data Warehousing and Knowledge Discovery (DaWaK'01)
Typ in Konferenzband
Ort Munich, Germany
Abteilung IDM
Monat September
Jahr 2001
Seiten 328-338
SCCH ID# 117

Providing integrated access to multiple, heterogeneous, distributed, and autonomous data warehouses has become one of the leading issues in data warehouse research and industry. From a large data warehouse project we are conducting with the Upper-Austrian Health Insurance Organization we recognize the demand for making "islands" of data warehouse solutions interoperable to better support high-level strategic business applications. This paper presents a framework for providing interoperability of distributed, heterogeneous, and autonomous data warehouses based on a federated approach. We describe the main issues related to implementing such a federated data warehouse including the topics schema integration, query processing, data exchange, and mediation between the local and the federated data warehouse layers. We then focus on schema integration using XML, which offers significant benefits for interoperability, since it is a standardized, vendor and platform independent format for data and - in our case - metadata exchange.