Due to the increasing popularity of spatial databases, researchers have focused their efforts on improving the query processing performance of the most expensive spatial database operation: the spatial join. While most previous work focused on optimizing the ®lter step, it has been discovered recently that, for typical GIS data sets, the re®nement step of spatial join processing actually requires a longer processing time than the ®lter step. Furthermore, two-thirds of the time in processing the re®nement step is devoted to the computation of polygon intersections. To address this issue, we therefore introduce a novel approach to spatial join optimization that drastically reduces the time of the re®nement step. We propose a new approach called Symbolic Intersect Detection (SID) for early detection of true hits. Our SID optimization eliminates most of the expensive polygon intersect computations required by a spatial join by exploiting the symbolic topological relationships between...
Yun-Wu Huang, Matthew C. Jones, Elke A. Rundenstei