{"id":36843,"date":"2019-10-31T22:14:11","date_gmt":"2019-10-31T19:14:11","guid":{"rendered":"https:\/\/prohoster.info\/blog\/otkryt-kod-sql-dvizhka-blazingsql-ispolzuyushhego-gpu-dlya-uskoreniya\/"},"modified":"2019-10-31T22:14:11","modified_gmt":"2019-10-31T19:14:11","slug":"otkryt-kod-sql-dvizhka-blazingsql-ispolzuyushhego-gpu-dlya-uskoreniya","status":"publish","type":"post","link":"https:\/\/prohoster.info\/ro\/blog\/news\/otkryt-kod-sql-dvizhka-blazingsql-ispolzuyushhego-gpu-dlya-uskoreniya","title":{"rendered":"Codul engine-ului SQL BlazingSQL, care utilizeaz\u0103 GPU pentru accelerare, a fost deschis","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Anun\u021bat<\/a><\/noindex> deschiderea codurilor surs\u0103 ale motorului SQL BlazingSQL<\/a><\/noindex>, care folose\u0219te GPU pentru accelerarea proces\u0103rii datelor. BlazingSQL nu este o baz\u0103 de date complet\u0103, ci se pozi\u021bioneaz\u0103 ca un motor pentru analiza \u0219i procesarea unor seturi mari de date, comparabil \u00een sarcinile sale cu Apache Spark<\/a><\/noindex>. Codul este scris \u00een limbajul Python \u0219i a fost deschis<\/a><\/noindex> sub licen\u021ba Apache 2.0. <\/p>\n

BlazingSQL este adecvat pentru executarea de cereri analitice unice pe seturi mari de date (zeci de gigabyti), stocate \u00een formate de tabel (de exemplu, jurnal, statisticile NetFlow etc.). BlazingSQL poate executa cereri din fi\u0219iere raw \u00een formatele CSV \u0219i Apache Parquet, plasate \u00een sisteme de fi\u0219iere de re\u021bea \u0219i \u00een cloud, precum HDSF \u0219i AWS S3, transfer\u00e2nd direct rezultatul \u00een memoria GPU. Datorit\u0103 paraleliz\u0103rii opera\u021biunilor \u00een GPU \u0219i utiliz\u0103rii memoriei video mai rapide, execu\u021bia cererilor \u00een BlazingSQL se realizeaz\u0103 de p\u00e2n\u0103 la 20 de ori<\/a><\/noindex> mai repede dec\u00e2t \u00een Apache Spark.<\/p>\n

\"Codul<\/a><\/noindex><\/center><\/p>\n

Pentru lucrul cu GPU este utilizat un set de biblioteci dezvoltat cu participarea companiei NVIDIA aplica\u021bii deschise<\/a><\/noindex> RAPIDS , care permite crearea de aplica\u021bii pentru procesarea datelor \u0219i analize, executate integral pe partea GPU (se ofer\u0103<\/a><\/noindex>interfa\u021b\u0103 Python pentru utilizarea primitivelor de baz\u0103 CUDA \u0219i paralelizarea calculului).<\/a><\/noindex> BlazingSQL ofer\u0103 posibilitatea de a folosi SQL \u00een locul API-ului de procesare a datelor <\/p>\n

cuUDF Apache Arrow<\/a><\/noindex> (pe baza ), utilizat \u00een RAPIDS. BlazingSQL este un strat suplimentar care func\u021bioneaz\u0103 deasupra cuDF \u0219i folose\u0219te pentru citirea datelor de pe disc biblioteca cuIO. Cererile SQL sunt translatate \u00een apeluri de func\u021bii cuUDF, care permit \u00eenc\u0103rcarea datelor \u00een GPU \u0219i executarea opera\u021biunilor de \u00eembinare, agregare \u0219i filtrare. Se suport\u0103 construirea de configura\u021bii distribuite, acoperind mii de GPU.<\/a><\/noindex>BlazingSQL simplific\u0103 semnificativ lucrul cu datele \u2014 \u00een loc de sute de apeluri de func\u021bii cuDF, se poate folosi o singur\u0103 cerere SQL. Utilizarea SQL-ului permite integrarea RAPIDS cu sistemele existente de analiz\u0103, f\u0103r\u0103 a scrie manipulatoare specifice \u0219i f\u0103r\u0103 a recurge la \u00eenc\u0103rcarea intermediar\u0103 a datelor \u00eentr-o baz\u0103 de date suplimentar\u0103, dar <\/p>\n

BlazingSQL simplific\u0103 semnificativ lucrul cu datele \u2014 \u00een loc de sute de apeluri la func\u021bii cuDF, se poate utiliza o singur\u0103 interogare SQL. Utilizarea SQL ofer\u0103 posibilitatea de a integra RAPIDS cu sistemele de analiz\u0103 existente, f\u0103r\u0103 a necesita scrierea de procesatori specifici \u0219i f\u0103r\u0103 a apela la \u00eenc\u0103rcarea intermediar\u0103 a datelor \u00eentr-o baz\u0103 de date suplimentar\u0103, dar
\ncuML XGBoost<\/a><\/noindex> \u0219i pentru rezolvarea problemelor de analiz\u0103 \u0219i \u00eenv\u0103\u021bare automat\u0103.<\/a><\/noindex> A fost anun\u021bat\u0103 deschiderea codurilor surs\u0103 ale motorului SQL <\/p>\n

<\/a><\/noindex><\/p>\n

Sursa: opennet.ro<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u041e\u0431\u044a\u044f\u0432\u043b\u0435\u043d\u043e \u043e\u0431 \u043e\u0442\u043a\u0440\u044b\u0442\u0438\u0438 \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u0445 \u0442\u0435\u043a\u0441\u0442\u043e\u0432 SQL-\u0434\u0432\u0438\u0436\u043a\u0430 BlazingSQL, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0449\u0435\u0433\u043e GPU \u0434\u043b\u044f \u0443\u0441\u043a\u043e\u0440\u0435\u043d\u0438\u044f \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445. BlazingSQL \u043d\u0435 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u043b\u043d\u043e\u0446\u0435\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414, \u0430 \u043f\u043e\u0437\u0438\u0446\u0438\u043e\u043d\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043a\u0430\u043a \u0434\u0432\u0438\u0436\u043e\u043a \u0434\u043b\u044f \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0438 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u043d\u0430\u0431\u043e\u0440\u043e\u0432 \u0434\u0430\u043d\u043d\u044b\u0445, \u0441\u0440\u0430\u0432\u043d\u0438\u043c\u044b\u0439 \u043f\u043e \u0441\u0432\u043e\u0438\u043c \u0437\u0430\u0434\u0430\u0447\u0430\u043c \u0441 Apache Spark. \u041a\u043e\u0434 \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 Python \u0438 \u043e\u0442\u043a\u0440\u044b\u0442 \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 Apache 2.0. BlazingSQL \u043f\u043e\u0434\u0445\u043e\u0434\u0438\u0442 \u0434\u043b\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0435\u0434\u0438\u043d\u0438\u0447\u043d\u044b\u0445 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043d\u0430\u0434 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":27603,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-36843","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Codul motorului SQL BlazingSQL, care utilizeaz\u0103 GPU pentru accelerare, este deschis | ProHoster","description":"Anun\u021bat\u0103 deschiderea codurilor surs\u0103 ale motorului SQL.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/news\/otkryt-kod-sql-dvizhka-blazingsql-ispolzuyushhego-gpu-dlya-uskoreniya","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041e\u0442\u043a\u0440\u044b\u0442 \u043a\u043e\u0434 SQL-\u0434\u0432\u0438\u0436\u043a\u0430 BlazingSQL, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0449\u0435\u0433\u043e GPU \u0434\u043b\u044f \u0443\u0441\u043a\u043e\u0440\u0435\u043d\u0438\u044f | ProHoster","og:description":"\u041e\u0431\u044a\u044f\u0432\u043b\u0435\u043d\u043e \u043e\u0431 \u043e\u0442\u043a\u0440\u044b\u0442\u0438\u0438 \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u0445 \u0442\u0435\u043a\u0441\u0442\u043e\u0432 SQL-\u0434\u0432\u0438\u0436\u043a\u0430","og:url":"https:\/\/prohoster.info\/ro\/blog\/news\/otkryt-kod-sql-dvizhka-blazingsql-ispolzuyushhego-gpu-dlya-uskoreniya","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T19:14:11+00:00","article:modified_time":"2019-10-31T19:14:11+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"36843","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-22 05:02:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 01:37:23","updated":"2026-01-22 05:02:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/36843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=36843"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/36843\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media\/27603"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=36843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=36843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=36843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}