{"id":78198,"date":"2020-04-17T13:42:37","date_gmt":"2020-04-17T11:42:37","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/denormalizacziya-baz-dannyh-erp-sistem-i-ee-vliyanie-na-razvitie-po-otkryvaem-tavernu-na-tortuge"},"modified":"2020-04-17T13:42:37","modified_gmt":"2020-04-17T11:42:37","slug":"denormalizacziya-baz-dannyh-erp-sistem-i-ee-vliyanie-na-razvitie-po-otkryvaem-tavernu-na-tortuge","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/denormalizacziya-baz-dannyh-erp-sistem-i-ee-vliyanie-na-razvitie-po-otkryvaem-tavernu-na-tortuge","title":{"rendered":"Denormalizimi i bazave t\u00eb t\u00eb dh\u00ebnave t\u00eb sistemeve ERP dhe ndikimi i tij n\u00eb zhvillimin e softuerit: hapim nj\u00eb tavern\u00eb n\u00eb Tortuga","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>P\u00ebrsh\u00ebndetje! M\u00eb quajn\u00eb Andrey Semenov, un\u00eb jam analisti i lart\u00eb n\u00eb Sportmaster. N\u00eb k\u00ebt\u00eb post, dua t\u00eb ngrej nj\u00eb \u00e7\u00ebshtje mbi denormalizimin e bazave t\u00eb t\u00eb dh\u00ebnave t\u00eb sistemeve ERP. Do t\u00eb shqyrtojm\u00eb kushtet e p\u00ebrgjithshme, si dhe nj\u00eb shembull t\u00eb ve\u00e7ant\u00eb - le t\u00eb themi, do t\u00eb jet\u00eb nj\u00eb tavern\u00eb e mrekullueshme monopoliste p\u00ebr pirat\u00ebt dhe marinaret. N\u00eb t\u00eb, pirat\u00ebt dhe marinaret duhet t\u00eb sh\u00ebrbehen ndryshe, pasi paraqitjet p\u00ebr bukurin\u00eb dhe modelet e konsumit t\u00eb k\u00ebtyre zot\u00ebrinjve ndryshojn\u00eb ndjesh\u00ebm. <\/p>\n<p>Si ta b\u00ebjm\u00eb q\u00eb t\u00eb gjith\u00eb t\u00eb jen\u00eb t\u00eb k\u00ebnaqur? Si t\u00eb mos \u00e7mendem duke projektuar dhe mb\u00ebshtetur nj\u00eb sistem t\u00eb till\u00eb? \u00c7far\u00eb t\u00eb b\u00ebjm\u00eb n\u00ebse n\u00eb tavern\u00eb fillojn\u00eb t\u00eb vijn\u00eb jo vet\u00ebm pirat\u00ebt dhe marinaret e njohur?<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/sportmaster_lab\/blog\/497550\/\"><img decoding=\"async\" alt=\"Denormalizimi i bazave t\u00eb t\u00eb dh\u00ebnave t\u00eb sistemeve ERP dhe ndikimi i tij n\u00eb zhvillimin e softuerit: hapim nj\u00eb tavern\u00eb n\u00eb Tortuga\" src=\"\/wp-content\/uploads\/2020\/04\/bd0ccbfa3e3649aac20631e09fcb5b16.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>T\u00eb gjitha n\u00ebn kat. Por le t\u00eb shkojm\u00eb me radh\u00eb.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>1. Kufizimet dhe supozimet<\/h2>\n<p>\nE gjith\u00eb kjo p\u00ebrmbajtje iu referohet vet\u00ebm bazave t\u00eb t\u00eb dh\u00ebnave relacional. Pasojat e denormalizimit, t\u00eb cilat jan\u00eb t\u00eb miratuara edhe n\u00eb internet, n\u00eb form\u00ebn e anomali modifikimi, eliminimi dhe ndihm\u00ebs, nuk diskutohen. Rastet ku denormalizimi \u00ebsht\u00eb i zakonsh\u00ebm, me shembuj klasik\u00eb: numri dhe seria e pasaport\u00ebs, data dhe koha etj., jan\u00eb l\u00ebn\u00eb jasht\u00eb publikimit.<\/p>\n<p>N\u00eb postin e p\u00ebrdorur jan\u00eb definicionet intuitivisht kuptimplot\u00eb dhe praktikisht t\u00eb aplikueshme t\u00eb formave normale, pa referenca n\u00eb terma matematikor\u00eb. N\u00eb at\u00eb form\u00eb, si\u00e7 mund t\u00eb aplikohen n\u00eb shqyrtimin e realiteteve t\u00eb proceseve t\u00eb biznesit (BP) dhe projektimin e softuerit industrial.<\/p>\n<p>Ekziston nj\u00eb mendim se projektimi i skllev\u00ebrve t\u00eb t\u00eb dh\u00ebnave, mjeteve p\u00ebr krijimin e raportimit dhe marr\u00ebveshjeve integruese (ku p\u00ebrdoret p\u00ebrfaq\u00ebsimi tabelar i informacionit), dallon nga projektimi i bazave t\u00eb t\u00eb dh\u00ebnave t\u00eb sistemeve ERP n\u00eb at\u00eb q\u00eb leht\u00ebsia e konsumit dhe zbatimi p\u00ebr t\u00eb arritur denormalizimin e vet\u00ebdijsh\u00ebm mund t\u00eb ket\u00eb p\u00ebrpar\u00ebsi mbi ruajtjen e integritetit t\u00eb t\u00eb dh\u00ebnave. Un\u00eb e ndajem k\u00ebt\u00eb mendim, dhe ajo q\u00eb do t\u00eb p\u00ebrshkruhet m\u00eb posht\u00eb lidhet ekskluzivisht me modelet e t\u00eb dh\u00ebnave kryesore dhe t\u00eb dh\u00ebnat transaksionale t\u00eb sistemeve ERP.<\/p>\n<p>P\u00ebrshkrimi i formave normale \u00ebsht\u00eb dh\u00ebn\u00eb n\u00eb nj\u00eb shembull t\u00eb kuptuesh\u00ebm n\u00eb nivelin e zakonsh\u00ebm p\u00ebr shumic\u00ebn e lexuesve. Megjithat\u00eb, si nj\u00eb ilustrim i duksh\u00ebm n\u00eb pikat 4-5, \u00ebsht\u00eb p\u00ebrdorur q\u00ebllimisht nj\u00eb detyr\u00eb theksuar \"e shpikur\". N\u00ebse nuk e b\u00ebni k\u00ebt\u00eb dhe merrni nj\u00eb shembull t\u00eb njohur, p\u00ebr shembull, modelin e ruajtjes s\u00eb porosis\u00eb nga p. 2, mund t\u00eb p\u00ebrfundoni n\u00eb nj\u00eb situat\u00eb ku fokusi i v\u00ebmendjes s\u00eb lexuesit do t\u00eb kaloj\u00eb nga p\u00ebrshkrimi i ofruar i procesit n\u00eb model, n\u00eb p\u00ebrvoj\u00ebn dhe perceptimin personal t\u00eb asaj si duhet t\u00eb nd\u00ebrtohen proceset dhe modelet e ruajtjes s\u00eb t\u00eb dh\u00ebnave n\u00eb IS. Me fjal\u00eb t\u00eb tjera, merrni dy analist\u00eb t\u00eb kualifikuar IT, le t\u00eb jap\u00eb nj\u00ebri sh\u00ebrbim logjistik\u00ebve q\u00eb transportojn\u00eb pasagjer\u00eb, tjetri \u2013 logjistik\u00ebve q\u00eb transportojn\u00eb makina p\u00ebr prodhimin e mikro\u00e7ipave. K\u00ebrkoni prej tyre, pa diskutuar paraprakisht proceset e automatizueshme, t\u00eb hartojn\u00eb nj\u00eb model t\u00eb dh\u00ebnash p\u00ebr ruajtjen e informacionit mbi nj\u00eb udh\u00ebtim hekurudhor. <\/p>\n<p>Ekziston nj\u00eb probabilitet i konsideruesh\u00ebm q\u00eb n\u00eb modelet e propozuara ju do t\u00eb gjeni jo vet\u00ebm nj\u00eb grup t\u00eb ndrysh\u00ebm atributesh, por edhe grupe entitete t\u00eb papajtueshme, sepse \u00e7do analist do t\u00eb mb\u00ebshtetet n\u00eb proceset dhe detyrat e njohura p\u00ebr t\u00eb. Dhe p\u00ebr t\u00eb th\u00ebn\u00eb n\u00eb nj\u00eb situat\u00eb t\u00eb till\u00eb, se cila model \u00ebsht\u00eb \"e sakt\u00eb\", \u00ebsht\u00eb e pamundur, sepse nuk ka nj\u00eb kriter vler\u00ebsimi.<\/p>\n<h2>2. Formate normale<\/h2>\n<p>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/mz\/vc\/ex\/mzvcexxqfzhzyybzk8zvbndmtcc.png\"><img decoding=\"async\" alt=\"Denormalizimi i bazave t\u00eb t\u00eb dh\u00ebnave t\u00eb sistemeve ERP dhe ndikimi i tij n\u00eb zhvillimin e softuerit: hapim nj\u00eb tavern\u00eb n\u00eb Tortuga\" src=\"\/wp-content\/uploads\/2020\/04\/e2d3fc5656b59671648511b0a0e5f7b9.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p><b>Forma e par\u00eb normale e DB<\/b> k\u00ebrkon atomizimin e t\u00eb gjitha atributeve. <br \/>\nN\u00eb ve\u00e7anti, n\u00ebse nj\u00eb objekti A i ekzistojn\u00eb atribute j\u00ebshtore a dhe b, t\u00eb tilla q\u00eb c=f(a,b) dhe n\u00eb tabel\u00ebn q\u00eb p\u00ebrshkruan objektin A ju ruani vler\u00ebn e atributit c, at\u00ebher\u00eb n\u00eb DB \u00ebsht\u00eb shkelur forma e par\u00eb normale. P\u00ebr shembull, n\u00ebse n\u00eb specifikimin e porosis\u00eb tregohet sasia, nj\u00ebsi t\u00eb cilat varen nga lloji i produktit: n\u00eb nj\u00eb rast mund t\u00eb jen\u00eb cop\u00eb, n\u00eb tjetrin litra, n\u00eb t\u00eb tretin paketa q\u00eb p\u00ebrb\u00ebhen nga copa (n\u00eb modelin e m\u00ebsip\u00ebrm Good_count_WR), at\u00ebher\u00eb n\u00eb DB \u00ebsht\u00eb shkelur atomizmi i atributeve. N\u00eb k\u00ebt\u00eb rast, p\u00ebr t\u00eb th\u00ebn\u00eb se si duhet t\u00eb duket grupi i tabelave n\u00eb specifikimin e porosis\u00eb, nevojitet nj\u00eb p\u00ebrshkrim i qart\u00eb i procesit t\u00eb pun\u00ebs n\u00eb IS, dhe pasi proceset mund t\u00eb jen\u00eb t\u00eb ndryshme, at\u00ebher\u00eb edhe versionet \"e sakta\" mund t\u00eb jen\u00eb t\u00eb shumta.<\/p>\n<p><b>Forma e dyt\u00eb normale e DB<\/b> k\u00ebrkon respektimin e formes s\u00eb par\u00eb dhe nj\u00eb tabele t\u00eb ve\u00e7ant\u00eb p\u00ebr \u00e7do entitet q\u00eb lidhet me procesin e pun\u00ebs n\u00eb IS. N\u00ebse n\u00eb nj\u00eb tabel\u00eb ekzistojn\u00eb var\u00ebsi me =f1(a) dhe d=f2(b) dhe nuk ekziston var\u00ebsi me =f3(b), at\u00ebher\u00eb tabela shkel form\u00ebn e dyt\u00eb normale. N\u00eb shembullin e m\u00ebsip\u00ebrm, n\u00eb tabel\u00ebn \"Porosi\" nuk ekziston nj\u00eb var\u00ebsi mes porosis\u00eb dhe adres\u00ebs. Ndryshoni emrin e rrug\u00ebs ose qytetit, dhe nuk do t\u00eb merrni ndonj\u00eb ndikim n\u00eb atributet thelb\u00ebsore t\u00eb porosis\u00eb. <\/p>\n<p><b>Forma e tret\u00eb normale e DB<\/b> k\u00ebrkon respektimin e form\u00ebs s\u00eb dyt\u00eb normale dhe munges\u00ebn e var\u00ebsive funksionale midis atributeve t\u00eb entiteteve t\u00eb ndryshme. Kjo rregull mund t\u00eb formulohet k\u00ebshtu: \"gjith\u00e7ka q\u00eb mund t\u00eb llogaritet, duhet t\u00eb llogaritet\". N\u00eb terma t\u00eb tjer\u00eb, n\u00ebse ekzistojn\u00eb dy objekte A dhe B. N\u00eb tabel\u00ebn q\u00eb mban atributet e objektit A, shfaqet atributi C, dhe p\u00ebr objektin B ekziston nj\u00eb atribut b, t\u00eb till\u00eb q\u00eb ekziston c=f4(b), at\u00ebher\u00eb \u00ebsht\u00eb shkelur forma e tret\u00eb normale. N\u00eb shembullin e m\u00ebposht\u00ebm, atributi \"Numri i copave\" (Total_count_WR) n\u00eb regjistrimin e porosis\u00eb qart\u00eb pretendohet se shkel form\u00ebn e tret\u00eb normale.<\/p>\n<h2>3. Qasja ime ndaj p\u00ebrdorimit t\u00eb normalizimit<\/h2>\n<p>\n1. Vet\u00ebm procesi i automatiksh\u00ebn me q\u00ebllim t\u00eb biznesit mund t\u00eb ofroj\u00eb analistin kriteret p\u00ebr identifikimin e entiteteve dhe atributeve gjat\u00eb krijimit t\u00eb modelit t\u00eb ruajtjes s\u00eb t\u00eb dh\u00ebnave. Krijimi i modelit t\u00eb procesit \u00ebsht\u00eb nj\u00eb kushte e domosdoshme p\u00ebr krijimin e nj\u00eb model normal t\u00eb t\u00eb dh\u00ebnave.<\/p>\n<p>2. Arritja e form\u00ebs s\u00eb tret\u00eb normale n\u00eb kuptimin e sakt\u00eb mund t\u00eb mos jet\u00eb e arsyeshme n\u00eb praktik\u00ebn reale t\u00eb krijimit t\u00eb sistemeve ERP kur p\u00ebrmbushen disa ose t\u00eb gjitha kushtet e m\u00ebposhtme:<\/p>\n<ul>\n<li>proceset automatizues shpesh nuk i n\u00ebnshtrohen ndryshimeve, <\/li>\n<li>koha p\u00ebr hulumtim dhe zhvillim \u00ebsht\u00eb e shpejt\u00eb, <\/li>\n<li>k\u00ebrkesat p\u00ebr integritetin e t\u00eb dh\u00ebnave jan\u00eb relativisht t\u00eb ul\u00ebta (gabime t\u00eb mundshme n\u00eb programin industrial nuk \u00e7ojn\u00eb n\u00eb humbje t\u00eb parave ose klient\u00ebve nga ana e bler\u00ebsit t\u00eb softuerit)<\/li>\n<li>N\u00eb mekanizmin e lidhjes s\u00eb tabelave t\u00eb jashtme Foreign Data Wrapper (postgres_fdw) \u00ebsht\u00eb realizuar mb\u00ebshtetje p\u00ebr autentikimin e bazuar n\u00eb certifikata. Kur p\u00ebrdoret autentikimi SCRAM, klient\u00ebve u lejohet t\u00eb k\u00ebrkojn\u00eb \u2018<\/li>\n<\/ul>\n<p>\nN\u00ebn kushtet e p\u00ebrshkruara, shpenzimet p\u00ebr identifikimin, p\u00ebrshkrimin e ciklit t\u00eb jet\u00ebs s\u00eb disa objekteve dhe atributeve t\u00eb tyre mund t\u00eb mos justifikohen nga k\u00ebndv\u00ebshtrimi i efikasitetit ekonomik.<\/p>\n<p>3. \u00c7do pasoj\u00eb denormalizimi e modelit t\u00eb t\u00eb dh\u00ebnave n\u00eb nj\u00eb IS t\u00eb krijuar tashm\u00eb mund t\u00eb kurohet me hulumtim t\u00eb kujdessh\u00ebm t\u00eb kodit dhe testimit.<\/p>\n<p>4. Denormalizimi \u00ebsht\u00eb nj\u00eb metod\u00eb p\u00ebr t\u00eb transferuar ngarkes\u00ebn e pun\u00ebs nga faza e hulumtimit t\u00eb burimeve t\u00eb t\u00eb dh\u00ebnave dhe projektimit t\u00eb procesit t\u00eb biznesit n\u00eb faz\u00ebn e zhvillimit, nga periudha e zbatimit n\u00eb periudh\u00ebn e zhvillimit t\u00eb sistemit.<\/p>\n<p>5. S\u00eb bashku me form\u00ebn e tret\u00eb normale t\u00eb DB \u00ebsht\u00eb e arsyeshme t\u00eb synohet kur:<\/p>\n<ul>\n<li>Korrigjimi i proceseve t\u00eb biznesit p\u00ebrkat\u00ebse \u00ebsht\u00eb i pap\u00ebrshkruesh\u00ebm.<\/li>\n<li>Brenda ekipit t\u00eb zbatimit dhe\/ose zhvillimit ka nj\u00eb ndarje t\u00eb dob\u00ebt t\u00eb pun\u00ebs.<\/li>\n<li>Sistemet q\u00eb b\u00ebjn\u00eb pjes\u00eb n\u00eb konturin integrues zhvillohen sipas planeve t\u00eb tyre.<\/li>\n<li>Mosqart\u00ebsia e t\u00eb dh\u00ebnave mund t\u00eb \u00e7oj\u00eb n\u00eb humbje t\u00eb klient\u00ebve ose parave p\u00ebr kompanin\u00eb.<\/li>\n<\/ul>\n<p>\n6. Projektimi i modelit t\u00eb t\u00eb dh\u00ebnave duhet t\u00eb realizohet nga analisti vet\u00ebm n\u00eb lidhje me modelet e procesit t\u00eb biznesit t\u00eb synuar dhe procesit n\u00eb IS. N\u00ebse projektimi i modelit t\u00eb t\u00eb dh\u00ebnave merret nga zhvilluesi, ai do t\u00eb duhet t\u00eb thelloj\u00eb njohurit\u00eb e tij n\u00eb fush\u00ebn e tem\u00ebs deri n\u00eb at\u00eb mas\u00eb sa t\u00eb kuptoj\u00eb ve\u00e7an\u00ebrisht ndryshimin midis vlerave t\u00eb atribut\u00ebve - kushti themelor p\u00ebr t\u00eb nxjerr\u00eb atributet atomike. K\u00ebshtu, ai merr p\u00ebrsip\u00ebr funksione q\u00eb nuk i p\u00ebrkasin.<\/p>\n<h2>4 Detyra p\u00ebr ilustrim<\/h2>\n<p>\nSupozoni se keni nj\u00eb tavern\u00eb t\u00eb vog\u00ebl robotike n\u00eb port. Segmenti juaj i tregut: marinaret dhe pirate q\u00eb hyjn\u00eb n\u00eb port dhe kan\u00eb nevoj\u00eb p\u00ebr pushim. Marinaret ju blejn\u00eb \u00e7aj me majdanek, nd\u00ebrsa pirateve ju shisni rum dhe kocka p\u00ebr dh\u00ebmb\u00eb p\u00ebr t\u00eb shfryr\u00eb mjekr\u00ebn. Sh\u00ebrbimi brenda tavern\u00ebs ofrohet nga nj\u00eb robot-hostes dhe nj\u00eb robot-barman. Fal\u00eb cil\u00ebsis\u00eb s\u00eb lart\u00eb dhe \u00e7mimeve t\u00eb ulta keni eliminuar t\u00eb gjith\u00eb konkurent\u00ebt, k\u00ebshtu q\u00eb \u00e7do njeri q\u00eb zbret nga anija vjen n\u00eb tavern\u00ebn tuaj, e cila \u00ebsht\u00eb e vetmja n\u00eb port.<\/p>\n<p>Kompleksi i sistemeve informative t\u00eb tavern\u00ebs p\u00ebrb\u00ebhet nga programet e m\u00ebposhtme: <\/p>\n<ul>\n<li>Sistemi i parandalimit t\u00eb hersh\u00ebm p\u00ebr klient\u00ebt, q\u00eb njeh kategorin\u00eb e tyre sipas karakteristikave dalluese.<\/li>\n<li>Sistemi i menaxhimit t\u00eb robot\u00ebve-hostes dhe robot\u00ebve-barman\u00eb.<\/li>\n<li>Sistemi i menaxhimit t\u00eb magazin\u00ebs dhe shp\u00ebrndarjes n\u00eb pik\u00ebn e shitjes.<\/li>\n<li>Sistemi i menaxhimit t\u00eb marr\u00ebdh\u00ebnieve me furnizuesit (SUMP)<\/li>\n<\/ul>\n<p>\nProcesi:<\/p>\n<p>Sistemi i parandalimit t\u00eb hersh\u00ebm njeh njer\u00ebzit q\u00eb zbresin nga anija. N\u00ebse nj\u00eb person \u00ebsht\u00eb i rruar mir\u00eb, ai e identifikon si marinar, nd\u00ebrsa n\u00ebse nj\u00eb person i \u00ebsht\u00eb zbuluar nj\u00eb mjek\u00ebr, ai identifikohet si pirate.<\/p>\n<p>Duke n\u00eb tavern\u00eb, mysafiri d\u00ebgjon p\u00ebrsh\u00ebndetje nga robot-hipotezari n\u00eb p\u00ebrputhje me kategorin\u00eb e tij, p\u00ebr shembull: \"Ho-ho-ho, t\u00eb nderuar pirat, kaloni te tavolina nr. \u2026\"<\/p>\n<p>Ekipi kalon n\u00eb tryez\u00ebn e caktuar, ku roboti-barman ka p\u00ebrgatitur tashm\u00eb produktet p\u00ebr t\u00eb sipas kategoris\u00eb. Roboti-barman i d\u00ebrgon informacionin sistemit t\u00eb magazinimit se sasia tjet\u00ebr e d\u00ebrges\u00ebs duhet t\u00eb rritet, nd\u00ebrsa sistemi i informacionit t\u00eb magazin\u00ebs formon nj\u00eb k\u00ebrkes\u00eb p\u00ebr blerje n\u00eb SUMP n\u00eb baz\u00eb t\u00eb stoqeve n\u00eb magazin\u00eb.<\/p>\n<p>Le t\u00eb thoni se sistemi i paralajm\u00ebrimit t\u00eb hersh\u00ebm \u00ebsht\u00eb krijuar nga IT-ja juaj e brendshme, nd\u00ebrsa programi i menaxhimit t\u00eb robot\u00ebve barmen \u00ebsht\u00eb zhvilluar nga nj\u00eb kontraktor i jasht\u00ebm, sakt\u00ebsisht p\u00ebr biznesin tuaj. Sistem\u00ebt p\u00ebr menaxhimin e magazin\u00ebs dhe marr\u00ebdh\u00ebnieve me furnitor\u00ebt jan\u00eb zgjidhje t\u00eb personalizuara t\u00eb paketuar nga tregu.<\/p>\n<h2>5. Shembuj t\u00eb denormalizimit dhe ndikimi i tij n\u00eb zhvillimin e softuerit<\/h2>\n<p>\nGjat\u00eb projektimit t\u00eb procesit t\u00eb biznesit, ekspert\u00ebt e pyetur n\u00eb fush\u00eb than\u00eb nj\u00ebz\u00ebri se n\u00eb t\u00eb gjith\u00eb bot\u00ebn pirat\u00ebt pijn\u00eb rum dhe shp\u00eblarin mjekr\u00ebn me thar\u00ebse kockash, nd\u00ebrsa marinar\u00ebt pijn\u00eb \u00e7aj me xhaxh dhe jan\u00eb gjithmon\u00eb t\u00eb rruajtur mir\u00eb. <\/p>\n<p>Shfaqet nj\u00eb katalog i tipeve t\u00eb klient\u00ebve me dy vlera: 1- pirat\u00ebt, 2 \u2014 marinar\u00ebt, i p\u00ebrgjithsh\u00ebm p\u00ebr gjith\u00eb kufirin informativ t\u00eb kompanis\u00eb. <\/p>\n<p>Sistemi i paralajm\u00ebrimit p\u00ebr klientin menj\u00ebher\u00eb ruan rezultatin e p\u00ebrpunimit t\u00eb imazhit si identifikues (ID) t\u00eb klientit t\u00eb njohur dhe lloji i tij: marinar ose pirat. <\/p>\n<p>ID e objektit t\u00eb njohur<br \/>\nKategoria e klientit<\/p>\n<p>100500<br \/>\nPirate<\/p>\n<p>100501<br \/>\nPirate<\/p>\n<p>100502<br \/>\nMarinar<\/p>\n<p>T\u00eb kthejm\u00eb v\u00ebmendjen, q\u00eb<\/p>\n<p>1. Marinaret tan\u00eb n\u00eb t\u00eb v\u00ebrtet\u00eb jan\u00eb njer\u00ebz t\u00eb rruar<br \/>\n2. Pirate tan\u00eb n\u00eb t\u00eb v\u00ebrtet\u00eb jan\u00eb njer\u00ebz me mjek\u00ebr<\/p>\n<p>Cilat probleme duhet t\u00eb zgjidhen n\u00eb k\u00ebt\u00eb rast, p\u00ebr t\u00eb arritur q\u00eb struktura jon\u00eb t\u00eb ket\u00eb form\u00ebn e tret\u00eb normale:<\/p>\n<ul>\n<li>shkelja e atomizmit t\u00eb atributit \u2014 Kategoria e klientit<\/li>\n<li>p\u00ebrzierja e faktit t\u00eb analizuar dhe p\u00ebrfundimit n\u00eb nj\u00eb tabel\u00eb <\/li>\n<li>var\u00ebsia funksionale e regjistruar midis atributeve t\u00eb subjekteve t\u00eb ndryshme. <\/li>\n<\/ul>\n<p>\nN\u00eb form\u00ebn e normalizuar, do t\u00eb kishim dy tabela: <\/p>\n<ul>\n<li>rezultati i njohjes si nj\u00eb grup i karakteristikave t\u00eb caktuara,<\/li>\n<\/ul>\n<p><\/p>\n<p>ID e objektit t\u00eb njohur<br \/>\nMjekra<\/p>\n<p>100500<br \/>\nPo.<\/p>\n<p>100501<br \/>\nPo.<\/p>\n<p>100502<br \/>\nJo<\/p>\n<p><\/p>\n<ul>\n<li>rezultati i p\u00ebrcaktimit t\u00eb llojit t\u00eb klientit si aplikimi i logjik\u00ebs s\u00eb vendosur n\u00eb sistemin e informacionit p\u00ebr interpretimin e karakteristikave t\u00eb caktuara<\/li>\n<\/ul>\n<p>ID e objektit t\u00eb njohur<br \/>\nID e identifikimit<br \/>\nKategoria e klientit<\/p>\n<p>100500<br \/>\n100001<br \/>\nPirate<\/p>\n<p>100501<br \/>\n100002<br \/>\nPirate<\/p>\n<p>100502<br \/>\n100003<br \/>\nMarinar<\/p>\n<p>Si organizimi i normalizuar i ruajtjes s\u00eb t\u00eb dh\u00ebnave mund ta leht\u00ebsoj\u00eb zhvillimin e kompleksit t\u00eb sistemeve informacionit? Le t\u00eb supozojm\u00eb se papritur keni klient\u00eb t\u00eb rinj. Le t\u00eb jen\u00eb ata pirat\u00eb japonez\u00eb, t\u00eb cil\u00ebt mund t\u00eb mos ken\u00eb mjek\u00ebr, por ecin me nj\u00eb papagal mbi supin, dhe pirat\u00ebt ekologjist\u00eb, me profilin blu t\u00eb Gret\u00ebs n\u00eb gjoksin e majt\u00eb, q\u00eb do t'i njihni leht\u00ebsisht. <\/p>\n<p>Pirat\u00ebt ekologjist\u00eb, natyrisht, nuk mund t\u00eb p\u00ebrdorin krehra nga kocka dhe k\u00ebrkojn\u00eb nj\u00eb alternativ\u00eb nga plastika e ricikluar detare.<\/p>\n<p>Ju nevojitet t\u00eb rregulloni algoritmet e funksionimit t\u00eb programeve sipas inputeve t\u00eb reja. Po t\u00eb ishin zbatuar rregullat e normalizimit, do t'ju duhej vet\u00ebm t\u00eb plot\u00ebsonit disa hyrje p\u00ebr disa dega t\u00eb proceseve n\u00eb disa sisteme dhe t\u00eb krijonit dega t\u00eb reja vet\u00ebm p\u00ebr rastet dhe n\u00eb sistemet ku mbulimi i fytyr\u00ebs ka r\u00ebnd\u00ebsi. Por, pasi rregullat nuk u zbatuan, ju duhet t\u00eb analizoni t\u00eb gjith\u00eb kodin, n\u00eb t\u00eb gjith\u00eb konturin ku p\u00ebrdoren vlerat e referenc\u00ebs p\u00ebr llojet e klient\u00ebve dhe t\u00eb p\u00ebrcaktoni qart\u00eb se n\u00eb nj\u00eb rast algoritmi duhet t\u00eb marr\u00eb parasysh aktivitetin profesionist t\u00eb klientit, nd\u00ebrsa n\u00eb nj\u00eb rast tjet\u00ebr karakteristikat fizike. <\/p>\n<p>N\u00eb form\u00ebn e till\u00eb, <b><i>po synojn\u00eb <\/i><\/b>n\u00eb normalizimin e saj, do t\u00eb kishim dy tabela me t\u00eb dh\u00ebna operative dhe dy referenca:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/qn\/pq\/g4\/qnpqg4idbhbsqejhnryzfuilhhy.png\"><img decoding=\"async\" alt=\"Denormalizimi i bazave t\u00eb t\u00eb dh\u00ebnave t\u00eb sistemeve ERP dhe ndikimi i tij n\u00eb zhvillimin e softuerit: hapim nj\u00eb tavern\u00eb n\u00eb Tortuga\" src=\"\/wp-content\/uploads\/2020\/04\/eea87da839171e8a3a42db0618972124.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<ul>\n<li>rezultati i njohjes si nj\u00eb grup i karakteristikave t\u00eb caktuara,<\/li>\n<\/ul>\n<p><\/p>\n<p>ID e objektit t\u00eb njohur<br \/>\nGreta n\u00eb gjoksin e majt\u00eb<br \/>\nPteza mbi sup<br \/>\nMjekra<\/p>\n<p>100510<br \/>\n1<br \/>\n1<br \/>\n1<\/p>\n<p>100511<br \/>\n0<br \/>\n0<br \/>\n1<\/p>\n<p>100512<\/p>\n<p>1<br \/>\n0<\/p>\n<ul>\n<li>rezultati i p\u00ebrcaktimit t\u00eb llojit t\u00eb klientit (le t\u00eb jet\u00eb kjo nj\u00eb paraqitje p\u00ebrdoruesi, n\u00eb t\u00eb cil\u00ebn shfaqen p\u00ebrshkrimet nga referencat)<\/li>\n<\/ul>\n<p>\nA do t\u00eb thot\u00eb denormalizimi i zbuluar se sistemet nuk do t\u00eb mund t\u00eb p\u00ebrmir\u00ebsohen p\u00ebr kushtet e reja? Sigurisht q\u00eb jo. N\u00ebse e imagjinoni se t\u00eb gjitha sistemet informacionit ishin krijuar nga nj\u00eb ekip me flukse t\u00eb zeros, zhvillimet jan\u00eb dokumentuar mir\u00eb dhe informacioni brenda ekipit kalon pa humbje, at\u00ebher\u00eb ndryshimet e nevojshme mund t\u00eb realizohen me p\u00ebrpjekje minimale. Por, n\u00ebse kthehemi n\u00eb kushtet fillestare t\u00eb detyr\u00ebs, vet\u00ebm p\u00ebr t\u00eb printuar protokollet e diskutimeve t\u00eb p\u00ebrbashk\u00ebta do t\u00eb fshihen 1.5 tastiera dhe nj\u00eb tjet\u00ebr 0.5 p\u00ebr formatin e procedurave t\u00eb blerjeve.<\/p>\n<p>N\u00eb shembullin e m\u00ebsip\u00ebrm, jan\u00eb shkelur t\u00eb tri format normale, le t\u00eb provojm\u00eb t'i shkelim ato nj\u00eb e nga nj\u00eb.<\/p>\n<p><b>Shkelja e form\u00ebs s\u00eb par\u00eb normale:<\/b><\/p>\n<p>Supozoni se q\u00eb mallrat n\u00eb magazin\u00ebn tuaj d\u00ebrgohen nga magazinat e furnizuesve me vet\u00eb-marrje duke p\u00ebrdorur nj\u00eb Gazel\u00eb prej 1.5 ton\u00ebsh q\u00eb i takon tavern\u00ebs tuaj. Madh\u00ebsia e porosive tuaja \u00ebsht\u00eb aq e vog\u00ebl n\u00eb raport me qarkullimin e furnizuesve, sa q\u00eb ato realizohen gjithmon\u00eb nj\u00eb p\u00ebr nj\u00eb pa pritur p\u00ebr prodhimin. A nevojiten tabelat e ve\u00e7anta p\u00ebr k\u00ebt\u00eb BP: mjete transporti, lloje mjete transporti, a duhet t\u00eb ndahen planin dhe faktin n\u00eb porosit\u00eb tuaja t\u00eb d\u00ebrguara te furnizuesit?<\/p>\n<p>Mendojeni sa shum\u00eb \u2018koneksione t\u00eb tep\u00ebrta\u2019 do t\u00eb duhet t\u00eb shkruajn\u00eb programuesit tuaj, n\u00ebse p\u00ebr zhvillimin e programit p\u00ebrdoret modeli m\u00eb posht\u00eb.<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/bz\/js\/gf\/bzjsgfs0fephwjwqx8xdvunrgva.png\"><img decoding=\"async\" alt=\"Denormalizimi i bazave t\u00eb t\u00eb dh\u00ebnave t\u00eb sistemeve ERP dhe ndikimi i tij n\u00eb zhvillimin e softuerit: hapim nj\u00eb tavern\u00eb n\u00eb Tortuga\" src=\"\/wp-content\/uploads\/2020\/04\/7309871d1ecc5c1ceb4f077ea4afebff.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>Supozoni se ne mor\u00ebm vendimin se struktura e propozuar \u00ebsht\u00eb tep\u00ebr e komplikuar, p\u00ebr rastin ton\u00eb ndarja e planit dhe faktit n\u00eb rekordet e porosis\u00eb \u00ebsht\u00eb informacion i tep\u00ebrt, dhe specifikimi i formuar i porosis\u00eb rishkruhet sipas rezultateve t\u00eb pranuara t\u00eb mallrave t\u00eb mb\u00ebrritura, raste t\u00eb rralla t\u00eb humbjes dhe dor\u00ebzimit t\u00eb mallrave t\u00eb cil\u00ebsis\u00eb s\u00eb pamjaftueshme rregullohen jasht\u00eb SIS.<br \/>\nDhe nj\u00eb dit\u00eb e shihni sall\u00ebn e tavern\u00ebs plot me pirate t\u00eb zem\u00ebruar dhe t\u00eb paushqyer. \u00c7far\u00eb ndodhi? <\/p>\n<p>Doli q\u00eb me rritjen e biznesit tuaj, rritet edhe konsumimi. Disa her\u00eb, ishte marr\u00eb nj\u00eb vendim menaxherial, q\u00eb n\u00ebse gazela ishte e ngarkuar tej kapacitetit sipas v\u00ebllimit dhe\/ose pesh\u00ebs, gj\u00eb q\u00eb ndodhte jasht\u00ebzakonisht rrall\u00eb, furnizuesi prioritizonte ngarkes\u00ebn n\u00eb favor t\u00eb pijeve. <\/p>\n<p>Malli i pap\u00ebrfunduar kalonte n\u00eb porosin\u00eb e ardhshme dhe ishte d\u00ebrguar n\u00eb nj\u00eb fluturim t\u00eb ri, prania e nj\u00eb mbetjeje t\u00eb pakap\u00ebrcyeshme n\u00eb magazin\u00eb pran\u00eb tavern\u00ebs e lejonte t\u00eb mos v\u00ebrehej rastet e humbura.<\/p>\n<p>N\u00eb port u mbyll konkurrenti i fundit, dhe rasti i humbur i ngarkes\u00ebs s\u00eb gazel\u00ebs, i anashkaluar nga prioritizimi i bazuar n\u00eb supozimin e mjaftueshm\u00ebris\u00eb s\u00eb mbetjeve t\u00eb pakap\u00ebrcyeshme dhe ngarkes\u00ebs periodike t\u00eb mjeteve, u b\u00eb praktik\u00eb e zakonshme. Sistemi i krijuar do t\u00eb punoj\u00eb perfekt n\u00eb p\u00ebrputhje me algoritmet e vendosura brenda tij dhe do t\u00eb jet\u00eb i privuar nga \u00e7do mund\u00ebsi p\u00ebr t\u00eb ndjekur mosrealizimin sistematik t\u00eb porosive t\u00eb p\u00ebrcaktuara. Vet\u00ebm reputacioni i prishur dhe klient\u00ebt e pak\u00ebnaqur do t\u00eb jen\u00eb n\u00eb gjendje t\u00eb zbulojn\u00eb problemin.<\/p>\n<p>Nj\u00eb lexues i v\u00ebmendsh\u00ebm me siguri e ka v\u00ebn\u00eb re se sasia e porositur n\u00eb specifikimin e porosis\u00eb (T_ORDER_SPEC) n\u00eb seksionet 2 dhe 5 mund t\u00eb p\u00ebrmbush\u00eb dhe ndonj\u00ebher\u00eb nuk p\u00ebrmbush k\u00ebrkes\u00ebn e norm\u00ebs s\u00eb par\u00eb normale. E gjith\u00eb kjo varet nga n\u00ebse, p\u00ebr shasshin e mallrave t\u00eb zgjedhura, mund t\u00eb bien n\u00eb t\u00eb nj\u00ebjtin fush\u00eb nj\u00ebsi mat\u00ebse t\u00eb ndryshme n\u00eb thelb. <\/p>\n<p><b>Shkelja e norm\u00ebs s\u00eb dyt\u00eb normale:<\/b><\/p>\n<p>Me rritjen e k\u00ebrkesave tuaja, blini disa mjete transporti me p\u00ebrmasa t\u00eb ndryshme. N\u00eb kontekstin e paraqitur m\u00eb lart, krijimi i nj\u00eb udh\u00ebzuesi p\u00ebr mjetet e transportit u konsiderua i tepruar, duke b\u00ebr\u00eb q\u00eb t\u00eb gjith\u00eb algoritmet e pun\u00ebs me t\u00eb dh\u00ebnat q\u00eb sh\u00ebrbejn\u00eb nevojave t\u00eb shp\u00ebrndarjes dhe magazinimit t\u00eb perceptojn\u00eb l\u00ebvizjen e mallrave nga furnizuesi n\u00eb magazin\u00eb si nj\u00eb fluturim ekskluzivisht me furgonin 1.5-ton. Pra, s\u00eb bashku me blerjen e mjeteve t\u00eb reja, ju gjithsesi krijoni nj\u00eb udh\u00ebzues p\u00ebr mjetet e transportit, por gjat\u00eb ripunimit do t'ju duhet t\u00eb analizoni t\u00eb gjith\u00eb kodin q\u00eb referohet n\u00eb l\u00ebvizjen e mallrave p\u00ebr t\u00eb zbuluar n\u00ebse n\u00eb \u00e7do rast t\u00eb caktuar ka lidhje me karakteristikat e atij automobili me t\u00eb cilin filloi biznesi.<\/p>\n<p><b>Shkelja e norm\u00ebs s\u00eb tret\u00eb normale:<\/b><\/p>\n<p>N\u00eb nj\u00eb moment, ju filloni t\u00eb krijoni nj\u00eb program besnik\u00ebrie, duke u shfaqur regjistrimi i nj\u00eb klienti t\u00eb rregullt. Pse, p\u00ebr shembull, t\u00eb humbni koh\u00eb n\u00eb krijimin e prezantimeve materiale q\u00eb ruajn\u00eb t\u00eb dh\u00ebnat e agreguara p\u00ebr shitjet e nj\u00eb klienti p\u00ebr t'u p\u00ebrdorur n\u00eb raportim dhe p\u00ebr t'u d\u00ebrguar n\u00eb sistemet analitike, n\u00ebse n\u00eb faz\u00ebn fillestare t\u00eb programit t\u00eb besnik\u00ebris\u00eb, gjith\u00e7ka q\u00eb shqet\u00ebson bler\u00ebsin mund t\u00eb vendoset n\u00eb regjistrin e vet klientit? Dhe, me t\u00eb v\u00ebrtet\u00eb, fillimisht duket se nuk ka kuptim. Por sa her\u00eb q\u00eb biznesi juaj do t\u00eb lidhet, p\u00ebr shembull, me kanale t\u00eb reja shitjesh, duhet t\u00eb jet\u00eb dikush midis analist\u00ebve tuaj q\u00eb t\u00eb kujtoj\u00eb se ekziston nj\u00eb atribut agregues. <\/p>\n<p>Duke projektuar \u00e7do proces t\u00eb ri, le t\u00eb themi, shitjet n\u00eb internet, shitjet p\u00ebrmes distributor\u00ebve t\u00eb lidhur me sistemin e p\u00ebrbashk\u00ebt t\u00eb besnik\u00ebris\u00eb, dikush duhet t\u00eb mbaj\u00eb mend se t\u00eb gjith\u00eb proceset e reja duhet t\u00eb garantojn\u00eb integritetin e t\u00eb dh\u00ebnave n\u00eb nivelin e kodit. P\u00ebr nj\u00eb DB industrial me mij\u00ebra tabela, kjo duket si nj\u00eb detyr\u00eb e pap\u00ebrmbushshme.<\/p>\n<p>Nj\u00eb zhvillues i p\u00ebrparuar, sigurisht q\u00eb di si t\u00eb menaxhoj\u00eb t\u00eb gjitha problemet e p\u00ebrmendura m\u00eb lart, por, sipas mendimit tim, detyra e nj\u00eb analisti t\u00eb p\u00ebrvoj\u00ebs \u00ebsht\u00eb q\u00eb t\u00eb mos i lejoj\u00eb ato.<\/p>\n<p>Dua t\u00eb shpreh mir\u00ebnjohjen time p\u00ebr feedback-un e \u00e7muar gjat\u00eb p\u00ebrgatitjes s\u00eb publikimit p\u00ebr zhvilluesin e njohur Evgenij Yaruhinin.<\/p>\n<h2>Literatura<\/h2>\n<p>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/en\/post\/254773\/\">https:\/\/habr.com\/en\/post\/254773\/<\/a><\/noindex><br \/>\nConnolly Thomas, Begg Caroline. Bazat e t\u00eb dh\u00ebnave. Projektimi, implementimi dhe mb\u00ebshtetjes. Teoria dhe praktika<br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/sportmaster_lab\/blog\/497550\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u0438\u0432\u0435\u0442! \u041c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043d\u0434\u0440\u0435\u0439 \u0421\u0435\u043c\u0435\u043d\u043e\u0432, \u044f \u0441\u0442\u0430\u0440\u0448\u0438\u0439 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a \u0432 \u0421\u043f\u043e\u0440\u0442\u043c\u0430\u0441\u0442\u0435\u0440. \u0412 \u044d\u0442\u043e\u043c \u043f\u043e\u0441\u0442\u0435 \u044f \u0445\u043e\u0447\u0443 \u043f\u043e\u0434\u043d\u044f\u0442\u044c \u0432\u043e\u043f\u0440\u043e\u0441 \u0434\u0435\u043d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 ERP-\u0441\u0438\u0441\u0442\u0435\u043c. \u041c\u044b \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043e\u0431\u0449\u0438\u0435 \u0443\u0441\u043b\u043e\u0432\u0438\u044f, \u0430 \u0442\u0430\u043a\u0436\u0435 \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u0439 \u043f\u0440\u0438\u043c\u0435\u0440 \u2014 \u0441\u043a\u0430\u0436\u0435\u043c, \u044d\u0442\u043e \u0431\u0443\u0434\u0435\u0442 \u043f\u0440\u0435\u043a\u0440\u0430\u0441\u043d\u0430\u044f \u0442\u0430\u0432\u0435\u0440\u043d\u0430-\u043c\u043e\u043d\u043e\u043f\u043e\u043b\u0438\u0441\u0442 \u0434\u043b\u044f \u043f\u0438\u0440\u0430\u0442\u043e\u0432 \u0438 \u043c\u043e\u0440\u044f\u043a\u043e\u0432. \u0412 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043f\u0438\u0440\u0430\u0442\u043e\u0432 \u0438 \u043c\u043e\u0440\u044f\u043a\u043e\u0432 \u043d\u0430\u0434\u043e \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u0442\u044c \u043f\u043e-\u0440\u0430\u0437\u043d\u043e\u043c\u0443, \u0438\u0431\u043e \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043e \u043f\u0440\u0435\u043a\u0440\u0430\u0441\u043d\u043e\u043c \u0438 \u043f\u043e\u0442\u0440\u0435\u0431\u0438\u0442\u0435\u043b\u044c\u0441\u043a\u0438\u0435 \u043f\u0430\u0442\u0442\u0435\u0440\u043d\u044b \u0443 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":78199,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-78198","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.2 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u0440\u0438\u0432\u0435\u0442! \u041c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043d\u0434\u0440\u0435\u0439 \u0421\u0435\u043c\u0435\u043d\u043e\u0432, \u044f \u0441\u0442\u0430\u0440\u0448\u0438\u0439 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a \u0432 \u0421\u043f\u043e\u0440\u0442\u043c\u0430\u0441\u0442\u0435\u0440. \u0412 \u044d\u0442\u043e\u043c \u043f\u043e\u0441\u0442\u0435 \u044f \u0445\u043e\u0447\u0443 \u043f\u043e\u0434\u043d\u044f\u0442\u044c \u0432\u043e\u043f\u0440\u043e\u0441 \u0434\u0435\u043d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 ERP-\u0441\u0438\u0441\u0442\u0435\u043c.\" \/>\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\/denormalizacziya-baz-dannyh-erp-sistem-i-ee-vliyanie-na-razvitie-po-otkryvaem-tavernu-na-tortuge\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\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\u0414\u0435\u043d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 ERP-\u0441\u0438\u0441\u0442\u0435\u043c \u0438 \u0435\u0435 \u0432\u043b\u0438\u044f\u043d\u0438\u0435 \u043d\u0430 \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u041f\u041e: \u043e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c \u0442\u0430\u0432\u0435\u0440\u043d\u0443 \u043d\u0430 \u0422\u043e\u0440\u0442\u0443\u0433\u0435 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u0438\u0432\u0435\u0442! \u041c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043d\u0434\u0440\u0435\u0439 \u0421\u0435\u043c\u0435\u043d\u043e\u0432, \u044f \u0441\u0442\u0430\u0440\u0448\u0438\u0439 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a \u0432 \u0421\u043f\u043e\u0440\u0442\u043c\u0430\u0441\u0442\u0435\u0440. \u0412 \u044d\u0442\u043e\u043c \u043f\u043e\u0441\u0442\u0435 \u044f \u0445\u043e\u0447\u0443 \u043f\u043e\u0434\u043d\u044f\u0442\u044c \u0432\u043e\u043f\u0440\u043e\u0441 \u0434\u0435\u043d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 ERP-\u0441\u0438\u0441\u0442\u0435\u043c.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/denormalizacziya-baz-dannyh-erp-sistem-i-ee-vliyanie-na-razvitie-po-otkryvaem-tavernu-na-tortuge\" \/>\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-04-17T11:42:37+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-04-17T11:42:37+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\udd47Denormalizimi i bazave t\u00eb t\u00eb dh\u00ebnave ERP dhe ndikimi i tij n\u00eb zhvillimin e softuerit: hapim tavern\u00ebn n\u00eb Tortuga | ProHoster","description":"P\u00ebrsh\u00ebndetje! M\u00eb quajn\u00eb Andrey Semyonov, un\u00eb jam analist i lart\u00eb n\u00eb Sportmaster. N\u00eb k\u00ebt\u00eb post, dua t\u00eb diskutoj p\u00ebr \u00e7\u00ebshtjen e denormalizimit t\u00eb bazave t\u00eb t\u00eb dh\u00ebnave ERP.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/denormalizacziya-baz-dannyh-erp-sistem-i-ee-vliyanie-na-razvitie-po-otkryvaem-tavernu-na-tortuge","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\u0414\u0435\u043d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 ERP-\u0441\u0438\u0441\u0442\u0435\u043c \u0438 \u0435\u0435 \u0432\u043b\u0438\u044f\u043d\u0438\u0435 \u043d\u0430 \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u041f\u041e: \u043e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c \u0442\u0430\u0432\u0435\u0440\u043d\u0443 \u043d\u0430 \u0422\u043e\u0440\u0442\u0443\u0433\u0435 | ProHoster","og:description":"\u041f\u0440\u0438\u0432\u0435\u0442! \u041c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043d\u0434\u0440\u0435\u0439 \u0421\u0435\u043c\u0435\u043d\u043e\u0432, \u044f \u0441\u0442\u0430\u0440\u0448\u0438\u0439 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a \u0432 \u0421\u043f\u043e\u0440\u0442\u043c\u0430\u0441\u0442\u0435\u0440. \u0412 \u044d\u0442\u043e\u043c \u043f\u043e\u0441\u0442\u0435 \u044f \u0445\u043e\u0447\u0443 \u043f\u043e\u0434\u043d\u044f\u0442\u044c \u0432\u043e\u043f\u0440\u043e\u0441 \u0434\u0435\u043d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 ERP-\u0441\u0438\u0441\u0442\u0435\u043c.","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/denormalizacziya-baz-dannyh-erp-sistem-i-ee-vliyanie-na-razvitie-po-otkryvaem-tavernu-na-tortuge","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-04-17T11:42:37+00:00","article:modified_time":"2020-04-17T11:42:37+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"78198","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 17:03:32","updated":"2022-09-30 18:32:54","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\/78198","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=78198"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/78198\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/78199"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=78198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=78198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=78198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}