Abstract
Current business database systems utilize histograms to approximate frequency distributions of attribute values of relations. These are used to efficiently estimate query result sizes and access plan costs and thus minimize the query response time for business (and non-commercial) database systems. In two recent works [10, 11] we proposed two new forms of histogram-like techniques called the Rectangular and Trapezoidal Attribute Cardinality Maps (ACM) respectively, that give much smaller estimation errors than the traditional equi-width and equi-depth histograms currently being used by many commercial database systems. In [10, 11] we also provided a fairly extensive mathematical analysis for their average and worst case errors for their frequency estimates — which, in turn, were verified for synthetic data.
This paper reports the prototype validation for the Rectangular- ACM (R-ACM) for query optimization in real-world database systems. By using an extensive set of experiments using real-life data [1,2], we demonstrate that the R-ACM scheme is much more accurate than the traditional histograms for query result size estimation. We anticipate that it could become an invaluable tool for query optimization in the future.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
National Basket Ball Association. NBA Players Performance Statistics. ftp://olympos.cs.umd.edu, 1992
U.S. Census Bureau. U.S. Census Database 1997
Christodoulakis S. Estimating selectivities in databases. In: Technical Report CSRG-136, computer Science Dept., University of Toronto, 1981
Faloutsos Ch., Matias Y., Silberschatz A. Modeling skewed distributions using multi- fractals and the 80–20 law. In Technical Report, Dept. of Computer Science, University of Maryland, 1996
Ioannidis Y., Christodoulakis S. On the propagation of errors in the size of join results. In: Proceedings of the ACM SIGMOD Conference, 1991, pp 268 – 277
Ioannidis Y., Christodoulakis S. Optimal histograms for limiting worst-case error propagation in the size of join results. In: ACM TODS, 1992
Kooi R.P. The optimization of queries in relational databases. Ph.D. Thesis, Case Western Reserve University, 1980
Mannino M.V., Chu P., Sager T. Statistical profile estimation in database systems. In: ACM Computing Surveys, 1988, Vol. 20, pp 192–221
Muralikrishna M., Dewitt D.J. Equi-depth histograms for estimating selectivity factors for multi-dimensional queries. In: Proceedings of ACM SIGMOD Conference, 1988, pp 28 – 36
Oommen J.B., Thiyagarajah M. The rectangular attribute cardinality map: A new histogram-like technique for query optimization. Technical Report, School of Computer Science, Carleton University, Ottawa, Canada, In preparation. Can be made available to the referees if needed
Oommen J.B., Thiyagarajah M. The trapezoidal attribute cardinality map: A new histogram-like technique for query optimization. Technical Report, School of Computer Science, Carleton University, Ottawa, Canada, In preparation. Can be made available to the referees if needed
Piatetsky-Shapiro G., Connell Ch. Accurate estimation of the number of tuples satisfying a condition. In: Proceedings of ACM SIGMOD Conference, 1984, pp 256 – 276
Thiyagarajah M. Ph.D. Thesis — In preparation, School of Computer Science, Carleton University, Ottawa, Canada
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag London Limited
About this paper
Cite this paper
Thiyagarajah, M., Oommen, B.J. (1999). Prototype Validation of the Rectangular Attribute Cardinality Map for Query Optimization in Database Systems. In: Abramowicz, W., Orlowska, M.E. (eds) BIS ’99. Springer, London. https://doi.org/10.1007/978-1-4471-0875-7_21
Download citation
DOI: https://doi.org/10.1007/978-1-4471-0875-7_21
Publisher Name: Springer, London
Print ISBN: 978-1-85233-167-2
Online ISBN: 978-1-4471-0875-7
eBook Packages: Springer Book Archive