{"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\/news\/otkryt-kod-sql-dvizhka-blazingsql-ispolzuyushhego-gpu-dlya-uskoreniya","title":{"rendered":"Kodi i motorit SQL BlazingSQL, q\u00eb p\u00ebrdor GPU p\u00ebr p\u00ebrshpejtimin e procesimit, \u00ebsht\u00eb hapur","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Njoftuar<\/a><\/noindex> p\u00ebr hapjen e teksteve burimore t\u00eb motorit SQL BlazingSQL<\/a><\/noindex>, q\u00eb p\u00ebrdor GPU p\u00ebr p\u00ebrshpejtimin e p\u00ebrpunimit t\u00eb t\u00eb dh\u00ebnave. BlazingSQL nuk \u00ebsht\u00eb nj\u00eb sistem i plot\u00eb menaxhimi t\u00eb bazave t\u00eb t\u00eb dh\u00ebnave, por pozicionohet si nj\u00eb motor p\u00ebr analizimin dhe p\u00ebrpunimin e grupeve t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave, i krahasuesh\u00ebm n\u00eb objektiva 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 kryerjen e k\u00ebrkesave analitike t\u00eb ve\u00e7anta mbi grupe t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave (dhjet\u00ebra gigabajt), t\u00eb ruajtura n\u00eb formate tabelare (p.sh., logjet, statistika NetFlow, etj.). BlazingSQL mund t\u00eb kryej\u00eb k\u00ebrkesa nga skedar\u00ebt raw n\u00eb formatet CSV dhe Apache Parquet, t\u00eb vendosura n\u00eb sisteme t\u00eb skedar\u00ebve rrjet\u00eb dhe n\u00eb re, si HDSF dhe AWS S3, duke transmetuar direkt rezultatin n\u00eb memorien e GPU. Fal\u00eb paralelizimit t\u00eb operacioneve n\u00eb GPU dhe p\u00ebrdorimit t\u00eb memories m\u00eb t\u00eb shpejt\u00eb video, k\u00ebrkesat n\u00eb BlazingSQL realizohen 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 bibliotekash t\u00eb zhvilluar me pjes\u00ebmarrjen e kompanis\u00eb NVIDIA aplikacioneve t\u00eb hapura<\/a><\/noindex> bibliotekat RAPIDS<\/a><\/noindex>, q\u00eb mund\u00ebsojn\u00eb krijimin e aplikacioneve p\u00ebr p\u00ebrpunimin e t\u00eb dh\u00ebnave dhe analizat, t\u00eb cilat realizohen plot\u00ebsisht n\u00eb an\u00ebn e GPU (ofrohet interfaci Python<\/a><\/noindex> p\u00ebr p\u00ebrdorimin e primitiveve t\u00eb ul\u00ebta CUDA dhe paralelizimin 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> (bazuar n\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\u00ebrkthehen n\u00eb thirrje funksionesh cuUDF, q\u00eb lejojn\u00eb ngarkimin e t\u00eb dh\u00ebnave n\u00eb GPU dhe kryerjen e operacioneve t\u00eb bashkimit, grumbullimit dhe filtrimit mbi to. \u00cbsht\u00eb e mb\u00ebshtetur krijimi i konfiguracioneve t\u00eb shp\u00ebrndara q\u00eb mbulojn\u00eb mij\u00ebra GPU. <\/p>\n

BlazingSQL e thjeshton ndjesh\u00ebm pun\u00ebn me t\u00eb dh\u00ebnat \u2014 n\u00eb vend t\u00eb qindra thirrjeve t\u00eb funksioneve cuDF, mund t\u00eb mjaftojn\u00eb nj\u00eb SQL-k\u00ebrkes\u00eb. P\u00ebrdorimi i SQL-s\u00eb ofron mund\u00ebsin\u00eb p\u00ebr t\u00eb siguruar integrimin e RAPIDS me sistemet ekzistuese t\u00eb analiz\u00ebs, pa shkruar trajtues specifik\u00eb dhe pa b\u00ebr\u00eb ngarkim t\u00eb nd\u00ebrmjet\u00ebm t\u00eb t\u00eb dh\u00ebnave n\u00eb nj\u00eb DBMS shtes\u00eb, por
\nduke ruajtur p\u00ebrputhshm\u00ebrin\u00eb e plot\u00eb me t\u00eb gjitha pjes\u00ebt e RAPIDS, duke p\u00ebrkthyer funksionalitetin e disponuesh\u00ebm n\u00eb SQL dhe duke siguruar nj\u00eb performanc\u00eb n\u00eb nivelin e cuDF. Nd\u00ebr t\u00eb tjera, mb\u00ebshtetet integrimi me bibliotekat XGBoost<\/a><\/noindex> dhe cuML<\/a><\/noindex> p\u00ebr zgjidhjen e detyrave t\u00eb analiz\u00ebs dhe 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-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\udd47Kodi i motorit SQL BlazingSQL, i cili p\u00ebrdor GPU p\u00ebr akcelerim, \u00ebsht\u00eb hapur | ProHoster","description":"\u00cbsht\u00eb deklaruar hapja e kodit burimor t\u00eb motorit SQL","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/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","og:url":"https:\/\/prohoster.info\/sq\/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\/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}]}}