|
| This Article | ||
| ||
| Share | ||
| Bibliographic References | ||
| Add to: | ||
| | ||
| Search | ||
| ||
13th International Conference on Data Engineering (ICDE'97)
Modeling Multidimensional Databases
University of Birmingham, Birmingham, U.K.
April 07-April 11
ISBN: 0-8186-7807-0
| ASCII Text | x | ||
| Rakesh Agrawal, Ashish Gupta, Sunita Sarawagi, "Modeling Multidimensional Databases," Data Engineering, International Conference on, pp. 232, 13th International Conference on Data Engineering (ICDE'97), 1997. | |||
| BibTex | x | ||
| @article{ 10.1109/ICDE.1997.581777, author = {Rakesh Agrawal and Ashish Gupta and Sunita Sarawagi}, title = {Modeling Multidimensional Databases}, journal ={Data Engineering, International Conference on}, volume = {0}, year = {1997}, issn = {1063-6382}, pages = {232}, doi = {http://doi.ieeecomputersociety.org/10.1109/ICDE.1997.581777}, publisher = {IEEE Computer Society}, address = {Los Alamitos, CA, USA}, } | |||
| RefWorks Procite/RefMan/Endnote | x | ||
| TY - CONF JO - Data Engineering, International Conference on TI - Modeling Multidimensional Databases SN - 1063-6382 SP EP A1 - Rakesh Agrawal, A1 - Ashish Gupta, A1 - Sunita Sarawagi, PY - 1997 KW - Multidimensional data model KW - Online analytical processing KW - OLAP KW - aggregating data KW - multidimensional summaries KW - drill-down KW - roll-ups VL - 0 JA - Data Engineering, International Conference on ER - | |||
We 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 adhoc 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 frontend from the backend. Finally, the proposed model provides a framework in which to study multidimensional databases and opens several new research problems.
Index Terms:
Multidimensional data model, Online analytical processing, OLAP, aggregating data, multidimensional summaries, drill-down, roll-ups
Citation:
Rakesh Agrawal, Ashish Gupta, Sunita Sarawagi, "Modeling Multidimensional Databases," icde, pp.232, 13th International Conference on Data Engineering (ICDE'97), 1997
Usage of this product signifies your acceptance of the Terms of Use.
