Abstract
Access to spatial objects is often required in many nonstandard database applications, such as GIS, VLSI and CAD. In this paper, we examine the R-tree as an index structure, and modify it to allow concurrent accesses. We investigate three different locking methods for concurrency control. The first method uses a single lock to lock the entire tree, allowing concurrent searches but only sequential updates. The second method locks the whole tree only when the splitting or merging of nodes in the tree is required. The third method uses the lock-coupling technique to lock individual nodes of the tree.
We discuss in detail three common user operations, search, insert, and delete, on the R-tree. A system operation, maintain, which may be invoked when there is overflow or underflow at some nodes is also discussed. Concurrency control algorithms using the three locking methods mentioned above are described in this paper. They have also been implemented in the SR distributed programming language. We report on our preliminary results comparing their relative performance.
This work was supported in part by the Natural Sciences and Engineering Research Council of Canada under the Networks of Centres of Excellence Program and in part by the Advanced Systems Institute of British Columbia.
Preview
Unable to display preview. Download preview PDF.
References
G.R. Andrew. The distributed programming language SR, Software-Practice and Experience, Vol. 12, No. 8 (Aug. 1982), pp. 719–754.
R. Bayer and M. Schkolnick. Concurrency of operations on B-trees, Acta Inf., Vol. 9(1977), pp. 1–21.
P. Bernstein, et al., Concurrency Control and Recovery in Database Systems, Addison-Wesley, 1987.
D. Comer. The ubiquitous B-tree, ACM Computer Surveys, Vol. 11, No. 2 (1979), pp. 121–138.
C.S. Ellis. Concurrent search and inserts in 2–3 trees, Acta Inf. Vol. 14, No. 1 (1980), pp. 63–86.
A. Guttman. R-Trees: A dynamic index structure for spatial searching, SIGMOD Record, Vol. 14, No. 2 (June 1984), pp. 47–57.
I. Kamel and C. Faloutsos. Parallel R-trees, CS-TR-2820, UMIACS-TR-92-1, Computer Science Technical Report Series, University of Maryland, College Park, MD, 1992.
E.J. Otoo. Efficient concurrency control protocols for B-tree indexes, SCS-TR-166, Jan. 1990, School of Computer Science, Carleton University, Ottawa, Canada.
H. Samet. Hierarchical representations of collections of small rectangles, ACM Computing Surveys, Vol. 20, No. 4 (Dec. 1988), pp. 271–309.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1993 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Ng, V., Kameda, T. (1993). Concurrent accesses to R-trees. In: Abel, D., Chin Ooi, B. (eds) Advances in Spatial Databases. SSD 1993. Lecture Notes in Computer Science, vol 692. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-56869-7_9
Download citation
DOI: https://doi.org/10.1007/3-540-56869-7_9
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-56869-8
Online ISBN: 978-3-540-47765-5
eBook Packages: Springer Book Archive