DOI 10.1007/s10619-009-7057-4 Maintenance of top-k materialized views

Abstract In this paper we present results on the problem of maintaining material-ized top-k views and provide results in two directions. The first problem we tackle concerns the maintenance of top-k views in the presence of high deletion rates. We provide a principled method that complements the inefficiency of the state of the art independently of the statistical properties of the data and the characteristics of the update streams. The second problem we have been concerned with has to do with the efficient maintenance of multiple top-k views in the presence of updates to their base relation. To this end, we provide theoretical guarantees for the nucleation (practically, inclusion) of a view with respect to another view and the reflection of this property to the management of updates. We also provide algorithmic results towards the mainte-nance of a large number of views, via their appropriate structuring in hierarchies of views