Skip to main content
SpringerLink
Log in

On Estimating Result Sizes of Multi-way Spatial Joins

  • Conference paper
  • First Online:
Computational Science and Its Applications — ICCSA 2003 (ICCSA 2003)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2669))

Included in the following conference series:

  • 1463 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. S. Acharya, V. Poosala and S. Ramaswamy, “Selectivity Estimation in Spatial Databases,” Proc. of ACM SIGMOD, 1999.

    Google Scholar 

  2. 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.

    Google Scholar 

  3. Y. E. Ioannidis and S. Christodoulakis, “On the Propagation of Errors in the Size of Join Results, ” Proc. of ACM SIGMOD, 268–277, 1991.

    Google Scholar 

  4. I. Kamel and C. Faloutsos, “On Packing R-tree,” Proc. of CIKM, 490–499, 1993.

    Google Scholar 

  5. 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.

    Google Scholar 

  6. D. Papadias, N. Mamoulis and Y. Theodoridis, “Constraint-Based Processing of Multiway Spatial Joins,” Algorithmica, Vol. 30, No. 2, 188–215, 2001.

    Article  MATH  MathSciNet  Google Scholar 

  7. 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.

    Google Scholar 

  8. H.-H. Park, Early Separated Filter/Refinement Strategies and Multi-way Spatial Joins for Spatial Query Optimization, Ph.D Thesis, KAIST, 2001.

    Google Scholar 

  9. Y. Theodoridis, E. Stefanakis and T. Sellis, “Cost Models for Join Queries in Spatial Databases,” Proc. of IEEE ICDE, 476–483, 1998.

    Google Scholar 

  10. U.S. Bureau of the Census, Washington, DC., “TIGER/Line Files, 1995, Technical Documentation.”

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. School of Electrical and Electronics Engineering, Chung-Ang University, 221, HukSuk-Dong, DongJak-Ku, Seoul, 156-756, Korea

    Ho-Hyun Park

Authors
  1. Ho-Hyun Park
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Army High Performance Computing Research Center, USA University of Minessota Department of Computer Science and Engineering, MN, 55455, USA

    Vipin Kumar

  2. Department of Computer Science, University of Calgary, Calgary, AB, T2N1N4, Canada

    Marina L. Gavrilova

  3. Heuchera Technologies Inc., 122 9251-8Yonge Street, Richmond Hill, ON, Canada, L4C 9T3

    Chih Jeng Kenneth Tan

  4. School of Computer Science, The Queen’s University of Belfast, Belfast, BT7 1NN, Northern Ireland UK

    Chih Jeng Kenneth Tan

  5. Département d’informatique et de recherche opérationelle Montréal, Université de Montréal, Québec, H3C 3J7, Canada

    Pierre L’Ecuyer

Rights and permissions

Reprints 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

Publish with us

Policies and ethics

Search

Navigation