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 database systems. In two recent works [7, 8] we proposed (and thoroughly analyzed) 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. This paper reports how the benchmarking of the Rectangular-ACM (R-ACM) and the Trapezoidal-ACM (T-ACM) for query optimization can be achieved. By conducting an extensive set of experiments using the acclaimed TPC-D benchmark queries and database [15], we demonstrate that these new ACM schemes are much more accurate than the traditional histograms for query result size estimation.
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
Christodoulakis, S.: Estimating selectivities in data bases. Technical Report CSRG-136, Computer Science Dept, University of Toronto, (1981)
Christos Faloutsos, Yossi Matias and Avi Silberschatz: Modeling skewed distributions using multifractals and the 80-20 law. Technical Report, Dept. of Computer Science, University of Maryland, (1996)
Yannis Ioannidis and S. Christodoulakis: On the propagation of errors in the size of join results. Proceedings of the ACM-SIGMOD Conference, (1991) 268–277
R. P. Kooi: The optimization of queries in relational databases. Case Western Reserve University, (1980)
Mannino, M.V., Chu, P. and Sager, T.: Statistical profile estimation in database systems. ACM Computing Surveys, (1988) Vol 20 192–221
M. Muralikrishna and David J Dewitt: Equi-depth histograms for estimating selectivity factors for multi-dimensional queries. Proceedings of ACM-SIGMOD Conference, (1988) 28–36
Oommen, B. John and Thiyagarajah, Murali: The Rectangular Attribute Cardinality Map: A New Histogram-like Technique for Query Optimization. School of Computer Science, Carleton University, Ottawa, Canada, TR-99-01, (1999)
Oommen, B. John and Thiyagarajah, Murali: The Trapezoidal Attribute Cardinality Map: A New Histogram-like Technique for Query Optimization. School of Computer Science, Carleton University, Ottawa, Canada, TR-99-04, (1999)
Thiyagarajah, Murali and Oommen, B. John: Prototype Validation of the Trape-zoidal Attribute Cardinality Map for Query Optimization in Database Systems. International Conference on Enterprise Information Systems-ICEIS’99, Setubal, Portugal, (1999)
Thiyagarajah, Murali and Oommen, B. John: Prototype Validation of the Rectangular Attribute Cardinality Map for Query Optimization in Database Systems. International Conference on Business Information Systems-BIS’99, Poznan, Poland, (1999)
Oommen, B. John and Thiyagarajah, Murali: Benchmarking Attribute Cardinality Maps for Database Systems Using the TPC-D Specifications. School of Computer Science, Carleton University, Ottawa, Canada, TR-99-07, (1999)
Oommen, B. John and Thiyagarajah, Murali: The Rectangular Attribute Cardinality Map: A New Histogram-like Technique for Query Optimization. International Database Engineering and Applications Symposium, IDEAS’99, Montreal, Canada, (1999)
Gregory Piatetsky-Shapiro and Charles Connell: Accurate estimation of the number of tuples satisfying a condition. Proceedings of ACM-SIGMOD Conference, 256–276, (1984)
Murali Thiyagarajah: Attribute Cardinality Maps: New Query Result Size Estimation Techniques for Database Systems. PhD Thesis, Carleton University, Ottawa, Canada (1999)
Transaction Processing Council (TPC): TPC-D Benchmark Specification. (1998)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Oommen, B.J., Thiyagarajah, M. (1999). Benchmarking Attribute Cardinality Maps for Database Systems Using the TPC-D Specifications. In: Bench-Capon, T.J., Soda, G., Tjoa, A.M. (eds) Database and Expert Systems Applications. DEXA 1999. Lecture Notes in Computer Science, vol 1677. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48309-8_27
Download citation
DOI: https://doi.org/10.1007/3-540-48309-8_27
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-66448-2
Online ISBN: 978-3-540-48309-0
eBook Packages: Springer Book Archive