{"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 dh\u00ebnave t\u00eb sistemeve ERP dhe ndikimi i saj n\u00eb zhvillimin e softuerit: hapim tavern\u00ebn n\u00eb Tortuga","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>P\u00ebrsh\u00ebndetje! M\u00eb quajn\u00eb Andrei Semenov, un\u00eb jam analist senior n\u00eb Sportmaster. N\u00eb k\u00ebt\u00eb postim do t\u00eb diskutoj mbi \u00e7\u00ebshtjen e denormalizimit t\u00eb bazave t\u00eb t\u00eb dh\u00ebnave ERP. Do t\u00eb shqyrtojm\u00eb kushtet e p\u00ebrgjithshme dhe gjithashtu nj\u00eb shembull konkret \u2014 le t\u00eb themi se do t\u00eb jet\u00eb nj\u00eb tavern\u00eb monopolit p\u00ebr pirate dhe detar\u00eb. N\u00eb t\u00eb, pirate dhe detar\u00ebt duhet t\u00eb trajtohen ndryshe, sepse konceptet mbi t\u00eb bukur\u00ebn dhe\u6a21\u5f0ft e konsumit t\u00eb k\u00ebtyre zot\u00ebrinjve ndahen n\u00eb m\u00ebnyr\u00eb t\u00eb r\u00ebnd\u00ebsishme. <\/p>\n<p>Si t\u00eb b\u00ebjm\u00eb q\u00eb t\u00eb gjith\u00eb t\u00eb jen\u00eb t\u00eb k\u00ebnaqur? Si t\u00eb mos \u00e7mendem kur projektoj dhe mbaj 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 pirate dhe detar\u00eb t\u00eb zakonsh\u00ebm?<\/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 dh\u00ebnave t\u00eb sistemeve ERP dhe ndikimi i saj n\u00eb zhvillimin e softuerit: hapim tavern\u00ebn n\u00eb Tortuga\" src=\"\/wp-content\/uploads\/2020\/04\/bd0ccbfa3e3649aac20631e09fcb5b16.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>T gjith\u00e7ka \u00ebsht\u00eb m\u00eb posht\u00eb. Por le t\u00eb ecim n\u00eb radh\u00eb.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>1. Kufizimet dhe supozimet<\/h2>\n<p>\n\u00c7do gj\u00eb e shkruar i referohet vet\u00ebm bazave t\u00eb t\u00eb dh\u00ebnave relacionale. Pasojat e denormalizimit, t\u00eb cilat jan\u00eb mir\u00eb t\u00eb njohura, p\u00ebrfshir\u00eb ato n\u00eb internet, si anomalit\u00eb e modifikimit, fshirjes dhe inserimit, nuk diskutohen. Rastet ku denormalizimi \u00ebsht\u00eb i zakonsh\u00ebm, me shembuj klasik\u00eb, si serie dhe numri i pasaport\u00ebs, data dhe ora etj., lihen jasht\u00eb k\u00ebtij publikimi.<\/p>\n<p>N\u00eb postim p\u00ebrdoren definita intuitivisht t\u00eb kuptueshme dhe praktikisht t\u00eb aplikueshme p\u00ebr format normale, pa referenca n\u00eb terma matematikor\u00eb. N\u00eb form\u00ebn se si ato mund t\u00eb aplikohen n\u00eb shqyrtimin e proceseve t\u00eb v\u00ebrtet\u00eb t\u00eb biznesit (BP) dhe projektimin e softuer\u00ebve industrial\u00eb.<\/p>\n<p>Ekziston nj\u00eb mendim se projektimi i depozitave t\u00eb t\u00eb dh\u00ebnave, mjeteve p\u00ebr prodhimin e raporteve dhe marr\u00ebveshjeve integruese (n\u00eb t\u00eb cilat p\u00ebrdoret paraqitja tabelare e informacionit), ndryshon nga projektimi i bazave t\u00eb t\u00eb dh\u00ebnave ERP n\u00eb kuptimin q\u00eb leht\u00ebsia e konsumit dhe aplikimi p\u00ebr t\u00eb arritur at\u00eb, denormalizimi i vet\u00ebdijsh\u00ebm mund t\u00eb ket\u00eb prioritet ndaj mbrojtjes s\u00eb integritetit t\u00eb t\u00eb dh\u00ebnave. Un\u00eb e ndaj k\u00ebt\u00eb mendim, dhe ajo q\u00eb do t\u00eb p\u00ebrshkruhet m\u00eb posht\u00eb i p\u00ebrket ekskluzivisht modeleve t\u00eb t\u00eb dh\u00ebnave kryesore dhe t\u00eb dh\u00ebnave transaksionale t\u00eb sistemeve ERP.<\/p>\n<p>Shpjegimi i formave normale jepet me nj\u00eb shembull q\u00eb shumica e lexuesve e kuptojn\u00eb n\u00eb nivelin e zakonsh\u00ebm t\u00eb p\u00ebrditsh\u00ebm. Megjithat\u00eb, si nj\u00eb ilustrim vizual n\u00eb pikat 4-5, \u00ebsht\u00eb p\u00ebrdorur me vet\u00ebdije nj\u00eb detyr\u00eb theksuesh\u00ebm \"e shpikur\". N\u00ebse nuk e b\u00ebni k\u00ebt\u00eb dhe merrni ndonj\u00eb shembull klasikor, si modeli i depozitimit t\u00eb porosive nga pika 2, mund t\u00eb p\u00ebrfundoni n\u00eb nj\u00eb situat\u00eb ku fokusi i v\u00ebmendjes s\u00eb lexuesit do t\u00eb zhvendoset nga propozimi i ndarjes s\u00eb procesit n\u00eb model, n\u00eb p\u00ebrvoj\u00ebn personale dhe perceptimin e asaj si duhet nd\u00ebrtuar proceset dhe modelet e depozitimit t\u00eb t\u00eb dh\u00ebnave n\u00eb IS. Me fjal\u00eb t\u00eb tjera, merrni dy analist\u00eb IT t\u00eb kualifikuar, le t\u00eb thoni se nj\u00ebri ofron sh\u00ebrbim logjistik\u00eb p\u00ebr ata q\u00eb transportojn\u00eb pasagjer\u00eb, tjetri p\u00ebr ata q\u00eb transportojn\u00eb makina p\u00ebr prodhimin e mikro\u00e7ipave. K\u00ebrkoni nga ata, pa e diskutuar paraprakisht procesin e automatizuesh\u00ebm, t\u00eb hartojn\u00eb nj\u00eb model t\u00eb dh\u00ebnash p\u00ebr ruajtjen e informacionit mbi transportin hekurudhor. <\/p>\n<p>Ekziston nj\u00eb probabilitet jo zero se n\u00eb modelet e propozuara do t\u00eb gjeni jo vet\u00ebm nj\u00eb grup t\u00eb duksh\u00ebm atributesh t\u00eb ndryshme, por gjithashtu grupe entitetesh q\u00eb nuk p\u00ebrputhen, sepse \u00e7do analist do t\u00eb mb\u00ebshtetet n\u00eb proceset dhe detyrat q\u00eb i ka m\u00ebsuar. Dhe t\u00eb thuash 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 kriter vler\u00ebsimi.<\/p>\n<h2>2. Format 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 dh\u00ebnave t\u00eb sistemeve ERP dhe ndikimi i saj n\u00eb zhvillimin e softuerit: hapim tavern\u00ebn n\u00eb Tortuga\" src=\"\/wp-content\/uploads\/2020\/04\/e2d3fc5656b59671648511b0a0e5f7b9.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p><b>Forma normale e par\u00eb t\u00eb BD<\/b> k\u00ebrkon atomik\u00eb t\u00eb \u00e7do atribute. <br \/>\nN\u00eb ve\u00e7anti, n\u00ebse nj\u00eb objekti A i p\u00ebrkasin atribute jo kryesore a dhe b, t\u00eb tilla q\u00eb c=f(a,b) dhe n\u00eb tabel\u00ebn q\u00eb p\u00ebrshkruan objektin A ruani vler\u00ebn e atributeve c, at\u00ebher\u00eb BD e ka shkelur form\u00ebn normale t\u00eb par\u00eb. P\u00ebr shembull, n\u00ebse n\u00eb specifikimin e porosis\u00eb jepet sasia, nj\u00ebsit\u00eb e matjes s\u00eb s\u00eb cilave varen nga lloji i mallrave: n\u00eb nj\u00eb rast ato mund t\u00eb jen\u00eb copa, n\u00eb rastin tjet\u00ebr litra, n\u00eb t\u00eb tretin pako q\u00eb p\u00ebrb\u00ebhen nga copa (n\u00eb modelin m\u00eb sip\u00ebr Good_count_WR), at\u00ebher\u00eb BD ka shkelur atomik\u00ebn e atributeve. N\u00eb k\u00ebt\u00eb rast, p\u00ebr t\u00eb th\u00ebn\u00eb si duhet t\u00eb duket grupi i tabelave n\u00eb specifikimin e porosis\u00eb, nevojitet nj\u00eb p\u00ebrshkrim sh\u00ebnjest\u00ebr t\u00eb procesit t\u00eb pun\u00ebs n\u00eb IS, dhe p\u00ebr sa koh\u00eb q\u00eb proceset mund t\u00eb jen\u00eb t\u00eb ndryshme, ka shum\u00eb versione \"t\u00eb sakta\".<\/p>\n<p><b>Forma normale e dyt\u00eb t\u00eb BD<\/b> k\u00ebrkon p\u00ebrmbushjen e form\u00ebs s\u00eb par\u00eb dhe nj\u00eb tabel\u00eb t\u00eb vetme 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 s=f1(a) dhe d=f2(b) dhe nuk ekziston var\u00ebsi me s=f3(b), at\u00ebher\u00eb tabela e ka shkelur form\u00ebn normale t\u00eb dyt\u00eb. N\u00eb shembullin m\u00eb sip\u00ebr n\u00eb tabel\u00ebn \"Porosi\" nuk ekziston var\u00ebsi midis porosis\u00eb dhe adres\u00ebs. Ndryshoni emrin e rrug\u00ebs ose t\u00eb qytetit, dhe nuk do t\u00eb merrni ndonj\u00eb ndikim n\u00eb atributet thelb\u00ebsore t\u00eb porosis\u00eb. <\/p>\n<p><b>Forma normale e tret\u00eb t\u00eb BD<\/b> duhet t\u00eb p\u00ebrmbush\u00eb form\u00ebn e dyt\u00eb normale dhe t\u00eb mos ket\u00eb var\u00ebsi funksionale midis atributeve t\u00eb entiteteve t\u00eb ndryshme. Ky rregull mund t\u00eb formullohet k\u00ebshtu: \u00abgjith\u00e7ka q\u00eb mund t\u00eb llogaritet, duhet t\u00eb llogaritet\u00bb. N\u00eb fjal\u00eb t\u00eb tjera, n\u00ebse ekzistojn\u00eb dy objekte A dhe B. N\u00eb tabel\u00ebn q\u00eb ruan atributet e objektit A, shfaqet atributi C, nd\u00ebrsa n\u00eb objektin B ekziston nj\u00eb atribut b, i till\u00eb q\u00eb ka nj\u00eb c=f4(b), at\u00ebher\u00eb \u00ebsht\u00eb shkelur forma e tret\u00eb normale. N\u00eb shembullin e m\u00ebposht\u00ebm, atributi \u00abNumri i disa artikujve\u00bb (Total_count_WR) n\u00eb regjistrin e porosis\u00eb qart\u00eb pretendon t\u00eb shkel\u00eb form\u00ebn e tret\u00eb normale.<\/p>\n<h2>3. Qasja ime p\u00ebr aplikimin e normalizimit<\/h2>\n<p>\n1. Vet\u00ebm procesi i q\u00ebllimsh\u00ebm dhe i automatizuesh\u00ebm i biznesit mund t\u00eb siguroj\u00eb analistin me kritere 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 kusht i detyruesh\u00ebm p\u00ebr krijimin e nj\u00eb modeli normal t\u00eb t\u00eb dh\u00ebnave.<\/p>\n<p>2. Arritja e formes s\u00eb tret\u00eb normale n\u00eb kuptimin e sakt\u00eb mund t\u00eb mos jet\u00eb e arsyeshme n\u00eb praktik\u00ebn e v\u00ebrtet\u00eb t\u00eb krijimit t\u00eb sistemeve ERP n\u00ebse plot\u00ebsohen disa ose t\u00eb gjitha kushtet e m\u00ebposhtme:<\/p>\n<ul>\n<li>proceset e automatizueshme rrall\u00eb ndryshojn\u00eb, <\/li>\n<li>koha p\u00ebr hulumtim dhe zhvillim \u00ebsht\u00eb e kufizuar, <\/li>\n<li>k\u00ebrkesat p\u00ebr integritetin e t\u00eb dh\u00ebnave jan\u00eb relativisht t\u00eb ul\u00ebta (gabimet potenciale n\u00eb softuerin industrial nuk \u00e7ojn\u00eb n\u00eb humbje parash apo klient\u00ebsh p\u00ebr bler\u00ebsin e softuerit)<\/li>\n<li>etj.<\/li>\n<\/ul>\n<p>\nN\u00eb k\u00ebto kushte, shpenzimet p\u00ebr identifikimin dhe p\u00ebrshkrimin e ciklit t\u00eb jet\u00ebs s\u00eb disa objekteve dhe atributeve t\u00eb tyre mund t\u00eb mos justifikohen nga pik\u00ebpamja e efikasitetit ekonomik.<\/p>\n<p>3. Cdo pasoj\u00eb e denormalizimit t\u00eb modelit t\u00eb t\u00eb dh\u00ebnave n\u00eb nj\u00eb SI t\u00eb krijuar tashm\u00eb mund t\u00eb menaxhohet p\u00ebrmes nj\u00eb hulumtimi t\u00eb kujdessh\u00ebm t\u00eb kodit dhe testimit.<\/p>\n<p>4. Denormalizimi \u00ebsht\u00eb nj\u00eb m\u00ebnyr\u00eb p\u00ebr t\u00eb transferuar pun\u00ebn e nevojshme 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. \u00cbsht\u00eb e arsyeshme t\u00eb synohet forma e tret\u00eb normale t\u00eb DB n\u00ebse:<\/p>\n<ul>\n<li>Direksioni i ndryshimit t\u00eb proceseve t\u00eb automatizuar t\u00eb biznesit \u00ebsht\u00eb i paparashikuesh\u00ebm<\/li>\n<li>Brenda ekipit t\u00eb zbatimit dhe\/ose zhvillimit ekziston nj\u00eb ndarje e dob\u00ebt e pun\u00ebs<\/li>\n<li>Sistemet q\u00eb jan\u00eb pjes\u00eb e konturit integrues t\u00eb zhvillohen sipas planeve t\u00eb tyre<\/li>\n<li>Inkoherenca e t\u00eb dh\u00ebnave mund t\u00eb \u00e7oj\u00eb n\u00eb humbjen e 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 kryhet nga analisti vet\u00ebm n\u00eb lidhje me modelet e procesit t\u00eb biznesit dhe procesit n\u00eb SI. N\u00ebse projektimin e modelit t\u00eb t\u00eb dh\u00ebnave e b\u00ebn zhvilluesi, ai duhet t\u00eb p\u00ebrfshihet n\u00eb fush\u00ebn e subjektit n\u00eb m\u00ebnyr\u00eb q\u00eb, n\u00eb ve\u00e7anti, t\u00eb kuptoj\u00eb ndryshimin midis vlerave t\u00eb atributeve \u2014 nj\u00eb kusht i nevojsh\u00ebm p\u00ebr identifikimin e atributeve atomike. K\u00ebshtu, ai merr p\u00ebrsip\u00ebr funksione jo t\u00eb zakonshme.<\/p>\n<h2>4 Detyra p\u00ebr ilustrim<\/h2>\n<p>\nSupozoni se keni nj\u00eb tavern\u00eb t\u00eb vog\u00ebl robotizuese n\u00eb port. Segmenti juaj i tregut: marinar\u00ebt dhe pirat\u00ebt, t\u00eb cil\u00ebt hyjn\u00eb n\u00eb port dhe kan\u00eb nevoj\u00eb p\u00ebr pushim. Marinart i shisni \u00e7aj me rigon, dhe pirateve rum dhe brushat kockore p\u00ebr t\u00eb pastruar mjekr\u00ebn. Sh\u00ebrbimi n\u00eb taverna vet\u00eb ofrohet nga nj\u00eb robot-hostes dhe nj\u00eb robot-barman. Fal\u00eb cil\u00ebsis\u00eb s\u00eb lart\u00eb dhe \u00e7mimeve t\u00eb ul\u00ebta, keni d\u00ebbuar t\u00eb gjith\u00eb konkurrent\u00ebt, duke u b\u00ebr\u00eb q\u00eb \u00e7do njeri q\u00eb zbret nga anija t\u00eb vij\u00eb n\u00eb tavern\u00ebn tuaj, e cila \u00ebsht\u00eb e vetme n\u00eb port.<\/p>\n<p>Kompleksi i sistemeve informacioni t\u00eb tavern\u00ebs p\u00ebrb\u00ebhet nga programet e m\u00ebposhtme: <\/p>\n<ul>\n<li>Sistemi i njoftimit t\u00eb hersh\u00ebm p\u00ebr klientin, i cili e njeh kategorin\u00eb e tij sipas karakteristikave dalluese<\/li>\n<li>Sistemi i menaxhimit t\u00eb robot\u00ebve-hostes dhe robot\u00ebve-barman<\/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 njoftimit t\u00eb hersh\u00ebm njeh ata q\u00eb zbresin nga anija. N\u00ebse nj\u00eb person \u00ebsht\u00eb rruajtur, ai e p\u00ebrcakton si marinar, n\u00ebse personi ka nj\u00eb mjek\u00ebr, at\u00ebher\u00eb ai p\u00ebrcaktohet si pirat.<\/p>\n<p>Duke n\u00eb tavern\u00eb, mysafiri d\u00ebgjon robotin-prit\u00ebs q\u00eb e p\u00ebrsh\u00ebndet sipas kategoris\u00eb s\u00eb tij, p\u00ebr shembull: \"Ho-ho-ho, i nderuar pirate, kaloni n\u00eb tryez\u00ebn nr. ...\"<\/p>\n<p>Mysafiri kalon te tavolina e caktuar, ku robot-barmani tashm\u00eb ka p\u00ebrgatitur p\u00ebr t\u00eb produktet sipas kategoris\u00eb. Robot-barmani i d\u00ebrgon informacionin n\u00eb sistemin e magazin\u00ebs se sasia tjet\u00ebr e shp\u00ebrndarjes duhet t\u00eb rritet, sistemi i magazin\u00ebs duke u bazuar n\u00eb rezervat n\u00eb magazin\u00eb formon nj\u00eb k\u00ebrkes\u00eb p\u00ebr blerje n\u00eb SUMP.<\/p>\n<p>Le t\u00eb jet\u00eb sistemi i paralajm\u00ebrimit t\u00eb hersh\u00ebm i zhvilluar nga IT-ja juaj e brendshme, nd\u00ebrsa programin p\u00ebr menaxhimin e robot\u00ebve t\u00eb barit e krijoi nj\u00eb kontraktor i jasht\u00ebm specifikisht p\u00ebr biznesin tuaj. Sistem\u00ebt p\u00ebr menaxhimin e magazin\u00ebs dhe marr\u00ebdh\u00ebnieve me furnitor\u00ebt jan\u00eb zgjidhje kutish t\u00eb personalizuara 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 anketuar t\u00eb fush\u00ebs deklaruan me nj\u00eb z\u00eb se n\u00eb t\u00eb gjith\u00eb bot\u00ebn pirat\u00ebt pijn\u00eb rum dhe shqet\u00ebsohen me mjekra me krehra prej kocke, nd\u00ebrsa detar\u00ebt pijn\u00eb \u00e7aj me tym dhe jan\u00eb gjithmon\u00eb t\u00eb rruar mir\u00eb. <\/p>\n<p>Krijohet nj\u00eb katalog i tipeve t\u00eb klient\u00ebve me dy vlera: 1- pirat\u00ebt, 2 \u2014 detar\u00ebt, e p\u00ebrbashk\u00ebt p\u00ebr gjith\u00eb informacionin n\u00eb kontur 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 tipit t\u00eb tij: detar ose pirat. <\/p>\n<p>ID e objektit t\u00eb njohur<br \/>\nKategoria e klientit<\/p>\n<p>100500<br \/>\nPirat<\/p>\n<p>100501<br \/>\nPirat<\/p>\n<p>100502<br \/>\nDetar<\/p>\n<p>Le t\u00eb theksojm\u00eb p\u00ebrs\u00ebri q\u00eb<\/p>\n<p>1. Detar\u00ebt tan\u00eb jan\u00eb n\u00eb t\u00eb v\u00ebrtet\u00eb njer\u00ebz t\u00eb rruar<br \/>\n2. Pirat\u00ebt tan\u00eb jan\u00eb n\u00eb t\u00eb v\u00ebrtet\u00eb njer\u00ebz me mjekra<\/p>\n<p>\u00c7far\u00eb problemeve duhet t'i zgjidhim n\u00eb k\u00ebt\u00eb rast, n\u00eb m\u00ebnyr\u00eb q\u00eb struktura jon\u00eb t\u00eb synoj\u00eb form\u00ebn e tret\u00eb normale:<\/p>\n<ul>\n<li>shkelja e atomizimit 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 entiteteve 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 n\u00eb form\u00ebn e nj\u00eb grupi t\u00eb tipareve t\u00eb p\u00ebrcaktuara,<\/li>\n<\/ul>\n<p><\/p>\n<p>ID e objektit t\u00eb njohur<br \/>\nP\u00ebrkat\u00ebsia e qimeve n\u00eb fytyr\u00eb<\/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 tipit t\u00eb klientit si aplikim i logjik\u00ebs t\u00eb integruar n\u00eb IS p\u00ebr interpretimin e tipareve t\u00eb p\u00ebrcaktuara<\/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 \/>\nPirat<\/p>\n<p>100501<br \/>\n100002<br \/>\nPirat<\/p>\n<p>100502<br \/>\n100003<br \/>\nDetar<\/p>\n<p>Si mund t\u00eb leht\u00ebsoj\u00eb organizimi i normalizuar i ruajtjes s\u00eb t\u00eb dh\u00ebnave zhvillimin e kompleksit t\u00eb IS? Le t\u00eb themi se papritur ju shfaqen klient\u00eb t\u00eb rinj. Le t\u00eb jen\u00eb k\u00ebta pirat\u00eb japonez\u00eb t\u00eb cil\u00ebt nuk kan\u00eb mjekra, por ndajn\u00eb zogun n\u00eb sup, dhe pirat\u00ebt ekologjik\u00eb, i njihni leht\u00ebsisht nga profili blu i Gret\u00ebs n\u00eb gjoksin e majt\u00eb. <\/p>\n<p>Pirat\u00ebt ekologjik\u00eb, natyrisht, nuk mund t\u00eb p\u00ebrdorin krehra prej kocke dhe k\u00ebrkojn\u00eb nj\u00eb alternativ\u00eb nga plastika detare e ricikluar.<\/p>\n<p>Ju nevojitet t\u00eb rishikoni algoritmet e pun\u00ebs s\u00eb programeve p\u00ebr t'iu p\u00ebrshtatur inputeve t\u00eb reja. Po t\u00eb ishin zbatuar rregullat e normalizimit, do t'ju duhej vet\u00ebm n\u00eb disa sisteme t\u00eb shtoni hyrjet p\u00ebr disa deg\u00eb t\u00eb proceseve dhe t\u00eb krijoni dega t\u00eb reja vet\u00ebm p\u00ebr ato raste dhe n\u00eb ato IS, ku ka r\u00ebnd\u00ebsi p\u00ebrkat\u00ebsia e qimeve n\u00eb fytyr\u00eb. Por, duke qen\u00eb se rregullat nuk u zbatuan, do t'ju duhej t\u00eb analizoni t\u00eb gjith\u00eb kodin, n\u00eb t\u00eb gjith\u00eb kontur\u00ebt ku p\u00ebrdoren vlerat e katalogut t\u00eb tipeve t\u00eb klient\u00ebve dhe t\u00eb p\u00ebrcaktoni qart\u00eb se n\u00eb nj\u00eb rast algoritmi duhet t\u00eb marr\u00eb parasysh veprimtarin\u00eb profesionale t\u00eb klientit, nd\u00ebrsa n\u00eb nj\u00eb tjet\u00ebr ve\u00e7orit\u00eb fizike. <\/p>\n<p>N\u00eb form\u00ebn q\u00eb <b><i>synon <\/i><\/b>n\u00eb form\u00ebn e normalizuar, do t\u00eb kishim dy tabela me t\u00eb dh\u00ebna operative dhe dy kataloge:<\/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 dh\u00ebnave t\u00eb sistemeve ERP dhe ndikimi i saj n\u00eb zhvillimin e softuerit: hapim tavern\u00ebn 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 n\u00eb form\u00ebn e nj\u00eb grupi t\u00eb tipareve t\u00eb p\u00ebrcaktuara,<\/li>\n<\/ul>\n<p><\/p>\n<p>ID e objektit t\u00eb njohur<br \/>\nGreta n\u00eb gjoksin e majt\u00eb<br \/>\nZogu n\u00eb sup<br \/>\nP\u00ebrkat\u00ebsia e qimeve n\u00eb fytyr\u00eb<\/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 tipit t\u00eb klientit (le t\u00eb jet\u00eb nj\u00eb paraqitje p\u00ebrdoruese, ku do t\u00eb shfaqen p\u00ebrshkrimet nga katalog\u00ebt)<\/li>\n<\/ul>\n<p>\nN\u00ebnkupton 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 imagjinojm\u00eb se t\u00eb gjitha IS jan\u00eb krijuar nga nj\u00eb ekip me fluks t\u00eb pap\u00ebrmbajtur, zhvillimet jan\u00eb dokumentuar mir\u00eb dhe informacioni n\u00eb ekip kalon pa humbje, at\u00ebher\u00eb ndryshimet e k\u00ebrkuara mund t\u00eb realizohen me p\u00ebrpjekje t\u00eb pap\u00ebrfillshme. Por, po t\u00eb kthehemi tek kushtet fillestare t\u00eb problemit, vet\u00ebm p\u00ebr t\u00eb printuar protokollet e diskutimeve t\u00eb p\u00ebrbashk\u00ebta do t\u00eb fshihen 1.5 tastier\u00eb dhe edhe 0.5 p\u00ebr formimin e procedurave t\u00eb blerjes.<\/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 n\u00eb m\u00ebnyr\u00eb t\u00eb ve\u00e7ant\u00eb.<\/p>\n<p><b>Shkelja e form\u00ebs s\u00eb par\u00eb normale:<\/b><\/p>\n<p>Le t\u00eb themi, mallrat n\u00eb magazin\u00ebn tuaj d\u00ebrgohen nga magazinat e furnitor\u00ebve me vet\u00ebmbledhje duke p\u00ebrdorur nj\u00eb furgon 1.5-ton q\u00eb i p\u00ebrket tavern\u00ebs tuaj. Sasia e porosive tuaja \u00ebsht\u00eb kaq e vog\u00ebl n\u00eb krahasim me qarkullimin e furnitor\u00ebve, saq\u00eb ato realizohen gjithmon\u00eb nj\u00eb p\u00ebr nj\u00eb pa pritur prodhimin. A jan\u00eb t\u00eb nevojshme tabela t\u00eb ve\u00e7anta p\u00ebr k\u00ebt\u00eb BPr?: mjete transporti, llojet e mjeteve t\u00eb transportit, a duhet t\u00eb ndani planin dhe faktin n\u00eb porosit\u00eb tuaja t\u00eb d\u00ebrguara te furnitor\u00ebt?<\/p>\n<p>Mendoni se sa shum\u00eb 'koneksione' t\u00eb tep\u00ebrta do t'u duhej t\u00eb shkruanin programuesit tuaj, n\u00ebse p\u00ebr zhvillimin e programit do t\u00eb 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 dh\u00ebnave t\u00eb sistemeve ERP dhe ndikimi i saj n\u00eb zhvillimin e softuerit: hapim tavern\u00ebn n\u00eb Tortuga\" src=\"\/wp-content\/uploads\/2020\/04\/7309871d1ecc5c1ceb4f077ea4afebff.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>Supozoni se kemi marr\u00eb vendimin se struktura e propozuar \u00ebsht\u00eb tep\u00ebr e nd\u00ebrlikuar, p\u00ebr rastin ton\u00eb ndarja e planit dhe faktit n\u00eb regjistrimin e porosis\u00eb \u00ebsht\u00eb informacion i tepruar, dhe specifikimi i formuar i porosis\u00eb ri-shkruhet sipas rezultateve t\u00eb pranimit t\u00eb mallrave t\u00eb mb\u00ebrritur, rasti i rrall\u00eb i gabimit dhe ardhja e mallrave t\u00eb pap\u00ebrshtatsh\u00ebm rregullohen jasht\u00eb sistemit informacionit.<br \/>\nDhe nj\u00eb dit\u00eb shihni se e gjith\u00eb salla e tavern\u00ebs \u00ebsht\u00eb mbushur me pirat\u00eb t\u00eb zem\u00ebruar dhe t\u00eb papast\u00ebr. \u00c7far\u00eb ndodhi? <\/p>\n<p>Doli se me rritjen e biznesit tuaj \u00ebsht\u00eb rritur edhe konsumimi. Nj\u00ebher\u00eb ishte marr\u00eb nj\u00eb vendim menaxherial, q\u00eb n\u00ebse furgoni ishte i ngarkuar mbipesh\u00eb dhe\/ose mbi kapacitetin, q\u00eb ndodhte jasht\u00ebzakonisht rrall\u00eb, furnizuesi prioritetonte ngarkes\u00ebn n\u00eb favor t\u00eb pijes. <\/p>\n<p>Mallrat e munguar kalonin n\u00eb porosin\u00eb tjet\u00ebr dhe shkonin me nj\u00eb fluturim t\u00eb ri, prania e nj\u00eb sasie minimale n\u00eb depo n\u00eb tavern\u00eb lejonte q\u00eb t\u00eb kaloheshin rastet e humbjes.<\/p>\n<p>N\u00eb port, konkurenti i fundit u mbyll, dhe rasti i mbingarkes\u00ebs s\u00eb furgonit, q\u00eb ishte anashkaluar p\u00ebr shkak t\u00eb prioritizimit t\u00eb bazuar n\u00eb supozimin p\u00ebr mjaftueshm\u00ebrin\u00eb e sasive minimale dhe ngarkes\u00ebn periodike t\u00eb pamjaftueshme t\u00eb mjeteve, u b\u00eb praktik\u00eb e zakonshme. Sistemi i krijuar do t\u00eb funksionoj\u00eb n\u00eb p\u00ebrputhje me algoritmet e nd\u00ebrtuara dhe do t\u00eb jet\u00eb pa mund\u00ebsin\u00eb p\u00ebr t\u00eb ndjekur mosrespektimin sistematik t\u00eb porosive plane. Vet\u00ebm nj\u00eb reputacion i prishur dhe klient\u00eb t\u00eb pak\u00ebnaqur do t\u00eb mund t\u00eb zbulojn\u00eb problemin.<\/p>\n<p>Lexuesi 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 seksionin 2 dhe n\u00eb seksionin 5 mund t\u00eb p\u00ebrputhet ose jo me k\u00ebrkesat e normales s\u00eb par\u00eb. Kjo varet nga n\u00ebse, p\u00ebrzgjedhja e asortimentit t\u00eb mallrave lejon q\u00eb n\u00eb t\u00eb nj\u00ebjt\u00ebn fush\u00eb t\u00eb bien nj\u00ebsit\u00eb e ndryshme mat\u00ebs. <\/p>\n<p><b>Shkelja e normales s\u00eb dyt\u00eb:<\/b><\/p>\n<p>Me rritjen e nevojave tuaja blini edhe disa mjete transporti me p\u00ebrmasa t\u00eb ndryshme. N\u00eb kontekstin e p\u00ebrmendur m\u00eb sip\u00ebr, krijimi i nj\u00eb katalogu t\u00eb mjeteve t\u00eb transportit u shpall i tep\u00ebrt, si rezultat, t\u00eb gjitha algoritmet e pun\u00ebs me t\u00eb dh\u00ebnat q\u00eb sh\u00ebrbejn\u00eb nevojat e d\u00ebrges\u00ebs dhe depozit\u00ebs, perceptojn\u00eb l\u00ebvizjen e mallrave nga furnizuesi n\u00eb depo si nj\u00eb fluturim ekskluzivisht t\u00eb furgonit t\u00eb 1.5 ton\u00ebve. Pra, nd\u00ebrsa blini mjete t\u00eb reja transporti, ju gjithashtu krijoni nj\u00eb katalog t\u00eb mjeteve t\u00eb transportit, por n\u00eb p\u00ebrmir\u00ebsim 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 kuptuar n\u00ebse \u00e7do vend i ve\u00e7ant\u00eb ka referenca p\u00ebr karakteristikat e atij automjeti, me t\u00eb cilin filloi biznesi.<\/p>\n<p><b>Shkelja e normales s\u00eb tret\u00eb:<\/b><\/p>\n<p>N\u00eb nj\u00eb moment ju filloni t\u00eb krijoni nj\u00eb program besnik\u00ebrie, dhe shfaqet nj\u00eb regjistrim i klientit t\u00eb rregullt. Pse, p\u00ebr shembull, duhet t\u00eb humbisni koh\u00eb duke krijuar p\u00ebrfaq\u00ebsime materiale q\u00eb ruajn\u00eb t\u00eb dh\u00ebna t\u00eb agreguara mbi shitjet p\u00ebr klient\u00eb t\u00eb ve\u00e7ant\u00eb p\u00ebr t'u p\u00ebrdorur n\u00eb raportim dhe transmetim n\u00eb sistemet analitike, n\u00ebse n\u00eb faz\u00ebn fillestare t\u00eb programit t\u00eb besnik\u00ebris\u00eb, gjith\u00e7ka q\u00eb intereson bler\u00ebsin mund t\u00eb vendoset n\u00eb regjistrin e vet t\u00eb klientit? Dhe me t\u00eb v\u00ebrtet\u00eb, n\u00eb dukje nuk ka kuptim. Por \u00e7do her\u00eb q\u00eb biznesi juaj do t\u00eb lidh\u00eb, p\u00ebr shembull, kanale t\u00eb reja shitjeje, midis analist\u00ebve tuaj duhet t\u00eb ket\u00eb dik\u00eb q\u00eb t\u00eb kujtohet se ekziston nj\u00eb atribut agregues i till\u00eb. <\/p>\n<p>Duke projektuar \u00e7do proces t\u00eb ri, supozoni, 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 gjitha proceset e reja duhet t\u00eb garantojn\u00eb integritetin e t\u00eb dh\u00ebnave n\u00eb nivelin e kodit. P\u00ebr nj\u00eb baz\u00eb t\u00eb dh\u00ebnash industriale me mij\u00ebra tabela, kjo duket si nj\u00eb detyr\u00eb e realizueshme.<\/p>\n<p>Nj\u00eb zhvillues i p\u00ebrvojsh\u00ebm, sigurisht, e di se si t\u00eb zgjidh\u00eb t\u00eb gjitha problemet e lartp\u00ebrmendura, por, sipas mendimit tim, detyra e nj\u00eb analisti t\u00eb p\u00ebrvojsh\u00ebm \u00ebsht\u00eb t\u00eb mos i lejoj\u00eb ato.<\/p>\n<p>D\u00ebshiroj t\u00eb shpreh mir\u00ebnjohjen time p\u00ebr feedback-un e vlefsh\u00ebm gjat\u00eb p\u00ebrgatitjes s\u00eb publikimit p\u00ebr zhvilluesin kryesor Evgeny Yarukhin.<\/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. Databases. Design, Implementation and Maintenance. Theory and Practice.<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 4.9.10 - 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. \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\" \/>\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) 4.9.10\" \/>\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. \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\" \/>\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! Emri im \u00ebsht\u00eb Andrey Semenov, un\u00eb jam analist i lart\u00eb n\u00eb Sportmaster. N\u00eb k\u00ebt\u00eb post kam d\u00ebshir\u00eb t\u00eb ngre \u00e7\u00ebshtjen e denormalizimit t\u00eb bazave t\u00eb t\u00eb dh\u00ebnave ERP. Ne do t\u00eb shqyrtojm\u00eb kushtet e p\u00ebrgjithshme, si dhe nj\u00eb shembull konkret - le t\u00eb themi, kjo do t\u00eb jet\u00eb taverna e shk\u00eblqyer monopoliste p\u00ebr pirate dhe marinar\u00eb. N\u00eb t\u00eb cil\u00ebn pirat\u00ebt dhe marinar\u00ebt duhet t\u00eb sh\u00ebrbehen ndryshe, sepse p\u00ebrceptimet mbi t\u00eb bukur\u00ebn dhe modelet e konsumit jan\u00eb t\u00eb ndryshme.","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. \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","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"},"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}]}}