Management of multidimensional aggregates for efficient online analytical processing
- 20 January 2003
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
Abstract
Proper management of multidimensional aggregates is a fundamental prerequisite for efficient OLAP. The experimental OLAP server CubeStar, which concepts are described in this paper, was designed exactly for that purpose. All logical query processing is based solely on a specific algebra for multidimensional data. However, a relational database system is used for the physical storage of the data. Therefore, in popular terms CubeStar can be classified as a ROLAP system. In comparison to commercially available systems, CubeStar is superior in two aspects: First, the implemented multidimensional data model allows more adequate modeling of hierarchical dimensions, because properties which apply only to certain dimensional elements can be modeled context-sensitively. This fact is reflected by an extended star schema on the relational side. Second, CubeStar supports multidimensional query optimization by caching multidimensional aggregates. Since summary tables are not created in advance but as needed, hot spots can be adequately represented. The dynamic and partition-oriented caching method allows cost reductions of up to 60% with space requirements of less than 10% of the size of the fact table.Keywords
This publication has 10 references indexed in Scilit:
- On-line analytical processing in distributed data warehousesPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2002
- Index selection for OLAPPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2002
- Modeling multidimensional databasesPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2002
- Caching multidimensional queries using chunksPublished by Association for Computing Machinery (ACM) ,1998
- Querying multidimensional databasesPublished by Springer Nature ,1998
- THE CUBE-QUERY-LANGUAGE (CQL) FOR MULTIDIMENSIONAL STATISTICAL AND SCIENTIFIC DATABASE SYSTEMSPublished by World Scientific Pub Co Pte Ltd ,1997
- Selection of views to materialize in a data warehousePublished by Springer Nature ,1997
- Implementing data cubes efficientlyACM SIGMOD Record, 1996
- A data model for supporting on-line analytical processingPublished by Association for Computing Machinery (ACM) ,1996
- Database abstractionsACM Transactions on Database Systems, 1977