From a Procedural to a Visual Query Language for OLAP

  • Authors:
  • Luca Cabibbo;Riccardo Torlone

  • Affiliations:
  • -;-

  • Venue:
  • SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
  • Year:
  • 1998

Quantified Score

Hi-index 0.00

Visualization

Abstract

In this paper, we address the issue of designing effective query languages for OLAP databases. The basis of our investigation is MD, a new data model for multidimensional databases that, unlike other multidimensional models, is independent of any specific implementation (relational or proprietary multidimensional) and as such provides a clear separation between practical and conceptual aspects. In this framework, we present and compare two query languages, based on different paradigms, for OLAP databases. The first language is algebraic and provides an effective way to manipulate multidimensional data in a procedural fashion. Although this language is clean and powerful, it is clearly not suited for final users. We therefore propose a high-level graphical language that allows the user to specify analytical queries in a natural and intuitive way.