Pre-computing Approximate Hierarchical Range Queries in a Tree-Like Histogram

  • Francesco Buccafurri
  • Gianluca Lax
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2737)


Histograms are a lossy compression technique widely applied in various application contexts, like query optimization, statistical and temporal databases, OLAP applications, and so on. This paper presents a new histogram based on a hierarchical decomposition of the original data distribution kept in a complete binary tree. This tree, thus containing a set of pre-computed hierarchical queries, is encoded in a compressed form using bit saving in representing integer numbers. The approach, extending a recently proposed technique based on the application of such a decomposition to the buckets of a pre-existing histogram, is shown by several experiments to improve the accuracy of the state-of-the-art histograms.


Compression Ratio Parent Node Range Query Average Relative Error Query Optimization 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Buccafurri, F., Furfaro, F., Lax, G., Saccá, D.: Binary-tree histograms with tree indices. In: Hameurlain, A., Cicchetti, R., Traunmüller, R. (eds.) DEXA 2002. LNCS, vol. 2453, p. 861. Springer, Heidelberg (2002)CrossRefGoogle Scholar
  2. 2.
    Buccafurri, F., Pontieri, L., Rosaci, D., Saccà, D.: Improving Range Query Estimation on Histograms. In: ICDE 2002, San Jose (CA), USA (2002)Google Scholar
  3. 3.
    Buccafurri, F., Rosaci, D., Saccá, D.: Compressed datacubes for fast OLAP applications. In: Mohania, M., Tjoa, A.M. (eds.) DaWaK 1999. LNCS, vol. 1676, pp. 65–77. Springer, Heidelberg (1999)Google Scholar
  4. 4.
    Koudas, N., Muthukrishnan, S., Srivastava, D.: Optimal Histograms for Hierarchical Range Queries. In: Proc. of Symposium on Principles of Database Systems - PODS, Dallas, Texas, pp. 196–204 (2000)Google Scholar
  5. 5.
    Malvestuto, F.: A Universal-Scheme Approach to Statistical Databases Containing Homogeneous Summary Tables. ACM TODS 18(4), 678–708 (1993)CrossRefGoogle Scholar
  6. 6.
    Matias, Y., Vitter, J.S., Wang, M.: Wavelet-based histograms for selectivity estimation. In: Proceedings of the 1998 ACM SIGMOD Conference on Management of Data, Seattle, Washington (June 1998)Google Scholar
  7. 7.
    Natsev, A., Rastogi, R., Shim, K.: WALRUS: A Similarity Retrieval Algorithm for Image Databases. In: Proceedings of the 1999 ACM SIGMOD Conference on Management of Data (1999)Google Scholar
  8. 8.
    Poosala, V.: Histogram-based Estimation Techniques in Database Systems. PhD dissertation, University of Wisconsin-Madison (1997)Google Scholar
  9. 9.
    Poosala, V., Ioannidis, Y.E., Haas, P.J., Shekita, E.J.: Improved histograms for selectivity estimation of range predicates. In: Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, pp. 294–305 (1996)Google Scholar
  10. 10.
    Poosala, V., Ganti, V., Ioannidis, Y.E.: Approximate Query Answering using Histograms. IEEE Data Engineering Bulletin 22 (March 1999)Google Scholar
  11. 11.
    Selinger, P.G., Astrahan, M.M., Chamberlin, D.D., Lorie, R.A., Price, T.T.: Access path selection in a relational database management system. In: Proc. of ACM SIGMOD Internatinal Conference, pp. 23–24 (1979)Google Scholar
  12. 12.
    Sitzmann, I., Stuckey, P.J.: Improving Temporal Joins Using Histograms. In: Proc. of the Int. Conference, Database and Expert Systems Applications – DEXA (2000)Google Scholar
  13. 13.
    Stollnitz, E.J., Derose, T.D., Salesin, D.H.: Wavelets for Computer Graphics. Morgan Kauffmann, San Francisco (1996)Google Scholar
  14. 14.
    Vitter, J.S., Wang, M., Iyer, B.: Data Cube Approximation and Histograms via Wavelet. In: Proceedings of the 1998 CIKM International Conference on Information and Knowledge Management, Washington (1998)Google Scholar
  15. 15.
    Vitter, J.S., Wang, M.: Approximate Computation of Multidimansional Aggregates of Sparse Data using Wavelets. In: Proceedings of the 1999 ACM SIGMOD International Conference on Management of Data (1999)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2003

Authors and Affiliations

  • Francesco Buccafurri
    • 1
  • Gianluca Lax
    • 1
  1. 1.DIMETUniversità degli Studi Mediterranea di Reggio CalabriaReggio CalabriaItaly

Personalised recommendations