Ring-constrained join: deriving fair middleman locations from pointsets via a geometric constraint

We introduce a novel spatial join operator, the ring-constrained join (RCJ). Given two sets P and Q of spatial points, the result of RCJ consists of pairs p, q (where p P, q Q) satisfying an intuitive geometric constraint: the smallest circle enclosing p and q contains no other points in P, Q. This new operation has important applications in decision support, e.g., placing recycling stations at fair locations between restaurants and residential complexes. Clearly, RCJ is defined based on a geometric constraint but not on distances between points. Thus, our operation is fundamentally different from the conventional distance joins and closest pairs problems. We are not aware of efficient processing algorithms for RCJ in the literature. A brute-force solution requires computational cost quadratic to input size and it does not scale well for large datasets. In view of this, we develop efficient R-tree based algorithms for computing RCJ, by exploiting the characteristics of the geometric...

• Type: Conference
• Year: 2008
• Where: EDBT
• Authors: Man Lung Yiu, Panagiotis Karras, Nikos Mamoulis
• Keywords: Database, EDBT 2008, Geometric Constraint, Intuitive Geometric Constraint, Real Spatial Datasets