Multiway spatial joins

被引:65
作者
Mamoulis, N
Papadias, D
机构
[1] Univ Hong Kong, Dept Comp Sci & Informat Syst, Hong Kong, Hong Kong, Peoples R China
[2] Hong Kong Univ Sci & Technol, Dept Comp Sci, Hong Kong, Hong Kong, Peoples R China
来源
ACM TRANSACTIONS ON DATABASE SYSTEMS | 2001年 / 26卷 / 04期
关键词
algorithms; multiway joins; query processing; spatial joins;
D O I
10.1145/503099.503101
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Due to the evolution of Geographical Information Systems, large collections of spatial data having various thematic contents are currently available. As a result, the interest of users is not limited to simple spatial selections and joins, but complex query types that implicate numerous spatial inputs become more common. Although several algorithms have been proposed for computing the result of pairwise spatial joins, limited work exists on processing and optimization of multiway spatial joins. In this article, we review pairwise spatial join algorithms and show how they can be combined for multiple inputs. In addition, we explore the application of synchronous traversal (ST), a methodology that processes synchronously all inputs without producing intermediate results. Then, we integrate the two approaches in an engine that includes ST and pairwise algorithms, using dynamic programming to determine the optimal execution plan. The results show that, in most cases, multiway spatial joins are best processed by combining ST with pairwise methods. Finally, we study the optimization of very large queries by employing randomized search algorithms.
引用
收藏
页码:424 / 475
页数:52
相关论文
共 54 条
[1]  
Arge L., 1998, Proceedings of the Twenty-Fourth International Conference on Very-Large Databases, P570
[2]  
BACCHUS F, 1995, LECT NOTES COMPUTER, V976, P292
[3]  
BECKMANN N, 1990, SIGMOD REC, V19, P322, DOI 10.1145/93605.98741
[4]   SPACE-FILLING CURVES - THEIR GENERATION AND THEIR APPLICATION TO BANDWIDTH REDUCTION [J].
BIALLY, T .
IEEE TRANSACTIONS ON INFORMATION THEORY, 1969, 15 (06) :658-+
[5]  
Bouganim L., 1998, Proceedings of the 1998 ACM CIKM International Conference on Information and Knowledge Management, P105, DOI 10.1145/288627.288646
[6]   Parallel processing of spatial joins using R-trees [J].
Brinkhoff, T ;
Kriegel, HP ;
Seeger, B .
PROCEEDINGS OF THE TWELFTH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, 1996, :258-265
[7]  
BRINKHOFF T, 1993, P ACM SIGMOD INT C M, P237
[8]  
CHAYA S, 1999, P ACM SIGMOD C SIGMO, P13
[9]  
Corral A, 1999, LECT NOTES COMPUT SC, V1651, P251
[10]   EXPERIMENTAL EVALUATION OF PREPROCESSING ALGORITHMS FOR CONSTRAINT SATISFACTION PROBLEMS [J].
DECHTER, R ;
MEIRI, I .
ARTIFICIAL INTELLIGENCE, 1994, 68 (02) :211-241