Efficient Processing of Spatial Joins Using R-trees

ACM SIGMOD Record

Volumn 22, Issue 2, 1993, Pages 237-246

  Brinkhoff, Thomas ^a   Kriegel, Hans Peter ^a   Seeger, Bernhard ^a  

^a UNIVERSITY OF MUNICH   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMS; BUFFER CIRCUITS; DATA PROCESSING; DATABASE SYSTEMS; PERFORMANCE; QUERY LANGUAGES;

ACCESS METHOD; EXECUTION TIME; INPUT/OUTPUT TIME; R TREES; SPATIAL DATABASE SYSTEMS; SPATIAL JOINS; SPATIAL QUERIES;

DATA STRUCTURES;

JOIN PROCESSING; ORDERS OF MAGNITUDE; PERFORMANCE; PERFORMANCE COMPARISON; R-TREE FAMILIES; R-TREES; SPATIAL JOIN; SPATIAL OBJECTS; SPATIAL QUERIES; SUPERLINEAR;

EID: 0027621672     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/170036.170075     Document Type: Article

References (24)

1. Becker, L. A.: ‘A New Algorithm and a Cost Model for Join Processing with Grid Files’, PhD-thesis, University of Siegen, 1992.
2. Beckmann N., Kriegel H.-P., Schneider R., Seeger B.: ‘The R-tree: An Efficient and Robust Access Method for Points and Rectangles’, Proc. ACM SIGMOD Int. Conf. on Management of Data, Atlantic City, N.J., 1990, pp. 322-331.
3. Burrough P. A.: ‘Principles of Geographical Information Systems for Land Resources Assessment’, Oxford University Press, 1986.
4. Bureau of the Census: ‘Tiger/Line Precensus Files: 1990 technical documentation’, Bureau of the Census, Washington, DC, 1989.
5. Bentley J.L., Wood D.: ‘An Optimal Worst Case Algorithm for Reporting Intersections of Rectangles’, IEEE Trans, on Computers, Vol. C-29, No. 7, 1980, pp. 571-577.
6. Faloutsos, C.: ‘Gray Codes for Partial Match and Range Queries’, IEEE Trans, on Software Engineering, Vol. 14, No. 10, 1988, pp. 1381-1393.
7. Fotouhi F., Pramanik S.: ‘Optimal Secondary Storage Access Sequence for Performing Relational Join’, IEEE Trans. on Knowledge and Data Engineering, Vol. 1, No. 3, 1989, pp. 318-328.
8. Gargantini, I.: ‘An Effective Way to Represent Quadtrees’, Comm. of the ACM, Vol. 25, No. 12, 1982, pp. 905-910.
9. Günther, O.: ‘Efficient Computations of Spatial Joins’, Proc. 9th Int. Conf. on Data Engineering, Vienna, Austria, 1993.
10. Guttman A.: ‘R-trees: A Dynamic Index Structure for Spatial Searching’, Proc. ACM SIGMOD Int. Conf. on Management of Data, Boston, MA., 1984, pp. 47-57.
11. Harada L., Nakano M., Kitsuregawa M., Takagi M.: ‘Query Processing Methods for Multi-Attribute Clustered Relations’, Proc. 16th Int. Conf. on Very Large Data Bases, Brisbane, 1990, pp. 59-70.
12. Hoel E. G., Samet H.: ‘A Qualitative Comparison Study of Data Structures for Large Line Segment Databases’, Proc. ACM SIGMOD Int. Conf. on Management of Data, San Diego, CA., 1992, pp. 205-214.
13. Kriegel H.-P., Brinkhoff T., Schneider R.: ‘An Efficient Map Overlay Algorithm based on Spatial Access Methods and Computational Geometry’, Proc. Int. Workshop on Database Management Systems for Geographical Applications, Capri, Italy, 1991, in: Geographic Database Management Systems, Springer, 1992, pp. 194-211.
14. Kamel, I., Faloutsos, C.: ‘Parallel R-Trees’, Proc. ACM SIGMOD Int. Conf. on Management of Data, San Diego, CA., 1992, pp. 195-204.
15. Mishra P., Eich M.H.: ‘Join Processing in Relational Databases’, ACM Computing Surveys, Vol. 24, No. 1, 1992, pp. 63-113.
16. Merret T., Kambayashi Y., Yasuura H.: ‘Scheduling of Page-Fetches in Join-Operations’, Proc. 7th Int. Conf. on Very Large Data Bases, Cannes, 1981, pp. 488-498.
17. Orenstein J. A., Merrett T. H.: ‘A Class of Data Structures for Associative Searching’, Proc. 3rd ACM SIGACT/SIGMOD Symp. on Principles of Database Systems, 1984, pp. 181-190.
18. Orenstein J. A.: ‘Spatial Query Processing in an Object-Oriented Database System’, Proc. ACM SIGMOD Int. Conf. on Management of Data, Washington D.C., 1986, pp. 326-333.
19. Orenstein J. A.: ‘Redundancy in Spatial Databases’, Proc. ACM SIGMOD Int. Conf. on Management of Data, Portland, Oreg., 1989, pp. 294-305.
20. Preparata F. P., Shamos M. I.: ‘Computational Geometry’, Springer, 1988.
21. Rotem D.: ‘Spatial Join Indices’, Proc. Int. Conf. on Data Engineering, 1991, pp. 500-509.
22. Samet H.: ‘The Design and Analysis of Spatial Data Structures’, Addison Wesley, 1990.
23. Stonebraker M., Rowe L., Hirohama M.: ‘The Implementation of POSTGRES’, IEEE Trans. on Knowledge and Data Engineering, Vol. 2, No. 1, 1990, pp. 125-142.
24. Statistical Office of the European Communities: ‘Regions’, 1990.