开发者

MySQL implementation with CUDA

I am a senior undergrad majoring in CS. At the moment I am taking a Computer Architecture class. We need to do a project. I want to do something related to CUDA, where the performance of the computation will have a moderate increase compred to a serial implementation.

I am really interested in databases so I decided to do something related to SQL. I onl开发者_开发问答y have experience with MySQL and I could not find anything related to how to work with MySQL using CUDA. There is only one reseasrch I could find about SQL and it uses SQLite. I am not sure what to do and how to gather information on this subject so I decided to take your opinions.

Best


Just in case someone end-up in this page, the PGStorm is a module of foreign data wrapper of PostgreSQL database.

MySQL implementation with CUDA


You might want to look at implementation of SQL language which runs on GPU and uses CUDA. it is open source so you can look at algorithms for joins, sorts and groupings. Link : http://sourceforge.net/projects/alenka/


Really? Google found this from NVIDIA:

http://forums.nvidia.com/index.php?showtopic=100342

They have a guide. Is that not suitable? It's certainly not for the faint of heart.

http://developer.download.nvidia.com/compute/cuda/1_1/NVIDIA_CUDA_Programming_Guide_1.1.pdf


On the contrary to everyone else, while I'm not sure how, a GPU can work with MySQL... I dont know why every says it couldnt. If there is CPU workload in MySQL then whatever that CPU is doing, at some level, if someone took the time to implement it, a GPU could, for example, work on UPDATING separate rows on separate threads. Could either alloc each table to each block, or just freeform it and let the end user decide.

Or at least someone could edit the driver to speed up efficiency of communication.


It looks like that now there's a solution for querying data using SQL on gpus in python :

https://developer.nvidia.com/blog/beginners-guide-to-querying-data-using-sql-on-gpus-in-python/

I wonder if they are some other possibilities using different programming langages though.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜