Applying the golden rule of sampling for query estimation

SIGMOD Record (ACM Special Interest Group on Management of Data)

Volumn 30, Issue 2, 2001, Pages 449-460

  Wu, Yi Leh ^a   Agrawal, Divyakant ^a   El Abbadi, Amr ^a  

^a University of California   (United States)

Author keywords

Cumulative frequency distribution; Query estimation; Random sampling; Range query

Indexed keywords

EID: 0038968612     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/376284.375724     Document Type: Article

References (18)

1. Swarup Acharya, Viswanath Poosala, and Sridhar Ramaswamy. Selectivity estimation in spatial databases. In SIGMOD 1999, Proceedings ACM SIGMOD International Conference on Management of Data, June 1-3, 1999, Philadephia, Pennsylvania, USA, pages 13-24. ACM Press, 1999.
2. H. Ahrens and U. Dieter. Sequential random sampling. ACM Transaction Mathematical Software, 11(2):157-169, June 1985.
3. Surajit Chaudhuri, Rajeev Motwani, and Vivek Narasyya. On Random Sampling over Joins. In Proceedings of the 1999 ACM SIGMOD International Conference on Management of Data, pages 263-274, Philadelphia, Pennsylvania, June 1999.
4. Computational Science Education Project. Introduction to Monte Carlo Methods. http://csep1.phy.ornl.gov/mc/mc.html, 1995.
5. Roger Eckhardt. Stan Ulam, John Von Neumann, and the Monte Carlo Method. Los Alamos Science, (15, Spacial Issue):135, 1987.
6. P. B. Gibbons, V. Poosala, S. Acharya, Y. Matias Y. Bartal, S. Muthukrishnan, S. Ramaswamy, and T. Suel. AQUA: System and Techniques for Approximate Query Answering. Technical report, Bell Laboratories, Murray Hill, NJ, February 1998.
7. Phillip B. Gibbons and Yossi Matias. New sampling-based summary statistics for improving approximate query answers. In SIGMOD 1998, Proceedings ACM SIGMOD International Conference on Management of Data, June 2-4, 1998, Seattle, Washington, USA, pages 331-342. ACM Press, 1998.
8. Ching-Tien Ho, Rakesh Agrawal, Nimrod Megiddo, and Ramakrishnan Srikant. Range Queries in OLAP Data Cubes. In Proceedings of the 1997 ACM SIGMOD International Conference on Management of Data, pages 73-88, Arizona, 1997.
9. Yannis E. Ioannidis and Viswanath Poosala. Balancing Histogram Optimality and Practicality for Query Result Size Estimation. In Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data, pages 233-244, March 1995.
10. Richard J. Lipton, Jeffrey F. Naughton, and Donovan A. Schneider. Practical selectivity estimation through adaptive sampling. In Proceedings of 1990 ACM SIGMOD international conference on Management of data, pages 1-11, 1990.
11. Yossi Matias, Jeffrey Scott Vitter, and Min Wang. Wavelet-Based Histograms for Selectivity Estimation. In Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data, pages 448-459, Seattle, 1998.
12. V. Poosala, Y. E. Ioannidis, P. J. Haas, and E. Shekita. Improved Histograms for Selectivity Estimation of Range Predicates. In Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, Montreal, Canada, May 1996.
13. Viswanath Poosala. Private communication. 2000.
14. T. R. Smith. A digital library for geographically referenced materials. Computers, 29(5):54-60, May 1996.
15. TIGER. 1997 TIGER/Line Files (machine-readable data files). Technical report, U.S. Bureau Of the Census, Washington, DC, 1997.
16. Jeffrey Scott Vitter, Min Wang, and Bala Iyer. Data Cube Approximation and Histograms via Wavelets. In Proceedings of Seventh International Conference on Information and Knowledge Management - CIKM'98, pages 96-104, Bethesda, Maryland, November 1998.
17. Yi-Leh Wu, Divyakant Agrawal, and Amr El Abbadi. Applying the Golden Rule of Sampling for Query Estimation. Technical Report TRCS01-05, Computer Science Department, University of California at Santa Barbara, Santa Barbara, California, March 2001.
18. G. K. Zipf. Human Behavior and the Principle of Least Effort. Addison-Wesley, Reading, MA, 1949.