The TreeScape System: Reuse of Pre-Computed Aggregates over Irregular OLAP Hierarchies

We present the TreeScape system that, unlike any other system known to the authors, enables the reuse of pre-computed aggregate query results for irregular dimension hierarchies, which occur frequently in practice. The system establishes a foundation for obtaining high query processing performance while pre-computing only limited aggregates. The paper shows how this reuse of aggregates is enabled through dimension transformations that occur transparently to the user.

• Type: Conference
• Year: 2000
• Where: VLDB
• Authors: Torben Bach Pedersen, Christian S. Jensen, Curtis E. Dyreson
• Keywords: Database, Irregular Dimension Hierarchies, Pre-computed Aggregate Query, Query Processing Performance, VLDB 2000