loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
15th International Conference on Scientific and Statistical Database Management
Computing Cube View Dependences in OLAP Datacubes
Cambridge, Massachusetts, USA
July 09-July 11
ISBN: 0-7695-1964-4
Carlos Hurtado, Universidad de Chile
Claudio Guti?rrez, Universidad de Chile
A common technique for speeding up OLAP query processing is to materialize (pre-compute) some aggregate views, called cube views, and use them for the derivation of other cube views. The derivations are inferred from the dimension hierarchies, and are usually represented as a relation between cube views called cube dependence relation, also called summarizability relation for a single dimension hierarchy. In this paper, we study the problem of computing the summarizability relation of dimension schemas that model structural irregularities of dimensions by means of integrity constraints. We study the intrinsic complexity of the problem, and present an algorithm which uses deep structural properties of dimension hierarchies and constraints to solve the problem. Finally, we give an extension of the algorithm to compute the dependence relation for the multidimensional case.
Citation:
Carlos Hurtado, Claudio Guti?rrez, "Computing Cube View Dependences in OLAP Datacubes," ssdbm, pp.33, 15th International Conference on Scientific and Statistical Database Management, 2003
Usage of this product signifies your acceptance of the Terms of Use.