Welcome to the InfoSci Platform
Reference Hub2
OLAP with a Database Cluster

OLAP with a Database Cluster

Uwe Röhm
Copyright: © 2009 |Pages: 18
ISBN13: 9781605660585|ISBN10: 1605660582|EISBN13: 9781605660592
DOI: 10.4018/978-1-60566-058-5.ch047
Cite Chapter Cite Chapter

MLA

Röhm, Uwe. "OLAP with a Database Cluster." Database Technologies: Concepts, Methodologies, Tools, and Applications, edited by John Erickson, IGI Global, 2009, pp. 829-846. https://doi.org/10.4018/978-1-60566-058-5.ch047

APA

Röhm, U. (2009). OLAP with a Database Cluster. In J. Erickson (Ed.), Database Technologies: Concepts, Methodologies, Tools, and Applications (pp. 829-846). IGI Global. https://doi.org/10.4018/978-1-60566-058-5.ch047

Chicago

Röhm, Uwe. "OLAP with a Database Cluster." In Database Technologies: Concepts, Methodologies, Tools, and Applications, edited by John Erickson, 829-846. Hershey, PA: IGI Global, 2009. https://doi.org/10.4018/978-1-60566-058-5.ch047

Export Reference

Mendeley
Favorite

Abstract

This chapter presents a new approach to online decision support systems that is scalable, fast, and capable of analysing up-to-date data. It is based on a database cluster: a cluster of commercial off-the-shelf computers as hardware infrastructure and off-the-shelf database management systems as transactional storage managers. We focus on central architectural issues and on the performance implications of such a cluster-based decision support system. In the first half, we present a scalable infrastructure and discuss physical data design alternatives for cluster-based online decision support systems. In the second half of the chapter, we discuss query routing algorithms and freshness-aware scheduling. This protocol enables users to seamlessly decide how fresh the data analysed should be by allowing for different degrees of freshness of the online analytical processing (OLAP) nodes. In particular it becomes then possible to trade freshness of data for query performance.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.