Download:
|
by Hongjun Zhu, Jianwen Su, Oscar H. Ibarra
In Proceedings of the 12th International Conference on Statistical and Scientific Database Management (SSDBM
http://www.cs.ucsb.edu/~hongjunz/ssdbm00.ps
Add To MetaCart
Abstract:
The traditional spatial join evaluation strategy is to perform a join of "minimum bounding rectangles " (MBR) of the spatial objects and the join of the objects using the join results of MBR's. In this paper, we develop efficient algorithms for evaluating joins of "trapezoids " without using MBR's. When there are no intersecting non-horizontal boundaries in the same set, a spatial join of two N trapezoids sets can be done in O(N log b N+k) I/Os, and for the general case with no assumptions, a join can be done in O((N+l+k) log b N) I/Os, where b is the page size, k the number of trapezoid intersections, and l the number of non-horizontal boundary intersections within the same set. The new algorithms can be used to evaluate spatial joins for polygons. One possibility is to decompose polygons into trapezoids and apply a trapezoid join algorithm. In particular, this approach is efficient for "I/O bounded polygons " (each of which can be retrieved in a constant number of I/Os). We show that a spatial join of two sets of I/O bounded polygons, has the same complexity as a join of trapezoids. Another possibility is to approximate objects by I/O bounded polygons (e.g., 5-corner convex polygons) which are finer than rectangles and use the new algorithms as a filter. 1.
Citations
|
345
|
Applications of random sampling in computational geometry
– Clarkson
- 1989
|
|
270
|
Parallel processing of spatial joins using r-trees
– Brinkhoff, Kriegel, et al.
- 1996
|
|
231
|
Algorithms for Reporting and Counting Geometric Intersections
– Bentley, Ottmann
- 1979
|
|
170
|
Spatial query processing in an object-oriented database system
– Orenstein
- 1986
|
|
150
|
Partition based spatial-merge join
– Patel, DeWitt
- 1996
|
|
149
|
The buffer tree: A new technique for optimal I/O-algorithms
– Arge
- 1995
|
|
145
|
Fundamentals of spatial information systems
– Laurini, Thompson
- 1992
|
|
130
|
Multi-step processing of spatial joins
– Brinkhoff, Kriegel, et al.
- 1994
|
|
107
|
Constraint Databases
– Benedikt, Libkin
- 2000
|
|
101
|
PROBE Spatial Data Modeling and Query Processing in an Image Database Application
– Orenstein, Manola
- 1988
|
|
93
|
Efficient computation of spatial joins
– Gunther
- 1993
|
|
90
|
Spatial joins using r-trees: Breadth-first traversal with global optimizations
– Huang, Jing, et al.
- 1997
|
|
89
|
Spatial hash-joins
– Lo, Ravishankar
- 1996
|
|
79
|
External-memory algorithms for processing line segments in geographic information systems
– Arge, Vengroff, et al.
- 1995
|
|
77
|
Spatial join indices
– Rotem
- 1991
|
|
69
|
Redundancy in spatial databases
– ORENSTEIN
- 1989
|
|
68
|
A fast planar partition algorithm
– Mulmuley
- 1990
|
|
65
|
On two-dimensional indexability and optimal range search indexing
– Arge, Samoladas, et al.
- 1999
|
|
55
|
Scalable sweeping-based spatial join
– Arge, Procopiuc, et al.
- 1998
|
|
54
|
Algorithms for bichromatic line segment problems and polyhedral terrains. Algorithmica
– Chazelle, Edelsbrunner, et al.
- 1994
|
|
51
|
An optimal algorithm for finding segments intersections
– Balaban
- 1995
|
|
36
|
A new algorithm for computing joins with grid files
– Becker, Hinrichs, et al.
- 1993
|
|
35
|
Geometric intersection problems
– Shamos, Hoey
- 1976
|
|
34
|
Reporting and counting intersections between two sets of line segments
– Mairson, Stolfi
- 1988
|
|
26
|
Counting and reporting red/blue segment intersections
– Palazzi, Snoeyink
- 1994
|
|
7
|
Filter trees for managing spatial data over a range of size granularities
– Sevcik, Koudas
- 1996
|
|
7
|
A Raster approximation for processing of spatial joins
– Zimbrao, Souza
- 1998
|
|
4
|
Extending rectangle join algorithms for rectilinear polygons
– Zhu, Su, et al.
- 2000
|
|
3
|
An index structure for spatial joins in linear constraint databases
– Zhu, Su, et al.
- 1999
|
|
1
|
An optimal algorithm for itnersecting line segments in plane
– Chazelle, Edelsbrunner
- 1988
|