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, Alejandro Ariel, Izquierdo, Adrián
Publicado: 2008
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:https://bibliotecadigital.exactas.uba.ar/collection/paper/document/paper_14761289_v4_n4_p465_Vaisman
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
Descripción
Sumario: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.

Ejemplares similares