Title: Integrating XML data in the TARGIT OLAP system

Authors: Torben Bach Pedersen, Dennis Pedersen, Jesper Pedersen

Addresses: Department of Computer Science, Aalborg University, Fr. Bajers Vej 7E, 9220 Aalborg O, Denmark. ' Systematic Software Engineering, Soren Frichs Vej 39, 8000 Arhus C, Denmark. ' TARGIT, Egholmvej 1, 9800 Hjorring, Denmark

Abstract: This paper presents the results of industrial work on the logical integration of Online Analytical Processing (OLAP) and eXtensible Markup Language (XML) data sources, carried out in cooperation between TARGIT, a Danish OLAP client vendor, and Aalborg University. A prototype has been developed that allows XML data stored outside the OLAP system to be used as dimensions and measures in the OLAP system in the same way as ordinary dimensions and measures. This provides a powerful and flexible way to handle unexpected or short-term data requirements as well as rapidly changing data. Compared to earlier work, this paper presents several major extensions that resulted from TARGIT|S requirements. These include the ability to use XML data as measures, as well as a novel multigranular data model and query language that formalises and extends the TARGIT data model and query language. Experiments indicate that our approach is often a feasible alternative to physical integration.

Keywords: online analytical processing; OLAP; eXtensible Markup Language; XML; data integration; database federations; Denmark; data modelling; query languages.

DOI: 10.1504/IJWET.2008.019945

International Journal of Web Engineering and Technology, 2008 Vol.4 No.4, pp.495 - 533

Published online: 17 Aug 2008 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article