Spatial database acceleration using graphic card processors and user-defined functions

Marcin Aptekorz, Kamil Szostek, Mariusz Młynarczuk

Abstract


This paper proves that it is possible to accelerate spatial data analysis, for example astronomic data, without modifying source code of the database engine. User-defined function (UDF) were used in cooperation with NVIDIA CUDA to increase efficiency and speed of numerical operations.

Keywords


spatial database; GPU; UDF; PostgreSQL; MySQL

Full Text:

PDF (Polski)

References


Govindaraju N., Gray J., Kumar R., Manocha D.: GPUTeraSort: high performance graphics co-processor sorting for large database management. Proceedings of the 2006 ACM SIGMOD international conference on Management of data (SIGMOD ‘06). ACM, New York, USA 2006, s. 325÷336.

Pawłowski R., Mrozek D.: Przyspieszenie algorytmu Smitha-Watermana z użyciem procesora graficznego. Studia Informatica, Vol. 32, No. 2A(96), Wydawnictwo Politechniki Śląskiej, Gliwice 2011, s. 181÷198.

Bakkum P., Skadron K.: Accelerating SQL database operations on a GPU with CUDA. Proceedings of the 3rd Workshop on General-Purpose Computation on Graphics Processing Units (GPGPU ‘10). ACM, New York, USA 2010, s. 94÷103.

Govindaraju N. K., Lloyd B., Wang W., Lin M., Manocha D.: Fast Computation of Database Operations using Graphics Processors. Proceedings of SIGGRAPH ‘05 ACM SIGGRAPH 2005 Courses. ACM, Article No. 206, New York 2005.

van Leeuwen F.: Hipparcos, the New Reduction of the Raw Data. Astron. Astrophys. 439, (2005), 2007.

Piórkowski A.: MySQL Spatial and PostGIS - implementations of spatial data standards. EJPAU, T. 14(1), #03, 2011.

PostgreSQL Global Development Group, PostgreSQL 9.1.2 Documentation, http://www.postgresql.org/docs/9.1/static/ (dostęp: 31.12.2011).

Oracle Corporation, MySQL 5.0 Reference Manual, http://dev.mysql.com/doc/refman/5.0/en/ (dostęp: 31.12.2011).

CUDA Zone, NVIDIA Corporation, http://www.nvidia.pl/object/cuda_home_new_pl.html, (dostęp 31.12.2011).




DOI: http://dx.doi.org/10.21936/si2012_v33.n2B.180