Achieving Adaptivity For OLAP-XML Federations

Publikation: Bidrag til bog/antologi/rapport/konference proceedingKonferenceartikel i proceedingForskning

11 Citationer (Scopus)

Resumé

Motivated by the need for more flexible OLAP systems, this paper presents the results of 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 {\it 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.
OriginalsprogEngelsk
TitelProceedings of the ACM Fifth International Workshop on Data Warehousing and OLAP
ForlagAssociation for Computing Machinery
Publikationsdato2003
Sider25-32
StatusUdgivet - 2003
BegivenhedAchieving Adaptivity For OLAP-XML Federations -
Varighed: 19 maj 2010 → …

Konference

KonferenceAchieving Adaptivity For OLAP-XML Federations
Periode19/05/2010 → …

Bibliografisk note

ISSN ; -

Emneord

  • OLAP
  • database federations

Citer dette

Pedersen, D., & Pedersen, T. B. (2003). Achieving Adaptivity For OLAP-XML Federations. I Proceedings of the ACM Fifth International Workshop on Data Warehousing and OLAP (s. 25-32). Association for Computing Machinery.
Pedersen, D. ; Pedersen, Torben Bach. / Achieving Adaptivity For OLAP-XML Federations. Proceedings of the ACM Fifth International Workshop on Data Warehousing and OLAP. Association for Computing Machinery, 2003. s. 25-32
@inproceedings{9196caa0003b11dab4d5000ea68e967b,
title = "Achieving Adaptivity For OLAP-XML Federations",
abstract = "Motivated by the need for more flexible OLAP systems, this paper presents the results of 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 {\it 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.",
keywords = "OLAP, database federations, OLAP, database federations",
author = "D. Pedersen and Pedersen, {Torben Bach}",
note = "ISSN ; -",
year = "2003",
language = "English",
pages = "25--32",
booktitle = "Proceedings of the ACM Fifth International Workshop on Data Warehousing and OLAP",
publisher = "Association for Computing Machinery",
address = "United States",

}

Pedersen, D & Pedersen, TB 2003, Achieving Adaptivity For OLAP-XML Federations. i Proceedings of the ACM Fifth International Workshop on Data Warehousing and OLAP. Association for Computing Machinery, s. 25-32, Achieving Adaptivity For OLAP-XML Federations, 19/05/2010.

Achieving Adaptivity For OLAP-XML Federations. / Pedersen, D.; Pedersen, Torben Bach.

Proceedings of the ACM Fifth International Workshop on Data Warehousing and OLAP. Association for Computing Machinery, 2003. s. 25-32.

Publikation: Bidrag til bog/antologi/rapport/konference proceedingKonferenceartikel i proceedingForskning

TY - GEN

T1 - Achieving Adaptivity For OLAP-XML Federations

AU - Pedersen, D.

AU - Pedersen, Torben Bach

N1 - ISSN ; -

PY - 2003

Y1 - 2003

N2 - Motivated by the need for more flexible OLAP systems, this paper presents the results of 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 {\it 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.

AB - Motivated by the need for more flexible OLAP systems, this paper presents the results of 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 {\it 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.

KW - OLAP

KW - database federations

KW - OLAP

KW - database federations

M3 - Article in proceeding

SP - 25

EP - 32

BT - Proceedings of the ACM Fifth International Workshop on Data Warehousing and OLAP

PB - Association for Computing Machinery

ER -

Pedersen D, Pedersen TB. Achieving Adaptivity For OLAP-XML Federations. I Proceedings of the ACM Fifth International Workshop on Data Warehousing and OLAP. Association for Computing Machinery. 2003. s. 25-32