Skip to main content
Article
Dynamic Selectivity Estimation for Multidimensional Queries
International Conference on Foundations of Data Organization and Algorithms
  • Junping Sun, Nova Southeastern University
  • William I. Grosky
  • Farshad Fotouhi
Document Type
Article
Event Date/Location
Chicago, IL / 1993
Publication Date
10-1-1993
Abstract

We have developed an adaptive selectivity estimation scheme for multidimensional queries which, experiments indicate, performs better than previously formulated non-adaptive methods when the distribution of the data is not known. Our approach uses a technique based on dynamic quantized spaces, a dynamic data structure developed for motion analysis in the field of computer vision. The objective of this research is to overcome the disadvantages of previously formulated non-adaptive, static methods which are relatively inaccurate in a dynamic database environment when the distribution of the data is not uniform. We have shown via many experiments that our approach is more flexible and more accurate in the computation of selectivity factors than both the equi-width and equi-depth histogram methods when the database is large and undergoes frequent update activity following a non-uniform distribution.

DOI
10.1007/3-540-57301-1_14
Disciplines
Citation Information
Junping Sun, William I. Grosky and Farshad Fotouhi. "Dynamic Selectivity Estimation for Multidimensional Queries" International Conference on Foundations of Data Organization and Algorithms Vol. 730 (1993) p. 231 - 246 ISSN: 978-3-540-57301-2
Available at: http://works.bepress.com/junping-sun/30/