Get 20M+ Full-Text Papers For Less Than $1.50/day. Start a 14-Day Trial for You or Your Team.

Learn More →

A web-based architecture for Temporal OLAP

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 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. http://www.deepdyve.com/assets/images/DeepDyve-Logo-lg.png International Journal of Web Engineering and Technology Inderscience Publishers

A web-based architecture for Temporal OLAP

Download PDF
30 pages

Loading next page...
 
/lp/inderscience-publishers/a-web-based-architecture-for-temporal-olap-Q0SYyMDt0A
Publisher
Inderscience Publishers
Copyright
Copyright © Inderscience Enterprises Ltd. All rights reserved
ISSN
1476-1289
eISSN
1741-9212
DOI
10.1504/IJWET.2008.019944
Publisher site
See Article on Publisher Site

Abstract

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.

Journal

International Journal of Web Engineering and Technology – Inderscience Publishers

Published: Jan 1, 2008

There are no references for this article.