Pre-Aggregation for Irregular OLAP Hierarchies with the TreeScape System
暂无分享,去创建一个
We present the TreeScape system which, unlike any other system known to the authors, enables the reuse of pre-computed aggregate query results involving the kinds of irregular dimension hierarchies that occur frequently in practice. The system establishes a foundation for obtaining high-performance query processing while precomputing only few aggregates. It is demonstrated how this reuse of aggregates is enabled through dimension transformations that occur transparently to the user.
[1] Torben Bach Pedersen,et al. The TreeScape System: Reuse of Pre-Computed Aggregates over Irregular OLAP Hierarchies , 2000, VLDB.
[2] Jeffrey F. Naughton,et al. Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies , 1996, VLDB.
[3] Torben Bach Pedersen,et al. Extending Practical Pre-Aggregation in On-Line Analytical Processing , 1999, VLDB.