Fast incremental maintenance of approximate histograms

ACM Transactions on Database Systems

Volumn 27, Issue 3, 2002, Pages 261-298

  Gibbons, Phillip B ^a   Matias, Yossi ^b   Poosala, Viswanath ^c  

^a INTEL CORPORATION   (United States)

^b TEL AVIV UNIVERSITY   (Israel)

^c LUCENT TECHNOLOGIES   (United States)

Author keywords

Algorithms; Approximation; Experimentation; H.2.4 Database Management : Systems Query processing; Histograms; Incremental maintenance; Performance; Query optimization; Sampling

Indexed keywords

HISTOGRAMS; INCREMENTAL MAINTENANCE; QUERY OPTIMIZATION;

ALGORITHMS; DATA REDUCTION; PARAMETER ESTIMATION; PROBLEM SOLVING; QUERY LANGUAGES; THEOREM PROVING;

RELATIONAL DATABASE SYSTEMS;

EID: 0041401239     PISSN: 03625915     EISSN: None     Source Type: Journal    
DOI: 10.1145/581751.581753     Document Type: Article

References (33)

1. ABOULNAGA, A. AND CHAUDHURI, S. 1999. Self-tuning histograms: Building histograms without looking at data. In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Philadelphia, 181-192.
2. ACHARYA, S., GIBBONS, P. B., AND POOSALA, V. 2000. Congressional samples for approximate answering of group-by queries. In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Dallas, 487-498.
3. ACHARYA, S., GIBBONS, P. B., POOSALA, V., AND RAMASWAMY, S. 1999. Join synopses for approximate query answering. In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Philadelphia, 275-286.
4. BLOHSFELD, B., KORUS, D., AND SEEGER, B. 1999. A comparison of selectivity estimators for range queries on metric attributes. In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Philadelphia, 238-250.
5. BRUNO, N., CHAUDHURI, S., AND GRAVANO, L. 2001. STHoles: A multidimensional workload-aware histogram. In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Santa Barbara, CA, 211-222.
6. CHAUDHURI, S., DAS, G., AND NARASAYYA, V. 2001. A robust, optimization-based approach for approximate answering of aggregate queries. In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Santa Barbara, CA, 295-306.
7. CHAUDHURI, S., MOTWANI, R., AND NARASAYYA, V. 1998. Random sampling for histogram construction: How much is enough? In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Seattle, 436-447.
8. CHRISTODOULAKIS, S. 1984. Implications of certain assumptions in database performance evaluation. ACM Trans. Database Syst. 9, 2 (June), 163-186.
9. DESHPANDE, A., GAROFALAKIS, M., AND RASTOGI, R. 2001. Independence is good: Dependency-based histogram synopses for high-dimensional data. In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Santa Barbara, CA, 199-210.
10. GANTI, V., LEE, M.-L., AND RAMAKRISHNAN, R. 2000. ICICLES: Self-tuning samples for approximate query answering. In Proceedings of the 26th International Conference on Very Large Data Bases, Morgan Kaufman, Cairo, 176-187.
11. GIBBONS, P. B. 2001. Distinct sampling for highly-accurate answers to distinct values queries and event reports. In Proceedings of the 27th International Conference on Very Large Data Bases, Morgan Kaufman, Rome, 541-550.
12. GIBBONS, P. B. AND MATIAS, Y. 1998. New sampling-based summary statistics for improving approximate query answers. In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Seattle, 331-342.
13. GILBERT, A., GUHA, S., INDYK, P., KOTIDIS, Y., MUTHUKRISHNAN, S., AND STRAUSS, M. J. 2002a. Fast small-space algorithms for approximate histogram maintenance. In Proceedings of the 34th ACM Symposium on the Theory of Computing, ACM, Montreal.
14. GILBERT, A. C., KOTIDIS, Y., MUTHUKRISHNAN, S., AND STRAUSS, M. J. 2002b. How to summarize the universe: Dynamic maintenance of quantiles. In Proceedings of the 28th International Conference on Very Large Data Bases, Morgan Kaufman, Hong Kong.
15. GREENWALD, M. AND KHANNA, S. 2001. Space-efficient online computation of quantile summaries. In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Santa Barbara, CA, 58-66.
16. GUHA, S., KOUDAS, N., AND SHIM, K. 2001. Data-streams and histograms. In Proceedings of the 33rd ACM Symposium on Theory of Computing, ACM, Hersonissos, Crete, 471-175.
17. GUNOPULOS, D., KOLLIOS, G., TSOTRAS, V. J., AND DOMENICONI, C. 2000. Approximating multidimensional aggregate range queries over real attributes. In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Dallas, 463-474.
18. IOANNIDIS, Y. AND CHRISTODOULAKIS, S. 1991. On the propagation of errors in the size of join results. In Proceedings of the ACM SIGMOD Conference on Management of Data, ACM, Denver, 268-277.
19. IOANNIDIS, Y. AND POOSALA, V. 1999. Histogram-based techniques for approximating set-valued query-answers. In Proceedings of the 25th International Conference on Very Large Databases, Morgan Kaufman, Edinburgh, 174-185.
20. JAGADISH, H. V., KOUDAS, N., MUTHUKRISHNAN, S., POOSALA, V., SEVCIK, K., ANDSUEL, T. 1998. Optimal histograms with quality guarantees. In Proceedings of the 24th International Conference on Very Large Data Bases, Morgan Kaufman, New York, 275-286.
21. KONIG, A. C. AND WEIKUM, G. 1999. Combining histograms and parametric curve fitting for feedback-driven query result-size estimation. In Proceedings of the 25th International Conference on Very Large Databases, Morgan Kaufman, Edinburgh, 423-434.
22. KOOI, R. P. 1980. The optimization of queries in relational databases. PhD Thesis, Case Western Reserve University.
23. LIPTON, R. J., NAUGHTON, J. F., AND SCHNEIDER, D. A. 1990. Practical selectivity estimation through adaptive sampling. In Proceedings of the ACM SIGMOD Conference on Management of Data, ACM, Atlantic City, NJ, 1-11.
24. MATIAS, Y., VITTER, J. S., AND WANG, M. 1998. Wavelet-based histograms for selectivity estimation. In Proceedings of the ACM SIGMOD International Conference on Management of Data, ACM, Seattle, 448-459.
25. MATIAS, Y., VITTER, J. S., AND WANG, M. 2000. Dynamic maintenance of wavelet-based histograms. In Proceedings of the 26th International Conference on Very Large Data Bases, Morgan Kaufman, Cairo, 101-110.
26. POOSALA, V. 1997. Histogram-based estimation techniques in database systems. PhD Thesis, University of Wisconsin-Madison.
27. POOSALA, V. AND IOANNIDIS, Y. 1996. Estimation of query-result distribution and its application in parallel-join load balancing. In Proceedings of the 22nd International Conference on Very Large Databases, VLDB, Bombay, 448-459.
28. POOSALA, V. AND IOANNIDIS, Y. 1997. Selectivity estimation without the attribute value independence assumption. In Proceedings of the 23rd International Conference on Very Large Data Bases, Morgan Kaufman, Athens, 486-495.
29. POOSALA, V., IOANNIDIS, Y., HAAS, P., AND SHEKITA, E. 1996. Improved histograms for selectivity estimation of range predicates. In Proceedings of the ACM SIGMOD Conference on Management of Data, ACM, Montreal, 294-305.
30. REIF, J. H. AND VALIANT, L. G. 1987. A logarithmic time sort for linear size networks. J. ACM 34, 1, 60-76.
31. SELINGER, P. G., ASTRAHAN, M. M., CHAMBERLIN, D. D., LORIE, R. A., AND PRICE, T. T. 1979. Access path selection in a relational database management system. In Proceedings of the ACM SIGMOD Conference on Management of Data, ACM, Boston, 23-34.
32. VITTER, J. S. 1985. Random sampling with a reservoir. ACM Trans. Math. Softw. 11, 37-57.
33. ZIPF, G. K. 1949. Human Behaviour and the Principle of Least Effort. Addison-Wesley, Reading, Mass.