Modeling multidimensional databases

Agrawal, R. ; Gupta, A. ; Sarawagi, S. (1997) Modeling multidimensional databases In: 13th International Conference on Data Engineering.

Full text not available from this repository.

Official URL:

Related URL:


The authors propose a data model and a few algebraic operations that provide semantic foundation to multidimensional databases. The distinguishing feature of the proposed model is the symmetric treatment not only of all dimensions but also measures. The model provides support for multiple hierarchies along each dimension and support for ad hoc aggregates. The proposed operators are composable, reorderable, and closed in application. These operators are also minimal in the sense that none can be expressed in terms of others nor can any one be dropped without sacrificing functionality. They make possible the declarative specification and optimization of multidimensional database queries that are currently specified operationally. The operators have been designed to be translated to SQL and can be implemented either on top of a relational database system or within a special purpose multidimensional database engine. In effect, they provide an algebraic application programming interface (API) that allows the separation of the front end from the back end. Finally, the proposed model provides a framework in which to study multidimensional databases and opens several new research problems.

Item Type:Conference or Workshop Item (Paper)
Source:Copyright of this article belongs to IEEE
Keywords:Multidimensional systems;Relational databases;Spatial databases;Data models;Aggregates;Transaction databases;Graphical user interfaces;Engines;Software performance;Performance analysis
ID Code:128440
Deposited On:21 Oct 2022 03:49
Last Modified:14 Nov 2022 12:03

Repository Staff Only: item control page