Practical Selectivity Estimation Through Adaptive Sampling

ACM SIGMOD Record

Volumn 19, Issue 2, 1990, Pages 1-11

  Lipton, Richard J ^a   Naughton, Jeffrey F ^b   Schneider, Donovan A ^b  

^a PRINCETON UNIVERSITY   (United States)

^b UNIVERSITY OF WISCONSIN   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTER PROGRAMMING - ALGORITHMS; SAMPLING;

QUERY SIZE ESTIMATION; RANDOM SAMPLING;

DATABASE SYSTEMS;

EID: 0025446531     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/93605.93611     Document Type: Article

References (24)

1. D. Bitton, D DeWitt, and C Turbyfill Benchmarking database systems A systematic approach In Proc Ninth VLDB, pages 8-19, 1983
2. S. Christodoulakis Estimating block transfers and join sizes In Proc ACM
3. SIGMOD Conference, pages 40-54, May 1983
4. S. Christodoulakis Estimating record selectivity Information Systems, 8(2) 69-79, 1983
5. R. Demolombe Estimation of the number of tuples satisfying a query expressed in predicate calculus language In Proc Sixth VLDB, pages 55-63, 1980
6. J. Fedorowicz Database performance evaluation using multiple regression techniques In Proc ACM SIGMOD Conference, pages 70-76, June 1984
7. W. Feller An Introduction to Probability Theory and Its Applications, volume 1 John Wiley and Sons, Inc, New York, New York, 1968
8. W. -C. Hou, G Ozsoyoglu, and B Taneja Statistical estimators for relational algebra expressions In Proc ACM PODS, pages 276-287, March 1988
9. W. -C. Hou, G Ozsoyoglu, and B Taneja Processing aggregate relational queries with hard time constraints In Proc ACM SIGMOD Conference, pages 68-77, June 1989
10. L. Herschberg, P D Ting, and S B Yao Query optimization in star computer networks ACM Transactions on Database Systems, 7(4), December 1982
11. N. Kamel and R King A model of data distribution based on texture analysis In Proc ACM SIGMOD Conference, pages 319-325, May 1985
12. R. Kooi The optimization of queries in relational database systems PhD thesis, Case Western University, Cleveland, Ohio, 1980
13. R. Lip ton and J Naughton Estimating the size of generalized transitive closures In Proc Fifteenth VLDB, pages 165-172, August 1989
14. R. Lipton and J Naughton Query size estimation by adaptive sampling In Proc ACM PODS, March 1990
15. R. Lipton and J Naughton and D Schneider Practical Selectivity Estimation through Adaptive Sampling University of Wisconsin-Madison Computer Sciences Department Technical Report, March 1990
16. C. Lynch Selectivity estimation and query optimization in large databases with highly skewed distributions of column values In Proc Fourteenth VLDB, pages 240-251, August 1988
17. M. Mannino, P Chu, and T Sager Statistical profile estimation in database systems Computing Surveys, 20(3) 191-221, September 1988
18. M. Muralikrishna and D DeWitt Equidepth histograms for estimating selectivity factors for multi-dimensional queries In Proc SIGMOD Conference, pages 28-36, June 1988
19. A. Montgomery, D D'Douza, and S Lee The cost of relational algebraic operations on skewed data Estimates and experiments Information Processing Letters, pages 235-241, 1983
20. B. Muthuswamy and G Kerschberg A DDSM for relational query optimization Technical report, University of South Carolina, Columbia, 1985 As cited in [MCS88]
21. F. Olken and D Rotem Simple random sampling for relational databases In Proc Twelfth VLDB, pages 160-169, August 1986
22. F. Olken and D Rotem Random sampling from B+trees In Proc Fifteenth VLDB, pages 269-278, August 1989
23. G. Piatetsky-Shapiro and C Connell Accurate estimation of the number of tuples satisfying a condition In Proc A CM SIGMOD Conference, pages 256-276, June 1984
24. P. G. Selinger, ? M Astrahan, D D Chamberlin, R A Lone, and T G Price Access path selection in a relational database management system In Proc ACM SIGMOD Conference, pages 23-34, 1979