A web-based architecture for 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
Autores principales:	Vaisman, A.A., Izquierdo, A., Ktenas, M.
Formato:	JOUR
Materias:	Dimension updates Temporal databases Temporal OLAP TOLAP Web services Administrative data processing Computer programming languages Data processing Data structures Data warehouses Database systems Information management Information services Information theory Internet Linguistics Markup languages Metadata Warehouses World Wide Web XML Application servers Case studies Data warehouse structure Historical databases Historical information Multidimensional databases OLAP queries OLAP systems Query optimisation Query performances Real-world System implementation Temporal Data Temporal queries Three-tier architecture Versioning Web environment Web-based architecture XML documents XML metadata Query languages
Acceso en línea:	http://hdl.handle.net/20.500.12110/paper_14761289_v4_n4_p465_Vaisman
Aporte de:	Biblioteca Digital - Facultad de Ciencias Exactas y Naturales (UBA) de Universidad de Buenos Aires

id	todo:paper_14761289_v4_n4_p465_Vaisman
record_format	dspace
spelling	todo:paper_14761289_v4_n4_p465_Vaisman2023-10-03T16:18:58Z A web-based architecture for temporal OLAP Vaisman, A.A. Izquierdo, A. Ktenas, M. Dimension updates Temporal databases Temporal OLAP TOLAP Web services Administrative data processing Computer programming languages Data processing Data structures Data warehouses Database systems Information management Information services Information theory Internet Linguistics Markup languages Metadata Warehouses Web services World Wide Web XML Application servers Case studies Data warehouse structure Dimension updates Historical databases Historical information Multidimensional databases OLAP queries OLAP systems Query optimisation Query performances Real-world System implementation Temporal Data Temporal databases Temporal OLAP Temporal queries Three-tier architecture TOLAP Versioning Web environment Web-based architecture XML documents XML metadata Query languages 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, none 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. In the second part of the paper, we present TOLAP-QL, an SQL-like temporal query language. We describe the syntax and semantics of the language, a sequel of its logic-based predecessor, TOLAP. We study query optimisation in temporal OLAP, and introduce a technique based on materialisation of historical views. Last, but not least, we present a system implementation, and a real-world case study, that shows that our proposal achieves good query performance for OLAP queries over large historical databases in a web environment. Copyright © 2008 Inderscience Enterprises Ltd. Fil:Vaisman, A.A. Universidad de Buenos Aires. Facultad de Ciencias Exactas y Naturales; Argentina. Fil:Izquierdo, A. Universidad de Buenos Aires. Facultad de Ciencias Exactas y Naturales; Argentina. JOUR info:eu-repo/semantics/openAccess http://creativecommons.org/licenses/by/2.5/ar http://hdl.handle.net/20.500.12110/paper_14761289_v4_n4_p465_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	Dimension updates Temporal databases Temporal OLAP TOLAP Web services Administrative data processing Computer programming languages Data processing Data structures Data warehouses Database systems Information management Information services Information theory Internet Linguistics Markup languages Metadata Warehouses Web services World Wide Web XML Application servers Case studies Data warehouse structure Dimension updates Historical databases Historical information Multidimensional databases OLAP queries OLAP systems Query optimisation Query performances Real-world System implementation Temporal Data Temporal databases Temporal OLAP Temporal queries Three-tier architecture TOLAP Versioning Web environment Web-based architecture XML documents XML metadata Query languages
spellingShingle	Dimension updates Temporal databases Temporal OLAP TOLAP Web services Administrative data processing Computer programming languages Data processing Data structures Data warehouses Database systems Information management Information services Information theory Internet Linguistics Markup languages Metadata Warehouses Web services World Wide Web XML Application servers Case studies Data warehouse structure Dimension updates Historical databases Historical information Multidimensional databases OLAP queries OLAP systems Query optimisation Query performances Real-world System implementation Temporal Data Temporal databases Temporal OLAP Temporal queries Three-tier architecture TOLAP Versioning Web environment Web-based architecture XML documents XML metadata Query languages Vaisman, A.A. Izquierdo, A. Ktenas, M. A web-based architecture for temporal OLAP
topic_facet	Dimension updates Temporal databases Temporal OLAP TOLAP Web services Administrative data processing Computer programming languages Data processing Data structures Data warehouses Database systems Information management Information services Information theory Internet Linguistics Markup languages Metadata Warehouses Web services World Wide Web XML Application servers Case studies Data warehouse structure Dimension updates Historical databases Historical information Multidimensional databases OLAP queries OLAP systems Query optimisation Query performances Real-world System implementation Temporal Data Temporal databases Temporal OLAP Temporal queries Three-tier architecture TOLAP Versioning Web environment Web-based architecture XML documents XML metadata Query languages
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, none 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. In the second part of the paper, we present TOLAP-QL, an SQL-like temporal query language. We describe the syntax and semantics of the language, a sequel of its logic-based predecessor, TOLAP. We study query optimisation in temporal OLAP, and introduce a technique based on materialisation of historical views. Last, but not least, we present a system implementation, and a real-world case study, that shows that our proposal achieves good query performance for OLAP queries over large historical databases in a web environment. Copyright © 2008 Inderscience Enterprises Ltd.
format	JOUR
author	Vaisman, A.A. Izquierdo, A. Ktenas, M.
author_facet	Vaisman, A.A. Izquierdo, A. Ktenas, M.
author_sort	Vaisman, A.A.
title	A web-based architecture for temporal OLAP
title_short	A web-based architecture for temporal OLAP
title_full	A web-based architecture for temporal OLAP
title_fullStr	A web-based architecture for temporal OLAP
title_full_unstemmed	A web-based architecture for temporal OLAP
title_sort	web-based architecture for temporal olap
url	http://hdl.handle.net/20.500.12110/paper_14761289_v4_n4_p465_Vaisman
work_keys_str_mv	AT vaismanaa awebbasedarchitecturefortemporalolap AT izquierdoa awebbasedarchitecturefortemporalolap AT ktenasm awebbasedarchitecturefortemporalolap AT vaismanaa webbasedarchitecturefortemporalolap AT izquierdoa webbasedarchitecturefortemporalolap AT ktenasm webbasedarchitecturefortemporalolap
_version_	1807323784341880832

A web-based architecture for temporal OLAP

Ejemplares similares