Lazy Aggregates for Real-Time OLAP
Jukka Kiviniemi6
, Antoni Wolski6
, Antti Pesonen6
and Johannes Arminen6 
| (6) |
Technical Research Centre of Finland (VTT) VTT Information Technology, P.O. Box 1201, 02044 VTT, Finland |
Abstract
In OLAP models, or data cubes, aggregates have to be recalculated when the underlying base data changes. This may cause performance
problems in real-time OLAP systems, which continuously accommodate huge amounts of measurement data. To optimize the aggregate
computations, a new consistency criterion called the tolerance invariant is proposed. Lazy aggregates are aggregates that
are recalculated only when the tolerance invariant is violated, i.e., the error of the previously calculated aggregate exceeds
the given tolerance. An industrial case study is presented. The prototype implementation is described, together with the performance
results.
References secured to subscribers.