End-biased samples for join cardinality estimation

Proceedings - International Conference on Data Engineering

Volumn 2006, Issue , 2006, Pages 20-

  Estan, Cristian ^a   Naughton, Jeffrey F ^a  

^a University of Wisconsin Madison   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

CARDINALITY ESTIMATION; HISTOGRAMS; NETWORK TRAFFIC MEASUREMENT; PSEUDO RANDOM SAMPLES;

DATABASE SYSTEMS; NETWORK COMPONENTS; RANDOM PROCESSES; SAMPLING; TELECOMMUNICATION TRAFFIC;

TECHNOLOGY TRANSFER;

EID: 33749607007     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2006.61     Document Type: Conference Paper

References (28)

1. S. Acharya, P. Gibbons, V. Poosala, and S. Ramaswamy. Join synopses for approximate query answering. In SIGMOD, 1999.
2. N. Alon, P. Gibbons, Y. Matias, and M. Szegedy. Tracking join and self-join sizes in limited storage. In PODS, 1999.
3. N. Bruno, S. Chaudhuri, and L. Gravano. A multi-dimensional workload-aware histogram. In SIGMOD, 2001.
4. S. Chaudhuri, R. Motwani, and V. Narasayya. On random sampling over joins. In SIGMOD, 1999.
5. A. Dobra, M. Garofalakis, J. E. Gehrke, and R. Rastogi. Processing complex aggregate queries over data streams. In SIGMOD, 2002.
6. N. Duffield, C. Lund, and M. Thorup. Charging from sampled network usage. In SIGCOMM Internet Measurement Workshop, Nov. 2001.
7. N. G. Duffield and M. Grossglauser. Trajectory sampling for direct traffic observation. In Proceedings of the ACM SIGCOMM, pages 271-282, Aug. 2000.
8. C. Estan, K. Keys, D. Moore, and G. Varghese. Building a better netflow. In Proceedings of the ACM SIGCOMM, Aug. 2004.
9. C. Estan and J. E Naughton. End-biased samples for join cardinality estimation. U.W.-Madison C.S. Tech. rep. TR1541, Oct. 2005.
10. C. Estan and G. Varghese. New directions in traffic measurement and accounting: Focusing on the elephants, ignoring the mice. In ACM Trans. Comput. Syst., Aug. 2003.
11. P. Flajolet. On adaptive sampling. COMPUTG: Computing (Archive for Informatics and Numerical Computation), Springer-Verlag, 43, 1990.
12. S. Ganguly, M. Garofalakis, and R. Rastogi. Processing data-stream join aggregates using skimmed sketches. In EDBT, 2004.
13. M. Garofalakis and P. B. Gibbons. Wavelet synopses with error guarantees. In SIGMOD, 2002.
14. M. Garofalakis and A. Kumar. Deterministic wavelet thresholding for maximum-error metrics. In PODS, 2004.
15. P. B. Gibbons and Y. Matias. New sampling-based summary statistics for improving approximate query answers. In Proceedings of the ACM SIGMOD, pages 331-342, June 1998.
16. D. Gunopulos, G. Kollios, V. Tsotras, and C. Domeniconi. Approximating multi-dimensional aggregate range queries over real attributes. In SIGMOD, 2000.
17. P. Haas and A. Swami. Sequential sampling procedures for query size estimation. In SIGMOD, 1992.
18. Y. E. loannidis. Universality of serial histograms. In VLDB, 1993.
19. Y. E. loannidis and S. Christodoulakis. Optimal histograms for limiting worst-case error propagation in the size of the join radius. In ACM Transactions on Database Systems, volume 18, pages 709-748, 1993.
20. H. Jagadish, V. Poosala, N. Koudas, K. Sevcik, S. Muthukrishnan, and T. Suel. Optimal histograms with quality guarantees. In VLDB, 1998.
21. R. Kaushik, R. Ramakrishnan, and V. T. Chakaravarthy. Synposes for query optimization: A apace-complexity perspective. In Proceedings of PODS, 2004.
22. N. Koudas, S. Muthukrishnan, and D. Srivastava. Optimal histograms for hierarchical range queries. In PODS, 2000.
23. R. Lipton, J. Naughton, and D. Schneider. Practical selectivity estimation through adaptive sampling. In SIGMOD, 1990.
24. G. Manku and R. Motwani. Approximate frequency counts over data streams. In In Proceedings of the 28th International Conference on Very Large Data Bases, Aug. 2002.
25. M. Muralikrishna and D. DeWitt. Equi-depth histograms for estimating selectivity factors for multi-dimensional queries. In SIGMOD, 1988.
26. F. Olken and D. Rotem. Simple random sampling from relational databases. In VLDE, 1986.
27. G. Piatetsky-Shapiro and C. Connell. Accurate estimation of the number of tuples satisfying a condition. In SIGMOD, 1984.
28. V. Poosala, Y. E. Ioannidis, P. J. Haas, and E. J. Shekita. Improved histograms for selectivity estimation of range predicates. In SIGMOD, 1996.