Answering multidimensional queries on cubes using other cubes

Dimitri Theodoratos, Timos Sellis

Research output: Contribution to conferencePaperpeer-review

6 Scopus citations

Abstract

Recently there is an important interest on On-Line Analytical Processing (OLAP) technology. In this context, in order to facilitate complex analysis, data are usually modeled multidimensionally, where multiple hierarchies are associated with the dimensions. These Multidimensional (MD) data structures are called data cubes. In the existing OLAP products, the user interaction is limited to one operation at a time. Further, computing OLAP operations is very expensive since sequential scans are required. In this paper, we provide a simple data model for MD databases, and a simple algebraic MD query language that permit the modeling of the principal OLAP operations. The MD query language allows the user to directly specify the result. Therefore, optimization techniques can be applied globally to the MD query evaluation. We state declarative conditions for answering queries on cubes using exclusively one or more precomputed queries (derived cubes). Then, we provide instance independent expressions that compute an MD query on a cube front derived cubes. These results can be used to increase availability of data and to improve MD query performance.

Original languageEnglish (US)
Pages109-122
Number of pages14
StatePublished - Dec 3 2000
Externally publishedYes
EventSSDBM 2000: 12th International Conference on Scientific and Statistical Database Management - Berlin, Ger
Duration: Jul 26 2000Jul 28 2000

Other

OtherSSDBM 2000: 12th International Conference on Scientific and Statistical Database Management
CityBerlin, Ger
Period7/26/007/28/00

All Science Journal Classification (ASJC) codes

  • Software
  • Applied Mathematics

Fingerprint Dive into the research topics of 'Answering multidimensional queries on cubes using other cubes'. Together they form a unique fingerprint.

Cite this