Abstract
In a real life environment, spatial data is highly skewed. In general, there are two kinds of skews in spatial data. One is the placement skew and the other is the area skew. This paper introduces methods and the characteristics of estimating the accurate result sizes of the multi-way join for the area skewed spatial data. Especially, this paper describes the number and sort of the statistics which the optimizer should keep in order to calculate the multi-way join result size. Experimental results show our approach generally provides accurate estimation for the multi-way join for the area skewed spatial data.
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
S. Acharya, V. Poosala and S. Ramaswamy, “Selectivity Estimation in Spatial Databases,” Proc. of ACM SIGMOD, 1999.
Y.-W. Huang, N. Jing and E. A. Rundensteiner, “A Cost Model for Estimating the Performance of Spatial Joins Using R-trees,” Proc. of SSDBMS, 1997.
Y. E. Ioannidis and S. Christodoulakis, “On the Propagation of Errors in the Size of Join Results, ” Proc. of ACM SIGMOD, 268–277, 1991.
I. Kamel and C. Faloutsos, “On Packing R-tree,” Proc. of CIKM, 490–499, 1993.
B. Pagel, H. Six, H. Toben and P. Widmayer, “Towards an Analysis of Range Query Performance in Spatial Data Structures,” Proc. of ACM PODS, 214–221, 1993.
D. Papadias, N. Mamoulis and Y. Theodoridis, “Constraint-Based Processing of Multiway Spatial Joins,” Algorithmica, Vol. 30, No. 2, 188–215, 2001.
H.-H. Park, G.-H. Cha and C.-W. Chung, “Multi-way Spatial Joins Using R-trees: Methodology and Performance Evaluation,” Proc. of SSD, 229–250, Lecture Notes in Computer Science 1651, Springer-Verlag, 1999.
H.-H. Park, Early Separated Filter/Refinement Strategies and Multi-way Spatial Joins for Spatial Query Optimization, Ph.D Thesis, KAIST, 2001.
Y. Theodoridis, E. Stefanakis and T. Sellis, “Cost Models for Join Queries in Spatial Databases,” Proc. of IEEE ICDE, 476–483, 1998.
U.S. Bureau of the Census, Washington, DC., “TIGER/Line Files, 1995, Technical Documentation.”
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Park, HH. (2003). On Estimating Result Sizes of Multi-way Spatial Joins. In: Kumar, V., Gavrilova, M.L., Tan, C.J.K., L’Ecuyer, P. (eds) Computational Science and Its Applications — ICCSA 2003. ICCSA 2003. Lecture Notes in Computer Science, vol 2669. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44842-X_87
Download citation
DOI: https://doi.org/10.1007/3-540-44842-X_87
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40156-8
Online ISBN: 978-3-540-44842-6
eBook Packages: Springer Book Archive