Modeling multidimensional databases, cubes and cube operations
- 1 January 1998
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
Abstract
On-Line Analytical Processing (OLAP) is a trend in database technology, which was recently introduced and has attracted the interest of a lot of research work. OLAP is based on the multidimensional view of data, supported either by multidimensional databases (MOLAP) or relational engines (ROLAP). In this paper we propose a model for multidimensional databases. Dimensions, dimension hierarchies and cubes are formally, introduced. We also introduce cube operations (changing of levels in the dimension hierarchy, function application, navigation etc.). The approach is based on the notion of the base cube, which is used for the calculation of the results of cube operations. We focus our approach on the support of series of operations on cubes (i.e. the preservation of the results of previous operations and the applicability of aggregate functions in a series of operations). Furthermore, we provide a mapping of the multidimensional model to the relational model and to multidimensional arraysKeywords
This publication has 8 references indexed in Scilit:
- Data cube: a relational aggregation operator generalizing GROUP-BY, CROSS-TAB, and SUB-TOTALSPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2002
- OLAP and statistical databasesPublished by Association for Computing Machinery (ACM) ,1997
- A data model for supporting on-line analytical processingPublished by Association for Computing Machinery (ACM) ,1996
- Answering queries using views (extended abstract)Published by Association for Computing Machinery (ACM) ,1995
- Research problems in data warehousingPublished by Association for Computing Machinery (ACM) ,1995
- A functional model for macro-databasesACM SIGMOD Record, 1991
- Extending relational algebra and relational calculus with set-valued attributes and aggregate functionsACM Transactions on Database Systems, 1987
- A language and a physical organization technique for summary tablesPublished by Association for Computing Machinery (ACM) ,1985