MySQL 与 CUDA 的实现
我是一名高年级本科生，专业是CS。目前我正在上计算机体系结构课程。我们需要做一个项目。我想做一些与 CUDA 相关的事情，与串行实现相比，计算性能将有适度的提高。
我对数据库非常感兴趣，所以我决定做一些与SQL相关的事情。我只有 MySQL 的经验，找不到任何与如何使用 CUDA 使用 MySQL 相关的内容。我只能找到一项关于 SQL 的研究，它使用 SQLite。我不知道该怎么做以及如何收集有关此主题的信息，因此我决定听取您的意见。
最好的
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 only 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
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
以防万一有人最终进入此页面， PGStorm 是外部数据包装器的模块PostgreSQL 数据库。
Just in case someone end-up in this page, the PGStorm is a module of foreign data wrapper of PostgreSQL database.
您可能想查看在 GPU 上运行并使用 CUDA 的 SQL 语言的实现。
它是开源的，因此您可以查看连接、排序和分组的算法。
关联 ：
http://sourceforge.net/projects/alenka/
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/
真的吗？ Google 从 NVIDIA 找到了这个：
http://forums.nvidia.com/index.php?showtopic =100342
他们有导游。那不合适吗？这当然不适合胆小的人。
http://developer.download.nvidia.com/compute/cuda /1_1/NVIDIA_CUDA_Programming_Guide_1.1.pdf
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
与其他人相反，虽然我不确定如何，GPU 可以与 MySQL 一起工作......我不知道为什么每个人都说它不能。如果MySQL中有CPU工作负载，那么无论CPU在做什么，在某种程度上，如果有人花时间来实现它，GPU就可以在不同的线程上更新不同的行。可以将每个表分配给每个块，或者只是自由形式并让最终用户决定。
或者至少有人可以编辑驱动程序以加快通信效率。
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.
看起来现在有一个在
python中使用SQL在gpus上查询数据的解决方案： nvidia.com/blog/beginners-guide-to-querying-data-using-sql-on-gpus-in-python/" rel="nofollow noreferrer">https://developer.nvidia.com/blog/beginners- Guide-to-querying-data-using-sql-on-gpus-in-python/
我想知道它们是否是使用不同编程语言的其他可能性。
It looks like that now there's a solution for querying data using
SQLongpusinpython: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.