Exploiting spatial indexes for semijoin-based join processing in distributed spatial databases

IEEE Transactions on Knowledge and Data Engineering

Volumn 12, Issue 6, 2000, Pages 920-937

  Tan, Kian Lee ^a,b   Ooi, Beng Chin ^a,b   Abel, David J ^c  

^a IEEE   (Singapore)

^b NATIONAL UNIVERSITY OF SINGAPORE   (Singapore)

^c CSIRO   (Australia)

Author keywords

[No Author keywords available]

Indexed keywords

DISTRIBUTED SPATIAL DATABASE SYSTEMS; R-TREE; SPATIAL INDEXES; SPATIAL SEMIJOIN;

ALGORITHMS; APPROXIMATION THEORY; INDEXING (OF INFORMATION); PERFORMANCE; QUERY LANGUAGES; RESPONSE TIME (COMPUTER SYSTEMS); TREES (MATHEMATICS);

DISTRIBUTED DATABASE SYSTEMS;

EID: 0034314078     PISSN: 10414347     EISSN: None     Source Type: Journal    
DOI: 10.1109/69.895802     Document Type: Article

References (37)

1. +-tree Structure for Large Quadtrees," Int'l J. Computer Vision, Graphics, and Image Processing, vol. 27, pp. 19-31, 1983.
2. D.J. Abel, "Some Evolutionary Paths for Spatial Database," Proc. Int'l Symp. Next Generation Database Systems and Applications, pp. 1-10, 1993.
3. D.J. Abel, B.C. Ooi, R. Power, K.L. Tan, G. Williams, and X. Zhou, "The Virtual Database: A Tool for Migration from Legacy Lis," Proc. Australasian Urban and Regional Information Systems Assoc. (AURISA' 94), pp. 117-126, 1994.
4. D.J. Abel, B.C. Ooi, K.L. Tan, R. Power, and J.X. Yu, "Spatial Join Strategies in Distributed Spatial Dbms," Proc. Fourth Int'l Symp. Large Spatial Databases, pp. 348-367, Aug. 1995.
5. L. Arge, O. Procopiuc, S. Ramaswamy, T. Suel, and J. Vitter, "Scalable Sweeping-Based Spatial Join," Proc. Int'l Conf. Very Large Data Bases, pp. 570-581, 1998.
6. P. Bernstein and D.M. Chiu, "Using Semi-Joins to Solve Relational Queries," J. ACM, vol. 28, 1981.
7. T. Brinkhoff, H. Kriegel, R. Schneider, and B. Seeger, "The r*-tree: An Efficient and Robust Access Method for Points and Rectangles," Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 322-331, 1990.
8. T. Brinkhoff, H. Kriegel, R. Schneider, and B. Seeger, "Multi-Step Processing of Spatial Joins," Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 197-208, 1994.
9. T. Brinkhoff, H. Kriegel, and B. Seeger, "Efficient Processing of Spatial Joins Using R-Trees," Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 237-246, 1993.
10. J.L. Smith and D.J. Abel, "A Data Structure and Query Algorithm for a Database of a Real Entities," Australian Computer J., vol. 16, no. 4, pp. 147-154, 1984.
11. V. Gaede and O. Gunther, "Processing Joins with User-Defined Functions," Technical Report TR-94-103, Institut für Wirtschaftsinformatik, Humboldt-Universitat zu Berlin, 1994.
12. O. Gunther, "Efficient Computation of Spatial Joins," Proc. IEEE Int'l Conf. Data Eng., pp. 50-59, 1993.
13. A. Guttman, "R-trees: A Dynamic Index Structure for Spatial Searching," Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 47-57, 1984.
14. Y-W Huang, N. Jing, and E. A. Rundensteiner, "Spatial Joins Using R-Trees: Breadth-First Traversal with Global Optimizations," Proc. Int'l Conf. Very Large Data Bases, pp. 396-405, 1997.
15. N. Koudas and K.C. Sevcik, "Size Separation Spatial Joins," Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 324-335, 1997.
16. S. Leutenegger and M. Lopez, "The Effect of Buffering on the Performance of R-Trees," Proc. Intl Conf. Data Eng., pp. 164-171, 1998.
17. M-L. Lo and C.V. Ravishankar, "Spatial Joins Using Seeded Trees," Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 209-220, 1994.
18. M-L. Lo and C.V. Ravishankar, "Spatial Hash-Joins," Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 247-258, 1996.
19. H. Lu, R. Luo, and B.C. Ooi, "Spatial Joins by Precomputation of Approximation," Proc. Sixth Australasian Database Conf., pp. 132-142, 1995.
20. W. Lu and J. Han, "Distance-Associated Join Indices for Spatial Range Search," Proc. Ninth Int'l Conf. Data Eng., pp. 284-292, 1992.
21. G.M. Morton, "A Computer Oriented Geodetic Data Base and a New Technique in File Sequencing," technical report, 1966.
22. J. Nievergelt, H. Hinterberger, and K.C. Sevcik, "The Grid File: An Adaptable, Symmetric Multikey File Structure," ACM Trans. Database Systems, vol. 9, no. 3, 1984.
23. J.A. Orenstein, "Spatial Query Processing in an Object-Oriented Database System," Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 326-333, 1986.
24. J.A. Orenstein, "A Comparison of Spatial Query Processing Techniques for Naive and Parameter Spaces," Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 343-352, 1990.
25. J.A. Orenstein, "An Algorithm for Computing the Overlay of K-Dimensional Spaces," Proc. Second Int'l Symp. Large Spatial Databases, pp. 381-400, 1991.
26. M.T. Ozsu and P. Valduriez, Principles of Distributed Database Systems. Prentice-Hall, 1991.
27. J.M. Patel and D. DeWitt, "Partition-Based Spatial Merge Join," Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 259-270, 1996.
28. D. Rotem, "Spatial Join Indices," Proc. Int'l Conf. Data Eng., pp. 500-509, 1991.
29. H. Samet, The Design and Analysis of Spatial Data Structures. Addison-Wesley, 1990.
30. H.J. Schek, A.P. Sheth, B. D. Czejdo, eds., Proc. Third Workshop Research Issues in Data Eng.: Interoperability in Multidatabase Systems. IEEE CS Press, 1993.
31. +-tree: A Dynamic Index for Multi-Dimensional Objects," Proc. Int'l. Conf. Very Large Data Bases, pp. 507-518, 1987.
32. K.C. Sevcik and N. Koudas, "Filter Trees for Managing Spatial Data Over a Range of size Granularities," Proc. Int'l Conf. Very Large Data Bases, pp. 16-27, 1996.
33. Tomlinson Associates Ltd., GIS Planning - Land Status and Assets Management. Office of Geographic Data Coordination, 1993.
34. P. Valduriez, "Join Indices," ACM Trans. Database Systems, vol. 12, no. 2, 1987.
35. H.M. Veenhof, P.M.G. Apers, and M.A.W. Houtsma, "Optimization of N-Way Spatial Joins Using Filters," Proc. 13th British Nat'l Conf. Databases, 1995.
36. H.M. Veenhof, M.A.W. Houtsma, and P.M.G. Apers, "Query Optimization for Gis Using Filters," Proc. ACM Workshop Advances in Geographic Information Systems, 1993.
37. C.C. Yu and C.C. Chang, "Distributed Query Processing," ACM Computing Surveys, vol. 16, no. 4, 1984.