Spatial joins using R-trees: Breadth-first traversal with global optimizations

Proceedings of the 23rd International Conference on Very Large Databases, VLDB 1997

Volumn , Issue , 1997, Pages 396-405

  Huang, Yun Wu ^a   Jing, Ning ^b   Rundensteiner, Elke A ^c  

^a IBM T J WATSON RESEARCH CENTER   (United States)

^b Changsha Institute of Technology   (United States)

^c WORCESTER POLYTECHNIC INSTITUTE   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

GLOBAL OPTIMIZATION;

BREADTH-FIRST TRAVERSAL; BUFFER MANAGEMENT; EXPERIMENTAL EVALUATION; INTERMEDIATE JOIN INDEX; MEMORY MANAGEMENT; OPTIMIZATION STRATEGY; PERFORMANCE COMPARISON; STATE-OF-THE-ART APPROACH;

DECISION TREES;

EID: 84994130833     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (18)

1. Bayer, R. and McCreight, E., "Organization and Maintenance of Large Ordered Indexes", Acta Informatica, Vol. 1, No. 3, 1972, pp. 173-189.
2. Bechmann, N., Kriegel, H., Schneider, R., and Seeger, B., "The R-tree: An Efficient and Robust Access Method for Points and Rectangles", Proc. of the 1990 ACM SIGMOD Int. Conf. on Management of Data, May 1990, pp. 322-332.
3. Brinkhoff, T., Kriegel, H., and Seeger, B., "Efficient Processing of Spatial Joins Using R-trees", Proc. of the 1993 ACM SIGMOD Int. Conf. on Management of Data, 1993, pp. 237-246.
4. Bureau of Census., "Tiger/Lines Precensus Files: 1990 Technical Documentation", Technical report, Bureau of Census, Washington, D.C., 1989.
5. Faloutsos, C. and Kamel, I. "On Packing R-tree," Proc. of the CIKM, 1993, pp. 490-499.
6. Gunther, O., "Efficient Computation of Spatial Joins," Proc. of the 9th Int. Conf. on Data Eng., 1993, pp. 50-59.
7. Guttman, A., "R-tree: a dynamic index structure for spatial searching", Proc. of the 1984 ACM SIGMOD Int. Conf. on Management of Data, 1984, pp. 45-57.
8. Huang, Y.W., Jing, N., and Rundensteiner, E.A., "BFRJ: Global Optimization of Spatial Joins Using R-trees," Dept. of Computer Science, Worcester Polytechnic Institute, Tech. Report WPI-CS-TR-97-5, Jan. 1997.
9. Huang, Y.W., Jing N. and Rundensteiner, E. A., "Integrated Query Processing Strategies for Spatial Path Queries," IEEE Int. Conf. on Data Engineering, Birmingham, UK, April 1997.
10. Huang, Y.W., Jones, M. and Rundensteiner, E. A., "Improving Spatial Intersect Joins Using Sympolic Intersect Detection," 5th Int. Symp. on Large Spatial Databases, Berlin, Germany, 1997.
11. Huang, Y.W., Jing N. and Rundensteiner, E. A., "A Cost Model for Estimating the Performance of Spatial Joins Using R-trees," 9th Int. Conf. on Scientific and Statistical Database Management, Olympia, Washington, Aug. 1997.
12. Lo, M.L. and Ravishankar, C.V., "Spatial Hash-Joins," Proc. of the 1996 ACM SIGMOD Int. Conf. on Management of Data, June 1996, pp. 247-258.
13. Nievergelt, J. and Hinterberger, H., "The Grid File: A Adaptable, Symmetric Multikey File Structure", ACM Transactions on Database Systems, Vol. 9, No. 1, Mar. 1984, pp. 39-71.
14. Orenstein, J.A., "Spatial Query Processing in an Object-Oriented Database System", Proc. of the 1986 ACM SIGMOD Int. Conf. on Management of Data, 1986.
15. Patel, J.M. and DeWitt, D.J., "Partition Based Spatial-Merge Join," Proc. of the 1996 ACM SIGMOD Int. Conf. on Management of Data, June 1996, pp. 259-270.
16. Rotem, D., "Spatial Join Indices," IEEE 7th Int. Conf. on Data Engineering, 1991, pp. 500-509.
17. Seagate Corporation, "Performance Specifications for Barracuda 2LP Family Disk Drives," http://www.seagate.com, 1996.
18. Sellis, T., Roussopoulos, N. k, Faloutsos, C, "The #+-Tree: A Dynamic Index for Multidimensional Objects," Proc. of the VLDB Conf., Brighton, England, 1987, pp. 3-17.