GPU and SQL: Can GPU be used for SQL processing

Share

GPU vs CPU[7]A topic left unexamined in this paper is the possibility of breaking up a data set and running a query concurrently on multiple GPUs. Though there would certainly be coordination overhead, it is very likely that SQL queries could be further accelerated with such a con guration. Consider the NVIDIA Tesla S1070, a server product which contains 4 Tesla GPUs. This machine has a combined GPU throughput of 408 GB/sec, 960 streaming multiprocessors, and a total of 16 GB of GPU memory. Further research could implement a query mechanism that takes advantage of multiple GPUs resident on a single host and across multiple hosts.

 

CONCLUSIONS

This project simultaneously demonstrates the power of using a generic interface to drive GPU data processing and provides further evidence of the e_ectiveness of accelerat- ing database operations by o_oading queries to a GPU. Though only a subset of all possible SQL queries can be used, the results are promising and there is reason to believe that a full implementation of all possible SELECT queries would achieve similar results. SQL is an excellent interface through which the GPU can be accessed: it is much simpler and more widely used than many alternatives. Using SQL represents a break from the paradigm of previous research which drove GPU queries through the use of operational primitives, such as map, reduce, or sort. Additionally, it dramatically reduces the efort required to employ GPUs for database acceleration. The results of this paper suggest that implementing databases on GPU hardware is a fertile area for future research and commercial development. The SQLite database was used as a platform for the project, enabling the use of an existing SQL parsing mechanism and switching between CPU and GPU execution. Execution on the GPU was supported by reimplementing the SQLite virtual machine as a CUDA kernel. The queries executed on the GPU were an average of 35X faster than those executed through the serial SQLite virtual machine. The characteristics of each query, the type of data being queried, and the size of the result set were all signicant factors in how CPU and GPU execution compared. Despite this variation, the minimum speedup for the 13 queries considered was 20X. Additionally, the results of this paper are expected to im- prove with the release of the next generation of NVIDIA GPU hardware. Though further research is needed, clearly native SQL query processing can be signicantly accelerated with GPU hardware.

See the detailed PDF.

GPU and SQL

Share

COMMENTS

  • This is absolutely excellent. Thank you so much for writing it.

  • James Martinez

    Incredible, completely awesome. I’m just engaging in writing and submitting articles myself, absolutely nothing slightly near to your composing potential (ha!) however I’d fascination with you to take my stuff someday!

  • free xbox

    I’ve gone ahead and bookmarked http://ugurcandan.com/gpu-and-sql/ at Digg.com so my friends can see it too. I simply used GPU and SQL: Can GPU be used for SQL processing | Ugur Candan as the entry title in my Digg.com bookmark, as I figured if it is good enough for you to title your blog post that, then you probably would like to see it bookmarked the same way.

  • nice post! 🙂

  • Good writing here I really really like the way you write your blogs. I will continue to visit your site in the future to read more great blog posts like this one! This is an awesome post here. love on web fighters 🙂

  • great post! I love it 🙂

  • You definitely know very well what you’re discussing. Man, this website is just excellent! I cannot wait to read much more of what you have got to say. I am truly happy that I came across this when I do because I’m really getting down to get bored with the whole blogging scene. Youve turned me around man!

  • I would like to thank you for the efforts you have put in writing this website. I am hoping the same high-grade site post from you in the upcoming also. In fact your creative writing abilities has encouraged me to get my own blog now. Really the blogging is spreading its wings quickly. Your write up is a great example of it.

  • Servoo

    sağlam proje hesaplarıma göre eğer en iyi verim alacak şekilde yapılabilirse postgresql ve oracle dan 1000 kat, mongodb,monetdb bunlardan da 100 kat hızlı olabilir, karşılaştırma i7 vs r9 290x için geçerlidir.

  • Nasil calismalar bunlar . Detay verirsen ilgilenirim. Tsk

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.