Towards a robust query optimizer: A principled and practical approach

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2005, Pages 119-130

  Babcock, Brian ^a   Chaudhuri, Surajit ^b  

^a STANFORD UNIVERSITY   (United States)

^b MICROSOFT RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

CARDINALITY ESTIMATION; QUERY OPTIMIZATION; ROBUST CARDINALITY ESTIMATION TECHNIQUE;

DATABASE SYSTEMS; OPTIMIZATION; ROBUSTNESS (CONTROL SYSTEMS); SIGNAL FILTERING AND PREDICTION;

QUERY LANGUAGES;

EID: 29844440778     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1066157.1066172     Document Type: Conference Paper

References (32)

1. S. Acharya, P. B. Gibbons, V. Poosala, and S. Ramaswamy. Join synopses for approximate query answering. In Proc. 1999 SIGMOD Conf., pages 275-286, June 1999.
2. G. Antoshenkov. Query processing in DEC Rdb: Major issues and future challenges. Data Engineering Bulletin, 16(4):41-50, 1993.
3. J. M. Bernardo and A. F. M. Smith. Bayesian Theory. John Wiley, 1994.
4. S. Chaudhuri and V. Narasayya. Automating statistics management for query optimizers. In Proc. 2000 Intl. Conf. on Data Engineering, pages 339-348, 2000.
5. C.-M. Chen and N. Roussopoulos. Adaptive selectivity estimation using query feedback. In Proc. 1994 SIGMOD.
6. F. Chu, J. Y. Halpern, and J. Gehrke. Least expected cost query optimization: What can we expect? In Proc. 21st ACM PODS, pages 293-302, 2002.
7. F. Chu, J. Y. Halpern, and P. Seshadri. Least expected cost query optimization: An exercise in utility. In Proc. 18th ACM PODS, pages 138-147, 1999.
8. R. L. Cole. A decision theoretic cost model for dynamic plans. Data Engineering Bulletin, 23(2):34-41, 2000.
9. A. Deshpande, M. N. Garofalakis, and R. Rastogi. Independence is good: Dependency-based histogram synopses for high-dimensional data. In Proc. 2001 SIGMOD.
10. D. Donjerkovic and R. Ramakrishnan. Probabilistic optimization of Top N queries. In Proc. 1999 VLDB Conf., pages 411-422, 1999.
11. C. Faloutsos and I. Kamel. Relaxing the uniformity and independence assumptions using the concept of fractal dimensions. Journal of Computer and System Sciences, 55(2):229-240, 1997.
12. L. Getoor, B. Taskar, and D. Koller. Selectivity estimation using probabilistic models. In Proc. 2001 SIGMOD Conf.
13. P. Haas, J. Naughton, P. Seshadri, and L. Stokes. Sampling-based estimation of the number of distinct values of an attribute. In Proc. 1995 VLDB Conf., pages 311-322.
14. P. J. Haas, J. F. Naughton, S. Seshadri, and A. N. Swami. Selectivity and cost estimation for joins based on random sampling. Journal of Computer and System Sciences, 52(3):550-569, 1996.
15. P. J. Haas and A. N. Swami. Sequential sampling procedures for query size estimation. In Proc. 1992 SIGMOD Conf., pages 341-350, 1992.
16. Y. E. Ioannidis. The history of histograms (abridged). In Proc. 2003 VLDB Conf, pages 19-30, Sept. 2003.
17. Y. E. Ioannidis and S. Christodoulakis. On the propagation of errors in the size of join results. In Proc. 1991 SIGMOD Conf., pages 268-277, May 1991.
18. H. Jagadish, N. Koudas, S. Muthukrishnan, V. Poosala, K. Sevcik, and T. Suel. Optimal histograms with quality guarantees. In Proc. 1998 VLDB Conf., pages 275-286.
19. H. Jeffreys. Theory of Probability. Clarendon Press, 1961.
20. J.-H. Lee, D.-H. Kim, and C.-W. Chung. Multi-dimensional selectivity estimation using compressed histogram information. In Proc. 1999 SIGMOD Conf., pages 205-214.
21. P. M. Lee. Bayesian Statistics: An Introduction. Oxford University Press, 1989.
22. R. J. Lipton, J. F. Naughton, and D. A. Schneider. Practical selectivity estimation through adaptive sampling. In Proc. 1990 SIGMOD Conf, pages 1-11, 1990.
23. M. V. Mannino, P. Chu, and T. Sager. Statistical profile estimation in database systems. ACM Computing Surveys, 20(3):192-221, 1988.
24. Y. Matias, J. S. Vitter, and M. Wang. Wavelet-based histograms for selectivity estimation. In Proc. 1998 SIGMOD Conf, pages 448-459, June 1998.
25. M. Muralikrishna and D. J. DeWitt. Equi-depth histograms for estimating selectivity factors for multi-dimensional queries. In Proc. 1988 SIGMOD Conf., pages 28-36, 1988.
26. F. Olken. Random Sampling from Databases. PhD thesis, University of California at Berkeley, 1993.
27. V. Poosala and Y. E. Ioannidis. Selectivity estimation without the attribute value independence assumption. In Proc. 1997 VLDB Conf, pages 486-495, 1997.
28. V. Poosala, Y. E. Ioannidis, P. J. Haas, and E. J. Shekita. Improved histograms for selectivity estimation of range predicates. In Proc. 1996 SIGMOD Conf, pages 294-305.
29. K. Sarac, O. Egecioglu, and A. E. Abbadi. Iterated DFT based techniques for join size estimation. In Proc. 1988 ACM Intl. Conf. on Information and Knowledge Management.
30. P. Selinger, M. Astrahan, D. Chamberlin, R. Lorie, and T. Price. Access path selection in a relational database management system. In Proc. 1979 SIGMOD Conf., pages 23-34, June 1979.
31. K. D. Seppi, J. W. Barnes, and C. N. Morris. A Bayesian approach to database query optimization. ORSA Journal on Computing, 5(4):410-419, 1993.
32. Transaction Processing Performance Council. TPC-H benchmark 2.0.0, July 2002. http://www.tpc.org.