{"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\/sq\/blog\/novosti-interneta\/otkryt-kod-sql-dvizhka-blazingsql-ispolzuyushhego-gpu-dlya-uskoreniya","title":{"rendered":"Kodi i motorit SQL BlazingSQL, q\u00eb p\u00ebrdor GPU p\u00ebr t\u00eb p\u00ebrshpejtuar, \u00ebsht\u00eb publikuar","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Njoftuar<\/a><\/noindex> n\u00eb lidhje me hapjen e kodit burimor t\u00eb motorit SQL BlazingSQL<\/a><\/noindex>, i cili p\u00ebrdor GPU p\u00ebr t\u00eb p\u00ebrshpejtuar procesimin e t\u00eb dh\u00ebnave. BlazingSQL nuk \u00ebsht\u00eb nj\u00eb DBMS i plot\u00eb, por e pozicionon veten si nj\u00eb motor p\u00ebr analiz\u00ebn dhe p\u00ebrpunimin e grupeve t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave, duke u krahasuar me Apache Spark<\/a><\/noindex>. Kodi \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn Python dhe \u00ebsht\u00eb i hapur<\/a><\/noindex> n\u00ebn licenc\u00ebn Apache 2.0. <\/p>\n

BlazingSQL \u00ebsht\u00eb i p\u00ebrshtatsh\u00ebm p\u00ebr ekzekutimin e k\u00ebrkesave analitike unike mbi grupe t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave (dhjet\u00ebra gigabajt), t\u00eb ruajtura n\u00eb formate tabelar (si\u00e7 jan\u00eb skedar\u00ebt e log-eve, statistikat NetFlow, etj.). BlazingSQL mund t\u00eb ekzekutoj\u00eb k\u00ebrkesa nga skedar\u00ebt raw n\u00eb formatet CSV dhe Apache Parquet, t\u00eb vendosura n\u00eb sisteme t\u00eb ruajtjes n\u00eb rrjet dhe n\u00eb cloud, si HDFS dhe AWS S3, duke transferuar drejtp\u00ebrdrejt rezultatin n\u00eb memorjen e GPU-s\u00eb. Fal\u00eb p\u00ebrshpejtimit t\u00eb operacioneve n\u00eb GPU dhe p\u00ebrdorimit t\u00eb memorjes video m\u00eb t\u00eb shpejt\u00eb, ekzekutimi i k\u00ebrkesave n\u00eb BlazingSQL arrihet deri n\u00eb 20 her\u00eb<\/a><\/noindex> m\u00eb shpejt se n\u00eb Apache Spark.<\/p>\n

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

P\u00ebr pun\u00ebn me GPU, p\u00ebrdoret nj\u00eb grup t\u00eb hapura<\/a><\/noindex> bibliotekash RAPIDS<\/a><\/noindex>, q\u00eb lejon krijimin e aplikacioneve p\u00ebr p\u00ebrpunimin e t\u00eb dh\u00ebnave dhe analiz\u00ebn, t\u00eb cilat realizohen plot\u00ebsisht n\u00eb an\u00ebn e GPU-s\u00eb (ofrohet interfaci n\u00eb Python<\/a><\/noindex> p\u00ebr p\u00ebrdorimin e primitivave t\u00eb nivelit t\u00eb ul\u00ebt t\u00eb CUDA dhe p\u00ebrshpejtimin e llogaritjeve). <\/p>\n

BlazingSQL ofron mund\u00ebsin\u00eb e p\u00ebrdorimit t\u00eb SQL n\u00eb vend t\u00eb API p\u00ebr p\u00ebrpunimin e t\u00eb dh\u00ebnave cuUDF<\/a><\/noindex> (n\u00eb baz\u00eb t\u00eb Apache Arrow<\/a><\/noindex>), e p\u00ebrdorur n\u00eb RAPIDS. BlazingSQL \u00ebsht\u00eb nj\u00eb shtres\u00eb shtes\u00eb, q\u00eb punon mbi cuDF dhe p\u00ebrdor bibliotek\u00ebn cuIO p\u00ebr t\u00eb lexuar t\u00eb dh\u00ebna nga disku. K\u00ebrkesat SQL p\u00ebrkthyesh n\u00eb thirrjet e funksioneve cuUDF, t\u00eb cilat lejojn\u00eb ngarkimin e t\u00eb dh\u00ebnave n\u00eb GPU dhe ekzekutimin e operacioneve t\u00eb bashkimit, agregimit dhe filtrimit mbi to. Mb\u00ebshtetet krijimi i konfigurimeve t\u00eb shp\u00ebrndara, q\u00eb p\u00ebrfshijn\u00eb mij\u00ebra GPU. <\/p>\n

BlazingSQL e thjesht\u00ebson ndjesh\u00ebm pun\u00ebn me t\u00eb dh\u00ebnat \u2014 n\u00eb vend t\u00eb qindra thirrjeve funksionesh cuDF, mjafton nj\u00eb k\u00ebrkes\u00eb SQL. P\u00ebrdorimi i SQL siguron mund\u00ebsin\u00eb e integrimit t\u00eb RAPIDS me sistemet ekzistuese t\u00eb analiz\u00ebs, pa shkruar p\u00ebrpunues specifik\u00eb dhe pa e ngarkuar t\u00eb dh\u00ebnat n\u00eb nj\u00eb DBMS t\u00eb shtuar.
\nduke ruajtur k\u00ebshtu plot\u00ebsisht p\u00ebrputhshm\u00ebrin\u00eb me t\u00eb gjitha pjes\u00ebt e RAPIDS, duke p\u00ebrkthyer n\u00eb SQL funksionalitetin ekzistues dhe duke ofruar performanc\u00eb n\u00eb nivelin e cuDF. Gjithashtu, mb\u00ebshtetet integrimi me bibliotekat XGBoost<\/a><\/noindex> dhe cuML<\/a><\/noindex> p\u00ebr zgjidhjen e problemeve analitike dhe t\u00eb m\u00ebsimit t\u00eb makinerive. <\/p>\n

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

Burimi: opennet.ru<\/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-novosti-interneta"],"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\udd47Hapet kodi i motorit SQL BlazingSQL, i cili p\u00ebrdor GPU p\u00ebr p\u00ebrshpejtimin | ProHoster","description":"Njoftohet se \u00ebsht\u00eb hapur kodi burimor i motorit SQL BlazingSQL, i cili p\u00ebrdor GPU p\u00ebr t\u00eb p\u00ebrshpejtuar procesimin e t\u00eb dh\u00ebnave. BlazingSQL nuk \u00ebsht\u00eb nj\u00eb DBMS i plot\u00eb, por e pozicionon veten si nj\u00eb motor p\u00ebr analiz\u00ebn dhe p\u00ebrpunimin e grupeve t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave, duke u krahasuar me Apache Spark. Kodi \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn Python dhe \u00ebsht\u00eb i hapur n\u00ebn licenc\u00ebn Apache 2.0. BlazingSQL \u00ebsht\u00eb i p\u00ebrshtatsh\u00ebm p\u00ebr ekzekutimin e k\u00ebrkesave analitike unike mbi","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/otkryt-kod-sql-dvizhka-blazingsql-ispolzuyushhego-gpu-dlya-uskoreniya","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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 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","og:url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/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\/sq\/wp-json\/wp\/v2\/posts\/36843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=36843"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/36843\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/27603"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=36843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=36843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=36843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}