An Optimization Technique for Spatial Compound Joins Based on a Topological Relationship Query and Buffering Analysis in DSDBs with Partitioning Fragmentation
Xinyan Zhu, Chunhui Zhou, Wei Guo, Di Chen, Kezhong Liu
언어
영어(ENG)
URL
https://www.earticle.net/Article/A207862
※ 원문제공기관과의 협약기간이 종료되어 열람이 제한될 수 있습니다.
원문정보
초록
영어
Spatial Partitioning Fragmentation (SPF) is a popular method to partition data in Distributed Spatial Databases (DSDBs). The issue of cross-border queries is an inherent problem however with distributed spatial data queries based on partitioning fragmentation given a continuity and strong correlation of geospatial data. In the case of partitioning fragmentation, a global spatial join can be translated into multiple sub-joins, and then divided into 2 groups: Cross-Border Joins (CBJs) and Non-Cross-Border Joins (NCBJs). The CBJ approach is essential for process efficiency in a distributed spatial query. A compound join based on a topological relationship inquiry and a buffering analysis is a crucial class of spatial queries. This article studies compound join optimization for spatial queries in a DSDB, and proposes a set of theorems and rules for the optimization of CBJs, contributing a removal rule and a filtering rule. This article supplies a Partition Fragmentation Join Strategy (PFJS) to resolve the compound join problem based on these rules. Experimental results show that the PFJS can improve the efficiency of CBJs, when compared with the Naive Join Strategy (NJS) or the Spatial Semi-Join Strategy (SSJS). The PFJS contributes to the optimization of spatial compound joins.
목차
Abstract 1. Introduction 2. Related Work 3. The Join Optimization Principle for Compound Queries 3.1 The Classification of Spatial Topological Relationship Predicates and Spatial Joins 3.2 The Cross-border Spatial Query Principle Based on Partitioning Fragmentation 3.3 The Buffer Zone Boundary-restricting Theorem of a Spatial Fragment 3.4 The Removal Rule for Fragment Joins of a Compound Query 3.5 The Filtering Rule for Fragment Joins of a Compound Query 3.6 The Join Optimization Principle for CBJs and its Formalization 4. Comparison and Analysis of Three Strategies of Compound Queries 4.1 Naive Join Strategy (NJS) 4.2 Spatial Semi-Join Strategy (SSJS) 4.3 The Partition Fragments’ Join Strategy (PFJS) 4.4 Complexity Analysis of PFJS 5. Experiments and Analysis 5.1 Experimental Environment and Dataset 5.2 Methodology 5.3 Comparison of Performance in Processing a Compound Query with Partitioning Fragmentation 5.4 Comparison of Performance in Processing a Compound Query with Mixed Fragmentation 6. Summary and Future Prospects Acknowledgements References
보안공학연구지원센터(IJDTA) [Science & Engineering Research Support Center, Republic of Korea(IJDTA)]
설립연도
2006
분야
공학>컴퓨터학
소개
1. 보안공학에 대한 각종 조사 및 연구
2. 보안공학에 대한 응용기술 연구 및 발표
3. 보안공학에 관한 각종 학술 발표회 및 전시회 개최
4. 보안공학 기술의 상호 협조 및 정보교환
5. 보안공학에 관한 표준화 사업 및 규격의 제정
6. 보안공학에 관한 산학연 협동의 증진
7. 국제적 학술 교류 및 기술 협력
8. 보안공학에 관한 논문지 발간
9. 기타 본 회 목적 달성에 필요한 사업
간행물
간행물명
International Journal of Database Theory and Application
간기
격월간
pISSN
2005-4270
수록기간
2008~2016
십진분류
KDC 505DDC 605
이 권호 내 다른 논문 / International Journal of Database Theory and Application Vol.5 No.4