Skip to main content

A Parallel Spatial Join Processing for Distributed Spatial Databases

  • Conference paper
  • First Online:
Flexible Query Answering Systems (FQAS 2002)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 2522))

Included in the following conference series:

Abstract

In recent years, there have been needs of accessing spatial data from distributed and preexisting spatial database systems interconnected through a network. In a distributed environment, spatial joins for two spatial relations residing at geographically separated sites are expensive in terms of computation and transmission cost because of the large size and complexity of spatial data. Previous distributed algorithm based on the spatial semijoin has accomplished performance improvements by eliminating objects before transmission to reduce both transmission and local processing costs. But with a widespread of a high bandwidth data transmission, the parallelism through data redistribution may improve the performance of spatial joins in spite of additional transmission costs. Hence, we propose a parallel spatial join processing for distributed spatial databases. We apply the task distribution method minimizing the data transmission and the solution for task distribution using a graph partitioning method. In experiments, we showed that the proposed method provides useful reductions in the cost of evaluating a join.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.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. Wang, F.: A Distributed Geographic Information System on the Common Object Request Broker Architecture. GeoInformatica, Vol. 4, No.1, (2000) 89–115

    Article  MATH  Google Scholar 

  2. Abel, D.J., Ooi, B.C., Tan, K.L., Power, R., Yu, and J.X.: Spatial Join Strategies in Distributed Spatial DBMS. Proceedings of 4th International Symposium on Large Spatial Databases (SSD), Portland, USA, (1995) 348–367

    Google Scholar 

  3. Tan, K.L., Ooi, B.C., and Abel, D.J.: Exploiting Spatial Indexes for Semijoin-Based Join Processing in Distributed Spatial Databases. IEEE Transactions on Knowledge and Data Engineering, Vol.12, No.6, (2000) 920–936

    Article  Google Scholar 

  4. Park, C. and Seret, D.: Parallel Join Processing in Broadcast Lacal Area Network, Proceedings of the IEEE Region 10 Conference (TENCON), Seoul, (1987)

    Google Scholar 

  5. Wond, E. and Katz, R.H., Distributing a Database for Parallelism, Proceedings of the ACM-SIGMOD International conference on Management of Data, (1983)

    Google Scholar 

  6. Brinkhoff, T., Kriegel, H.P., and Seeger, B.: Efficient Processing of Spatial Joins Using Rtrees. Proceedings of ACM SIGMOD Conf., (1993)

    Google Scholar 

  7. Brinkhoff, T. et al.: Multi-Step Processing of Spatial Joins, Proceedings of the ACM SIGMOD International Conference on Management of Data, Minneapolis, Minnesota, (1994) 197–208

    Google Scholar 

  8. Zhou, X., et al.: Data Partitioning for Parallel Spatial Join Processing, Proceedings of 5th International Symposium on Large Spatial Databases (SSD), (1997) 178–196

    Google Scholar 

  9. Zhou, X., Abel, D.J., and Truffet, D.: Data Partitioning for Parallel Spatial Join Processing. GeoInformatica (1998) 175–204

    Google Scholar 

  10. T. Brinkhoff, H.P. Kriegel and B. Seeger: Parallel Processing of Spatial Joins Using Rtrees, International Conference on Data Engineering, New Orleans, (1996) 258–265

    Google Scholar 

  11. E. G. Hoel and H. Samet: Data-Parallel Primitives for Spatial Operations using PMQuadtrees, Proceedings of Computer Architectures for Machine Perception’ 95, Como, Italy, September (dy1995) 266–273

    Google Scholar 

  12. Jin-Deog Kim, Bong-Hee Hong: Parallel Spatial Joins using Grid Files, Proceedings of the Seventh International Conference on Parallel and Distributed Systems (ICPADS’00)

    Google Scholar 

  13. Jin-Deog Kim, Bong-Hee Hong: Parallel Spatial Join Algorithms using Grid Files, Proceedings of the International Symposium on Database Applications in Non-Traditional Environments (DANTE’99), (1999) 226–234

    Google Scholar 

  14. Shekhar, S.,et al.: Declustering and Load-Balancing Methods for Parallelizing GIS, IEEE Transactions on Knowledge and Data Engineering, Volume 10, No.4, (1998) 632–655

    Article  Google Scholar 

  15. Patel, J. M. and Dewitt, D. J.: Partition Based Spatial-Merge Join, Proceedings of ACM SIGMOD International conference on Management of Data (1996)

    Google Scholar 

  16. Patel, J., et al.: Building a scalable geo-Spatial DBMS: Technology, implementation, and Evaluation, Proceedings of ACM SIGMOD International conference on Management of Data, SIGMOD’ 97, (1997)

    Google Scholar 

  17. Stone, H.S.: Multiprocessor scheduling with the aid of network flow algorithms, IEEE Transactions on Software Engineering, vol. SE-3, (1977) 85–93

    Article  Google Scholar 

  18. Ford, L.R., and Fulkerson, D.R.: Flows in Networks, Princeton, NJ: Princeton Univ. Press, (1962)

    MATH  Google Scholar 

  19. Borland Corporation, Visibroker Home page. http://www.borland.com/bes/visibroker/.

  20. Sequoia 2000 FTP server Home page. http://www.s2k-ftp.cs.berkeley.edu:8000/.

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2002 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Kang, MS., Ko, SK., Koh, K., Choy, YC. (2002). A Parallel Spatial Join Processing for Distributed Spatial Databases. In: Carbonell, J.G., Siekmann, J., Andreasen, T., Christiansen, H., Motro, A., Legind Larsen, H. (eds) Flexible Query Answering Systems. FQAS 2002. Lecture Notes in Computer Science(), vol 2522. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-36109-X_17

Download citation

  • DOI: https://doi.org/10.1007/3-540-36109-X_17

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-00074-7

  • Online ISBN: 978-3-540-36109-1

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics