Characterization of hierarchies and some operators in OLAP environment

  • Authors:
  • Elaheh Pourabbas;Maurizio Rafanelli

  • Affiliations:
  • Istituto di Analisi dei Sistemi ed Informatica - CNR, Viale Manzoni 30, 00185 Roma, Italy;Istituto di Analisi dei Sistemi ed Informatica - CNR, Viale Manzoni 30, 00185 Roma, Italy

  • Venue:
  • Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
  • Year:
  • 1999

Quantified Score

Hi-index 0.00

Visualization

Abstract

Recently numerous proposals for modelling and querying Multidimensional Databases (MDDB) are proposed. Among the still open problems there is a rigorous classification of the different types of hierarchies. In this paper we propose and discuss some different types of hierarchies within a single dimension of a cube. These hierarchies divide in different levels of aggregation a single dimension. Depending on them, we discuss the characterization of some OLAP operators which refer to hierarchies in order to maintain the data cube consistency. Moreover, we propose a set of operators for changing the hierarchy structure. The issues discussed provides modelling flexibility during the scheme design phase and correct data analysis.