The Community for Technology Leaders
Database Engineering and Applications Symposium, International (2000)
Yokohama, Japan
Sept. 18, 2000 to Sept. 20, 2000
ISSN: 1098-8068
ISBN: 0-7695-0789-1
pp: 236
B.J. Oommen , Sch. of Comput. Sci., Carleton Univ., Ottawa, Ont., Canada
M. Thiyagarajah , Sch. of Comput. Sci., Carleton Univ., Ottawa, Ont., Canada
ABSTRACT
Histogram techniques are used to efficiently estimate query result sizes in most of the modern-day database systems. In a recent work (Oommen and Thiyagarajah, 1999), we introduced a new histogram-like approximation strategy, called the Rectangular Attribute Cardinality Map (R-ACM), which approximates the density function within a given sector by a rectangular cell. In this paper, we introduce another histogram-like approximation strategy, called the Trapezoidal Attribute Cardinality Map (T-ACM) that approximates the density function within a given sector by a trapezoidal cell, where the slope of the trapezoid is obtained so as to fix the actual probability mass within the cell. We present numerous analytic and experimental results concerning the T-ACM demonstrating its superiority over the traditional equi-width and equi-depth histograms for query result size estimation. We hope that with the R-ACM introduced in (Oommen and Thiyagarajah, 1999), the T-ACM could become an invaluable tool for query optimization in the future database systems.
INDEX TERMS
database theory; query result size estimation; Trapezoidal Attribute Cardinality Map; query optimization; histogram-like approximation strategy; Rectangular Attribute Cardinality Map; density function approximation; probability; experimental results; T-ACM; equi-width histograms; equi-depth histograms; R-ACM
CITATION
B.J. Oommen, M. Thiyagarajah, "Query Result Size Estimation Using the Trapezoidal Attribute Cardinality Map", Database Engineering and Applications Symposium, International, vol. 00, no. , pp. 236, 2000, doi:10.1109/IDEAS.2000.880582
90 ms
(Ver 3.3 (11022016))