Digital Symposium Collection 2000  

 
 
 
 
 
 

 















PISA: Performance Models for Index Structures with and without Aggregated Data

M. Jürgens and H.-J. Lenz

  View Paper (PDF)  

Return to Paper Session 2: Indexing

Abstract

Different models to estimate the performance of tree-based index structures exist. Materialized aggregates in the inner nodes of such index structures are used to speed up range queries on aggregates. This is achieved by avoiding traversing the index tree down to the leaves through aggregates precomputed in the inner nodes. None of the existing models deals with these aggregated data. In this paper, we extend the existing models to take account of aggregated data. Our main contribution is a new generic performance model to estimate the model is adaptable to the distribution of the data and the location of the query boxes (e. g. uniform, normal, and skewed distributions). Experiments confirm that in most cases the

























Copyright(C) 2000 ACM