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...
Guardado en:
Autores principales: | , , |
---|---|
Formato: | CONF |
Materias: | |
Acceso en línea: | http://hdl.handle.net/20.500.12110/paper_07695269_v_n_p220_Vaisman |
Aporte de: |
id |
todo:paper_07695269_v_n_p220_Vaisman |
---|---|
record_format |
dspace |
spelling |
todo:paper_07695269_v_n_p220_Vaisman2023-10-03T15:39:43Z Web-enabled temporal OLAP Vaisman, A.A. Izquierdo, A. Ktenas, M. 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. CONF info:eu-repo/semantics/openAccess http://creativecommons.org/licenses/by/2.5/ar 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 Vaisman, A.A. Izquierdo, A. Ktenas, M. 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. |
format |
CONF |
author |
Vaisman, A.A. Izquierdo, A. Ktenas, M. |
author_facet |
Vaisman, A.A. Izquierdo, A. Ktenas, M. |
author_sort |
Vaisman, A.A. |
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 |
url |
http://hdl.handle.net/20.500.12110/paper_07695269_v_n_p220_Vaisman |
work_keys_str_mv |
AT vaismanaa webenabledtemporalolap AT izquierdoa webenabledtemporalolap AT ktenasm webenabledtemporalolap |
_version_ |
1807320134669303808 |