###
计算机系统应用英文版:2016,25(10):233-239
本文二维码信息
码上扫一扫!
开源关系数据库集群的并行空间连接算法实现
(1.福建农林大学 资源与环境学院, 福州 350002;2.中国科学院 遥感与数字地球研究所, 北京 100011)
Research and Realization on Parallel Spatial Join Query Algorithm Based on Open Source RDBMS Cluster
(1.College of Resource and Environmental Science, Fujian Agriculture and Forestry University, Fuzhou 350002, China;2.Institute of Remote Sensing and Digital Earth, Chinese Academy of Sciences, Beijing 100011, China)
摘要
图/表
参考文献
相似文献
本文已被:浏览 1271次   下载 1639
Received:February 19, 2016    Revised:April 19, 2016
中文摘要: 当前对并行空间连接查询的研究主要集中在算法设计上,缺少在并行关系数据库管理系统上的应用实现研究.通过分析并行空间连接算法流程,利用开源并行关系数据库集群项目PL/Proxy,提出了混合式计算迁移模式并扩展了对空间操作的支持,并在其上实现了可扩展的基于空间划分的并行空间连接算法.通过真实数据的实验表明:设计实现的并行空间连接算法在空间数据划分负载均衡的情况下,可实现近线性的加速比;而在空间划分产生数据倾斜严重的情况下,仍具有一定的加速比,同时具备针对空间划分方案改进的可扩展能力.算法的实现方式为进行并行空间数据管理研究提供了一种可行的解决方案.
Abstract:Existing studies on parallel spatial join query mostly focus on algorithm process. Few of them pay enough attentions on implementation and application research. After analyzing existing algorithm process, parallel spatial join algorithms are divided into four phases which are parallel candidate tasks generating, assignment, executing and results collection. Each of them is designed and implemented on a parallel RDBMS cluster which is built on a open-source project named ‘PL/Proxy’. In addition, to implement parallel computation, mixed computation migration method is proposed. Spatial extension function is implemented to support the spatial data sets operation on the cluster. Result of experiments using real data sets shows that, the implemented algorithm gains near linear speedup when data declustering scheme is optimal. Moreover, speedup is also gained while significant data skew caused by data declustering exists. The data declustering scheme is replaceable for improving the algorithm performance. A practicable solution for parallel spatial data sets management is provided in this paper.
文章编号:     中图分类号:    文献标志码:
基金项目:国家高技术研究计划(863)(2013AA12A403)
引用文本:
范协裕,任应超.开源关系数据库集群的并行空间连接算法实现.计算机系统应用,2016,25(10):233-239
FAN Xie-YU,REN Ying-Chao.Research and Realization on Parallel Spatial Join Query Algorithm Based on Open Source RDBMS Cluster.COMPUTER SYSTEMS APPLICATIONS,2016,25(10):233-239