{"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\/novosti-interneta\/otkryt-kod-sql-dvizhka-blazingsql-ispolzuyushhego-gpu-dlya-uskoreniya","title":{"rendered":"Avaldatud on BlazingSQL SQL-mootori kood, mis kasutab GPU-d kiirusel kiirusel","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Teadetatud<\/a><\/noindex> SQL-mootori avatud l\u00e4htekoodist BlazingSQL<\/a><\/noindex>, mis kasutab andmete t\u00f6\u00f6tlemise kiirusel GPU-d. BlazingSQL ei ole t\u00e4ie\u00f5iguslik andmebaasi s\u00fcsteem, vaid positsioneeritakse suurte andmekogumite anal\u00fc\u00fcsi ja t\u00f6\u00f6tlemisena, mis on oma \u00fclesannetes v\u00f5rdne Apache Spark<\/a><\/noindex>. Kood on kirjutatud Python keeles ja avatud<\/a><\/noindex> ainekood on litsentsitud Apache 2.0 all. <\/p>\n

BlazingSQL sobib suurte andmekogumite (k\u00fcmneid gigabaite) anal\u00fc\u00fcsik\u00fcsimuste t\u00e4itmiseks, mida hoitakse tabelivormingutes (n\u00e4iteks logid, NetFlow statistika jms). BlazingSQL saab esitada p\u00e4ringuid toorfailidest CSV ja Apache Parquet formaatides, mis on paiknenud v\u00f5rgus ja pilvefailis\u00fcsteemides, nagu HDFS ja AWS S3, edastades tulemuse otse GPU m\u00e4lu. Operatsioonide paralleelne teostamine GPU-s ja kiirema videom\u00e4lu kasutamine v\u00f5imaldab BlazingSQL-is p\u00e4ringute t\u00e4itmist kuni 20 korda<\/a><\/noindex> kiirem kui Apache Spark.<\/p>\n

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

GPU-dega t\u00f6\u00f6tamiseks kasutatakse NVIDIAt kaasava arenduse kogumit avatud<\/a><\/noindex> raamatukogusid RAPIDS<\/a><\/noindex>, mis v\u00f5imaldab luua rakendusi andmete t\u00f6\u00f6tlemiseks ja anal\u00fc\u00fcsiks, teostades neid t\u00e4ielikult GPU poolel (pakub Python liidese<\/a><\/noindex> CUDA madala taseme primitiivide kasutamiseks ja arvutuste paralleelimiseks). <\/p>\n

BlazingSQL pakub v\u00f5imalust kasutada SQL-i andmete t\u00f6\u00f6tlemise API asemel. cuUDF<\/a><\/noindex> (baasil Apache Arrow<\/a><\/noindex>), mida kasutatakse RAPIDS-is. BlazingSQL on t\u00e4iendav kiht, mis t\u00f6\u00f6tab cuDF-i kohal ja kasutab andmete lugemiseks kuIO teegi. SQL-p\u00e4ringud muudetakse cuUDF funktsioonik\u00f5nedele, mis v\u00f5imaldavad andmete laadimist GPU-sse ning nende peal muundamise, agregatsiooni ja filtreerimise tehteid. Toetatakse jaotatud konfiguratsioonide loomist, mis katab tuhandeid GPU-sid. <\/p>\n

BlazingSQL lihtsustab andmetega t\u00f6\u00f6tamist oluliselt \u2014 sadade cuDF funktsioonide kutsumise asemel piisab \u00fchest SQL-p\u00e4ringust. SQL-i kasutamine v\u00f5imaldab tagada RAPIDSi integreerimist olemasolevate anal\u00fc\u00fcsis\u00fcsteemidega, ilma et oleks vaja kirjutada spetsiifilisi t\u00f6\u00f6tlejaid v\u00f5i laadida andmeid vahepeal t\u00e4iendavasse andmebaasi.
\nsamasuguste librariociazione hoolitsedes, et k\u00f5ik RAPIDS-i osad oleksid t\u00e4ielikult \u00fchilduvad, transkribeerides SQL-iga olemasoleva funktsionaalsuse ja tagades cuDF tasemel j\u00f5udluse. Samuti on tagatud integreerimise tugi raamatukogudega XGBoost<\/a><\/noindex> ja cuML<\/a><\/noindex> anal\u00fc\u00fctika 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-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\udd47BlazingSQLi SQL-mootor, mis kasutab GPU-d kiirendamiseks, on avatud | ProHoster","description":"BlazingSQLi SQL-mootori avamine, mis kasutab andmete t\u00f6\u00f6tlemise kiirendamiseks GPU-d, on v\u00e4lja kuulutatud. BlazingSQL ei ole t\u00e4isv\u00e4\u00e4rtuslik andmebaasis\u00fcsteem, vaid positsioneeritakse suurte andmekogumite anal\u00fc\u00fcsi ja t\u00f6\u00f6tlemise mootorrina, mille \u00fclesanded sarnanevad Apache Sparkiga. Kood on kirjutatud Pythonis ja on avatud Apache 2.0 litsentsi all. BlazingSQL sobib \u00fcksikute anal\u00fc\u00fctiliste p\u00e4ringute teostamiseks,","canonical_url":"https:\/\/prohoster.info\/et\/blog\/novosti-interneta\/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 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\/et\/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"},"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}]}}