A Design of Parallel R-tree on Cluster of Workstations

R-tree is widely used in indexing of multidimensional and spatial data. When it is used in environment of COW (Cluster Of Workstations), to the best of our knowledge it is used in Master-Slave mode or its variants. Under this mode when an entry is accessed, it must be locked. The higher the locked entry in the R-tree, the more transactions will be stopped from accessing all the offspring of it. Therefore the degree of concurrency is paralyzed. Moreover, the Master will become the hotspot in parallel processing which can worsen the overall performance. In this paper we present an upgraded parallel R-tree model which is suitable for the environment of COW. Our parallel R-tree can not only balance the load among processors but also decrease the conflicts of intra-and inter-transactions. We can successfully prevent the emergence of hot spot from accessing the R-tree. The detailed searching algorithm and the load shipping algorithm of this parallel R-tree are given. Lastly we provide experimental results which show that the parallel R-tree performs well as expected.

[1]  Kunihiko Kaneko,et al.  Parallel R-tree search algorithm on DSVM , 1999, Proceedings. 6th International Conference on Advanced Systems for Advanced Applications.

[2]  Leslie G. Valiant,et al.  A bridging model for parallel computation , 1990, CACM.

[3]  David B. Skillicorn,et al.  Questions and Answers about BSP , 1997, Sci. Program..

[4]  Scott T. Leutenegger,et al.  Master-client R-trees: a new parallel R-tree architecture , 1999, Proceedings. Eleventh International Conference on Scientific and Statistical Database Management.

[5]  Antonin Guttman,et al.  R-trees: a dynamic index structure for spatial searching , 1984, SIGMOD '84.

[6]  Michael T. Goodrich,et al.  A bridging model for parallel computation, communication, and I/O , 1996, CSUR.

[7]  Torsten Suel,et al.  BSPlib: The BSP programming library , 1998, Parallel Comput..

[8]  Marcel Kornacker,et al.  High-Concurrency Locking in R-Trees , 1995, VLDB.

[9]  David J. DeWitt,et al.  Parallel database systems: the future of high performance database systems , 1992, CACM.

[10]  Weimin Zheng,et al.  GPR-Tree: a global parallel index structure for multiattribute declustering on cluster of workstations , 1997, Proceedings. Advances in Parallel and Distributed Computing.