Integrating XML data in the TARGIT OLAP system Online publication date: Sun, 17-Aug-2008
by Torben Bach Pedersen, Dennis Pedersen, Jesper Pedersen
International Journal of Web Engineering and Technology (IJWET), Vol. 4, No. 4, 2008
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.
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Web Engineering and Technology (IJWET):
Login with your Inderscience username and password:
Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.
If you still need assistance, please email subs@inderscience.com