{"id":6299,"date":"2016-05-09T07:00:05","date_gmt":"2016-05-09T15:00:05","guid":{"rendered":"http:\/\/formtek.com\/blog\/?p=6299"},"modified":"2016-03-31T07:40:10","modified_gmt":"2016-03-31T15:40:10","slug":"mapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries","status":"publish","type":"post","link":"https:\/\/formtek.com\/blog\/mapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries\/","title":{"rendered":"MapD and GPUs: Fast Data: Speeding up Compute-Bound Database Queries"},"content":{"rendered":"<p>Big Data sets are only possible if there is some Big Processing available to handle the enormous volumes. \u00a0While the amount of data being captured is rising exponentially hardware and software engineers are rushing to develop software algorithms and processing hardware that can keep up with the load.<\/p>\n<p>Increasingly GPU architectures are being used to solve exceptionally complex problems. \u00a0The misnamed graphical processing unit (GPU) is a\u00a0computer processor that is fine-tuned to process complex mathematical operations, like matrix mathematics and linear algebra very quickly. \u00a0These chips were initially used primarily to work on graphic and image processing problems, but more recently they are <a href=\"http:\/\/www.nvidia.com\/object\/what-is-gpu-computing.html#sthash.5lVMJyXz.dpuf\" target=\"_blank\">finding success<\/a>\u00a0when applied to a variety of\u00a0 scientific, analytics, engineering, consumer, and enterprise applications.<\/p>\n<p>For example, consider database technology. \u00a0Recently speed gains have been seen by database solutions that are designed to run completely in-memory. \u00a0<a href=\"https:\/\/en.wikipedia.org\/wiki\/SAP_HANA\" target=\"_blank\">SAP HANA<\/a> and <a href=\"http:\/\/blog.cloudera.com\/blog\/2013\/11\/putting-spark-to-use-fast-in-memory-computing-for-your-big-data-applications\/\" target=\"_blank\">Spark <\/a>are examples of this. \u00a0In-memory databases are great when the problems you work on are memory bound. \u00a0 But there&#8217;s another possible approach. \u00a0The San Francisco-based startup <a href=\"http:\/\/www.mapd.com\/\" target=\"_blank\">MapD <\/a>has applied the use of GPUs to database processing. \u00a0The MapD solution attempts to use GPUs to speed things up processing for <a href=\"http:\/\/www.nextplatform.com\/2016\/03\/30\/mapd-gpu-database-looks-forward-heftier-iron\/\" target=\"_blank\">problems that are\u00a0compute-bound<\/a>. \u00a0The speed gains that they&#8217;ve seen have been huge, sometimes as much as 100 times the performance of standard CPU-based databases.<\/p>\n<p><a href=\"https:\/\/451research.com\/biography?eid=848\">James Curtis<\/a>, 451 Group&#8217;s Senior Analyst, <a href=\"http:\/\/www.prnewswire.com\/news-releases\/mapd-launches-lightning-fast-gpu-database-and-visual-analytics-platform-lands-10m-series-a-funding-300243220.html\" target=\"_blank\">said that<\/a> &#8220;MapD has an innovative high-performance offering that combines GPU technology with the firm&#8217;s own columnar database and visualization frontend, making MapD well suited to help organizations drive real-time decision making.&#8221;<\/p>\n<p><a href=\"http:\/\/www.mapd.com\/blog\/author\/todd-mostak\/\" target=\"_blank\">Todd Mostak<\/a>, founder of MapD, t<a href=\"http:\/\/blogs.wsj.com\/venturecapital\/2016\/03\/30\/mapd-locates-10-million-series-a-for-faster-databases\/\" target=\"_blank\">old the Wall Street Journal<\/a> that &#8220;I would say we\u2019re \u2018fast data.\u2019&#8221;<\/p>\n<div class=\"lightsocial_container\"><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/digg.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/digg.png\" alt=\"Digg This\" title=\"Digg This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.reddit.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/reddit.png\" alt=\"Reddit This\" title=\"Reddit This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.stumbleupon.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/stumbleupon.png\" alt=\"Stumble Now!\" title=\"Stumble Now!\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/buzz.yahoo.com\/buzz?targetUrl=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F&amp;headline=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/yahoo_buzz.png\" alt=\"Buzz This\" title=\"Buzz This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.dzone.com\/links\/add.html?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dzone.png\" alt=\"Vote on DZone\" title=\"Vote on DZone\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.facebook.com\/sharer.php?t=&amp;u=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/facebook.png\" alt=\"Share on Facebook\" title=\"Share on Facebook\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/delicious.com\/save?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/delicious.png\" alt=\"Bookmark this on Delicious\" title=\"Bookmark this on Delicious\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.dotnetkicks.com\/kick\/?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dotnetkicks.png\" alt=\"Kick It on DotNetKicks.com\" title=\"Kick It on DotNetKicks.com\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/dotnetshoutout.com\/Submit?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dotnetshoutout.png\" alt=\"Shout it\" title=\"Shout it\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.linkedin.com\/shareArticle?mini=true&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F&amp;title=&amp;summary=&amp;source=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/linkedin.png\" alt=\"Share on LinkedIn\" title=\"Share on LinkedIn\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.technorati.com\/faves?add=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/technorati.png\" alt=\"Bookmark this on Technorati\" title=\"Bookmark this on Technorati\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/twitter.com\/home?status=Reading+https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/twitter.png\" alt=\"Post on Twitter\" title=\"Post on Twitter\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.google.com\/buzz\/post?url=https%3A%2F%2Fformtek.com%2Fblog%2Fmapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/google_buzz.png\" alt=\"Google Buzz (aka. Google Reader)\" title=\"Google Buzz (aka. Google Reader)\" \/><\/a><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Big Data sets are only possible if there is some Big Processing available to handle the enormous volumes. \u00a0While the amount of data being captured is rising exponentially hardware and software engineers are rushing to develop software algorithms and processing<span class=\"ellipsis\">&hellip;<\/span><\/p>\n<div class=\"read-more\"><a href=\"https:\/\/formtek.com\/blog\/mapd-and-gpus-fast-data-speeding-up-compute-bound-database-queries\/\">Read more &#8250;<\/a><\/div>\n<p><!-- end of .read-more --><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35,36],"tags":[],"class_list":["post-6299","post","type-post","status-publish","format-standard","hentry","category-structured-data","category-technology"],"_links":{"self":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts\/6299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/comments?post=6299"}],"version-history":[{"count":0,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts\/6299\/revisions"}],"wp:attachment":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/media?parent=6299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/categories?post=6299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/tags?post=6299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}