Rcube

Abstract

This article addresses the query performance issue for Relational OLAP (ROLAP) datacubes. We present RCUBE, a distributed multidimensional ROLAP indexing scheme which is practical to implement, requires only a small communication volume, and is fully adapted to distributed disks. Our solution is efficient for spatial searches in high dimensions and scalable in terms of data sizes, dimensions, and number of processors. Our method is also incrementally maintainable. Using “surrogate” group-bys, it allows for the efficient processing of arbitrary OLAP queries on partial cubes, where not all of the group-bys have been materialized. Our experiments with RCUBE show that the ROLAP advantage of better scalability, in comparison to MOLAP, can be maintained while providing a fast and flexible index for OLAP queries.

Dynamic View Management System for Query Prediction to View Materialization

“…OLAP is defined as online analytical processing system to answer the multidimensional queries (Dehne et al, 2008;Lawrence & Rau-Chaplin, 2008;Ravat et al, 2008). Multidimensional queries are complex and operate on huge amount of data, furthermore; these queries are used to managerial decisions in decision support systems (DSS) and data mining.…”