{"id":30268,"date":"2019-10-31T21:34:35","date_gmt":"2019-10-31T18:34:35","guid":{"rendered":"https:\/\/prohoster.info\/blog\/kak-peremeshhat-vygruzhat-i-integrirovat-ochen-bolshie-dannye-dyoshevo-i-bystro-chto-takoe-pushdown-optimizatsiya\/"},"modified":"2019-10-31T21:34:35","modified_gmt":"2019-10-31T18:34:35","slug":"kak-peremeshhat-vygruzhat-i-integrirovat-ochen-bolshie-dannye-dyoshevo-i-bystro-chto-takoe-pushdown-optimizatsiya","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/kak-peremeshhat-vygruzhat-i-integrirovat-ochen-bolshie-dannye-dyoshevo-i-bystro-chto-takoe-pushdown-optimizatsiya","title":{"rendered":"Kuidas viia, eksportida ja integreerida v\u00e4ga suuri andmeid odavalt ja kiiresti? Mis on pushdown-optimeerimine?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Iga tegevus suurte andmete t\u00f6\u00f6tlemisel n\u00f5uab suuremaid arvutusv\u00f5imeid. Tavaline andmete liigutamine Hadoopisse v\u00f5ib v\u00f5tta n\u00e4dalaid v\u00f5i maksta sama palju kui lennuki tiib. Kas te ei soovi oodata ja kulutada? Tasakaalustage koormus erinevate platvormide vahel. \u00dcks v\u00f5imalus on pushdown-optimeerimine.<\/p>\n<p><\/p>\n<p>Palusin Venemaa juhtivalt Informatica toote arendamise ja haldamise treenerilt Alexei Ananjevilt r\u00e4\u00e4kida pushdown-optimeerimise funktsioonist Informatica Big Data Management (BDM) tarkvaras. Kas olete kunagi \u00f5ppinud Informatica tooteid kasutama? T\u00f5en\u00e4oliselt on just Alexei r\u00e4\u00e4kinud teile PowerCenteri aluseid ja selgitanud, kuidas kaarte koostada. <\/p>\n<p><\/p>\n<p><strong>Alexei Ananjev, DIS Groupi koolituse suuna juht<\/strong><\/p>\n<p><\/p>\n<p><strong>Mis on pushdown?<\/strong><\/p>\n<p><\/p>\n<p>Paljud teist on juba tuttavad Informatica Big Data Management (BDM) tarkvaraga. See toode suudab integreerida suuri andmeid erinevatest allikatest, liigutada neid erinevate s\u00fcsteemide vahel, tagada nendele lihtne ligip\u00e4\u00e4s, v\u00f5imaldab neid profiilida ja palju muud.<br \/>\nAhned k\u00e4tes suudab BDM teha imesid: \u00fclesanded t\u00e4idetakse kiiresti ja minimaalsete arvutusressurssidega. <\/p>\n<p><\/p>\n<p>Kas soovite samuti nii? \u00d5ppige kasutama pushdown-funktsiooni BDM-is, et jagada arvutuskoormust erinevate platvormide vahel. Pushdown-tehnoloogia v\u00f5imaldab muuta kaardi skriptiks ja valida keskkonna, kus see skript k\u00e4ivitatakse. See valik v\u00f5imaldab kombineerida erinevate platvormide tugevusi ja saavutada nende maksimaalne j\u00f5udlus.<\/p>\n<p><\/p>\n<p>Skripti t\u00e4itmise keskkonna seadmiseks peate valima pushdown-t\u00fc\u00fcbi. Skript v\u00f5ib olla t\u00e4ielikult k\u00e4ivitatud Hadoopis v\u00f5i osaliselt jaotatud allika ja sihtkoha vahel. On 4 v\u00f5imalikku pushdown-t\u00fc\u00fcpi. Kaarti ei pea muutma skriptiks (native). Kaarti saab t\u00e4ita maksimaalselt allikas (source) v\u00f5i t\u00e4ielikult allikas (full). Samuti saab kaardi muuta Hadoopi skriptiks (none).<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<p><strong>Pushdown-optimeerimine<\/strong><\/p>\n<p><\/p>\n<p>Neid 4 t\u00fc\u00fcpi saab omavahel erinevalt kombineerida \u2013 optimeerida pushdown vastavalt s\u00fcsteemi konkreetsetele vajadustele. N\u00e4iteks on sageli m\u00f5istlik andmeid andmebaasist v\u00e4lja t\u00f5mmata, kasutades selle enda v\u00f5imalusi. Ja andmete t\u00f6\u00f6tlemine \u2013 Hadoopi j\u00f5udlusega, et andmebaasi mitte \u00fcle koormata.<\/p>\n<p><\/p>\n<p>Vaadakem olukorda, kus nii allikas kui vastuv\u00f5tja asuvad andmebaasis, ja t\u00e4itmisplatvormi saab valida: olenevalt seadetest on see Informatica, andmebaasiserver v\u00f5i Hadoop. See n\u00e4ide v\u00f5imaldab k\u00f5ige t\u00e4psemalt m\u00f5ista selle mehhanismi tehnilist k\u00fclge. Loomulikult ei esine sellist olukorda reaalelus, kuid funktsionaalsuse demonstreerimiseks sobib see k\u00f5ige paremini. <\/p>\n<p><\/p>\n<p>V\u00f5tame mappimise kahe tabeli lugemiseks \u00fches Oracle andmebaasis. Ja lugemise tulemused salvestame samasse andmebaasi tabelisse. Mappimise skeem on j\u00e4rgmine:<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Kuidas viia, eksportida ja integreerida v\u00e4ga suuri andmeid odavalt ja kiiresti? Mis on pushdown-optimeerimine?\" src=\"\/wp-content\/uploads\/2019\/03\/e5bdacf6d7b0c3dbffd56c4876515520.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Informatica BDM 10.2.1 versioonis n\u00e4eb see v\u00e4lja j\u00e4rgmiselt:<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Kuidas viia, eksportida ja integreerida v\u00e4ga suuri andmeid odavalt ja kiiresti? Mis on pushdown-optimeerimine?\" src=\"\/wp-content\/uploads\/2019\/03\/5e7e1d81f0eac539aaec1c21717341e7.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><strong>Pushdown t\u00fc\u00fcp \u2013 native<\/strong><\/p>\n<p><\/p>\n<p>Kui valime pushdown native t\u00fc\u00fcbi, siis mappimine teostatakse <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/server\/dts-dronten\/\"   title=\"serveris\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2457\">serveris<\/a> Informatica. Andmed loetakse Oracle serverist, kantakse Informatica serverisse, muudetakse seal ja edastatakse Hadoopisse. Teisis\u00f5nu, saame tavalise ETL-protsessi.<\/p>\n<p><\/p>\n<p><strong>Pushdown t\u00fc\u00fcp \u2013 source <\/strong><\/p>\n<p><\/p>\n<p>Valides source t\u00fc\u00fcbi, saame v\u00f5imaluse jagada meie protsess <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/server\/dts-prohoster\/\"   title=\"serverilt\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2959\">serverilt<\/a> andmebaaside (DB) ja Hadoop vahel. Protsessi t\u00e4itmisel selle seadistusega saadetakse andmebaasi p\u00e4ringud tabelite andmete valimiseks. Ja \u00fclej\u00e4\u00e4nu toimub Hadoopis sammudena.<br \/>\nT\u00e4itmise skeem n\u00e4eb v\u00e4lja j\u00e4rgmiselt:<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Kuidas viia, eksportida ja integreerida v\u00e4ga suuri andmeid odavalt ja kiiresti? Mis on pushdown-optimeerimine?\" src=\"\/wp-content\/uploads\/2019\/03\/8b3b071ea0580394b222da033effceee.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Allpool on n\u00e4ide t\u00e4itmisv\u00f5imekuse seadistamisest.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Kuidas viia, eksportida ja integreerida v\u00e4ga suuri andmeid odavalt ja kiiresti? Mis on pushdown-optimeerimine?\" src=\"\/wp-content\/uploads\/2019\/03\/da7434ae71f4b2265f61fd31e182897e.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Sel juhul teostatakse mappimine kahes etapis. Selle seadistustes n\u00e4eme, et see on muutunud skriptiks, mis saadetakse allikale. \u00dchendamine ja andmete muutmine toimub \u00fcmberkirjutatud p\u00e4ringuna allikas.<br \/>\nAlloleval pildil n\u00e4eme optimeeritud mappimist BDM-is, ja allikas on \u00fcmberkirjutatud p\u00e4ring.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Kuidas viia, eksportida ja integreerida v\u00e4ga suuri andmeid odavalt ja kiiresti? Mis on pushdown-optimeerimine?\" src=\"\/wp-content\/uploads\/2019\/03\/c0e7534b06d2e09785ad8a6c5df15f6f.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Hadoopi roll selles konfiguratsioonis piirdub andmevoo haldamisega \u2013 nende dirigeerimisega. P\u00e4ringu tulemus suunatakse Hadoopisse. Andmete lugemise l\u00f5ppedes salvestatakse fail Hadoopist vastuv\u00f5tjasse.<\/p>\n<p><\/p>\n<p><strong>Pushdown t\u00fc\u00fcp \u2013 full <\/strong><\/p>\n<p><\/p>\n<p>Valides full t\u00fc\u00fcbi, muutub mappimine t\u00e4ielikult andmebaasi p\u00e4ringuks. Ja p\u00e4ringu tulemus suunatakse Hadoopisse. Sellise protsessi skeem on esitatud allpool.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Kuidas viia, eksportida ja integreerida v\u00e4ga suuri andmeid odavalt ja kiiresti? Mis on pushdown-optimeerimine?\" src=\"\/wp-content\/uploads\/2019\/03\/bfbb3f593a7053a0157d481d9b3bce83.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Seadistuse n\u00e4ide on esitatud allpool.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Kuidas viia, eksportida ja integreerida v\u00e4ga suuri andmeid odavalt ja kiiresti? Mis on pushdown-optimeerimine?\" src=\"\/wp-content\/uploads\/2019\/03\/31c70c7fb10996d5a506c6a4618f5f2f.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Tulemuseks saame optimeeritud mappimise, mis on sarnane eelmisele. Erinevus seisneb ainult selles, et kogu loogika kantakse vastuv\u00f5tjasse \u00fcmberkirjutatud sisendi kujul. Optimeeritud mappimise n\u00e4ide on esitatud allpool.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Kuidas viia, eksportida ja integreerida v\u00e4ga suuri andmeid odavalt ja kiiresti? Mis on pushdown-optimeerimine?\" src=\"\/wp-content\/uploads\/2019\/03\/edabf7ab6eba768849d096a4319e5126.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Siin, nagu eelnevas olukorras, t\u00e4idab Hadoop dirigendi rolli. Siiski toimub allika lugemine t\u00e4ielikult ja edasi vastuv\u00f5tja tasandil teostatakse andmete t\u00f6\u00f6tlemise loogika.<\/p>\n<p><\/p>\n<p><strong>Pushdown t\u00fc\u00fcp \u2013 null<\/strong><\/p>\n<p><\/p>\n<p>Viimane variant on pushdown t\u00fc\u00fcp, mille raames meie mapp muutub Hadoopi skriptiks.<\/p>\n<p><\/p>\n<p>Optimeeritud mapp n\u00e4eb n\u00fc\u00fcd v\u00e4lja j\u00e4rgmine:<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Kuidas viia, eksportida ja integreerida v\u00e4ga suuri andmeid odavalt ja kiiresti? Mis on pushdown-optimeerimine?\" src=\"\/wp-content\/uploads\/2019\/03\/deb8311403d4e95c2fef06d3b5c94e64.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Siin loetakse andmed allikafailidest esmalt Hadoopis. Seej\u00e4rel \u00fchendatakse need kaks faili Hadoopi vahendite abil. P\u00e4rast seda muudetakse andmed ja laaditakse andmebaasi.<\/p>\n<p><\/p>\n<p>M\u00f5istes pushdown-optimiseerimise p\u00f5him\u00f5tteid, saab paljusid suurte andmete t\u00f6\u00f6tlemise protsesse v\u00e4ga t\u00f5husalt korraldada. N\u00e4iteks hiljuti suudeti \u00fchel suurel ettev\u00f5ttel saada Hadoopist v\u00e4lja suure hulga andmeid, mille kogumine oli kestnud aastaid, vaid mitme n\u00e4dala jooksul.<\/p>\n<p>Allikas: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/445240\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041b\u044e\u0431\u0430\u044f \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u044f \u0441 \u0431\u043e\u043b\u044c\u0448\u0438\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0432\u044b\u0447\u0438\u0441\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u043c\u043e\u0449\u043d\u043e\u0441\u0442\u0435\u0439. \u041e\u0431\u044b\u0447\u043d\u043e\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u0449\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u0431\u0430\u0437\u044b \u043d\u0430 Hadoop \u043c\u043e\u0436\u0435\u0442 \u0434\u043b\u0438\u0442\u044c\u0441\u044f \u043d\u0435\u0434\u0435\u043b\u044f\u043c\u0438 \u0438\u043b\u0438 \u0441\u0442\u043e\u0438\u0442\u044c, \u043a\u0430\u043a \u043a\u0440\u044b\u043b\u043e \u0441\u0430\u043c\u043e\u043b\u0451\u0442\u0430. \u041d\u0435 \u0445\u043e\u0442\u0438\u0442\u0435 \u0436\u0434\u0430\u0442\u044c \u0438 \u0442\u0440\u0430\u0442\u0438\u0442\u044c\u0441\u044f? \u0421\u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u0443\u0439\u0442\u0435 \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0443 \u043d\u0430 \u0440\u0430\u0437\u043d\u044b\u0435 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b. \u041e\u0434\u0438\u043d \u0438\u0437 \u0441\u043f\u043e\u0441\u043e\u0431\u043e\u0432 \u2013 pushdown-\u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f. \u042f \u043f\u043e\u043f\u0440\u043e\u0441\u0438\u043b \u0432\u0435\u0434\u0443\u0449\u0435\u0433\u043e \u0432 \u0420\u043e\u0441\u0441\u0438\u0438 \u0442\u0440\u0435\u043d\u0435\u0440\u0430 \u043f\u043e \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0435 \u0438 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044e \u043f\u0440\u043e\u0434\u0443\u043a\u0442\u043e\u0432 Informatica \u0410\u043b\u0435\u043a\u0441\u0435\u044f \u0410\u043d\u0430\u043d\u044c\u0435\u0432\u0430 \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u0430\u0442\u044c \u043e [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-30268","post","type-post","status-publish","format-standard","hentry","category-blog"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041b\u044e\u0431\u0430\u044f \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u044f \u0441 \u0431\u043e\u043b\u044c\u0448\u0438\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0432\u044b\u0447\u0438\u0441\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u043c\u043e\u0449\u043d\u043e\u0441\u0442\u0435\u0439. \u041e\u0431\u044b\u0447\u043d\u043e\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u0449\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u0431\u0430\u0437\u044b \u043d\u0430 Hadoop \u043c\u043e\u0436\u0435\u0442 \u0434\u043b\u0438\u0442\u044c\u0441\u044f \u043d\u0435\u0434\u0435\u043b\u044f\u043c\u0438 \u0438\u043b\u0438 \u0441\u0442\u043e\u0438\u0442\u044c, \u043a\u0430\u043a \u043a\u0440\u044b\u043b\u043e \u0441\u0430\u043c\u043e\u043b\u0451\u0442\u0430.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/et\/blog\/kak-peremeshhat-vygruzhat-i-integrirovat-ochen-bolshie-dannye-dyoshevo-i-bystro-chto-takoe-pushdown-optimizatsiya\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"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\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u041a\u0430\u043a \u043f\u0435\u0440\u0435\u043c\u0435\u0449\u0430\u0442\u044c, \u0432\u044b\u0433\u0440\u0443\u0436\u0430\u0442\u044c \u0438 \u0438\u043d\u0442\u0435\u0433\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043e\u0447\u0435\u043d\u044c \u0431\u043e\u043b\u044c\u0448\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0434\u0451\u0448\u0435\u0432\u043e \u0438 \u0431\u044b\u0441\u0442\u0440\u043e? \u0427\u0442\u043e \u0442\u0430\u043a\u043e\u0435 pushdown-\u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f? | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041b\u044e\u0431\u0430\u044f \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u044f \u0441 \u0431\u043e\u043b\u044c\u0448\u0438\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0432\u044b\u0447\u0438\u0441\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u043c\u043e\u0449\u043d\u043e\u0441\u0442\u0435\u0439. \u041e\u0431\u044b\u0447\u043d\u043e\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u0449\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u0431\u0430\u0437\u044b \u043d\u0430 Hadoop \u043c\u043e\u0436\u0435\u0442 \u0434\u043b\u0438\u0442\u044c\u0441\u044f \u043d\u0435\u0434\u0435\u043b\u044f\u043c\u0438 \u0438\u043b\u0438 \u0441\u0442\u043e\u0438\u0442\u044c, \u043a\u0430\u043a \u043a\u0440\u044b\u043b\u043e \u0441\u0430\u043c\u043e\u043b\u0451\u0442\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/kak-peremeshhat-vygruzhat-i-integrirovat-ochen-bolshie-dannye-dyoshevo-i-bystro-chto-takoe-pushdown-optimizatsiya\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-10-31T18:34:35+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T18:34:35+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Kuidas liikuda, eksportida ja integreerida v\u00e4ga suuri andmeid odavalt ja kiiresti? Mis on pushdown-optimiseerimine? | ProHoster","description":"Iga operatsioon suurte andmete puhul n\u00f5uab suurt arvutusv\u00f5imet. Tavaandmete liikumine andmebaasist Hadoopi v\u00f5ib kesta n\u00e4dalate viisi v\u00f5i maksta kui lennuki tiib.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/kak-peremeshhat-vygruzhat-i-integrirovat-ochen-bolshie-dannye-dyoshevo-i-bystro-chto-takoe-pushdown-optimizatsiya","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\u041a\u0430\u043a \u043f\u0435\u0440\u0435\u043c\u0435\u0449\u0430\u0442\u044c, \u0432\u044b\u0433\u0440\u0443\u0436\u0430\u0442\u044c \u0438 \u0438\u043d\u0442\u0435\u0433\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043e\u0447\u0435\u043d\u044c \u0431\u043e\u043b\u044c\u0448\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0434\u0451\u0448\u0435\u0432\u043e \u0438 \u0431\u044b\u0441\u0442\u0440\u043e? \u0427\u0442\u043e \u0442\u0430\u043a\u043e\u0435 pushdown-\u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f? | ProHoster","og:description":"\u041b\u044e\u0431\u0430\u044f \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u044f \u0441 \u0431\u043e\u043b\u044c\u0448\u0438\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0432\u044b\u0447\u0438\u0441\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u043c\u043e\u0449\u043d\u043e\u0441\u0442\u0435\u0439. \u041e\u0431\u044b\u0447\u043d\u043e\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u0449\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u0431\u0430\u0437\u044b \u043d\u0430 Hadoop \u043c\u043e\u0436\u0435\u0442 \u0434\u043b\u0438\u0442\u044c\u0441\u044f \u043d\u0435\u0434\u0435\u043b\u044f\u043c\u0438 \u0438\u043b\u0438 \u0441\u0442\u043e\u0438\u0442\u044c, \u043a\u0430\u043a \u043a\u0440\u044b\u043b\u043e \u0441\u0430\u043c\u043e\u043b\u0451\u0442\u0430.","og:url":"https:\/\/prohoster.info\/et\/blog\/kak-peremeshhat-vygruzhat-i-integrirovat-ochen-bolshie-dannye-dyoshevo-i-bystro-chto-takoe-pushdown-optimizatsiya","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-31T18:34:35+00:00","article:modified_time":"2019-10-31T18:34:35+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"30268","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":"Article","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-02-09 21:49:15","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 03:38:39","updated":"2026-02-09 21:49:15","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\/30268","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=30268"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/30268\/revisions"}],"predecessor-version":[{"id":160240,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/30268\/revisions\/160240"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=30268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=30268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=30268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}