{"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\/et\/blog\/news\/otkryt-kod-sql-dvizhka-blazingsql-ispolzuyushhego-gpu-dlya-uskoreniya","title":{"rendered":"BlazingSQL SQL-mootori avatud kood on n\u00fc\u00fcd saadaval, kasutades GPU-d kiirendamiseks","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

K\u00e4ideldud<\/a><\/noindex> SQL-mootori allikakoodide avamisest BlazingSQL<\/a><\/noindex>, mis kasutab andmete t\u00f6\u00f6tlemise kiirendamiseks GPU-d. BlazingSQL ei ole t\u00e4isv\u00e4\u00e4rtuslik andmebaasi haldur, vaid positsioneerib end kui suurte andmekogumite anal\u00fc\u00fcsi ja t\u00f6\u00f6tlemise mootor, olles oma \u00fclesanne v\u00f5rreldav Apache Spark<\/a><\/noindex>. Kood on kirjutatud Pythonis ja avatud<\/a><\/noindex> lisensiga Apache 2.0. <\/p>\n

BlazingSQL sobib suurte andmekogumite (k\u00fcmned gigabaitid) \u00fcheainsa anal\u00fc\u00fctilise p\u00e4ringu k\u00e4itamiseks, mis on salvestatud tabelivormingus (n\u00e4iteks logid, NetFlow statistika jne). BlazingSQL suudab k\u00e4itada p\u00e4ringuid toorfailidest formaatides CSV ja Apache Parquet, mis asuvad v\u00f5rgus ja pilves failis\u00fcsteemides, nagu HDSF ja AWS S3, edastades tulemuse otse GPU m\u00e4llu. T\u00e4nu operatsioonide paraleliseerimisele GPU-l ja kiirema videom\u00e4lu kasutamisele toimub p\u00e4ringute t\u00e4itmine BlazingSQL-is kuni 20 korda<\/a><\/noindex> kiirem kui Apache Sparkis.<\/p>\n

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

GPU-dega t\u00f6\u00f6tamiseks kasutatakse NVIDIA osalusel arendatavat teekide komplekti avatud<\/a><\/noindex> biblioteekide RAPIDS<\/a><\/noindex>, mis v\u00f5imaldab luua andmete t\u00f6\u00f6tlemise ja anal\u00fc\u00fcsi rakendusi, mis toimivad t\u00e4ielikult GPU k\u00fcljes (pakutakse Python-liides<\/a><\/noindex> CUDA madala taseme primitiivide kasutamiseks ja arvutuste paraleliseerimiseks). <\/p>\n

BlazingSQL v\u00f5imaldab SQL-i kasutamist andmete t\u00f6\u00f6tlemise API asemel cuUDF<\/a><\/noindex> (p\u00f5hjal Apache Arrow<\/a><\/noindex>), mida kasutatakse RAPIDS-is. BlazingSQL on t\u00e4iendav kiht, mis t\u00f6\u00f6tab cuDF-i peal ja kasutab andmete lugemiseks diskilt cuIO teeki. SQL-p\u00e4ringud muudetakse cuUDF-funktsioonide kutsumisteks, mis v\u00f5imaldavad andmete laadimist GPU-sse ja nende \u00fcle toimingute, nagu liitmine, agregatsioon ja filtreerimine. Toetatakse hajutatud konfiguratsioonide loomist, mis h\u00f5lmavad tuhandeid GPU-sid. <\/p>\n

BlazingSQL lihtsustab andmet\u00f6\u00f6tlust oluliselt \u2014 sadu cuDF funktsioonide kutsumise asemel saab piirduda \u00fche SQL-p\u00e4ringuga. SQL-i kasutamine v\u00f5imaldab tagada RAPIDSi integreerimise olemasolevate anal\u00fc\u00fcsis\u00fcsteemidega, ilma et oleks vaja kirjutada spetsiifilisi t\u00f6\u00f6tlejaid ja andmete laadimist t\u00e4iendavatesse andmebaasidesse.
\ns\u00e4ilitades samas t\u00e4ielikku \u00fchilduvust k\u00f5igi RAPIDS-i osadega, muutes olemasoleva funktsionaalsuse SQL-iks ja tagades cuDF tasemel j\u00f5udluse. Sealhulgas on tagatud integreerimise toetus raamatukogudega XGBoost<\/a><\/noindex> ja cuML<\/a><\/noindex> anal\u00fc\u00fcsi ja masin\u00f5ppe \u00fclesannete lahendamiseks. <\/p>\n

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

Allikas: 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\udd47BlazingSQL SQL-mootori kood on avatud, kasutades GPU-d kiirendamiseks | ProHoster","description":"SQL-mootori allikakoodide avamise teadet","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/otkryt-kod-sql-dvizhka-blazingsql-ispolzuyushhego-gpu-dlya-uskoreniya","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\/et\/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\/et\/wp-json\/wp\/v2\/posts\/36843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=36843"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/36843\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/27603"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=36843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=36843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=36843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}