Browse > Article
http://dx.doi.org/10.9717/kmms.2011.14.5.669

Parallel Range Query processing on R-tree with Graphics Processing Units  

Yu, Bo-Seon (인하대학교 일반대학원 정보공학과)
Kim, Hyun-Duk (인하대학교 일반대학원 정보공학과)
Choi, Won-Ik (인하대학교 정보통신공학부)
Kwon, Dong-Seop (명지대학교 컴퓨터공학과)
Publication Information
Journal of Korea Multimedia Society / v.14, no.5, 2011 , pp. 669-680 More about this Journal
Abstract
R-trees are widely used in various areas such as geographical information systems, CAD systems and spatial databases in order to efficiently index multi-dimensional data. As data sets used in these areas grow in size and complexity, however, range query operations on R-tree are needed to be further faster to meet the area-specific constraints. To address this problem, there have been various research efforts to develop strategies for acceleration query processing on R-tree by using the buffer mechanism or parallelizing the query processing on R-tree through multiple disks and processors. As a part of the strategies, approaches which parallelize query processing on R-tree through Graphics Processor Units(GPUs) have been explored. The use of GPUs may guarantee improved performances resulting from faster calculations and reduced disk accesses but may cause additional overhead costs caused by high memory access latencies and low data exchange rate between GPUs and the CPU. In this paper, to address the overhead problems and to adapt GPUs efficiently, we propose a novel approach which uses a GPU as a buffer to parallelize query processing on R-tree. The use of buffer algorithm can give improved performance by reducing the number of disk access and maximizing coalesced memory access resulting in minimizing GPU memory access latencies. Through the extensive performance studies, we observed that the proposed approach achieved up to 5 times higher query performance than the original CPU-based R-trees.
Keywords
Database; Index Structure; Paralle Processing;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 H. Ferhatosmanoglu, A.S. Tosun, G. Canahuate, and A. Ramachandran, "Efficient Parallel Processing of Range Queries Through Replicated Declustering," Distributed and Parallel Databases, Vol.20, pp.117-147, 2006.   DOI   ScienceOn
2 N. Koudas, C. Faloutsos, and I. Kamel, "Declustering Spatial Databases on A Multi- Computer Archetecture," Proc. Of EDBT, 1996.
3 B. Schnitzer and Scott T. Leutenegger, "Master-Client R-Trees: A New Parallel R-Tree Architecture," Scientific and Statistical Database Management, pp.68-77, 1999.
4 Shuhua Lai, Fenghua Zhu, and Yongqiang Sun, "A Design of Parallel R-tree on Cluster of Workstations," Proc. Of IWDNIS, pp. 119-133, 2000.
5 Botao Wang, Hiroyuki Horinokuchi, Junihiko Kaneko, and Akifui Makinouchi, "Parallel R-tree Search Algorithm on DSVM. Database Systems for Advanced Applications," Proc. Of SICDSAA, Hsinchu, Taiwan 1999.
6 J. Nievergelt, H. Hinterberger, and K. Sevcik, "The Grid File: An Adaptable, Symmetric Multikey File Structure," Proc. Of 3rd ECI Conf., Number 123 in LNCS Springer-Verlag, pp.236-251, 1981.
7 K. Yang, B. He, R. Fang, M. Lu, N. Govindaraju, Q. Luo, P. Sander, and J. Shi, "In-memory Grid Files on Graphics ProcesSors," Proc. Of the 3rd international workshop on Data management on new hardware, 2007.
8 Jun Rao and Kenneth A. Ross, "Cache Conscious Indexing for Decision-Support in Main Memory," Proc. Of VLDB, pp.78-89, 1999.
9 R. Fang, B. He, M. Lu, K. Yang, N. K. Govindaraju, Q. Luo, and P. V. Sander. "Gpuqp: Query Co-processing Using Graphics Processors," Proc. Of the ACM SIGMOD, pp. 1061-1063, 2007.
10 장병준, 임인성, "Performance Analysis and Enhancing Techniques of Kd-Tree Traversal Methods on GPU," 한국정보과학회논문지:컴퓨팅의 실제 및 레터, Vol.16, No.2, pp. 177-185, 2010.
11 홍인실, 계희원, 신영길, "절단면 재렌더링 기법을 이용한 GPU기반 MIP 볼륨 렌더링," 한국멀티미디어학회논문지, Vol.10, No.3, pp. 316-324, 2007.
12 C.F. Ibrahim Kamel, "Parallel R-Trees," Proc. Of SIGMOD92, 1992.
13 J. D. Owens, D. Luebke, N. Govindaraju, M. Harris, J. Kruger, A. E. Lefohn, and T. J. Purcell, "A Survey of General-Purpose Computation on Graphics Hardware," Proc. Of CGF, Vol.26, 2007.
14 CUDA programming Guide 2.2.
15 A. Guttman, "R-trees: A Dynamic Index Structure for Spatial Searching," Proc. Of SIGMOD84, 1984.
16 Xiaodong Fu, Dingxing Wang, Weimin Zheng, and Meiming Sheng, "GPR-Tree: A Global Parallel Index Structure for Multiattribute Declustering on Cluster of Workstations," Proc. Of APDC, pp.300-306, 1997.