loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
18th International Conference on Data Engineering (ICDE'02)
Improving Range Query Estimation on Histograms
San Jose, California
February 26-March 01
ISBN: 0-7695-1531-2
Francesco Buccafurri, University of Reggio Calabria
Domenico Rosaci, University of Reggio Calabria
Luigi Pontieri, DEIS-UNICAL & ISI-CNR
Domenico Saccà, DEIS-UNICAL & ISI-CNR
Histograms are used to summarize the contents of relations for the estimation of query result sizes into a number of buckets. Several techniques (e.g., MaxDiff and V-Optimal) have been proposed in the past for determining bucket boundaries which provide better estimations. This paper proposes to use a 32-bit information (4-level tree index) for each bucket for storing approximated cumulative frequencies at 7 internal intervals of a bucket. Both theoretical analysis and experimental results show that the 4-level tree index provides the best frequency estimation inside a bucket. The index is later added to two well-known techniques for constructing histograms, MaxDiff and V-Optimal, thus obtaining high improvements in the frequency estimation over inter-bucket ranges w.r.t. the original methods.
Index Terms:
histograms, range query estimation, OLAP queries
Citation:
Francesco Buccafurri, Domenico Rosaci, Luigi Pontieri, Domenico Saccà, "Improving Range Query Estimation on Histograms," icde, pp.0628, 18th International Conference on Data Engineering (ICDE'02), 2002
Usage of this product signifies your acceptance of the Terms of Use.