한국정보과학회논문지:데이타베이스 (Journal of KIISE:Databases)

한국정보과학회 (Korean Institute of Information Scientists and Engineers)
권호 표지

다중 공간 조인의 병렬 처리

Parallel Processing of Multi-Way Spatial Join

  • 발행 : 2000.06.30
PDF 다운로드
⟨ 이전 논문 다음 논문 ⟩

초록

GIS에서 사용하는 다중 공간 조인은 두 개 이상의 공간 조인이 중첩된 표현이다. 이는 공간 조인에 비해 보다 많은 수행 사간을 필요로 하는데 이를 빠르게 처리하기 위한 병렬화 알고리즘에 대한 연구가 없었다. 이 논문에서는 다중 공간 조인을 다중 공간 여과와 다중 공간 정제로 나누어서 병렬화한다. 그리고, 정제 단계에서 효율적인 정제 수행을 위해 2단계 실행 방법을 제시하는데, 첫번째가 다중 공간 여과의 결과인 후보 객체 테이블에서 발생하는 객체 및 연산의 중복을 제거하기 위한 그래프 생성이고, 두번째가 그래프의 분할에 의한 병렬 정제이다. 그래프에 의한 정제가 그렇지 않은 방법에 비해 매우 높은 성능 향상을 보였으며 병렬 정제를 위한 태스크 생성 방법은 객체를 정점으로 표현하는 그래프에서의 중복 최소화 분할방법이 가장 좋은 성능을 나타내었다.

Multi-way spatial join is a nested expression of two or more spatial joins. It costs much to process multi-way spatial join, but there have not still reported the scheme of parallel processing of multi-way spatial join. In this paper, parallel processing of multi-way spatial join consists of parallel multi-way spatial filter and parallel spatial refinement. Parallel spatial refinement is executed by the following two steps. The first is the generation of a graph used for reducing duplication of both spatial objects and spatial operations from pairs candidate object table that are the results of multi-way spatial filter. The second is the parallel spatial refinement using that graph. Refinement using the graph is proved to be more efficient than the others. In task creation for parallel refinement, minimum duplication partitioning of the Spatial_Obicct_On_Node graph shows best performance.

키워드

참고문헌

  1. M.L. Lo, C.V. Ravishankar, The Design and Implementation of Seeded Trees : An efficient Method for Spatial Joins, IEEE Transactions of Knowledgement and Data Engineering, Vol 10 No 1 pp 136-152, 1998 https://doi.org/10.1109/69.667097
  2. T. Brinkhoff, H.P. Kriegel, B. Seeger, Efficient Processing of Spatial Joins Using R-Trees, Proc. ACM SIGMOD Int. Conf. pp 237-246, 1993 https://doi.org/10.1145/170036.170075
  3. T. Brinkhoff, H.P. Kriegel, B. Seeger, Parallel Processing of Spatial Joins Using R-Trees, Proc. 12th IEEE Data Engineering pp258-265, 1996 https://doi.org/10.1109/ICDE.1996.492114
  4. Erik g. Hoel, Hanan Samet, Data-Parallel Spatial Join algorithms, International Conference on Parallel Processing, 1994, pp227-234
  5. H. Veenhof Processing Multi-Way Spatial Joins, CTIT Ph.D-thesis senes no. 97-15, ISBN 90-365-1002-3, September 1997
  6. W. Hong and M. Stonebraker. Optimization of Parallel query Execution Plans In XPRS, Proceedings of the 1st Conference on Parallel and Distributed Information Systems, pp218-225, December 1991 https://doi.org/10.1109/PDIS.1991.183106
  7. D.J. DeWitt and R. Gerber, Multiprocessor Hash-Based Join Algorithms, Proc. 11th Int'l conf. Very large Data Bases, pp. 151-162, August 1985
  8. H. Lu, K.L. Tan, and M.-C Shan, Hash-Based join Algorihtms for Multiprocessor Computers with Shared Memory Proc. 16th Int'l Conf. Very Large Data Bases, pp. 198-209, August 1990
  9. J. Richardson, H. Lu, and K. Mikkilineni, Design and Evaluation of Parallel Pipelined Join Algorithms Proc ACM SIGMOD pp. 399-409, May 1987 https://doi.org/10.1145/38714.38756
  10. D. Schneider and D.J. DeWitt, A Performance Evaluation of Four Parallel Join Algorihtms in a Shared-Nothing Multiprocessor Environment, Proc. ACM SIGMOD pp. 110-121, 1989 https://doi.org/10.1145/67544.66937
  11. H. Lu, M.-C Shan, K.L Tan, Optimization of Multi-Way Join Queries for Parallel Execution, Proceedings of 17th International Conference on Very Large Data Bases, pp. 549-560. September, 1991
  12. M.S Chen, P.S. Yu, Optimization of Parallel Execution for Multi-Join Queries, IEEE Transactions on Knowledge and Data Engineering, pp 416-428, June 1996 https://doi.org/10.1109/69.506709
  13. A.N. Wilschut, J. Flokstra, P.M.G. Apers Parallel Evaluation of multi-join queries, Proc. ACM SIGMOD, pp. 115-125, 1995 https://doi.org/10.1145/223784.223803
  14. N. Mamoulis, D. Papadias Integration of Spatial Join Algorithms for Processing Multiple Inputs, Proc. ACM SIGMOD, pp. 1-12, June 1999 https://doi.org/10.1145/304182.304183
  15. D. Papadias, N, Mamoulis, Y. Theodoridis Processing and Optimization of Multiway Spatial Joins Using R-trees, Proceedings of 18th Symposium on Principles of Database Systems, pp.44-55, March 1999 https://doi.org/10.1145/303976.303981
  16. M. stonebraker, J. Frew, K. Gardels, J. Meredith The Sequoia 2000 Storage Benchmark Proc. ACM SIGMOD, pp. 2-11, May 1993 https://doi.org/10.1145/170036.170038