Partition Based Spatial - Merge Join

SIGMOD Record (ACM Special Interest Group on Management of Data)

Volumn 25, Issue 2, 1996, Pages 259-270

  Patel, Jignesh M ^a   DeWitt, David J ^a  

^a University of Wisconsin ^*  (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMS; COMPUTATIONAL GEOMETRY; DATA ACQUISITION; GEOGRAPHIC INFORMATION SYSTEMS; QUERY LANGUAGES; RELATIONAL DATABASE SYSTEMS;

DATABASE SYSTEM PARADISE; NESTED LOOPS JOIN ALGORITHM; PARTITION BASED SPATIAL MERGE (PBSM) JOIN; PLANE SWEEPING TECHNIQUES; SPATIAL INDICES;

MERGING;

EID: 0030157411     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/235968.233338     Document Type: Article

References (42)

1. ESRI, Redlands, CA. "ARC/INFO: The World's GIS. An ESR1 White Paper", March 1995.
2. J. L. Bentley. "Multidimensional Binary Search Trees Used for Associative Searching". In Communication of the ACM, volume 18(9), September 1975.
3. J. L. Bentley. "Multidimensional Binary Search Trees in Database Applications". In IEEE Transactions on Software Engineering, volume 5(4), 1979.
4. L. Becker, K. Hinrichs, and U. Finke. "A New Algorithm for Computing Joins With Grid Files". In IEEE Transactions on Knowledge and Data Engineering, 1993.
5. T. Brinkhoff, H. P. Kriegel, and B. Seeger. "Efficient Processing of Spatial Joins Using R-trees". In Proceedings of the 1993 ACM-SICMOD Conference, Washington, DC, May 1993.
6. N. Beckmann, H. P. Kriegel, R. Schneider, and B. Seeger. "The R*-tree: An Efficient and Robust Access Method for Points and Rectangles". In Proceedings of the 1990 ACM-SICMOD Conference, June 1990.
7. T. Brinkhoff, H. P. Kriegel, R. Schneider, and B. Seeger. "Multi - step Processing of Spatial Joins". In Proceedings of the 1994 ACM-SIGMOD Conference, Minneapolis, May 1994.
8. P. A. Burrough. " Principles of Geographic Information Systems for Land Resources Assessment". Oxford University Press, 1986.
9. M. J. Carey, D. J. DeWitt, M. J. Franklin, N. E. Hall, M. McAuliffe, J. F. Naughton, D. T. Schuh, M. H. Solomon, C. K. Tan, O. Tsatalos, S. White, and M. J. Zwilling. "Shoring up Persistent Applications". In Proceedings of the 1994 ACM-SIGMOD Conference, "Minneapolis, Minnesota", May 1994.
10. T. Sellis C. Faloutsos and N. Roussopoulos. "Analysis of Object Oriented Spatial Access Methods". In Proceedings of the 1987 ACM-SIGMOD Conference, San Francisco, May 1987.
11. Intergraph Corporation. "GIS/AM/FM Information". "http://www.intergraph.com/utilmap.shtml", 1995.
12. D. J. DeWitt, N. Kabra, J. Luo, J. M. Patel, and J. Yu. "Client - Server Paradise". In Proceedings of the 20th VLDB Conf., Santiago, Chile, September 1994.
13. D. J. DeWitt, J. Luo, J. M. Patel, and J. Yu. "Paradise - A Parallel Geographic Information System". In Proceedings of the ACM Workshop on Advances in Geographic Information Systems. Arlington, Virginia, November 1993.
14. D. J. DeWitt, J. F. Naughton, D. A. Schneider, and S. Seshadri. "Practical Skew Handling in Parallel Joins". In Proceedings of the 19th VLDB Conf., August 1992.
15. R. H. Güting and W. Shilling. "A Practical Divide - and - Conquer Algorithm for the Rectangle Intersection Problem". In Information Sciences, volume 42, 1987.
16. O. Günther. "Efficient Computation of Spatial Joins". In IEEE Transactions on Knowledge and Data Engineering, 1993.
17. A. Gutman. "R-trees: A Dynamic Index Structure for Spatial Searching". In Proceedings of the 1984 ACM-SIGMOD Conference, Boston, Mass, June 1984.
18. L. Harada, M. Nakano, M. Kitsuregawa, and M. Takagi. "Query Processing Methods for Multi - Attribute Clustered Relations". In Proceedings of the 16th VLDB Conf., Brisbane, Australia, 1990.
19. E. G. Hoel and H. Samet. "Benchmarking Spatial Join Operations with Spatial Output". In Proceedings of the 21st VLDB Conf., Zurich, Switzerland, September 1995.
20. M. Kitsuregawa, L. Harada, and M. Takagi. "Join Strategies on KD-Tree Indexed Relations". In IEEE Transactions on Knowledge and Data Engineering, 1989.
21. M. L. Lo and C. V. Ravishankar. "Spatial Joins Using Seeded Trees". In Proceedings of the 1994 ACM-SIGMOD Conference, Minneapolis, May 1994.
22. M. L. Lo and C. V. Ravishankar. "Generating Seeded Trees From Data Sets". In Proceedings of the Fourth International Symposium on Large Spatial Databases, Portland, ME, August 1995.
23. M. L. Lo and C. V. Ravishankar. "Spatial Hash - Joins". In Proceedings of the 1996 ACM-SICMOD Conference, Montreal, Canada, June 1996.
24. C. Mead and L. Conway. "Introduction to VLSI Systems". Addison - Wesley, Reading, Mass., 1980.
25. D. J. Maguire, M. F. Goodchild, and D. W. Rhind. "Geographic Information Systems", volume 1. Longman Scientific & Technical, copublished in the US with John Wiley & Sons, Inc. New York, 1991.
26. J. Nievergelt, H. Hinterberger, and K. C. Sevcik. "The Grid File: An Adaptable, Symmetric Multikey File Structure". ACM Transactions on Database Systems, March 1984.
27. R. C. Nelson and H. Samet. "A Consistent Hierarchical Representation for Vector Data". In Computer Graphics, volume 20(4), August 1986.
28. J. A. Orenstein and T. H. Merrett. "A Class of Data Structures for Associative Searching". In Proceedings of the 3rd ACM SIGACT - SIGMOD Symposium on Principles of Database Systems, 1984.
29. J. A. Orenstein and F. A. Manola. "PROBE Spatial Data Modeling and Query Processing in an Image Database Application". In IEEE Transactions on Software Engineering, volume 14(5), May 1988.
30. J. A. Orenstein. "Spatial Query Processing in an Object - Oriented Database System". In Proceedings of the 1986 ACM-SIGMOD Conference, 1986.
31. J. A. Orenstein. "Redundancy in Spatial Databases". In Proceedings of the 1989 ACM-SIGMOD Conference, 1989.
32. J. A. Orenstein. "A Comparison of Spatial Query Processing Techniques for Native and Parameter Spaces". In Proceedings of the 1990 ACM-SIGMOD Conference, 1990.
33. J. M. Patel and D. J. DeWitt. "Partition Based Spatial - Merge Join". http://www.cs.wisc.edu/paradise/paradise.papers.html.
34. F. P. Preparata and M. I. Shamos, editors. "Computational Geometry". Springer, 1988.
35. D. Rotem. "Spatial Join Indices". In IEEE Transactions on Knowledge and Data Engineering, Kobe, April 1991.
36. M. Stonebraker, J. Frew, K. Gardels, and J. Meredith. "The SEQUOIA 2000 Storage Benchmark". In Proceedings of the 1993 ACM-SIGMOD Conference. Washington, D.C., May 1993.
37. M. Stonebraker. "The Case for Shared Nothing". Database Engineering, 9(1), 1986.
38. U. S. Bureau of the Census, Washington, DC. "TIGER/Line Files(TM), 1992 Technical Documentation".
39. K. L. Tan and J. X. Yu. "A Performance Study of Declustering Strategies for Parallel Spatial Databases". In The 6th International Conference on Database and Expert Systems Applications (DEXA), London, United Kingdom, September 1995.
40. M. Ubell. "The Montage Extensible DataBlade Architecture". In Proceedings of the 1994 ACM-SIGMOD Conference, May 1994.
41. P. Valduriez. "Join Indices". In ACMTODS, volume 12(2), 1987.
42. H. Zeller and J. Gray. "An Adaptive Hash Join Algorithm for Multiuser Environments". In Proceedings of the 16th VLDB Conf., Brisbane, Australia, 1990.