Achieving Adaptivity for OLAP-XML Federations

Motivated by the need for more flexible OLAP systems, this pa-per presents work on logical integration of external data in OLAP databases, carried out in cooperation between the Danish OLAP client vendor TARGIT and Aalborg University. Flexibility is en-sured by supporting XML as the external data format, since almost all data sources can be efficiently wrapped in XML. Earlier work has resulted in an extension of the TARGIT system, allowing ex-ternal XML data to be used as dimensions and measures in OLAP databases. This work has led to a number of new ideas for improv-ing the system’s ability to adapt to changes in its surroundings. This paper describes the potential problems that may interrupt the operation of the integration system, in particular those caused by the often autonomous and unreliable nature of external XML data sources, and methods for handling these problems. Specifi-cally, we describe techniques for handling changes in external XML data sources. We also describe techniques for improving the relia-bility of external XML sources, e.g., when these are found on the Internet, by dynamically trying to locate alternative sources during the evaluation of a query. Finally, we discuss solutions to a num-ber of other possible problems, and show how the techniques can be integrated in the TARGIT architecture. Experiments performed with a prototype implementation of central functionality shows the viability of the proposed solutions