{"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\/sk\/blog\/administrirovanie\/denormalizacziya-baz-dannyh-erp-sistem-i-ee-vliyanie-na-razvitie-po-otkryvaem-tavernu-na-tortuge","title":{"rendered":"Denormaliz\u00e1cia datab\u00e1z ERP syst\u00e9mov a jej vplyv na rozvoj softv\u00e9ru: otv\u00e1rame tavernu na Tortuge","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Ahoj! Vol\u00e1m sa Andrej Semenov, som senior analytik v Sportmaster. V tomto pr\u00edspevku chcem zdvihn\u00fa\u0165 ot\u00e1zku denormaliz\u00e1cie datab\u00e1z ERP syst\u00e9mov. Presk\u00famame v\u0161eobecn\u00e9 podmienky a taktie\u017e konkr\u00e9tny pr\u00edklad \u2014 povedzme, \u017ee to bude \u00fa\u017easn\u00e1 monopoln\u00e1 kr\u010dma pre pir\u00e1tov a n\u00e1morn\u00edkov. V tejto kr\u010dme mus\u00edme obsluhova\u0165 pir\u00e1tov a n\u00e1morn\u00edkov r\u00f4znymi sp\u00f4sobmi, preto\u017ee predstavy o kr\u00e1se a spotrebite\u013esk\u00e9 zvyky t\u00fdchto v\u00e1\u017een\u00fdch p\u00e1nov sa podstatne l\u00ed\u0161ia. <\/p>\n<p>Ako dosiahnu\u0165, aby boli v\u0161etci spokojn\u00ed? Ako nezbl\u00e1zni\u0165 sa pri navrhovan\u00ed a podpore tak\u00e9ho syst\u00e9mu? \u010co robi\u0165, ak do kr\u010dmy za\u010dn\u00fa prich\u00e1dza\u0165 nielen zn\u00e1mi pir\u00e1ti a n\u00e1morn\u00edci?<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/sportmaster_lab\/blog\/497550\/\"><img decoding=\"async\" alt=\"Denormaliz\u00e1cia datab\u00e1z ERP syst\u00e9mov a jej vplyv na rozvoj softv\u00e9ru: otv\u00e1rame tavernu na Tortuge\" src=\"\/wp-content\/uploads\/2020\/04\/bd0ccbfa3e3649aac20631e09fcb5b16.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>V\u0161etko je pod katom. Ale po\u010fme z poriadku.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>1. Obmedzenia a predpoklady<\/h2>\n<p>\nV\u0161etko, \u010do je uveden\u00e9, sa t\u00fdka iba rela\u010dn\u00fdch datab\u00e1z. Dobr\u00e9, aj na internete dobre osvetlen\u00e9, n\u00e1sledky denormaliz\u00e1cie vo forme anom\u00e1li\u00ed \u00faprav, odstra\u0148ovania a vkladania nie s\u00fa sk\u00faman\u00e9. Mimo publik\u00e1cie ost\u00e1vaj\u00fa pr\u00edpady, ke\u010f je denormaliz\u00e1cia samozrejmou z\u00e1le\u017eitos\u0165ou s klasick\u00fdmi pr\u00edkladmi: s\u00e9ria a \u010d\u00edslo pasu, d\u00e1tum a \u010das a \u010fal\u0161ie.<\/p>\n<p>V pr\u00edspevku s\u00fa pou\u017eit\u00e9 intuit\u00edvne zrozumite\u013en\u00e9 a prakticky pou\u017eite\u013en\u00e9 defin\u00edcie norm\u00e1lnych foriem, bez odkazu na matematick\u00e9 pojmy. V takej forme, v akej ich mo\u017eno aplikova\u0165 na prieskum skuto\u010dn\u00fdch obchodn\u00fdch procesov (OBP) a navrhovanie priemyseln\u00fdch softv\u00e9rov.<\/p>\n<p>Existuje n\u00e1zor, \u017ee n\u00e1vrh \u00falo\u017eiska d\u00e1t, n\u00e1strojov na tvorbu reportov a integra\u010dn\u00fdch doh\u00f4d (v ktor\u00fdch sa pou\u017e\u00edva tabu\u013ekov\u00e9 zobrazenie inform\u00e1ci\u00ed), sa l\u00ed\u0161i od n\u00e1vrhu datab\u00e1z ERP syst\u00e9mov t\u00fdm, \u017ee pohodlie spotreby a aplik\u00e1cia pre jeho dosiahnutie vedomou denormaliz\u00e1ciou m\u00f4\u017ee ma\u0165 prednos\u0165 pred ochranou integrity \u00fadajov. Zdie\u013eam tento n\u00e1zor a ni\u017e\u0161ie uveden\u00e9 sa t\u00fdka v\u00fdlu\u010dne modelov master d\u00e1t a transak\u010dn\u00fdch \u00fadajov ERP syst\u00e9mov.<\/p>\n<p>Vysvetlenie norm\u00e1lnych foriem je uveden\u00e9 na pr\u00edklade, ktor\u00fd je v\u00e4\u010d\u0161ine \u010ditate\u013eov zrozumite\u013en\u00fd z be\u017en\u00e9ho \u017eivota. Av\u0161ak ako n\u00e1zorn\u00e1 ilustr\u00e1cia s\u00fa v bodoch 4-5 z\u00e1merne pou\u017eit\u00e9 doplnkov\u00fdmi fikt\u00edvnymi \u00falohami. Ak by sme to neurobili a vzali by sme nejak\u00fd u\u010debnicov\u00fd pr\u00edklad, ako je model skladovania objedn\u00e1vok z bodu 2, mohli by sme sa ocitn\u00fa\u0165 v situ\u00e1cii, kedy bude pozornos\u0165 \u010ditate\u013ea presunut\u00e1 z navrhnut\u00e9ho rozlo\u017eenia procesu na osobn\u00fa sk\u00fasenos\u0165 a vn\u00edmanie toho, ako by mali by\u0165 procesy a modely skladovania d\u00e1t v IS postaven\u00e9. In\u00fdmi slovami, vezmite dvoch kvalifikovan\u00fdch IT analytikov, nech jeden poskytuje slu\u017eby logistikom pre prepravu cestuj\u00facich a druh\u00fd logistikom pre prepravu strojov na v\u00fdrobu mikro\u010dipov. Po\u017eiadate ich, aby bez predch\u00e1dzaj\u00faceho dohovoru o automatizovate\u013en\u00fdch BP vytvorili model \u00fadajov na uchov\u00e1vanie inform\u00e1ci\u00ed o \u017eelezni\u010dnom lete. <\/p>\n<p>Existuje nenulov\u00e1 pravdepodobnos\u0165, \u017ee v navrhnut\u00fdch modeloch n\u00e1jdete nielen v\u00fdrazne odli\u0161n\u00fd s\u00fabor atrib\u00fatov, ale aj nezhoduj\u00face sa mno\u017einy ent\u00edt, preto\u017ee ka\u017ed\u00fd analytik sa opiera o jemu zn\u00e1me procesy a \u00falohy. A v takej situ\u00e1cii je nemo\u017en\u00e9 poveda\u0165, ktor\u00fd model je \u201espr\u00e1vny\u201c, preto\u017ee neexistuje krit\u00e9rium hodnotenia.<\/p>\n<h2>2. Norm\u00e1lne formy<\/h2>\n<p>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/mz\/vc\/ex\/mzvcexxqfzhzyybzk8zvbndmtcc.png\"><img decoding=\"async\" alt=\"Denormaliz\u00e1cia datab\u00e1z ERP syst\u00e9mov a jej vplyv na rozvoj softv\u00e9ru: otv\u00e1rame tavernu na Tortuge\" src=\"\/wp-content\/uploads\/2020\/04\/e2d3fc5656b59671648511b0a0e5f7b9.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p><b>Prv\u00e1 norm\u00e1lna forma DB<\/b> vy\u017eaduje atomickos\u0165 v\u0161etk\u00fdch atrib\u00fatov. <br \/>\nKonkr\u00e9tne, ak objekt A m\u00e1 nek\u013e\u00fa\u010dov\u00e9 atrib\u00faty a a b, tak \u017ee c=f(a,b) a v tabu\u013eke popisuj\u00facej objekt A uchov\u00e1vate hodnotu atrib\u00fatu c, tak v DB je poru\u0161en\u00e1 prv\u00e1 norm\u00e1lna forma. Napr\u00edklad, ak sa v \u0161pecifik\u00e1cii objedn\u00e1vky uv\u00e1dza mno\u017estvo, ktor\u00e9ho jednotky z\u00e1visia od typu tovaru: v jednom pr\u00edpade to m\u00f4\u017eu by\u0165 kusy, v druhom litry, v tre\u0165om balenia pozost\u00e1vaj\u00face z kusov (v hore uvedenom modeli Good_count_WR), tak je v DB poru\u0161en\u00e1 atomickos\u0165 atrib\u00fatov. V tomto pr\u00edpade, aby sme mohli poveda\u0165, ak\u00fd by mal by\u0165 tvar tabu\u013eky v \u0161pecifik\u00e1cii objedn\u00e1vky, potrebujeme cie\u013eov\u00e9 op\u00edsanie procesu pr\u00e1ce v IS, a ke\u010f\u017ee procesy m\u00f4\u017eu by\u0165 r\u00f4zne, m\u00f4\u017eu existova\u0165 aj \u201espr\u00e1vne\u201c verzie.<\/p>\n<p><b>Druh\u00e1 norm\u00e1lna forma DB<\/b> vy\u017eaduje dodr\u017eiavanie prvej formy a vlastnej tabu\u013eky pre ka\u017ed\u00fd entitu, ktor\u00e1 sa t\u00fdka pracovn\u00e9ho procesu v IS. Ak v jednej tabu\u013eke existuj\u00fa z\u00e1vislosti s=f1(a) a d=f2(b) a neexistuje z\u00e1vislos\u0165 s=f3(b), potom je v tabu\u013eke poru\u0161en\u00e1 druh\u00e1 norm\u00e1lna forma. V uvedenom pr\u00edklade v tabu\u013eke \u201eObjedn\u00e1vka\u201c neexistuje z\u00e1vislos\u0165 medzi objedn\u00e1vkou a adresou. Zme\u0148te n\u00e1zov ulice alebo mesta a neovplyvn\u00edte \u017eiadne podstatn\u00e9 atrib\u00faty objedn\u00e1vky. <\/p>\n<p><b>Tretia norm\u00e1lna forma DB<\/b> vy\u017eaduje dodr\u017eiavanie druhej norm\u00e1lnej formy a absenciu funk\u010dn\u00fdch z\u00e1vislost\u00ed medzi atrib\u00fatmi r\u00f4znych ent\u00edt. Toto pravidlo sa d\u00e1 vyjadri\u0165 takto: \u201ev\u0161etko, \u010do m\u00f4\u017ee by\u0165 vypo\u010d\u00edtan\u00e9, by malo by\u0165 vypo\u010d\u00edtan\u00e9\u201c. In\u00fdmi slovami, ak existuj\u00fa dva objekty A a B. V tabu\u013eke, ktor\u00e1 uchov\u00e1va atrib\u00faty objektu A, sa prejavuje atrib\u00fat C, u objektu B existuje atrib\u00fat b, tak\u00fd, \u017ee existuje c=f4(b), potom je poru\u0161en\u00e1 tretia norm\u00e1lna forma. V nasleduj\u00facom pr\u00edklade atrib\u00fat \u201ePo\u010det kusov\u201c (Total_count_WR) v z\u00e1zname objedn\u00e1vky jasne vykazuje pokus o poru\u0161enie tretej norm\u00e1lnej formy.<\/p>\n<h2>3. M\u00f4j pr\u00edstup k aplik\u00e1cii normaliz\u00e1cie<\/h2>\n<p>\n1. Iba cie\u013eov\u00fd automatizovate\u013en\u00fd obchodn\u00fd proces m\u00f4\u017ee poskytn\u00fa\u0165 analytikovi krit\u00e9ri\u00e1 na identifik\u00e1ciu ent\u00edt a atrib\u00fatov pri vytv\u00e1ran\u00ed modelu ukladania d\u00e1t. Vytvorenie modelu procesu je povinnou podmienkou na vytvorenie norm\u00e1lneho modelu d\u00e1t.<\/p>\n<p>2. Dosiahnutie tretej norm\u00e1lnej formy v pr\u00edsnom zmysle nemus\u00ed by\u0165 v re\u00e1lnej praxi vytv\u00e1rania ERP syst\u00e9mov \u00fa\u010deln\u00e9, ak s\u00fa splnen\u00e9 niektor\u00e9 alebo v\u0161etky nasleduj\u00face podmienky:<\/p>\n<ul>\n<li>automatizovate\u013en\u00e9 procesy s\u00fa zriedka vystaven\u00e9 zmen\u00e1m, <\/li>\n<li>lehoty na v\u00fdskum a v\u00fdvoj s\u00fa stla\u010den\u00e9, <\/li>\n<li>po\u017eiadavky na integritu d\u00e1t s\u00fa podmiene\u010dne n\u00edzke (potenci\u00e1lne chyby v priemyseln\u00fdch softv\u00e9rov\u00fdch rie\u0161eniach neved\u00fa k strate pe\u0148az\u00ed alebo z\u00e1kazn\u00edkov zo strany dod\u00e1vate\u013ea softv\u00e9ru)<\/li>\n<li>a podobne.<\/li>\n<\/ul>\n<p>\nPod uveden\u00fdmi podmienkami n\u00e1klady na identifik\u00e1ciu, popis \u017eivotn\u00e9ho cyklu niektor\u00fdch objektov a ich atrib\u00fatov nemusia by\u0165 od\u00f4vodnen\u00e9 z h\u013eadiska ekonomickej efektivity.<\/p>\n<p>3. Ak\u00e9ko\u013evek n\u00e1sledky denormaliz\u00e1cie modelu d\u00e1t u\u017e vytvorenej IS m\u00f4\u017eu by\u0165 obmedzen\u00e9 d\u00f4kladn\u00fdm predbe\u017en\u00fdm presk\u00faman\u00edm k\u00f3du a testovan\u00edm.<\/p>\n<p>4. Denormaliz\u00e1cia je sp\u00f4sob, ako prenies\u0165 pr\u00e1cu z f\u00e1zy sk\u00famania zdrojov d\u00e1t a projektovania obchodn\u00e9ho procesu do f\u00e1zy v\u00fdvoja, z obdobia implement\u00e1cie do obdobia rozvoja syst\u00e9mu.<\/p>\n<p>5. K tretej norm\u00e1lnej forme DB je rozumn\u00e9 smerova\u0165, ak:<\/p>\n<ul>\n<li>Zmena automatizovate\u013en\u00fdch obchodn\u00fdch procesov je \u0165a\u017eko progn\u00f3zovate\u013en\u00e1.<\/li>\n<li>V r\u00e1mci t\u00edmu pre implement\u00e1ciu a\/alebo rozvoj je zjavn\u00e9 slab\u00e9 prenikanie rozdelenia pr\u00e1ce.<\/li>\n<li>Syst\u00e9my zapojen\u00e9 do integra\u010dn\u00e9ho okruhu sa vyv\u00edjaj\u00fa pod\u013ea vlastn\u00fdch pl\u00e1nov.<\/li>\n<li>Nezhoda v \u00fadajoch m\u00f4\u017ee vies\u0165 k strate z\u00e1kazn\u00edkov alebo pe\u0148az\u00ed pre spolo\u010dnos\u0165.<\/li>\n<\/ul>\n<p>\n6. Navrhnutie modelu d\u00e1t by mal vykon\u00e1va\u0165 analytik len v s\u00favislosti s modelmi cie\u013eov\u00e9ho obchodn\u00e9ho procesu a procesu v IS. Ak model d\u00e1t navrhuje v\u00fdvoj\u00e1r, bude sa musie\u0165 hlboko zaobera\u0165 predmetnou oblas\u0165ou, aby najm\u00e4 pochopil rozdiel medzi hodnotami atrib\u00fatov \u2014 \u010do je nevyhnutn\u00e1 podmienka na vy\u010dlenenie atom\u00e1rnych atrib\u00fatov. T\u00fdmto sp\u00f4sobom prevezme nevhodn\u00e9 funkcie.<\/p>\n<h2>4 \u00daloha na ilustr\u00e1ciu.<\/h2>\n<p>\nPredpokladajme, \u017ee m\u00e1te mal\u00fa robotizovan\u00fa tavernu v pr\u00edstave. Va\u0161a trhov\u00e1 segment\u00e1cia zah\u0155\u0148a n\u00e1morn\u00edkov a pir\u00e1tov, ktor\u00ed prich\u00e1dzaj\u00fa do pr\u00edstavu a potrebuj\u00fa odpo\u010dinok. N\u00e1morn\u00edkom pred\u00e1vate \u010daj s tymianom, zatia\u013e \u010do pir\u00e1tom rom a kostiakov\u00e9 hrebe\u0148 na \u010desanie brady. Slu\u017ebu v tavernu vykon\u00e1va robot-hosteska a robot-barman. V\u010faka vysokej kvalite a n\u00edzkym cen\u00e1m ste vytla\u010dili v\u0161etk\u00fdch konkurentov, tak\u017ee ka\u017ed\u00fd, kto zost\u00fapi z lode, prich\u00e1dza do va\u0161ej taverny, ktor\u00e1 je jedin\u00e1 v pr\u00edstave.<\/p>\n<p>Kombin\u00e1cia informa\u010dn\u00fdch syst\u00e9mov taverny pozost\u00e1va z nasleduj\u00faceho softv\u00e9ru: <\/p>\n<ul>\n<li>Syst\u00e9m v\u010dasn\u00e9ho varovania o z\u00e1kazn\u00edkovi, ktor\u00fd rozpozn\u00e1va jeho kateg\u00f3riu pod\u013ea charakteristick\u00fdch znakov.<\/li>\n<li>Syst\u00e9m riadenia robotov-hostesiek a robotov-barmanov.<\/li>\n<li>Syst\u00e9m riadenia skladu a dod\u00e1vky na predajn\u00e9 miesto.<\/li>\n<li>Syst\u00e9m riadenia vz\u0165ahov s dod\u00e1vate\u013emi (CRM).<\/li>\n<\/ul>\n<p>\nProces:<\/p>\n<p>Syst\u00e9m v\u010dasn\u00e9ho varovania rozpozn\u00e1va \u013eud\u00ed, ktor\u00ed zostupuj\u00fa z lode. Ak je osoba hladko oholen\u00e1, ur\u010d\u00ed ju ako n\u00e1morn\u00edka, ak m\u00e1 osoba bradu, ur\u010duje sa ako pir\u00e1t.<\/p>\n<p>Ke\u010f vst\u00fapi do taverny, hos\u0165 po\u010duje od robota-hostesky pozdrav pod\u013ea svojej kateg\u00f3rie, napr\u00edklad: \u201eHo-ho-ho, v\u00e1\u017een\u00fd pir\u00e1t, prejdite k stolu \u010d. \u2026\u201c<\/p>\n<p>Hos\u0165 prech\u00e1dza k ur\u010den\u00e9mu stolu, kde robot-barman u\u017e pripravil pre neho tovar v s\u00falade s kateg\u00f3riou. Robot-barman odosiela inform\u00e1cie do skladov\u00e9ho syst\u00e9mu o tom, \u017ee nasleduj\u00faca z\u00e1sielka by mala by\u0165 zv\u00e4\u010d\u0161en\u00e1, skladov\u00fd IS na z\u00e1klade zostatkov v \u00falo\u017eisku vytv\u00e1ra objedn\u00e1vku na n\u00e1kup v SUOP.<\/p>\n<p>Nech syst\u00e9m v\u010dasn\u00e9ho upozornenia vyvinul v\u00e1\u0161 intern\u00fd IT t\u00edm, program na riadenie barov\u00fdch robotov vytvoril extern\u00fd dod\u00e1vate\u013e \u0161peci\u00e1lne pre v\u00e1\u0161 biznis. Syst\u00e9my pre riadenie skladu a vz\u0165ahov s dod\u00e1vate\u013emi s\u00fa prisp\u00f4soben\u00fdmi rie\u0161eniami z trhu.<\/p>\n<h2>5. Pr\u00edklady denormaliz\u00e1cie a jej vplyv na rozvoj softv\u00e9ru<\/h2>\n<p>\nPri projektovan\u00ed obchodn\u00e9ho procesu oslovovan\u00ed odborn\u00edci z oblasti jednomyse\u013ene uviedli, \u017ee po celom svete pir\u00e1ti pij\u00fa rum a \u010desaj\u00fa si brady kostenn\u00fdmi hrebe\u0148mi, zatia\u013e \u010do n\u00e1morn\u00edci pij\u00fa \u010daj s tymi\u00e1nom a s\u00fa v\u017edy hladko oholen\u00fdmi. <\/p>\n<p>Objavuje sa zoznam typov klientov so \u017eiados\u0165ami: 1- pir\u00e1ti, 2 - n\u00e1morn\u00edci, spolo\u010dn\u00fd pre cel\u00fd informa\u010dn\u00fd obvod spolo\u010dnosti. <\/p>\n<p>Syst\u00e9m upozornenia na klienta ihne\u010f uklad\u00e1 v\u00fdsledok spracovania obrazu ako identifik\u00e1tor (ID) rozpoznan\u00e9ho klienta a jeho typ: n\u00e1morn\u00edk alebo pir\u00e1t. <\/p>\n<p>ID Rozpoznan\u00e9ho objektu<br \/>\nKateg\u00f3ria klienta<\/p>\n<p>100500<br \/>\nPir\u00e1tsky<\/p>\n<p>100501<br \/>\nPir\u00e1tsky<\/p>\n<p>100502<br \/>\nN\u00e1morn\u00edk<\/p>\n<p>E\u0161te raz upozorn\u00edme, \u017ee<\/p>\n<p>1. Na\u0161i n\u00e1morn\u00edci s\u00fa v skuto\u010dnosti oholen\u00ed mu\u017ei<br \/>\n2. Na\u0161i pir\u00e1ti s\u00fa v skuto\u010dnosti bradat\u00ed mu\u017ei<\/p>\n<p>Ak\u00e9 probl\u00e9my je potrebn\u00e9 v tomto pr\u00edpade odstr\u00e1ni\u0165, aby sa na\u0161a \u0161trukt\u00fara usilovala o tret\u00ed norm\u00e1lny tvar:<\/p>\n<ul>\n<li>poru\u0161enie atomarity atrib\u00fatu - Kateg\u00f3ria klienta<\/li>\n<li>zmie\u0161anie analyzovan\u00e9ho faktu a v\u00fdstupu v jednej tabu\u013eke <\/li>\n<li>zaznamenan\u00e1 funk\u010dn\u00e1 z\u00e1vislos\u0165 medzi atrib\u00fatmi r\u00f4znych ent\u00edt. <\/li>\n<\/ul>\n<p>\nV normalizovanej podobe by sme dostali dve tabu\u013eky: <\/p>\n<ul>\n<li>v\u00fdsledok rozpoznania vo forme s\u00faboru stanoven\u00fdch charakterist\u00edk,<\/li>\n<\/ul>\n<p><\/p>\n<p>ID Rozpoznan\u00e9ho objektu<br \/>\nPorasty na tv\u00e1ri<\/p>\n<p>100500<br \/>\n\u00c1no<\/p>\n<p>100501<br \/>\n\u00c1no<\/p>\n<p>100502<br \/>\nNie<\/p>\n<p><\/p>\n<ul>\n<li>v\u00fdsledok ur\u010denia typu klienta ako aplik\u00e1cia zabudovanej logiky v IS na interpret\u00e1ciu stanoven\u00fdch charakterist\u00edk<\/li>\n<\/ul>\n<p>ID rozpoznan\u00e9ho objektu<br \/>\nID identifik\u00e1cie<br \/>\nKateg\u00f3ria klienta<\/p>\n<p>100500<br \/>\n100001<br \/>\nPir\u00e1tsky<\/p>\n<p>100501<br \/>\n100002<br \/>\nPir\u00e1tsky<\/p>\n<p>100502<br \/>\n100003<br \/>\nN\u00e1morn\u00edk<\/p>\n<p>Ako m\u00f4\u017ee normalizovan\u00e1 organiz\u00e1cia ukladania d\u00e1t u\u013eah\u010di\u0165 rozvoj komplexu IS? Predpokladajme, \u017ee n\u00e1hle z\u00edskate nov\u00fdch z\u00e1kazn\u00edkov. Nech s\u00fa to japonsk\u00ed pir\u00e1ti, ktor\u00ed m\u00f4\u017eu ma\u0165 ch\u00fdbaj\u00facu bradu, ale nosia papag\u00e1ja na pleci, a ekologick\u00ed pir\u00e1ti, ktor\u00fdch \u013eahko spozn\u00e1te pod\u013ea modr\u00e9ho profilu Greta na \u013eavej hrudi. <\/p>\n<p>Ekologick\u00ed pir\u00e1ti samozrejme nem\u00f4\u017eu pou\u017e\u00edva\u0165 kostn\u00e9 hrebe\u0148 a po\u017eaduj\u00fa anal\u00f3g z recyklovan\u00e9ho morsk\u00e9ho plastu.<\/p>\n<p>Je potrebn\u00e9 prepracova\u0165 algoritmy programov v s\u00falade s nov\u00fdmi vstupmi. Keby boli pravidl\u00e1 normaliz\u00e1cie dodr\u017ean\u00e9, museli by ste iba v \u010dasti syst\u00e9mov doplni\u0165 vstupy pre niektor\u00e9 vetvy procesov a vytvori\u0165 nov\u00e9 vetvy iba pre tie pr\u00edpady a v t\u00fdch IS, kde m\u00e1 v\u00fdznam ochlpenie na tv\u00e1ri. Ale preto\u017ee pravidl\u00e1 neboli dodr\u017ean\u00e9, budete musie\u0165 analyzova\u0165 cel\u00fd k\u00f3d vo v\u0161etk\u00fdch obvodoch, kde sa pou\u017e\u00edvaj\u00fa hodnoty referen\u010dn\u00e9ho typu klientov, a jednozna\u010dne stanovi\u0165, \u017ee v jednom pr\u00edpade mus\u00ed algoritmus bra\u0165 do \u00favahy profesion\u00e1lnu \u010dinnos\u0165 klienta, zatia\u013e \u010do v inom fyzick\u00e9 vlastnosti. <\/p>\n<p>V podobe, ktor\u00fa <b><i>usiluje sa <\/i><\/b>k normalizovan\u00e9mu, z\u00edskali by sme dve tabu\u013eky s prev\u00e1dzkov\u00fdmi d\u00e1tami a dva referen\u010dn\u00e9 zdroje:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/qn\/pq\/g4\/qnpqg4idbhbsqejhnryzfuilhhy.png\"><img decoding=\"async\" alt=\"Denormaliz\u00e1cia datab\u00e1z ERP syst\u00e9mov a jej vplyv na rozvoj softv\u00e9ru: otv\u00e1rame tavernu na Tortuge\" src=\"\/wp-content\/uploads\/2020\/04\/eea87da839171e8a3a42db0618972124.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<ul>\n<li>v\u00fdsledok rozpoznania vo forme s\u00faboru stanoven\u00fdch charakterist\u00edk,<\/li>\n<\/ul>\n<p><\/p>\n<p>ID rozpoznan\u00e9ho objektu<br \/>\nGreta na \u013eavej hrudi<br \/>\nPt\u00e1k na pleci<br \/>\nPorasty na tv\u00e1ri<\/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>v\u00fdsledok ur\u010denia typu klienta (nech je to u\u017e\u00edvate\u013esk\u00e9 zobrazenie, v ktorom s\u00fa uveden\u00e9 popisy z referen\u010dn\u00fdch zdrojov)<\/li>\n<\/ul>\n<p>\nZnamen\u00e1 zisten\u00e1 denormaliz\u00e1cia, \u017ee syst\u00e9my nebude mo\u017en\u00e9 prisp\u00f4sobi\u0165 nov\u00fdm podmienkam? Samozrejme, \u017ee nie. Ak si predstav\u00edme, \u017ee v\u0161etky IS boli vytvoren\u00e9 jedn\u00fdm t\u00edmom s nulovou fluktu\u00e1ciou zamestnancov, v\u00fdvoj je dobre zdokladovan\u00fd a inform\u00e1cie s\u00fa v t\u00edme pren\u00e1\u0161an\u00e9 bez str\u00e1t, po\u017eadovan\u00e9 zmeny m\u00f4\u017eu by\u0165 vykonan\u00e9 s nezanedbate\u013en\u00fdmi n\u00e1kladmi. Ale ak sa vr\u00e1time k p\u00f4vodn\u00fdm podmienkam \u00falohy, iba vytla\u010denie protokolov spolo\u010dn\u00fdch diskusi\u00ed zni\u010d\u00ed 1,5 kl\u00e1vesn\u00edc a \u010fal\u0161\u00edch 0,5 na vybavenie obstar\u00e1vac\u00edch proced\u00far.<\/p>\n<p>V uvedenom pr\u00edklade s\u00fa poru\u0161en\u00e9 v\u0161etky tri norm\u00e1lne formy, po\u010fme sa pok\u00fasi\u0165 poru\u0161ova\u0165 ich osobitne.<\/p>\n<p><b>Poru\u0161enie prvej norm\u00e1lnej formy:<\/b><\/p>\n<p>Predpokladajme, \u017ee tovar na va\u0161u skladov\u00fa z\u00e1klad\u0148u je dod\u00e1van\u00fd zo skladov dod\u00e1vate\u013eov osobn\u00fdm vyzdvihnut\u00edm pomocou jedn\u00e9ho 1,5-tonov\u00e9ho dod\u00e1vkov\u00e9ho vozidla, ktor\u00e9 patr\u00ed va\u0161ej kr\u010dme. Ve\u013ekos\u0165 va\u0161ich objedn\u00e1vok je tak mal\u00e1 v porovnan\u00ed s objemmi dod\u00e1vate\u013eov, \u017ee s\u00fa v\u017edy vykon\u00e1van\u00e9 presne bez \u010dakania na v\u00fdrobu. Potrebuj\u00fa sa pri takomto prev\u00e1dzkovom modeli samostatn\u00e9 tabu\u013eky: vozidl\u00e1, typy vozidiel, alebo je potrebn\u00e9 rozdeli\u0165 pl\u00e1n a fakt v va\u0161ich objedn\u00e1vkach odoslan\u00fdch dod\u00e1vate\u013eom?<\/p>\n<p>Len si predstavte, ko\u013eko \"zbyto\u010dn\u00fdch\" spojen\u00ed bud\u00fa musie\u0165 nap\u00edsa\u0165 va\u0161i program\u00e1tori, ak na v\u00fdvoj programu pou\u017eij\u00fa ni\u017e\u0161ie uveden\u00fd model.<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/bz\/js\/gf\/bzjsgfs0fephwjwqx8xdvunrgva.png\"><img decoding=\"async\" alt=\"Denormaliz\u00e1cia datab\u00e1z ERP syst\u00e9mov a jej vplyv na rozvoj softv\u00e9ru: otv\u00e1rame tavernu na Tortuge\" src=\"\/wp-content\/uploads\/2020\/04\/7309871d1ecc5c1ceb4f077ea4afebff.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>Predpokladajme, \u017ee sme sa rozhodli, \u017ee navrhnut\u00e1 \u0161trukt\u00fara je zbyto\u010dne zlo\u017eit\u00e1, pre n\u00e1\u0161 pr\u00edpad je rozde\u013eovanie pl\u00e1nu a skuto\u010dnosti v z\u00e1zname objedn\u00e1vky zbyto\u010dn\u00e1 inform\u00e1cia a vytvoren\u00e1 \u0161pecifik\u00e1cia objedn\u00e1vky sa prepisuje na z\u00e1klade v\u00fdsledkov prijatia doru\u010den\u00e9ho tovaru, zriedkav\u00e9 prehozy a doru\u010denie nekvalitn\u00e9ho tovaru sa rie\u0161ia mimo informa\u010dn\u00e9ho syst\u00e9mu.<br \/>\nA raz vid\u00edte, ako je cel\u00fd s\u00e1l kr\u010dmy zaplnen\u00fd rozhor\u010den\u00fdmi a neupraven\u00fdmi pir\u00e1tmi. \u010co sa stalo? <\/p>\n<p>Uk\u00e1zalo sa, \u017ee s rastom v\u00e1\u0161ho podnikania r\u00e1stlo aj spotrebovanie. Niekedy bolo prijat\u00e9 mana\u017e\u00e9rske rozhodnutie, \u017ee ak bol dod\u00e1vkov\u00fd automobil pre\u0165a\u017een\u00fd objemom a\/alebo hmotnos\u0165ou, \u010do sa st\u00e1valo ve\u013emi zriedka, dod\u00e1vate\u013e uprednostnil na\u010d\u00edtanie v prospech n\u00e1pojov. <\/p>\n<p>Nedodan\u00fd tovar sa dostal do nasleduj\u00facej objedn\u00e1vky a odi\u0161iel v novom lete, existencia minim\u00e1lneho zostatku na sklade pri kr\u010dme umo\u017enila ignorova\u0165 prehliadan\u00e9 pr\u00edpady.<\/p>\n<p>V pr\u00edstave sa uzavrel posledn\u00fd konkurent a prehliadan\u00fd pr\u00edpad pre\u0165a\u017eenia dod\u00e1vkov\u00e9ho vozidla, ktor\u00fd bol ob\u00edden\u00fd prioritiz\u00e1ciou zalo\u017eenou na predpoklade dostato\u010dnosti minim\u00e1lneho zostatku a ob\u010dasnom nedorozumen\u00ed prepravn\u00e9ho vozidla, sa stal be\u017enou praxou. Vytvoren\u00fd syst\u00e9m bude ide\u00e1lne fungova\u0165 v s\u00falade s algorithmy, ktor\u00e9 s\u00fa v \u0148om zakotven\u00e9, a nebude ma\u0165 \u017eiadnu mo\u017enos\u0165 sledova\u0165 systematick\u00e9 nevykon\u00e1vanie pl\u00e1novan\u00fdch objedn\u00e1vok. Iba po\u0161koden\u00e1 poves\u0165 a nespokojn\u00ed z\u00e1kazn\u00edci m\u00f4\u017eu odhali\u0165 probl\u00e9m.<\/p>\n<p>Pozorn\u00fd \u010ditate\u013e si ur\u010dite v\u0161imol, \u017ee objednan\u00e9 mno\u017estvo v \u0161pecifik\u00e1cii objedn\u00e1vky (T_ORDER_SPEC) v sekcii 2 a v sekcii 5 m\u00f4\u017ee zodpoveda\u0165 alebo nemus\u00ed zodpoveda\u0165 po\u017eiadavke prvej norm\u00e1lnej formy. V\u0161etko z\u00e1vis\u00ed od toho, \u010di m\u00f4\u017eu pri vybranom sortimente tovarov do jedn\u00e9ho a toho ist\u00e9ho po\u013ea pr\u00eds\u0165 r\u00f4zne podstatne jednotky merania. <\/p>\n<p><b>Poru\u0161enie druhej norm\u00e1lnej formy:<\/b><\/p>\n<p>S rastom va\u0161ich potrieb si zak\u00fapite nieko\u013eko dopravn\u00fdch prostriedkov r\u00f4znych rozmerov. V uvedenom kontexte bolo vytvorenie referen\u010dn\u00e9ho zoznamu dopravn\u00fdch prostriedkov pova\u017eovan\u00e9 za nadbyto\u010dn\u00e9, a v\u0161etky algoritmy spracovania \u00fadajov, ktor\u00e9 podporuj\u00fa potreby dod\u00e1vky a skladu, pova\u017euj\u00fa presun n\u00e1kladu od dod\u00e1vate\u013ea na sklad, za prepravu v\u00fdlu\u010dne 1,5-tonovej dod\u00e1vky. A tak, spolu s n\u00e1kupom nov\u00fdch dopravn\u00fdch prostriedkov, vytvor\u00edte referen\u010dn\u00fd zoznam dopravn\u00fdch prostriedkov, av\u0161ak pri \u00faprav\u00e1ch budete musie\u0165 analyzova\u0165 cel\u00fd k\u00f3d, ktor\u00fd sa odvol\u00e1va na presun n\u00e1kladu, aby ste zistili, \u010di sa v ka\u017edom jednotlivom pr\u00edpade nepredpokladaj\u00fa charakteristiky toho vozidla, s ktor\u00fdm sa za\u010d\u00ednalo.<\/p>\n<p><b>Poru\u0161enie tretej norm\u00e1lnej formy:<\/b><\/p>\n<p>V nejakom momente za\u010dnete vytv\u00e1ra\u0165 program lojality a vznikne z\u00e1znam st\u00e1lych z\u00e1kazn\u00edkov. Pre\u010do, napr\u00edklad, str\u00e1ca\u0165 \u010das na vytv\u00e1ranie materi\u00e1lnych reprezent\u00e1ci\u00ed, ktor\u00e9 uchov\u00e1vaj\u00fa agregovan\u00e9 \u00fadaje o predajoch konkr\u00e9tnemu z\u00e1kazn\u00edkovi na \u00fa\u010dely reportovania a odovzdania analytick\u00fdm syst\u00e9mom, ak v \u0161t\u00e1diu spustenia programu lojality m\u00f4\u017ee by\u0165 v\u0161etko, \u010do zauj\u00edma z\u00e1kazn\u00edka, uveden\u00e9 priamo na z\u00e1zname samotn\u00e9ho klienta? A skuto\u010dne, na prv\u00fd poh\u013ead, to d\u00e1va zmysel. Ale zaka\u017ed\u00fdm, ke\u010f va\u0161a firma pripoj\u00ed nov\u00e9 predajn\u00e9 kan\u00e1ly, mal by medzi va\u0161imi analytikmi by\u0165 niekto, kto si spomenie, \u017ee existuje tak\u00fd agregovan\u00fd atrib\u00fat. <\/p>\n<p>Pri n\u00e1vrhu ka\u017ed\u00e9ho nov\u00e9ho procesu, povedzme predaja cez internet, predaja cez distrib\u00fatorov pripojen\u00fdch k spolo\u010dnej syst\u00e9me lojality, niekto mus\u00ed ma\u0165 na pam\u00e4ti, \u017ee v\u0161etky nov\u00e9 procesy musia zabezpe\u010di\u0165 na \u00farovni k\u00f3du integritu \u00fadajov. Pre priemyseln\u00fa datab\u00e1zu s tis\u00edckami tabuliek sa to zd\u00e1 by\u0165 \u0165a\u017eko realizovate\u013enou \u00falohou.<\/p>\n<p>Sk\u00fasen\u00fd v\u00fdvoj\u00e1r ur\u010dite vie, ako eliminova\u0165 v\u0161etky vy\u0161\u0161ie uveden\u00e9 probl\u00e9my, ale domnievam sa, \u017ee \u00falohou sk\u00fasen\u00e9ho analytika je zabr\u00e1ni\u0165 ich vzniku.<\/p>\n<p>Chcem vyjadri\u0165 v\u010faku za cenn\u00fa sp\u00e4tn\u00fa v\u00e4zbu pri pr\u00edprave publik\u00e1cie hlavn\u00e9mu v\u00fdvoj\u00e1rovi Jevgenijovi Jaruchinovi.<\/p>\n<h2>Literat\u00fara<\/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. Datab\u00e1zy. N\u00e1vrh, implement\u00e1cia a \u00fadr\u017eba. Te\u00f3ria a prax.<br \/>\n<br \/>Zdroj: <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.4 - 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\/sk\/blog\/administrirovanie\/denormalizacziya-baz-dannyh-erp-sistem-i-ee-vliyanie-na-razvitie-po-otkryvaem-tavernu-na-tortuge\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sk_SK\" \/>\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\/sk\/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\udd47Denormaliz\u00e1cia datab\u00e1z ERP syst\u00e9mov a jej vplyv na rozvoj softv\u00e9ru: otv\u00e1rame tavernu na Tortuge | ProHoster","description":"Ahoj! Vol\u00e1m sa Andrej Semenov, som senior analytik v Sportmaster. V tomto pr\u00edspevku chcem otvori\u0165 t\u00e9mu denormaliz\u00e1cie datab\u00e1z ERP syst\u00e9mov.","canonical_url":"https:\/\/prohoster.info\/sk\/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":"sk_SK","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\/sk\/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\/sk\/wp-json\/wp\/v2\/posts\/78198","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=78198"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/78198\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media\/78199"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=78198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=78198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=78198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}