Integrating XML data in the TARGIT OLAP system

Abstract

For additional information, see the DB TECH REPORTS homepage: www.cs.auc.dk/DBTR . Any software made available via DB TECH REPORTS is provided "as is" and without any express or implied warranties, including, without limitation, the implied warranty of merchantability and fitness for a particular purpose.The DB TECH REPORTS icon is made from two letters in an early version of the Rune alphabet, which was used by the Vikings, among others. Runes have angular shapes and lack horizontal lines because the primary storage medium was wood, although they may also be found on jewelry, tools, and weapons. Runes were perceived as having magic, hidden powers. The first letter in the logo is "Dagaz," the rune for day or daylight and the phonetic equivalent of "d." Its meanings include happiness, activity, and satisfaction. The second letter is "Berkano," which is associated with the birch tree. Its divinatory meanings include health, new beginnings, growth, plenty, and clearance. It is associated with Idun, goddess of Spring, and with fertility. It is the phonetic equivalent of "b." Abstract This paper presents the results of industrial work on the logical integration of OLAP and 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 formalizes and extends the TARGIT data model and query language.

Cubing Algorithms for XML Data

“…Still in line with this main research direction, [22] studies the problem of enriching SQL XM by novel characteristics that allow us to achieve adaptive features during query and processing tasks over OLAP-XML federations, with the aim of making SQL XM robust with respect to changes that can occur in external XML data sources, and compliant with load balancing issues over external XML data sources. Furthermore, in [23] authors extend previous research results by devising an interesting case study focused on OLAP-XML federations in the context of the OLAP server platform TARGIT, and show how external Web-accessible XML data can be integrated within a real-life OLAP server platform thanks to ad-hoc constructs, data models and query languages. Finally, in [34] authors proposed a physical algebra able to make the OLAP-XML query engine more reliable and efficient over rapidly-changing XML data disseminated across the Web, such as stock quotations and performance economic indicators.…”

The Forgotten Document-Oriented Database Management Systems: An Overview and Benchmark of Native XML DODBMSes in Comparison with JSON DODBMSes

“…As future work, we plan to add support for OLAP queries [41] on XML data and XML data in combination with other data [42,43] both in terms of performance and functionality. This will involve designing new sampling strategies and supporting more aggregation queries [42]. The sampling methods will include constraints on other labels and values contained in the records.…”

High-level ETL for semantic data warehouses

“…Therefore, we plan to extend our framework from purely physical to also virtual data integration where instead of materializing all source data in the DW, ETL processes will run on demand. When considering virtual data integration, it is important to develop query optimization techniques for OLAP queries on virtual semantic DWs, similar to the ones developed for virtual integration of data cubes and XML data [54][55][56]. Another interesting work will be to apply this layer-based integration process in a Big Data and Data Lake environment.…”