Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2003.10D.4.591

Efficient Parallel Spatial Join Processing Method in a Shared-Nothing Database Cluster System  

Chung, Warn-Ill (인하대학교 대학원 전자계산공학과)
Lee, Chung-Ho (인하대학교 지능형 GIS 연구센터)
Bae, Hae-Young (인하대학교 컴퓨터공학과)
Publication Information
The KIPS Transactions:PartD / v.10D, no.4, 2003 , pp. 591-602 More about this Journal
Abstract
Delay and discontinuance phenomenon of service are cause by sudden increase of the network communication amount and the quantity consumed of resources when Internet users are driven excessively to a conventional single large database sewer. To solve these problems, spatial database cluster consisted of several single nodes on high-speed network to offer high-performance is risen. But, research about spatial join operation that can reduce the performance of whole system in case process at single node is not achieved. So, in this paper, we propose efficient parallel spatial join processing method in a spatial database cluster system that uses data partitions and replications method that considers the characteristics of space data. Since proposed method does not need the creation step and the assignment step of tasks, and does not occur additional message transmission between cluster nodes that appear in existent parallel spatial join method, it shows performance improvement of 23% than the conventional parallel R-tree spatial join for a shared-nothing architecture about expensive spatial join queries. Also, It can minimize the response time to user because it removes redundant refinement operation at each cluster node.
Keywords
Spatial Database Cluster; Parallel Spatial Join; Spatial Index;
Citations & Related Records
Times Cited By KSCI : 3  (Citation Analysis)
연도 인용수 순위
1 Chan Gu Li, Load Balancing Method using Proximity of Query Region in Web GIS Clustering System, Master Thesis, Inha Univ., 2002
2 H. J. LeeParallel Pipelined Spatial Join Method for Efficient Query Processing In Distributed Spatial Database Systems, Master Thesis, Inha Univ., 2002
3 T. Brinkhoff, H. P. Kriegel and B. Seeger, Parallel Processing of Spatial Joins using R-trees, Proceedings of the 12th International Conference on Data Engineering, New Orleans, Louisiana, USA, pp.284-292, 1996   DOI
4 Y. I. Jang, C. H. Lee, J. D. Lee and H. Y. Bae, Web GIS Cluster Design with Extended Workload-Aware Request Distribution(WARD) Strategy, Proceedings of KISS, pp. 304-306, 2001   과학기술학회마을
5 T. Brinkhoff, H. P.Kriegel, R. Schneider and B. Seeger, Multi-Step Proceesing of Spatial Joins, Proceedings of the ACM SIGMOD International Conference on Management of Data, pp.197-208, 1994   DOI
6 Jin Deog Kim et al., 'A Study on Task Allocation of Parallel Spatial Joins using Fixed Grids', KIPS Journal, Vol.8-D, No.4, pp.347-360, 2001   과학기술학회마을
7 K. Tamura, Y. Nakano, K. Kaneko and A. Makinouchi, The Parallel Processing of Spatial Selection for Very Large GeoSpatial Databases, ICPADS 2001, pp. 26-30, 2001   DOI
8 Y. D. Seo, Implementation and Performance Evaluation of Parallel Spatial Join Algorithm using R-tree, Master Thesis, Pusan National Univ., 1999
9 T. Brinkhoff and H. P. Kriegel, Efficient Processing of Spatial Joins Using R-trees, Proc. ACM SIGMOD International Conference On Management of Data, Washington, DC. pp.237-246, 1993   DOI
10 B. Kemme, Database Replication for Clusters of Workstations, Ph.D thesis, Department of Computer Science, ETH Zurich, Switzerland, 2000
11 E. G. Hoel and H. Samet, 'Data-Parallel Spatial Join Algorithms', Proceedings of International Conference on Parallel Processing, pp.227-234, 1994   DOI
12 L. Mutenda, M. Kitsuregawa, Parallel R-tree Spatial Join for a Shared-Nothing Architecture, 1999 Int'l Symposium on Database Applications, pp.429-436, 1999   DOI
13 H. P. Kriegel, T. Brinkhoff and Ralf Schneider, 'Efficient Spatial Query Processing in Geographic Database Systm', Data Engineering Bulletin 16(3), pp.10-15, 1993
14 Chung-Ho Lee, A Partial Replication Protocol and a Dynamically Scaling Method for Database Cluster Systems, Ph.D Thesis, Inha Univ., 2003
15 Gunter von Bultzingsloewen, 'Optimizing SQL Queries for Parallel Execution', SIGMOD RECORD, Vol.18, No.4, Dec., 1989   DOI
16 D. Ries and R. Epstein, Evaluation of distribution criteria for distributed database system, UBC/ERL Technical Report M78/22, UC Berkeley, May, 1978
17 J. M. Patel and D. J. DeWitt, Partition Based Spatial-Merge Join, Proc. of ACM SIGMOD, 1996   DOI
18 M. L. Lee, M. Kitsuregawa, B. C. Ooi, K. Tan, and A. Mondal, 'Towards Self-Tuning Data Placement in Parallel Database Systmes', Proceedings of the ACM SIGMOD Int'l Conf. on Management of Data, Dallas, Taxas, pp. 225-236, 2000   DOI
19 L. Arge, O. Procepiue, B. S. Rarnaswamy, T. Suel and J. S. Vitter, 'Scalable Sweeping-Based Spatial Join', Proc. of VLDG conf., 1998