{"id":87609,"date":"2020-07-09T01:42:11","date_gmt":"2020-07-08T23:42:11","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/kogda-u-vas-sberovskie-masshtaby-ispolzovanie-ab-initio-pri-rabote-s-hive-i-greenplum"},"modified":"2020-07-09T01:42:11","modified_gmt":"2020-07-08T23:42:11","slug":"kogda-u-vas-sberovskie-masshtaby-ispolzovanie-ab-initio-pri-rabote-s-hive-i-greenplum","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kogda-u-vas-sberovskie-masshtaby-ispolzovanie-ab-initio-pri-rabote-s-hive-i-greenplum","title":{"rendered":"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Disa m\u00eb par\u00eb, na erdhi n\u00eb mendje pyetja e zgjedhjes s\u00eb nj\u00eb mjeti ETL p\u00ebr t\u00eb punuar me BigData. Zgjidhja e m\u00ebparshme Informatica BDM nuk na e plot\u00ebsonte nevojat p\u00ebr shkak t\u00eb funksionalitetit t\u00eb kufizuar. P\u00ebrdorimi i saj p\u00ebrfundonte n\u00eb nj\u00eb korniz\u00eb p\u00ebr t\u00eb nisur komandat spark-submit. N\u00eb treg nuk kishte shum\u00eb alternativa q\u00eb ishin n\u00eb gjendje t\u00eb punonin me volumet e t\u00eb dh\u00ebnave me t\u00eb cilat ne merremi \u00e7do dit\u00eb. N\u00eb fund, ne zgjodh\u00ebm Ab Initio. Gjat\u00eb demonstratave pilot, produkti tregoi nj\u00eb shpejt\u00ebsi shum\u00eb t\u00eb lart\u00eb n\u00eb p\u00ebrpunimin e t\u00eb dh\u00ebnave. Informacione mbi Ab Initio n\u00eb gjuh\u00ebn ruse jan\u00eb pothuajse t\u00eb pandodhura, prandaj vendos\u00ebm t\u00eb ndajm\u00eb p\u00ebrvoj\u00ebn ton\u00eb n\u00eb Habr.<\/p>\n<p>Ab Initio ka nj\u00eb shum\u00ebllojshm\u00ebri transformimesh klasike dhe t\u00eb pazakonta, kodi i t\u00eb cilave mund t\u00eb zgjerohet me an\u00eb t\u00eb gjuh\u00ebs s\u00eb tij PDL. P\u00ebr bizneset e vogla, nj\u00eb mjet kaq i fuqish\u00ebm, ndoshta, do t\u00eb ishte i tep\u00ebrt, dhe shumica e mund\u00ebsive t\u00eb tij mund t\u00eb duken t\u00eb shtrenjta dhe pa p\u00ebrdorim. Por n\u00ebse shkall\u00ebt tuaja i afrohen atyre t\u00eb Sberbank, at\u00ebher\u00eb Ab Initio mund t\u00eb jet\u00eb i interesuar p\u00ebr ju. <\/p>\n<p>Ai ndihmon biznesin globalisht t\u00eb grumbulloj\u00eb njohuri dhe t\u00eb zhvilloj\u00eb ekosistemin, nd\u00ebrsa zhvilluesit \u2014 t\u00eb avancojn\u00eb aft\u00ebsit\u00eb e tyre n\u00eb ETL, t\u00eb p\u00ebrmir\u00ebsojn\u00eb njohurit\u00eb n\u00eb shell, ofron mund\u00ebsin\u00eb p\u00ebr t'u njohur me gjuh\u00ebn PDL, jep nj\u00eb pamje vizuale t\u00eb proceseve t\u00eb ngarkes\u00ebs, dhe e thjeshton zhvillimin fal\u00eb shumtis\u00eb s\u00eb komponent\u00ebve funksional\u00eb.<\/p>\n<p>N\u00eb k\u00ebt\u00eb postim do t\u00eb flas p\u00ebr mund\u00ebsit\u00eb e Ab Initio dhe do t\u00eb jap karakteristikat krahasuese p\u00ebr pun\u00ebn e tij me Hive dhe GreenPlum.<\/p>\n<ul>\n<li>P\u00ebrshkrimi i korniz\u00ebs MDW dhe pun\u00ebve p\u00ebr p\u00ebrshtatjen e saj p\u00ebr GreenPlum<\/li>\n<li>Karakteristikat krahasuese t\u00eb performanc\u00ebs s\u00eb Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum<\/li>\n<li>Puna e Ab Initio me GreenPlum n\u00eb modalitetin Near Real Time<\/li>\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nFunksionaliteti i k\u00ebtij produkti \u00ebsht\u00eb shum\u00eb i gjer\u00eb dhe k\u00ebrkon nj\u00eb koh\u00eb t\u00eb konsiderueshme p\u00ebr t'u m\u00ebsuar. Megjithat\u00eb, me aft\u00ebsi t\u00eb duhura n\u00eb pun\u00eb dhe konfigurime t\u00eb sakta t\u00eb performanc\u00ebs, rezultatet e p\u00ebrpunimit t\u00eb t\u00eb dh\u00ebnave jan\u00eb mjaft impresionuese. P\u00ebrdorimi i Ab Initio p\u00ebr nj\u00eb zhvillues mund t\u00eb ofroj\u00eb nj\u00eb p\u00ebrvoj\u00eb interesante. Kjo \u00ebsht\u00eb nj\u00eb shikim i ri n\u00eb zhvillimin ETL, nj\u00eb hibrid midis mjedisit vizual dhe zhvillimit t\u00eb ngarkesave n\u00eb nj\u00eb gjuh\u00eb t\u00eb ngjashme me skriptin.<\/p>\n<p>Biznesi po zhvillon ekosistemet e tij dhe ky mjet duket se \u00ebsht\u00eb m\u00eb i nevojsh\u00ebm se kurr\u00eb. Me Ab Initio \u00ebsht\u00eb e mundur t\u00eb grumbullohen njohurit\u00eb mbi biznesin aktual dhe t'i p\u00ebrdorim ato p\u00ebr t\u00eb zgjeruar bizneset e vjetra dhe p\u00ebr t\u00eb hapur t\u00eb reja. Alternativat e Ab Initio p\u00ebrfshijn\u00eb mjediset vizuale t\u00eb zhvillimit Informatica BDM dhe ato jo-vizuale si Apache Spark.<\/p>\n<h3>P\u00ebrshkrimi i Ab Initio<\/h3>\n<p>\nAb Initio, si\u00e7 \u00ebsht\u00eb dhe mjetet e tjera ETL, p\u00ebrb\u00ebn nj\u00eb grup produktesh.<\/p>\n<p><img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/c467fe1e8455805075856967b577f8b7.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nAb Initio GDE (Graphical Development Environment) \u00ebsht\u00eb nj\u00eb mjedis p\u00ebr zhvilluesit ku ata ndyshojn\u00eb transformimet e t\u00eb dh\u00ebnave dhe i lidhen ato me rrjedha t\u00eb dh\u00ebnash n\u00eb form\u00ebn e shigjetave. K\u00ebto transformime quhen graf\u00eb:<\/p>\n<p><img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/7b0c19a82ae8b461a9bd85117555e106.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nLidhjet hyr\u00ebse dhe dal\u00ebse t\u00eb komponent\u00ebve funksional\u00eb jan\u00eb porte dhe p\u00ebrmbajn\u00eb fushat e llogaritura brenda transformimeve. Disa graf\u00eb, t\u00eb lidhur me rrjedha n\u00eb form\u00ebn e shigjetave sipas rendit t\u00eb ekzekutimit quhen plan.<\/p>\n<p>Ekzistojn\u00eb disa qindra komponent\u00eb funksional\u00eb, q\u00eb jan\u00eb shum\u00eb t\u00eb shumt\u00eb. Shumica e tyre jan\u00eb t\u00eb specializuar. Mund\u00ebsit\u00eb e transformimeve klasike n\u00eb Ab Initio jan\u00eb m\u00eb t\u00eb gjera se n\u00eb mjetet e tjera ETL. P\u00ebr shembull, Join ka disa dalje. P\u00ebrve\u00e7 rezultatit t\u00eb bashkimit t\u00eb dataset-eve, mund t\u00eb merret n\u00eb dalje edhe regjistrimi i dataset-eve hyr\u00ebse p\u00ebr t\u00eb cilat nuk arriti t\u00eb bashkohet. Po ashtu, mund t\u00eb merret rejects, errors dhe log-u i pun\u00ebs s\u00eb transformimit, i cili mund t\u00eb lexohet si nj\u00eb skedar tekstual n\u00eb k\u00ebt\u00eb graf dhe t\u00eb p\u00ebrpunohen nga transformime t\u00eb tjera:<\/p>\n<p><img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/c7d70879daad364a3d4aa41a0a1b738d.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nOse, p\u00ebr shembull, mund t\u00eb materializohet pranuesi i t\u00eb dh\u00ebnave n\u00eb form\u00ebn e nj\u00eb tabele dhe n\u00eb k\u00ebt\u00eb graf t\u00eb lexohen t\u00eb dh\u00ebnat prej saj.<\/p>\n<p>Ka transformime origjinale. P\u00ebr shembull, transformimi Scan ka funksionalitet si funksionet analitike. Ekzistojn\u00eb transformime me emra t\u00eb kuptuesh\u00ebm: Create Data, Read Excel, Normalize, Sort within Groups, Run Program, Run SQL, Join with DB, etj. Graf\u00ebt mund t\u00eb p\u00ebrdorin parametra t\u00eb koh\u00ebs s\u00eb ekzekutimit, p\u00ebrfshir\u00eb mund\u00ebsin\u00eb e kalimit t\u00eb parametrave nga sistemi operativ ose n\u00eb sistemin operativ. Skedar\u00ebt me grupin e gatsh\u00ebm t\u00eb parametrave t\u00eb d\u00ebrguar n\u00eb graf quhen parameter sets (psets).<\/p>\n<p>Si\u00e7 pritet, Ab Initio GDE ka depozitat e saj, t\u00eb quajtura EME (Enterprise Meta Environment). Zhvilluesit kan\u00eb mund\u00ebsin\u00eb t\u00eb punojn\u00eb me versione lokale t\u00eb kodit dhe t\u00eb b\u00ebjn\u00eb check in t\u00eb zhvillimeve t\u00eb tyre n\u00eb depozitat qendrore.<\/p>\n<p>Ka kemi mund\u00ebsin\u00eb q\u00eb gjat\u00eb ose pas ekzekutimit t\u00eb grafik\u00ebs t\u00eb klikojm\u00eb mbi \u00e7do lidhje q\u00eb transformon flukset dhe t\u00eb shikojm\u00eb t\u00eb dh\u00ebnat q\u00eb kaluan nd\u00ebrmjet k\u00ebtyre transformimeve.<\/p>\n<p><img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/a674507b2cd25b980cb862bda2e10cbe.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nGjithashtu, ka mund\u00ebsin\u00eb t\u00eb klikojm\u00eb mbi \u00e7do rrjedh\u00eb dhe t\u00eb shikojm\u00eb detajet e ndjekjes \u2013 sa paralelisht ka punuar transformimi, sa rreshta dhe byte jan\u00eb ngarkuar n\u00eb cil\u00ebn nga paralel\u00ebt.<\/p>\n<p><img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/6188d17bebe756ee59e6956f9a40ec43.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nKa mund\u00ebsi t\u00eb ndajm\u00eb ekzekutimin e grafik\u00ebs n\u00eb faza dhe t\u00eb sh\u00ebnojm\u00eb se disa transformime duhet t\u00eb ekzekutohen n\u00eb fillim (n\u00eb faz\u00ebn zero), pasuar nga ato n\u00eb faz\u00ebn e par\u00eb, dhe m\u00eb pas n\u00eb faz\u00ebn e dyt\u00eb, etj.<\/p>\n<p>\u00c7do transformim mund t\u00eb zgjedh\u00eb nj\u00eb layout t\u00eb ashtuquajtur (ku do t\u00eb ekzekutohet): pa paralel\u00eb ose n\u00eb fluste paralel\u00eb, numrin e t\u00eb cilave mund ta p\u00ebrcaktojm\u00eb. N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb, skedar\u00ebt p\u00ebrkoh\u00ebsor\u00eb q\u00eb krijon Ab Initio gjat\u00eb pun\u00ebs s\u00eb transformimeve mund t\u00eb vendosen si n\u00eb sistemin e skedareve <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sq\/server\/dts-los-angeles\/\"   title=\"\u0441\u0435\u0440\u0432\u0435\u0440\u0430\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3635\">\u0441\u0435\u0440\u0432\u0435\u0440\u0430<\/a>, ashtu edhe n\u00eb HDFS.<\/p>\n<p>N\u00eb \u00e7do transformim bazuar n\u00eb modelin e parazgjedhur, mund t\u00eb krijoni skenarin tuaj n\u00eb gjuh\u00ebn PDL, e cila \u00ebsht\u00eb paksa e ngjashme me shell. <\/p>\n<p>Me an\u00eb t\u00eb gjuh\u00ebs PDL, ju mund t\u00eb zgjatni funksionalitetin e transformimeve dhe, konkretisht, mund t\u00eb gjeneroni n\u00eb m\u00ebnyr\u00eb dinamike ( gjat\u00eb ekzekutimit) fragma t\u00eb rast\u00ebsishme t\u00eb kodit n\u00eb var\u00ebsi t\u00eb parametrave t\u00eb ekzekutimit.<\/p>\n<p>Po ashtu, n\u00eb Ab Initio integrimi me OS-n\u00eb \u00ebsht\u00eb m\u00ebse i zhvilluar p\u00ebrmes shell-it. Konkretisht n\u00eb Sberbank p\u00ebrdoret linux ksh. Mund t\u00eb shk\u00ebmbeni me shell variablat dhe t\u2019i p\u00ebrdorni ato si parametra t\u00eb grafik\u00ebve. Mund t\u00eb th\u00ebrrisni ekzekutimin e grafik\u00ebve Ab Initio nga shell dhe t\u00eb administroni Ab Initio.<\/p>\n<p>P\u00ebrve\u00e7 Ab Initio GDE, d\u00ebrgesa p\u00ebrfshin shum\u00eb produkte t\u00eb tjer\u00eb. Ka nj\u00eb sistem Co&gt;Operation me pretendimin p\u00ebr t\u2019u quajtur sistem operativ. Ka Control&gt;Center, ku mund t\u00eb vendosni n\u00eb program dhe t\u00eb monitoroni flukset e ngarkes\u00ebs. Ka produkte p\u00ebr zhvillim n\u00eb nj\u00eb nivel m\u00eb t\u00eb thjesht\u00eb sesa lejon Ab Initio GDE.<\/p>\n<h3>P\u00ebrshkrimi i korniz\u00ebs MDW dhe pun\u00ebve p\u00ebr p\u00ebrshtatjen e saj p\u00ebr GreenPlum<\/h3>\n<p>\nS\u00eb bashku me produktet e tij, shit\u00ebsi ofron produktin MDW (Metadata Driven Warehouse), i cili \u00ebsht\u00eb nj\u00eb konfigurues grafik\u00ebsh, i destinuar p\u00ebr t\u00eb ndihmuar n\u00eb detyrat tipike t\u00eb mbushjes s\u00eb depozita t\u00eb dh\u00ebnash ose vault-eve t\u00eb dh\u00ebnash.<\/p>\n<p>Ai p\u00ebrmban parser\u00eb metadatas p\u00ebrdoruesish (specifik p\u00ebr projektin) dhe gjenerator\u00eb kodi \u201cnd\u00ebr shfletues\u201d.<\/p>\n<p><img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/0842ecb9550f369875103ccb23cdf121.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nMDW merr modelin e t\u00eb dh\u00ebnave, nj\u00eb sked\u00eb konfigurimi p\u00ebr cil\u00ebsimin e lidhjes me baz\u00ebn e t\u00eb dh\u00ebnave (Oracle, Teradata ose Hive) dhe disa cil\u00ebsime t\u00eb tjera. Pjesa specifike p\u00ebr projektin, p\u00ebr shembull, e vendos modelin n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave. Pjesa standarde e produktit gjeneron grafet dhe skedat e konfigurimit p\u00ebr to, n\u00eb procesin e ngarkimit t\u00eb t\u00eb dh\u00ebnave n\u00eb tabelat e modelit. Kjo krijon grafet (dhe psets) p\u00ebr disa m\u00ebnyra t\u00eb pun\u00ebs fillestare dhe inkrementale p\u00ebr p\u00ebrdit\u00ebsimin e entiteteve.<\/p>\n<p>N\u00eb rastet e Hive dhe RDBMS, gjenerohen grafet e ndryshme p\u00ebr p\u00ebrdit\u00ebsimin fillestar dhe inkremental t\u00eb t\u00eb dh\u00ebnave.<\/p>\n<p>N\u00eb rastin e Hive, t\u00eb dh\u00ebnat e d\u00ebrguara t\u00eb dyt\u00ebs kombinohen p\u00ebrmes Ab Initio Join me t\u00eb dh\u00ebnat q\u00eb kan\u00eb qen\u00eb n\u00eb tabel\u00eb para p\u00ebrdit\u00ebsimit. Ngarkuesit e t\u00eb dh\u00ebnave n\u00eb MDW (si n\u00eb Hive, ashtu edhe n\u00eb RDBMS) jo vet\u00ebm q\u00eb futin t\u00eb dh\u00ebna t\u00eb reja nga d\u00eblta, por gjithashtu mbyllin periudhat e aktualitetit t\u00eb t\u00eb dh\u00ebnave, sipas \u00e7el\u00ebsave primar\u00eb p\u00ebr t\u00eb cil\u00ebt ka ardhur d\u00eblta. P\u00ebr m\u00eb tep\u00ebr, duhet t\u00eb rilexohet p\u00ebrs\u00ebri pjesa e pandryshuar e t\u00eb dh\u00ebnave. Megjithat\u00eb, kjo \u00ebsht\u00eb e nevojshme, pasi n\u00eb Hive nuk ka operacione t\u00eb fshirjes ose p\u00ebrdit\u00ebsimit.<\/p>\n<p><img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/36b6dd7c4d45727ad7d7aa1183fdd5fd.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nNd\u00ebrsa n\u00eb rastin e RDBMS, grafet p\u00ebr p\u00ebrdit\u00ebsimin inkremental t\u00eb t\u00eb dh\u00ebnave duken m\u00eb optimiste, sepse RDBMS ka mund\u00ebsi t\u00eb v\u00ebrteta p\u00ebr p\u00ebrdit\u00ebsim.<\/p>\n<p><img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/b62ac222bed575a60b632b13e012f603.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nD\u00eblta e pranuar ngarkohet n\u00eb nj\u00eb tabel\u00eb nd\u00ebrmjet\u00ebse n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave. Pas k\u00ebsaj, ndodhi kombinimi i d\u00eblta me t\u00eb dh\u00ebnat q\u00eb ishin n\u00eb tabel\u00eb para p\u00ebrdit\u00ebsimit. Kjo b\u00ebhet me an\u00eb t\u00eb SQL p\u00ebrmes nj\u00eb pyetjeje SQL t\u00eb gjeneruar. M\u00eb pas, p\u00ebrmes komandave SQL p\u00ebr fshirje+futje, b\u00ebhet futja e t\u00eb dh\u00ebnave t\u00eb reja nga d\u00eblta n\u00eb tabel\u00ebn e objektit dhe mbyllen periudhat e aktualitetit t\u00eb t\u00eb dh\u00ebnave, sipas \u00e7el\u00ebsave primar\u00eb p\u00ebr t\u00eb cil\u00ebt ka ardhur d\u00eblta. <br \/>\nNuk \u00ebsht\u00eb e nevojshme t\u00eb rilexohet pjesa e pandryshuar e t\u00eb dh\u00ebnave.<\/p>\n<p>K\u00ebshtu, arrit\u00ebm n\u00eb p\u00ebrfundimin se n\u00eb rastin e Hive, MDW duhet t\u00eb b\u00ebj\u00eb p\u00ebrs\u00ebri t\u00eb gjith\u00eb tabel\u00ebn, sepse Hive nuk ka funksion p\u00ebrdit\u00ebsimi. Dhe asgj\u00eb m\u00eb e mir\u00eb se rileximi i plot\u00eb i t\u00eb dh\u00ebnave gjat\u00eb p\u00ebrdit\u00ebsimit nuk \u00ebsht\u00eb krijuar. N\u00eb rastin e RDBMS, p\u00ebrkundrazi, krijuesit e produktit e konsideruan t\u00eb nevojshme t\u00eb besojn\u00eb lidhjen dhe p\u00ebrdit\u00ebsimin e tabelave p\u00ebr p\u00ebrdorimin e SQL.<\/p>\n<p>P\u00ebr projektin n\u00eb Sberbank, ne krijuam nj\u00eb implementim t\u00eb ri t\u00eb rip\u00ebrdorsh\u00ebm t\u00eb ngarkuesit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave p\u00ebr GreenPlum. Kjo ishte e bazuar n\u00eb versionin q\u00eb MDW gjeneron p\u00ebr Teradata. Pik\u00ebrisht Teradata, dhe jo Oracle, ishte m\u00eb e p\u00ebrshtatshme p\u00ebr k\u00ebt\u00eb, pasi gjithashtu \u00ebsht\u00eb nj\u00eb sistem MPP. M\u00ebnyrat e pun\u00ebs, si dhe sintaksa e Teradata dhe GreenPlum, rezultuan t\u00eb ken\u00eb ngjashm\u00ebri.<\/p>\n<p>Shembujt e dallimeve kritike p\u00ebr MDW midis RDBMS-ve t\u00eb ndryshme jan\u00eb si m\u00eb posht\u00eb. N\u00eb GreenPlum, ndryshe nga Teradata, kur krijoni tabela, duhet t\u00eb shkruani nj\u00eb klauzol\u00eb<\/p>\n<pre><code class=\"sql\">distributed by<\/code><\/pre>\n<p>\nN\u00eb Teradata shkruhet<\/p>\n<pre><code class=\"sql\">fshij &lt;table&gt; t&euml; gjitha<\/code><\/pre>\n<p>\n, nd\u00ebrsa n\u00eb GreenPlum shkruhet<\/p>\n<pre><code class=\"sql\">fshij nga &lt;table&gt;<\/code><\/pre>\n<p>\nN\u00eb Oracle, p\u00ebr q\u00ebllime optimizimi, shkruhet<\/p>\n<pre><code class=\"sql\">delete from t where rowid in ()<\/code><\/pre>\n<p>\n, nd\u00ebrsa n\u00eb Teradata dhe GreenPlum shkruhet<\/p>\n<pre><code class=\"sql\">delete from t where exists (select * from delta where delta.pk=t.pk)<\/code><\/pre>\n<p>\nGjithashtu, duhet t\u00eb theksojm\u00eb se p\u00ebr funksionimin e Ab Initio me GreenPlum, ishte e nevojshme t\u00eb instalonim klientin e GreenPlum n\u00eb t\u00eb gjitha nodet e klasterit Ab Initio. Kjo p\u00ebr shkak se ne u lidh\u00ebm me GreenPlum nj\u00ebher\u00ebsh nga t\u00eb gjitha nyjet e klasterit ton\u00eb. Dhe q\u00eb leximi nga GreenPlum t\u00eb ishte paralel dhe \u00e7do rrjedh\u00eb paralele e Ab Initio t\u00eb lexonte porcionin e saj t\u00eb t\u00eb dh\u00ebnave nga GreenPlum, duhej t\u00eb vendosnim n\u00eb seksionin \u201cku\u201d t\u00eb pyetjeve SQL nj\u00eb konstrukcion t\u00eb kuptuesh\u00ebm p\u00ebr Ab Initio<\/p>\n<pre><code class=\"sql\">where ABLOCAL()<\/code><\/pre>\n<p>\ndhe t\u00eb p\u00ebrcaktonim vler\u00ebn e k\u00ebsaj konstrukcioni, duke e caktuar parametrin e transformimit q\u00eb lexon nga DB<\/p>\n<pre><code class=\"sql\">ablocal_expr=\u00abstring_concat(\"mod(t.\", string_filter_out(\"{$TABLE_KEY}\",\"{}\"), \",\", (decimal(3))(number_of_partitions()),\"=\" , (decimal(3))(this_partition()))\u00bb<\/code><\/pre>\n<p>\n, e cila kompilohhet n\u00eb di\u00e7ka si<\/p>\n<pre><code class=\"sql\">mod(sk,10)=3<\/code><\/pre>\n<p>\n, dmth, na duhet t\u00eb tregojm\u00eb GreenPlum nj\u00eb filt\u00ebr t\u00eb qart\u00eb p\u00ebr secil\u00ebn parti. P\u00ebr bazat e tjera t\u00eb t\u00eb dh\u00ebnave (Teradata, Oracle), Ab Initio mund ta kryej\u00eb k\u00ebt\u00eb paralelizim automatikisht.<\/p>\n<h3>Karakteristikat krahasuese t\u00eb performanc\u00ebs s\u00eb Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum<\/h3>\n<p>\nN\u00eb Sberbank u zhvillua nj\u00eb eksperiment p\u00ebr t\u00eb krahasuar performanc\u00ebn e grafik\u00ebve t\u00eb gjeneruar nga MDW n\u00eb lidhje me Hive dhe GreenPlum. N\u00eb kuad\u00ebr t\u00eb eksperimentit, n\u00eb rastin e Hive kishte 5 node n\u00eb t\u00eb nj\u00ebjtin klaster me Ab Initio, nd\u00ebrsa n\u00eb rastin e GreenPlum kishte 4 node n\u00eb nj\u00eb klaster t\u00eb ve\u00e7ant\u00eb. DMth, Hive kishte nj\u00eb avantazh t\u00eb caktuar mbi GreenPlum \u201cn\u00eb harduer\u201d.<\/p>\n<p>U shqyrtuan dy \u00e7ift grafesh q\u00eb realizonin t\u00eb nj\u00ebjtin detyr\u00eb t\u00eb p\u00ebrdit\u00ebsimit t\u00eb t\u00eb dh\u00ebnave n\u00eb Hive dhe n\u00eb GreenPlum. N\u00eb k\u00ebt\u00eb rast, u nis\u00ebn grafik\u00ebt e gjeneruar nga konfiguratori MDW:<\/p>\n<ul>\n<li>ngarkesa fillestare + ngarkesa inkrimetuese e t\u00eb dh\u00ebnave t\u00eb rast\u00ebsishme t\u00eb gjeneruara n\u00eb tabel\u00ebn Hive<\/li>\n<li>ngarkesa fillestare + ngarkesa inkrimetuese e t\u00eb dh\u00ebnave t\u00eb rast\u00ebsishme t\u00eb gjeneruara n\u00eb nj\u00eb tabel\u00eb t\u00eb ngjashme GreenPlum<\/li>\n<\/ul>\n<p>\nN\u00eb t\u00eb dyja rastet (Hive dhe GreenPlum) u lan\u00e7uan ngarkesa n\u00eb 10 rrjedha paralele n\u00eb t\u00eb nj\u00ebjtin klaster Ab Initio. T\u00eb dh\u00ebnat nd\u00ebrmjet\u00ebse p\u00ebr llogaritjet Ab Initio u ruajt\u00ebn n\u00eb HDFS (n\u00eb terma t\u00eb Ab Initio u p\u00ebrdor MFS layout duke p\u00ebrdorur HDFS). Nj\u00eb rresht i t\u00eb dh\u00ebnave t\u00eb krijuara rast\u00ebsisht zinte 200 byte n\u00eb t\u00eb dyja rastet.<\/p>\n<p>Rezultati doli si m\u00eb posht\u00eb:<\/p>\n<p><b>Hive:<\/b><\/p>\n<p><b>Ngarkesa fillestare n\u00eb Hive<\/b><\/p>\n<p>Numri i rreshtave t\u00eb futur<br \/>\n6 000 000<br \/>\n60 000 000<br \/>\n600 000 000<\/p>\n<p>Koh\u00ebzgjatja e ngarkes\u00ebs fillestare<br \/>\nn\u00eb sekonda<br \/>\n41<br \/>\n203<br \/>\n1 601<\/p>\n<p><b>Ngarkesa inkrementale n\u00eb Hive<\/b><\/p>\n<p>Numri i rreshtave q\u00eb ishin n\u00eb<br \/>\ntabel\u00ebn e synuar n\u00eb fillim t\u00eb eksperimentit<br \/>\n6 000 000<br \/>\n60 000 000<br \/>\n600 000 000<\/p>\n<p>Numri i rreshtave t\u00eb dyt\u00eb q\u00eb u aplikuan n\u00eb<br \/>\ntabel\u00ebn e synuar gjat\u00eb eksperimentit<br \/>\n6 000 000<br \/>\n6 000 000<br \/>\n6 000 000<\/p>\n<p>Koh\u00ebzgjatja e ngarkes\u00ebs inkrementale<br \/>\nn\u00eb sekonda<br \/>\n88<br \/>\n299<br \/>\n<b>2 541<\/b><\/p>\n<p>\n<b>GreenPlum:<\/b><\/p>\n<p><b>Ngarkesa fillestare n\u00eb GreenPlum<\/b><\/p>\n<p>Numri i rreshtave t\u00eb futur<br \/>\n6 000 000<br \/>\n60 000 000<br \/>\n600 000 000<\/p>\n<p>Koh\u00ebzgjatja e ngarkes\u00ebs fillestare<br \/>\nn\u00eb sekonda<br \/>\n72<br \/>\n360<br \/>\n3 631<\/p>\n<p><b>Ngarkesa inkrementale n\u00eb GreenPlum<\/b><\/p>\n<p>Numri i rreshtave q\u00eb ishin n\u00eb<br \/>\ntabel\u00ebn e synuar n\u00eb fillim t\u00eb eksperimentit<br \/>\n6 000 000<br \/>\n60 000 000<br \/>\n600 000 000<\/p>\n<p>Numri i rreshtave t\u00eb dyt\u00eb q\u00eb u aplikuan n\u00eb<br \/>\ntabel\u00ebn e synuar gjat\u00eb eksperimentit<br \/>\n6 000 000<br \/>\n6 000 000<br \/>\n6 000 000<\/p>\n<p>Koh\u00ebzgjatja e ngarkes\u00ebs inkrementale<br \/>\nn\u00eb sekonda<br \/>\n159<br \/>\n199<br \/>\n<b>321<\/b><\/p>\n<p>\nDuket se shpejt\u00ebsia e ngarkes\u00ebs fillestare si n\u00eb Hive ashtu edhe n\u00eb GreenPlum varet linearisht nga volumi i t\u00eb dh\u00ebnave dhe p\u00ebr shkak t\u00eb pajisjeve m\u00eb t\u00eb mira \u00ebsht\u00eb pak m\u00eb e shpejt\u00eb p\u00ebr Hive se p\u00ebr GreenPlum.<\/p>\n<p>Ngarkesa inkrementale n\u00eb Hive gjithashtu varet linearisht nga volumi i t\u00eb dh\u00ebnave t\u00eb ngarkuara m\u00eb par\u00eb n\u00eb tabelat e synuara dhe kalon mjaft ngadal\u00eb me rritjen e volumit. Kjo shkaktohet nga nevoja p\u00ebr t\u00eb riparuar plot\u00ebsisht tabel\u00ebn e synuar. Kjo do t\u00eb thot\u00eb se aplikimi i ndryshimeve t\u00eb vogla n\u00eb tabela t\u00eb m\u00ebdha nuk \u00ebsht\u00eb nj\u00eb opsion i mir\u00eb p\u00ebr p\u00ebrdorim n\u00eb Hive.<\/p>\n<p>Ngarkesa inkrementale n\u00eb GreenPlum varion pak nga volumi i t\u00eb dh\u00ebnave t\u00eb ngarkuara m\u00eb par\u00eb n\u00eb tabelat e synuara dhe kalon mjaft shpejt. Kjo arrihet fal\u00eb SQL Joins dhe arkitektur\u00ebs s\u00eb GreenPlum, e cila lejon operacionin delete.<\/p>\n<p>Pra, GreenPlum b\u00ebn derdhjen e diferenc\u00ebs duke p\u00ebrdorur metod\u00ebn delete+insert, nd\u00ebrsa n\u00eb Hive nuk ka operacione delete ose update, prandaj e gjith\u00eb masa e t\u00eb dh\u00ebnave n\u00eb p\u00ebrdit\u00ebsimin inkremental duhej t\u00eb shkruhej p\u00ebrs\u00ebri n\u00eb t\u00ebr\u00ebsi. M\u00eb e dukshme \u00ebsht\u00eb krahasimi i qelizave t\u00eb theksuara me ndihm\u00ebn e bold, pasi kjo p\u00ebrkon me variantin m\u00eb t\u00eb zakonsh\u00ebm t\u00eb shfryt\u00ebzimit t\u00eb ngarkesave q\u00eb k\u00ebrkojn\u00eb shum\u00eb burime. Shikojm\u00eb se GreenPlum fitoi nga Hive n\u00eb k\u00ebt\u00eb test me 8 her\u00eb.<\/p>\n<h3>Puna e Ab Initio me GreenPlum n\u00eb modalitetin Near Real Time<\/h3>\n<p>\nN\u00eb k\u00ebt\u00eb eksperiment do t\u00eb shqyrtojm\u00eb mund\u00ebsin\u00eb q\u00eb Ab Initio t\u00eb b\u00ebj\u00eb p\u00ebrdit\u00ebsimin e tabel\u00ebs GreenPlum me grupe t\u00eb dh\u00ebnash t\u00eb krijuara rast\u00ebsisht n\u00eb nj\u00eb mod t\u00eb af\u00ebrt me koh\u00ebn reale. Do t\u00eb shqyrtojm\u00eb tabel\u00ebn GreenPlum dev42_1_db_usl.TESTING_SUBJ_org_finval, me t\u00eb cil\u00ebn do t\u00eb punohet.<\/p>\n<p>Do t\u00eb p\u00ebrdorim tre grafe Ab Initio p\u00ebr t\u00eb punuar me t\u00eb:<\/p>\n<p>1) Grafi Create_test_data.mp \u2013 krijon n\u00eb 10 rrjedha paralele skedar\u00ebt me t\u00eb dh\u00ebna n\u00eb HDFS me 6 000 000 rreshta. T\u00eb dh\u00ebnat jan\u00eb rast\u00ebsore, struktura e tyre \u00ebsht\u00eb organizuar p\u00ebr futje n\u00eb tabel\u00ebn ton\u00eb.<\/p>\n<p><img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/8cac605c1c5931313bd016a48fb6384e.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/b86988bf1722329bde60013ba025d600.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n2) Grafi mdw_load.day_one.current.dev42_1_db_usl_testing_subj_org_finval.pset \u2013 grafi i prodhuar MDW p\u00ebr ngarkimin fillestar t\u00eb t\u00eb dh\u00ebnave n\u00eb tabel\u00ebn ton\u00eb n\u00eb 10 rrjedha paralele (p\u00ebrdoren t\u00eb dh\u00ebna testuese, t\u00eb gjeneruara nga grafi (1)).<\/p>\n<p><img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/b4228a13c088c6b96abba35e9e58fe8e.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3) Grafi mdw_load.regular.current.dev42_1_db_usl_testing_subj_org_finval.pset \u2013 grafi i prodhuar MDW p\u00ebr p\u00ebrmir\u00ebsimin inkremental t\u00eb tabel\u00ebs ton\u00eb n\u00eb 10 rrjedha paralele duke p\u00ebrdorur nj\u00eb sked\u00eb t\u00eb dh\u00ebnash t\u00eb fresk\u00ebta q\u00eb kan\u00eb ardhur (deltat), t\u00eb gjeneruara nga grafi (1).<\/p>\n<p><img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/714a901616cf84e5a1fd7a764373e30f.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nDo t\u00eb ekzekutojm\u00eb skenarin e m\u00ebposht\u00ebm n\u00eb modin NRT:<\/p>\n<ul>\n<li>gjeneroni 6 000 000 rreshta testues.<\/li>\n<li>b\u00ebni ngarkimin fillestar duke futur 6 000 000 rreshta testues n\u00eb nj\u00eb tabel\u00eb bosh.<\/li>\n<li>p\u00ebrs\u00ebri 5 her\u00eb ngarkimin inkremental.\n<ul>\n<li>gjeneroni 6 000 000 rreshta testues.<\/li>\n<li>b\u00ebni nj\u00eb futur\u00eb inkrementale me 6 000 000 rreshta testues n\u00eb tabel\u00eb (n\u00eb k\u00ebt\u00eb rast, t\u00eb dh\u00ebnave t\u00eb vjetra u caktohet nj\u00eb koh\u00eb skadimi valid_to_ts dhe futen t\u00eb dh\u00ebna m\u00eb t\u00eb fresk\u00ebta me t\u00eb nj\u00ebjtin \u00e7el\u00ebs primar).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\nKy skenar imiton modin e funksionimit t\u00eb nj\u00eb sistemi t\u00eb biznesit real \u2013 n\u00eb koh\u00eb reale shfaqet nj\u00eb sasi e konsiderueshme t\u00eb dh\u00ebnash t\u00eb reja dhe menj\u00ebher\u00eb derdhen n\u00eb GreenPlum.<\/p>\n<p>Tani do t\u00eb shikojm\u00eb logun e pun\u00ebs s\u00eb skenarit:<\/p>\n<p><i>Start Create_test_data.input.pset n\u00eb 2020-06-04 11:49:11.<br \/>\nFinish Create_test_data.input.pset n\u00eb 2020-06-04 11:49:37.<br \/>\nStart mdw_load.day_one.current.dev42_1_db_usl_testing_subj_org_finval.pset n\u00eb 2020-06-04 11:49:37.<br \/>\nFinish mdw_load.day_one.current.dev42_1_db_usl_testing_subj_org_finval.pset n\u00eb 2020-06-04 11:50:42.<br \/>\nStart Create_test_data.input.pset n\u00eb 2020-06-04 11:50:42.<br \/>\nFinish Create_test_data.input.pset n\u00eb 2020-06-04 11:51:06.<br \/>\nStart mdw_load.regular.current.dev42_1_db_usl_testing_subj_org_finval.pset n\u00eb 2020-06-04 11:51:06.<br \/>\nFinish mdw_load.regular.current.dev42_1_db_usl_testing_subj_org_finval.pset n\u00eb 2020-06-04 11:53:41.<br \/>\nStart Create_test_data.input.pset n\u00eb 2020-06-04 11:53:41.<br \/>\nFinish Create_test_data.input.pset n\u00eb 2020-06-04 11:54:04.<br \/>\nStart mdw_load.regular.current.dev42_1_db_usl_testing_subj_org_finval.pset n\u00eb 2020-06-04 11:54:04.<br \/>\nFinish mdw_load.regular.current.dev42_1_db_usl_testing_subj_org_finval.pset n\u00eb 2020-06-04 11:56:51.<br \/>\nStart Create_test_data.input.pset n\u00eb 2020-06-04 11:56:51.<br \/>\nFinish Create_test_data.input.pset n\u00eb 2020-06-04 11:57:14.<br \/>\nStart mdw_load.regular.current.dev42_1_db_usl_testing_subj_org_finval.pset n\u00eb 2020-06-04 11:57:14.<br \/>\nFinish mdw_load.regular.current.dev42_1_db_usl_testing_subj_org_finval.pset n\u00eb 2020-06-04 11:59:55.<br \/>\nStart Create_test_data.input.pset n\u00eb 2020-06-04 11:59:55.<br \/>\nFinish Create_test_data.input.pset n\u00eb 2020-06-04 12:00:23.<br \/>\nStart mdw_load.regular.current.dev42_1_db_usl_testing_subj_org_finval.pset n\u00eb 2020-06-04 12:00:23.<br \/>\nFinish mdw_load.regular.current.dev42_1_db_usl_testing_subj_org_finval.pset n\u00eb 2020-06-04 12:03:23.<br \/>\nStart Create_test_data.input.pset n\u00eb 2020-06-04 12:03:23.<br \/>\nFinish Create_test_data.input.pset n\u00eb 2020-06-04 12:03:49.<br \/>\nNisni mdw_load.regular.current.dev42_1_db_usl_testing_subj_org_finval.pset m\u00eb 2020-06-04 12:03:49<br \/>\nMbarojm\u00eb mdw_load.regular.current.dev42_1_db_usl_testing_subj_org_finval.pset m\u00eb 2020-06-04 12:06:46<\/i><\/p>\n<p>K\u00ebshtu duket kjo pamje:<\/p>\n<p>Grafiku<br \/>\nKoha e fillimit<br \/>\nKoha e mbarimit<br \/>\nGjat\u00ebsia<\/p>\n<p>Krijo_test_data.input.pset<br \/>\n04.06.2020 11:49:11<br \/>\n04.06.2020 11:49:37<br \/>\n00:00:26<\/p>\n<p>mdw_load.day_one.current.<br \/>\ndev42_1_db_usl_testing_subj_org_finval.pset<br \/>\n04.06.2020 11:49:37<br \/>\n04.06.2020 11:50:42<br \/>\n00:01:05<\/p>\n<p>Krijo_test_data.input.pset<br \/>\n04.06.2020 11:50:42<br \/>\n04.06.2020 11:51:06<br \/>\n00:00:24<\/p>\n<p>mdw_load.regular.current.<br \/>\ndev42_1_db_usl_testing_subj_org_finval.pset<br \/>\n04.06.2020 11:51:06<br \/>\n04.06.2020 11:53:41<br \/>\n00:02:35<\/p>\n<p>Krijo_test_data.input.pset<br \/>\n04.06.2020 11:53:41<br \/>\n04.06.2020 11:54:04<br \/>\n00:00:23<\/p>\n<p>mdw_load.regular.current.<br \/>\ndev42_1_db_usl_testing_subj_org_finval.pset<br \/>\n04.06.2020 11:54:04<br \/>\n04.06.2020 11:56:51<br \/>\n00:02:47<\/p>\n<p>Krijo_test_data.input.pset<br \/>\n04.06.2020 11:56:51<br \/>\n04.06.2020 11:57:14<br \/>\n00:00:23<\/p>\n<p>mdw_load.regular.current.<br \/>\ndev42_1_db_usl_testing_subj_org_finval.pset<br \/>\n04.06.2020 11:57:14<br \/>\n04.06.2020 11:59:55<br \/>\n00:02:41<\/p>\n<p>Krijo_test_data.input.pset<br \/>\n04.06.2020 11:59:55<br \/>\n04.06.2020 12:00:23<br \/>\n00:00:28<\/p>\n<p>mdw_load.regular.current.<br \/>\ndev42_1_db_usl_testing_subj_org_finval.pset<br \/>\n04.06.2020 12:00:23<br \/>\n04.06.2020 12:03:23<br \/>\n00:03:00<\/p>\n<p>Krijo_test_data.input.pset<br \/>\n04.06.2020 12:03:23<br \/>\n04.06.2020 12:03:49<br \/>\n00:00:26<\/p>\n<p>mdw_load.regular.current.<br \/>\ndev42_1_db_usl_testing_subj_org_finval.pset<br \/>\n04.06.2020 12:03:49<br \/>\n04.06.2020 12:06:46<br \/>\n00:02:57<\/p>\n<p>\nV\u00ebrejm\u00eb se 6 000 000 rreshta inkrementi p\u00ebrpunohen brenda 3 minutash, q\u00eb \u00ebsht\u00eb mjaft shpejt.<br \/>\nT\u00eb dh\u00ebnat n\u00eb tabel\u00ebn e synuar rezultuan t\u00eb shp\u00ebrndara n\u00eb k\u00ebt\u00eb m\u00ebnyr\u00eb:<\/p>\n<pre><code class=\"sql\">select valid_from_ts, valid_to_ts, count(1), min(sk), max(sk) from dev42_1_db_usl.TESTING_SUBJ_org_finval group by valid_from_ts, valid_to_ts order by 1,2;<\/code><\/pre>\n<p>\n<img decoding=\"async\" alt=\"Kur keni shkall\u00eb t\u00eb madhe si Sber. P\u00ebrdorimi i Ab Initio n\u00eb pun\u00ebn me Hive dhe GreenPlum\" src=\"\/wp-content\/uploads\/2020\/07\/baefcfd8142f4ad6275333e3dcfccf94.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nMund t\u00eb shihet p\u00ebrputhja e t\u00eb dh\u00ebnave t\u00eb futura me momentet e aktivizimit t\u00eb grafik\u00ebve.<br \/>\nPra, mund t\u00eb nisim ngarkimin inkremental t\u00eb t\u00eb dh\u00ebnave n\u00eb GreenPlum me Ab Initio me nj\u00eb frekuenc\u00eb shum\u00eb t\u00eb lart\u00eb dhe t\u00eb v\u00ebzhgojm\u00eb shpejt\u00ebsin\u00eb e lart\u00eb t\u00eb futjes s\u00eb k\u00ebtyre t\u00eb dh\u00ebnave n\u00eb GreenPlum. Sigurisht, nuk do t\u00eb jet\u00eb e mundur t\u00eb fillojm\u00eb \u00e7do sekond\u00eb, pasi Ab Initio, si \u00e7do mjet ETL, k\u00ebrkon koh\u00eb \"p\u00ebr t'u ngrohur\" gjat\u00eb aktivizimit.<\/p>\n<h2>P\u00ebrfundim<\/h2>\n<p>\nAktualisht Ab Initio p\u00ebrdoret n\u00eb Sberbank p\u00ebr nd\u00ebrtimin e Nj\u00eb Shtrese Semantike t\u00eb Dh\u00ebnash (ECS). Ky projekt parashikon nd\u00ebrtimin e nj\u00eb versioni t\u00eb vet\u00ebm t\u00eb gjendjes s\u00eb entiteteve t\u00eb ndryshme t\u00eb biznesit t\u00eb bank\u00ebs. Informacioni vjen nga burime t\u00eb ndryshme, riplikat e t\u00eb cilave p\u00ebrgatiten n\u00eb Hadoop. N\u00eb p\u00ebrputhje me nevojat e biznesit, p\u00ebrgatitet modeli i t\u00eb dh\u00ebnave dhe p\u00ebrshkruhen transformimet e t\u00eb dh\u00ebnave. Ab Initio ngarkon informacionin n\u00eb ECS dhe t\u00eb dh\u00ebnat e ngarkuara jo vet\u00ebm q\u00eb paraqesin interes p\u00ebr biznesin p\u00ebr vet\u00eb, por gjithashtu sh\u00ebrbejn\u00eb si burim p\u00ebr nd\u00ebrtimin e vitrinave t\u00eb t\u00eb dh\u00ebnave. N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb, funksionaliteti i produktit lejon p\u00ebrdorimin e sistemeve t\u00eb ndryshme si pranues (Hive, Greenplum, Teradata, Oracle), duke ofruar mund\u00ebsin\u00eb p\u00ebr t\u00eb p\u00ebrgatitur t\u00eb dh\u00ebnat p\u00ebr biznesin n\u00eb formate t\u00eb ndryshme q\u00eb k\u00ebrkohet.<\/p>\n<p>Mund\u00ebsit\u00eb e Ab Initio jan\u00eb t\u00eb shumta, p\u00ebr shembull, framework-u i bashkangjitur MDW ofron mund\u00ebsin\u00eb p\u00ebr t\u00eb nd\u00ebrtuar historikun teknik dhe t\u00eb biznesit t\u00eb t\u00eb dh\u00ebnave \"nga kutia\". P\u00ebr zhvilluesit Ab Initio ofron mund\u00ebsin\u00eb q\u00eb \"t\u00eb mos shpikin bi\u00e7iklet\u00ebn\", por t\u00eb p\u00ebrdorin nj\u00eb s\u00ebr\u00eb komponentesh funksionale t\u00eb gatshme, t\u00eb cilat jan\u00eb n\u00eb thelb biblioteka t\u00eb nevojshme p\u00ebr pun\u00ebn me t\u00eb dh\u00ebnat.<\/p>\n<blockquote><p>Autori - ekspert i komunitetit profesional t\u00eb Sberbank SberProfi DWH\/BigData. Komuniteti profesional SberProfi DWH\/BigData \u00ebsht\u00eb p\u00ebrgjegj\u00ebs p\u00ebr zhvillimin e kompetencave n\u00eb fusha t\u00eb tilla si ekosistemi Hadoop, Teradata, Oracle DB, GreenPlum, si dhe n\u00eb mjetet BI Qlik, SAP BO, Tableau dhe t\u00eb tjera.<\/p><\/blockquote>\n<p>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/sberbank\/blog\/509936\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u043d\u0430\u0437\u0430\u0434 \u043f\u0435\u0440\u0435\u0434 \u043d\u0430\u043c\u0438 \u0432\u0441\u0442\u0430\u043b \u0432\u043e\u043f\u0440\u043e\u0441 \u0432\u044b\u0431\u043e\u0440\u0430 ETL-\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 BigData. \u0420\u0430\u043d\u0435\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0432\u0448\u0435\u0435\u0441\u044f \u0440\u0435\u0448\u0435\u043d\u0438\u0435 Informatica BDM \u043d\u0435 \u0443\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u043b\u043e \u043d\u0430\u0441 \u0438\u0437-\u0437\u0430 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u043d\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438. \u0415\u0451 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0441\u0432\u0435\u043b\u043e\u0441\u044c \u043a \u0444\u0440\u0435\u0439\u043c\u0432\u043e\u0440\u043a\u0443 \u043f\u043e \u0437\u0430\u043f\u0443\u0441\u043a\u0443 \u043a\u043e\u043c\u0430\u043d\u0434 spark-submit. \u041d\u0430 \u0440\u044b\u043d\u043a\u0435 \u0438\u043c\u0435\u043b\u043e\u0441\u044c \u043d\u0435 \u0442\u0430\u043a \u043c\u043d\u043e\u0433\u043e \u0430\u043d\u0430\u043b\u043e\u0433\u043e\u0432, \u0432 \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u0435 \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u044b\u0445 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 \u0442\u0435\u043c \u043e\u0431\u044a\u0451\u043c\u043e\u043c \u0434\u0430\u043d\u043d\u044b\u0445, \u0441 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043c\u044b \u0438\u043c\u0435\u0435\u043c \u0434\u0435\u043b\u043e \u043a\u0430\u0436\u0434\u044b\u0439 \u0434\u0435\u043d\u044c. [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":87610,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-87609","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u043d\u0430\u0437\u0430\u0434 \u043f\u0435\u0440\u0435\u0434 \u043d\u0430\u043c\u0438 \u0432\u0441\u0442\u0430\u043b \u0432\u043e\u043f\u0440\u043e\u0441 \u0432\u044b\u0431\u043e\u0440\u0430 ETL-\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 BigData. \u0420\u0430\u043d\u0435\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0432\u0448\u0435\u0435\u0441\u044f \u0440\u0435\u0448\u0435\u043d\u0438\u0435 Informatica BDM \u043d\u0435 \u0443\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u043b\u043e \u043d\u0430\u0441 \u0438\u0437-\u0437\u0430 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u043d\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438.\" \/>\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\/sq\/blog\/administrirovanie\/kogda-u-vas-sberovskie-masshtaby-ispolzovanie-ab-initio-pri-rabote-s-hive-i-greenplum\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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\u043e\u0433\u0434\u0430 \u0443 \u0432\u0430\u0441 \u0441\u0431\u0435\u0440\u043e\u0432\u0441\u043a\u0438\u0435 \u043c\u0430\u0441\u0448\u0442\u0430\u0431\u044b. \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 Ab Initio \u043f\u0440\u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441 Hive \u0438 GreenPlum | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u043d\u0430\u0437\u0430\u0434 \u043f\u0435\u0440\u0435\u0434 \u043d\u0430\u043c\u0438 \u0432\u0441\u0442\u0430\u043b \u0432\u043e\u043f\u0440\u043e\u0441 \u0432\u044b\u0431\u043e\u0440\u0430 ETL-\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 BigData. \u0420\u0430\u043d\u0435\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0432\u0448\u0435\u0435\u0441\u044f \u0440\u0435\u0448\u0435\u043d\u0438\u0435 Informatica BDM \u043d\u0435 \u0443\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u043b\u043e \u043d\u0430\u0441 \u0438\u0437-\u0437\u0430 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u043d\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kogda-u-vas-sberovskie-masshtaby-ispolzovanie-ab-initio-pri-rabote-s-hive-i-greenplum\" \/>\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=\"2020-07-08T23:42:11+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-07-08T23:42:11+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\udd47Kur ju keni p\u00ebrmasa t\u00eb m\u00ebdha. P\u00ebrdorimi i Ab Initio gjat\u00eb pun\u00ebs me Hive dhe GreenPlum | ProHoster","description":"Disa disa m\u00eb par\u00eb, u paraqit p\u00ebr ne nj\u00eb pyetje mbi zgjedhjen e nj\u00eb mjeti ETL p\u00ebr pun\u00ebn me BigData. Zgjidhja e p\u00ebrdorur m\u00eb par\u00eb, Informatica BDM, nuk ishte e k\u00ebnaqshme p\u00ebr ne p\u00ebr shkak t\u00eb funksionalitetit t\u00eb kufizuar.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kogda-u-vas-sberovskie-masshtaby-ispolzovanie-ab-initio-pri-rabote-s-hive-i-greenplum","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\u041a\u043e\u0433\u0434\u0430 \u0443 \u0432\u0430\u0441 \u0441\u0431\u0435\u0440\u043e\u0432\u0441\u043a\u0438\u0435 \u043c\u0430\u0441\u0448\u0442\u0430\u0431\u044b. \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 Ab Initio \u043f\u0440\u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441 Hive \u0438 GreenPlum | ProHoster","og:description":"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u043d\u0430\u0437\u0430\u0434 \u043f\u0435\u0440\u0435\u0434 \u043d\u0430\u043c\u0438 \u0432\u0441\u0442\u0430\u043b \u0432\u043e\u043f\u0440\u043e\u0441 \u0432\u044b\u0431\u043e\u0440\u0430 ETL-\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 BigData. \u0420\u0430\u043d\u0435\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0432\u0448\u0435\u0435\u0441\u044f \u0440\u0435\u0448\u0435\u043d\u0438\u0435 Informatica BDM \u043d\u0435 \u0443\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u043b\u043e \u043d\u0430\u0441 \u0438\u0437-\u0437\u0430 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u043d\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438.","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kogda-u-vas-sberovskie-masshtaby-ispolzovanie-ab-initio-pri-rabote-s-hive-i-greenplum","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":"2020-07-08T23:42:11+00:00","article:modified_time":"2020-07-08T23:42:11+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"87609","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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 13:47:29","updated":"2026-02-22 15:29:30","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\/87609","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=87609"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/87609\/revisions"}],"predecessor-version":[{"id":162163,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/87609\/revisions\/162163"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/87610"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=87609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=87609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=87609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}