Web-enabled temporal OLAP

Commercial OLAP systems usually consider OLAP dimensions as static entities. In practice, dimension updates are often necessary in order to adapt the multidimensional database to changing requirements. Query languages are then needed to retrieve historical information from a data warehouse. Although...

Descripción completa

Guardado en:
Detalles Bibliográficos
Publicado: 2006
Materias:
Data warehousing
OLAP
Temporal databases
Temporal OLAP
Data structures
Data warehouses
Query processing
Software engineering
XML
Web services
Acceso en línea:https://bibliotecadigital.exactas.uba.ar/collection/paper/document/paper_07695269_v_n_p220_Vaisman
http://hdl.handle.net/20.500.12110/paper_07695269_v_n_p220_Vaisman
Aporte de:
Biblioteca Digital - Facultad de Ciencias Exactas y Naturales (UBA) de Universidad de Buenos Aires
id paper:paper_07695269_v_n_p220_Vaisman
record_format dspace
spelling paper:paper_07695269_v_n_p220_Vaisman2023-06-08T15:45:47Z Web-enabled temporal OLAP Data warehousing OLAP Temporal databases Temporal OLAP Data structures Data warehouses Query processing Software engineering XML OLAP Temporal databases Temporal OLAP Web services Commercial OLAP systems usually consider OLAP dimensions as static entities. In practice, dimension updates are often necessary in order to adapt the multidimensional database to changing requirements. Query languages are then needed to retrieve historical information from a data warehouse. Although many proposals addressing temporal OLAP exist, no one supports full operation over the World Wide Web. After introducing a temporal data model supporting historical dimensions and fact table versioning, we present a three-tier architecture based on Web services, SOAP and XML, allowing efficient querying over the Web. In this architecture, XML metadata is stored at the application server in the form of XML documents containing the data warehouse structure. This allows addressing most of the requests (navigation through time, updates, and queries) without accessing the data warehouse. We present our implementation, and also discuss query processing issues, like answering historical queries using materialized views. © 2006 IEEE. 2006 https://bibliotecadigital.exactas.uba.ar/collection/paper/document/paper_07695269_v_n_p220_Vaisman http://hdl.handle.net/20.500.12110/paper_07695269_v_n_p220_Vaisman
institution Universidad de Buenos Aires
institution_str I-28
repository_str R-134
collection Biblioteca Digital - Facultad de Ciencias Exactas y Naturales (UBA)
topic Data warehousing
OLAP
Temporal databases
Temporal OLAP
Data structures
Data warehouses
Query processing
Software engineering
XML
OLAP
Temporal databases
Temporal OLAP
Web services
spellingShingle Data warehousing
OLAP
Temporal databases
Temporal OLAP
Data structures
Data warehouses
Query processing
Software engineering
XML
OLAP
Temporal databases
Temporal OLAP
Web services
Web-enabled temporal OLAP
topic_facet Data warehousing
OLAP
Temporal databases
Temporal OLAP
Data structures
Data warehouses
Query processing
Software engineering
XML
OLAP
Temporal databases
Temporal OLAP
Web services
description Commercial OLAP systems usually consider OLAP dimensions as static entities. In practice, dimension updates are often necessary in order to adapt the multidimensional database to changing requirements. Query languages are then needed to retrieve historical information from a data warehouse. Although many proposals addressing temporal OLAP exist, no one supports full operation over the World Wide Web. After introducing a temporal data model supporting historical dimensions and fact table versioning, we present a three-tier architecture based on Web services, SOAP and XML, allowing efficient querying over the Web. In this architecture, XML metadata is stored at the application server in the form of XML documents containing the data warehouse structure. This allows addressing most of the requests (navigation through time, updates, and queries) without accessing the data warehouse. We present our implementation, and also discuss query processing issues, like answering historical queries using materialized views. © 2006 IEEE.
title Web-enabled temporal OLAP
title_short Web-enabled temporal OLAP
title_full Web-enabled temporal OLAP
title_fullStr Web-enabled temporal OLAP
title_full_unstemmed Web-enabled temporal OLAP
title_sort web-enabled temporal olap
publishDate 2006
url https://bibliotecadigital.exactas.uba.ar/collection/paper/document/paper_07695269_v_n_p220_Vaisman
http://hdl.handle.net/20.500.12110/paper_07695269_v_n_p220_Vaisman
_version_ 1768546589150806016

Ejemplares similares