XML-extended OLAP querying

Pedersen, Dennis; Riis, Karsten; Pedersen, Torben Bach

doi:10.1109/ssdm.2002.1029721

Cited by 45 publications

(64 citation statements)

References 9 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…To copy otherwise, to republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. DOLAP'03, November 7, 2003 cooperation between TARGIT, a Danish OLAP client vendor [11], and Aalborg University, and is based on previous results [7,9]. TARGIT's practical experience with the OLAP industry and our experience with a prototype extension to TARGIT's client tool [7], has raised a number of new research issues on the adaptivity of OLAP-XML integration systems, which are also interesting in a broader context.…”

Section: Introductionmentioning

confidence: 99%

“…We have previously presented a federated database system that allows data outside the OLAP database to be used as logical dimensions or measures in a cube [7,9]. Since almost any kind of external data can be efficiently transformed to XML [14], including data from relational, object-oriented, and multidimensional DBMSs, XML was chosen as the external data format, thereby ensuring flexibility.…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Achieving adaptivity for OLAP-XML federations

Pedersen¹,

Pedersen

2003

Proceedings of the 6th ACM International Workshop on Data Warehousing and OLAP - DOLAP '03

View full text Add to dashboard Cite

Motivated by the need for more flexible OLAP systems, this paper 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 ensured 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 external XML data to be used as dimensions and measures in OLAP databases. This work has led to a number of new ideas for improving 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. Specifically, we describe techniques for handling changes in external XML data sources. We also describe techniques for improving the reliability 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 number 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.

show abstract

Section: Introductionmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Achieving adaptivity for OLAP-XML federations

Pedersen¹,

Pedersen

2003

Proceedings of the 6th ACM International Workshop on Data Warehousing and OLAP - DOLAP '03

View full text Add to dashboard Cite

show abstract

“…This can be based on semi-automatic, interactive tools for describing multiple data marts, for determining and verifying correspondences among their schemes and data, as well as for defining and verifying mappings among them. For instance, borrowing some ideas from [12,13], "integration links" can be used to relate data in different data marts.…”

Section: Resultsmentioning

confidence: 99%

“…Although our notion of compatibility is related to these kinds of relationships, the goals of the papers differ, since we refer to drill-across queries whereas [1] refers a weaker form of drill acrossing, specific to interactive navigation. Some work has been done on the problem of integrating data marts with external data stored in various formats: object-oriented [13] and XML [12]. This is clearly related to but different from our goal, since no attempt is made to combine multiple multidimensional databases.…”

Section: Introductionmentioning

confidence: 96%

See 1 more Smart Citation

On the integration of autonomous data marts

Cabibbo¹,

Torlone²

Proceedings. 16th International Conference on Scientific and Statistical Database Management, 2004.

View full text Add to dashboard Cite

show abstract

A relational–XML data warehouse for data aggregation with SQL and XQuery

2008

View full text Add to dashboard Cite

Integrating information from multiple data sources is becoming increasingly important for enterprises that partner with other companies for e‐commerce. However, companies have their internal business applications deployed on diverse platforms and no standard solution for integrating information from these sources exists. To support business intelligence query activities, it is useful to build a data warehouse on top of middleware that aggregates the data obtained from various heterogeneous database systems. Online analytical processing (OLAP) can then be used to provide fast access to materialized views from the data warehouse. Since extensible markup language (XML) documents are a common data representation standard on the Internet and relational tables are commonly used for production data, OLAP must handle both relational and XML data. SQL and XQuery can be used to process the materialized relational and XML data cubes created from the aggregated data. This paper shows how to handle the two kinds of data cubes from a relational–XML data warehouse using extract, transformation and loading. Copyright © 2008 John Wiley & Sons, Ltd.

show abstract

XML-extended OLAP querying

Cited by 45 publications

References 9 publications

Achieving adaptivity for OLAP-XML federations

Achieving adaptivity for OLAP-XML federations

On the integration of autonomous data marts

A relational–XML data warehouse for data aggregation with SQL and XQuery

Contact Info

Product

Resources

About