Compressed histograms with arbitrary bucket layouts for selectivity estimation

Information Sciences

Volumn 177, Issue 3, 2007, Pages 680-702

  Fuchs, Dennis ^a   He, Zhen ^b   Lee, Byung Suk ^c  

^a Tele Atlas   (United States)

^b LA TROBE UNIVERSITY   (Australia)

^c University of Vermont ^*  (United States)

Author keywords

Compression; Histogram; Selectivity; Self tuning

Indexed keywords

DATABASE SYSTEMS; PARAMETER ESTIMATION; QUERY LANGUAGES; STORAGE ALLOCATION (COMPUTER); VECTOR QUANTIZATION;

BUCKET LOCATION; HISTOGRAM; SELECTIVITY; SELF TUNING;

DATA COMPRESSION;

EID: 33750706512     PISSN: 00200255     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.ins.2006.07.013     Document Type: Article

References (18)

1. Ioannidis Y., and Christodoulakis S. On the propagation of errors in the size of join results. Proc. of ACM SIGMOD (1991), ACM Press, Denver, CO 268-277
2. Aboulnaga A., and Chaudhuri S. Self-tuning histograms: building histograms without looking at data. Proc. of ACM SIGMOD (1999), ACM Press, Philadelphia, PA 181-192
3. Acharya S., Poosala V., and Ramaswamy S. Selectivity estimation in spatial databases. Proc. of ACM SIGMOD (1999), ACM Press, Philadelphia, PA 13-24
4. Bruno N., Chaudhuri S., and Gravano L. STHoles: a multidimensional workload-aware histogram. Proc. of ACM SIGMOD (2001), ACM Press, Santa Barbara, CA 211-222
5. Chen C., and Roussopoulos N. Adaptive selectivity estimation using query feedback. Proc. of ACM SIGMOD (1994), ACM Press, Minneapolis, MN 161-172
6. Deshpande A., Garofalakis M., and Rastogi R. Independence is good: dependency-based histogram synopses for high-dimensional data. Proc. of ACM SIGMOD (2001), ACM Press, Santa Barbara, CA 199-210
7. Getoor L., Taskar B., and Koller D. Selectivity estimation using probabilistic models. Proc. of ACM SIGMOD (2001), ACM Press, Santa Barbara, CA 461-472
8. Gibbons P., Matias Y., and Poosala V. Fast incremental maintenance of approximate histograms. ACM Transactions on Database Systems 27 3 (2002) 261-298
9. Gunopulos D., Kollios G., Tsotras V., and Domeniconi C. Approximating multi-dimensional aggregate range queries over real attributes. Proc. of ACM SIGMOD (2000), ACM Press, Dallas, TX 463-474
10. Matias Y., Vitter J., and Wang M. Wavelet-based histograms for selectivity estimation. Proc. of ACM SIGMOD 1998 (1998), ACM Press, Seattle, WA 448-459
11. Matias Y., Vitter J., and Wang M. Dynamic maintenance of wavelet-based histograms. Proc. of VLDB, Cairo, Egypt (2000), Morgan Kaufman, Cairo, Egypt 101-110
12. Muralikrishna M., and DeWitt D.J. Equi-depth multidimensional histograms. Proc. of ACM SIGMOD (1988), ACM Press, Chicago, IL 28-36
13. Muthukrishnan S., Poosala V., and Suel T. On rectangular partitionings in two dimensions: algorithms, complexity, and applications. Proc. of ICDT (1999), Springer-Verlag, London, UK 236-256
14. Poosala V., and Ioannidis Y. Selectivity estimation without the attribute value independence assumption. Proc. of VLDB (1997), Morgan Kaufman, Athens, Greece 486-495
15. Thaper N., Guha S., Indyk P., and Koudas N. Dynamic multidimensional histograms. Proc. of ACM SIGMOD (2002), ACM Press, Madison, WI 428-439
16. Wu Y., Agrawal D., and El Abbadi A. Applying the golden rule of sampling for query estimation. Proc. of ACM SIGMOD (2001), ACM Press, Santa Barbara, CA 449-460
17. Lipton R., and Naughton J. Query size estimation by adaptive sampling. Proc. of ACM SIGACT-SIGMOD-SIGART Sympos. PODS (1990), ACM Press, Nashville, TN 40-46
18. Sakurai Y., Yoshikawa M., Uemura S., and Kojima H. The A-tree: an index structure for high-dimensional spaces using relative approximation. Proc. of VLDB (2000), Morgan Kaufman 516-526