{"id":55011,"date":"2020-01-10T00:00:00","date_gmt":"2020-01-09T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/bd-messendzhera-ch-1-proektiruem-karkas-bazy"},"modified":"2020-02-18T14:03:05","modified_gmt":"2020-02-18T11:03:05","slug":"bd-messendzhera-ch-1-proektiruem-karkas-bazy","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/bd-messendzhera-ch-1-proektiruem-karkas-bazy","title":{"rendered":"Zi\u0146u b\u0101ze (1. da\u013ca): b\u0101zes karkasa projekt\u0113\u0161ana","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>K\u0101 var biznesa pras\u012bbas p\u0101rv\u0113rst konkr\u0113t\u0101s datu strukt\u016br\u0101s ar piem\u0113ru, projekt\u0113jot \"no nulles\" datu b\u0101zi zi\u0146ojumapmai\u0146as lietotnei.<\/p>\n<ul>\n<li>1. da\u013ca: izstr\u0101d\u0101jam datub\u0101zes karkasu<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/483170\/\">2. da\u013ca: sekcijas izveide \"dz\u012bvaj\u0101\"<\/a><\/noindex><\/li>\n<\/ul>\n<p>\n<img decoding=\"async\" alt=\"Zi\u0146u b\u0101ze (1. da\u013ca): b\u0101zes karkasa projekt\u0113\u0161ana\" src=\"\/wp-content\/uploads\/2020\/01\/d4e85052405da3f6580e4e931c292079.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nM\u016bsu datu b\u0101ze neb\u016bs tik apjom\u012bga un sadal\u012bta, <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/vk\/blog\/342570\/\">k\u0101 VKontakte<\/a><\/noindex> vai <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/oleg-bunin\/blog\/340976\/\">Badoo<\/a><\/noindex>, bet \"lai b\u016btu\", tom\u0113r tai j\u0101b\u016bt labai \u2013 funkcion\u0101lai, \u0101trai un <b>ietilp\u012bgai vien\u0101 server\u012b.<\/b> PostgreSQL \u2013 lai var\u0113tu izvietot atsevi\u0161\u0137u servisa eksempl\u0101ru kaut kur citur, piem\u0113ram.<\/p>\n<p>T\u0101p\u0113c nerun\u0101sim par shardingu, replik\u0101ciju un \u0123eodistrib\u016bt\u0101m sist\u0113m\u0101m, bet koncentr\u0113simies uz sh\u0113m\u0101m DB iek\u0161ien\u0113.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>1. solis: Mazliet biznesa specifikas<\/h2>\n<p>\nM\u0113s projekt\u0113sim m\u016bsu zi\u0146ojumu apmai\u0146u nevis abstrakti, bet veiksim to iek\u0161\u0113j\u0101 kontekst\u0101 <noindex><a rel=\"nofollow\" href=\"https:\/\/sbis.ru\/help\/work_in\/sms\/\">korporat\u012bv\u0101 soci\u0101l\u0101 t\u012bkla.<\/a><\/noindex>Citiem v\u0101rdiem sakot, cilv\u0113ki m\u016bsu gad\u012bjum\u0101 ne \"vienk\u0101r\u0161i sarakst\u0101s\", bet sazin\u0101s sav\u0101 starp\u0101, risinot noteiktas biznesa probl\u0113mas.<\/p>\n<p>K\u0101das ir uz\u0146\u0113muma probl\u0113mas?.. Apskat\u012bsim piem\u0113ru ar Vas\u012bliju \u2013 izstr\u0101des noda\u013cas vad\u012bt\u0101ju.<\/p>\n<ul>\n<li><i>\"Nikolaj, \u0161ai uzdevumam steidzami vajag pl\u0101ksteri \u0161odien!\"<\/i><br \/>\nT\u0101tad, sarakste var notikt k\u0101da kontekst\u0101 <b>Dokumenta<\/b>.<\/li>\n<li><i>\"Kola, ejam \u0161ovakar doto sp\u0113l\u0113t?\"<\/i><br \/>\nTas noz\u012bm\u0113, ka pat vienai p\u0101ri sarunbiedru saruna var vienlaikus norisin\u0101ties <b>par da\u017e\u0101d\u0101m t\u0113m\u0101m<\/b>.<\/li>\n<li><i>\"P\u0113ter, Nikolaj, l\u016bdzu, paskaties pievienotaj\u0101 fail\u0101 uz jauno serveri. \"<\/i><br \/>\nT\u0101d\u0113j\u0101di vienam zi\u0146ojumam var b\u016bt <b>vair\u0101ki adres\u0101ti.<\/b>\u0160aj\u0101 laik\u0101 zi\u0146ojums var satur\u0113t <b>pievienotus failus<\/b>.<\/li>\n<li><i>\"Semen, tu ar\u012b paskaties.\"<\/i><br \/>\nUn var b\u016bt iesp\u0113ja jau eso\u0161aj\u0101 sarakst\u0113 <b>uzaicin\u0101t jaunu dal\u012bbnieku.<\/b>.<\/li>\n<\/ul>\n<p>\nPaiesim pagaid\u0101m pie \u0161\u012b \"ac\u012bmredzamo\" vajadz\u012bbu saraksta.<\/p>\n<blockquote><p>Bez pien\u0101c\u012bgas uzdevuma specifikas izpratnes un uzdotajiem ierobe\u017eojumiem izstr\u0101d\u0101t <b>efekt\u012bvu<\/b> DB sh\u0113mu t\u0101s risin\u0101\u0161anai ir praktiski neiesp\u0113jami.<\/p><\/blockquote>\n<p><\/p>\n<h2>2. solis: Minim\u0101l\u0101 lo\u0123isk\u0101 sh\u0113ma<\/h2>\n<p>\nPa\u0161reiz\u0113j\u0101 sh\u0113ma izskat\u0101s \u013coti l\u012bdz\u012bga e-pasta sarakstei \u2013 tradicion\u0101lais biznesa r\u012bks. Patie\u0161\u0101m, \"algotriski\" daudzas biznesa probl\u0113mas ir l\u012bdz\u012bgas, t\u0101p\u0113c ar\u012b r\u012bki to risin\u0101\u0161anai b\u016bs struktur\u0101li l\u012bdz\u012bgi.<\/p>\n<p>Fiks\u0113sim jau ieg\u016bto lo\u0123isko attiec\u012bbu sh\u0113mu. Lai viegl\u0101k izprastu m\u016bsu modeli, izmantosim visvienk\u0101r\u0161\u0101ko att\u0113lo\u0161anas <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/ER-%D0%BC%D0%BE%D0%B4%D0%B5%D0%BB%D1%8C\">ER modeli<\/a><\/noindex> bez UML vai IDEF not\u0101cijas sare\u017e\u0123\u012bjumiem:<\/p>\n<p><img decoding=\"async\" alt=\"Zi\u0146u b\u0101ze (1. da\u013ca): b\u0101zes karkasa projekt\u0113\u0161ana\" src=\"\/wp-content\/uploads\/2020\/01\/75d0b3cf9e5a44ae3e243449fa406fbc.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nM\u016bsu piem\u0113r\u0101 persona, dokuments un bin\u0101rais \u201e\u0137ermenis\u201d fails ir \u201e\u0101r\u0113j\u0101s\u201d entit\u0101tes, kas past\u0101v neatkar\u012bgi no m\u016bsu pakalpojuma. T\u0101d\u0113\u013c turpm\u0101k m\u0113s t\u0101s vienk\u0101r\u0161i uzskat\u012bsim par saites \u201ekurp\u201d pa UUID.<\/p>\n<blockquote><p>Z\u012bm\u0113jiet <b>sh\u0113mas p\u0113c iesp\u0113jas vienk\u0101r\u0161\u0101k<\/b> \u2014 liel\u0101k\u0101 da\u013ca no tiem, kam j\u016bs t\u0101s r\u0101d\u012bsiet, nav eksperti UML\/IDEF las\u012b\u0161an\u0101. Bet \u2014 noteikti z\u012bm\u0113jiet.<\/p><\/blockquote>\n<p><\/p>\n<h2>3. solis: Uzb\u016bv\u0113jam tabulu strukt\u016bru<\/h2>\n<p>\n<b class=\"spoiler_title\">Par tabulu un lauku nosaukumiem<\/b>Uz \u201ekrievu\u201d tabulu un lauku nosaukumiem var attiekties da\u017e\u0101di, bet tas ir gaumes jaut\u0101jums. \u0145emot v\u0113r\u0101 <noindex><a rel=\"nofollow\" href=\"https:\/\/tensor.ru\/about\/career\/vacancies\">ka mums \u201eTensor\u0101\u201d<\/a><\/noindex> nav \u0101rvalstu izstr\u0101d\u0101t\u0101ju un PostgreSQL mums \u013cauj dot nosaukumus pat \u0137\u012bnie\u0161u rakstz\u012bm\u0113m, ja t\u0101s <u>ir p\u0113di\u0146\u0101s<\/u>, tad m\u0113s dodam priek\u0161roku nosaukumiem, kas ir skaidri un saprotami, lai nerastos neskaidr\u012bbas.<br \/>\nT\u0101 k\u0101 zi\u0146ojumus raksta daudzi cilv\u0113ki vienlaic\u012bgi, da\u017ei no tiem pat var to dar\u012bt <u>offline re\u017e\u012bm\u0101<\/u>, tad vienk\u0101r\u0161\u0101kais variants ir <b>izmantot UUID k\u0101 identifikatorus<\/b> ne tikai \u0101r\u0113j\u0101m entit\u0101t\u0113m, bet ar\u012b visiem objektiem m\u016bsu pakalpojum\u0101. Turkl\u0101t tos var \u0123ener\u0113t pat klienta pus\u0113 \u2014 tas pal\u012bdz\u0113s mums atbalst\u012bt zi\u0146ojumu nos\u016bt\u012b\u0161anu \u012bslaic\u012bgas DB nepieejam\u012bbas laik\u0101, un kol\u012bziju varb\u016bt\u012bba ir \u013coti maza.<\/p>\n<p>M\u016bsu datub\u0101zes melnraksta tabulu strukt\u016bra izskat\u012bsies \u0161\u0101di:<br \/>\n<b class=\"spoiler_title\">Tabulas : RU<\/b><\/p>\n<pre><code class=\"sql\">CREATE TABLE \"T\u0113ma\"(\n  \"T\u0113ma\"\n    uuid\n      PRIMARY KEY\n, \"Dokuments\"\n    uuid\n, \"Nosaukums\"\n    text\n);\n\nCREATE TABLE \"Zi\u0146ojums\"(\n  \"Zi\u0146ojums\"\n    uuid\n      PRIMARY KEY\n, \"T\u0113ma\"\n    uuid\n, \"Autors\"\n    uuid\n, \"DatumsLaiks\"\n    timestamp\n, \"Teksts\"\n    text\n);\n\nCREATE TABLE \"Adres\u0101ts\"(\n  \"Zi\u0146ojums\"\n    uuid\n, \"Persona\"\n    uuid\n, PRIMARY KEY(\"Zi\u0146ojums\", \"Persona\")\n);\n\nCREATE TABLE \"Fails\"(\n  \"Fails\"\n    uuid\n      PRIMARY KEY\n, \"Zi\u0146ojums\"\n    uuid\n, \"BLOB\"\n    uuid\n, \"Nosaukums\"\n    text\n);<\/code><\/pre>\n<p>\n<b class=\"spoiler_title\">Tabulas : EN<\/b><\/p>\n<pre><code class=\"sql\">CREATE TABLE theme(\n  theme\n    uuid\n      PRIMARY KEY\n, document\n    uuid\n, title\n    text\n);\n\nCREATE TABLE message(\n  message\n    uuid\n      PRIMARY KEY\n, theme\n    uuid\n, author\n    uuid\n, dt\n    timestamp\n, body\n    text\n);\n\nCREATE TABLE message_addressee(\n  message\n    uuid\n, person\n    uuid\n, PRIMARY KEY(message, person)\n);\n\nCREATE TABLE message_file(\n  file\n    uuid\n      PRIMARY KEY\n, message\n    uuid\n, content\n    uuid\n, filename\n    text\n);<\/code><\/pre>\n<p><\/p>\n<blockquote><p>Visvienk\u0101r\u0161\u0101k\u0101 pieeja form\u0101ta aprakst\u012b\u0161anai \u2014 s\u0101kt \u201eizv\u0113rst\u201d saist\u012bbu grafu <b>no tabul\u0101m, kas nesauc<\/b> nevienu citu.<\/p><\/blockquote>\n<p><\/p>\n<h2>4. solis: Noskaidrot neuzkr\u012bto\u0161\u0101s vajadz\u012bbas<\/h2>\n<p>\nViss, m\u0113s esam izstr\u0101d\u0101ju\u0161i datub\u0101zi, kur\u0101 var lieliski rakst\u012bt un <i><b>k\u0101 nu katrs<\/b><\/i> las\u012bt.<\/p>\n<p>Ievietosim sevi lietot\u0101ja viet\u0101, kas izmanto m\u016bsu pakalpojumu \u2014 ko m\u0113s v\u0113l\u0113tos dar\u012bt, izmantojot to?<\/p>\n<ul>\n<li><i>P\u0113d\u0113jie zi\u0146ojumi<\/i><br \/>\nTas ir <b>hronolo\u0123iski sak\u0101rtoti<\/b> saska\u0146\u0101 ar da\u017e\u0101diem krit\u0113rijiem re\u0123istrs \"maniem\" zi\u0146ojumiem. Kur esmu viens no adres\u0101tiem, kur esmu autors, kur man ir rakst\u012bjis, bet neesmu atbild\u0113jis, kur man ir neateikts, ...<\/li>\n<li><i>Sarunu dal\u012bbnieki<\/i><br \/>\nKas visp\u0101r piedal\u0101s \u0161aj\u0101 garaj\u0101 sarun\u0101?<\/li>\n<\/ul>\n<p>\nM\u016bsu strukt\u016bra \u013cauj atrisin\u0101t abus \u0161os uzdevumus \"visp\u0101r\", bet \u0101tri \u2014 n\u0113. Probl\u0113ma ir t\u0101, ka, lai sak\u0101rtotu pirm\u0101 uzdevuma ietvaros <b>nav iesp\u0113jams izveidot indeksu<\/b>, kas der\u0113tu katram no dal\u012bbniekiem (un b\u016bs j\u0101izdodas visas ieraksti), bet otr\u0101 uzdevuma izpildei nepiecie\u0161ams <b>izdodas visus zi\u0146ojumus<\/b> pa t\u0113mu.<\/p>\n<blockquote><p>Nepl\u0101notas lietot\u0101ja uzdevumi var smagi ietekm\u0113t <b>veiktsp\u0113ju<\/b>.<\/p><\/blockquote>\n<p><\/p>\n<h2>Sol 5: P\u0101rdom\u0101ta denormaliz\u0101cija<\/h2>\n<p>\nAbas m\u016bsu probl\u0113mas var\u0113s atrisin\u0101t papildus tabulas, kur\u0101s m\u0113s <b>dubul\u0113sim da\u013cu datu<\/b>, kas nepiecie\u0161ami, lai uz t\u0101m veidotu atbilsto\u0161us m\u016bsu uzdevumiem indeksus.<br \/>\n<img decoding=\"async\" alt=\"Zi\u0146u b\u0101ze (1. da\u013ca): b\u0101zes karkasa projekt\u0113\u0161ana\" src=\"\/wp-content\/uploads\/2020\/01\/f136a9904518b05bca74cc2b9c2f01b2.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<b class=\"spoiler_title\">Tabulas : RU<\/b><\/p>\n<pre><code class=\"sql\">CREATE TABLE \"Zi\u0146ojumuRe\u0123istrs\"(\n  \"\u012apa\u0161nieks\"\n    uuid\n, \"Re\u0123istraTips\"\n    smallint\n, \"DatumsLaiks\"\n    timestamp\n, \"Zi\u0146ojums\"\n    uuid\n, PRIMARY KEY(\"\u012apa\u0161nieks\", \"Re\u0123istraTips\", \"Zi\u0146ojums\")\n);\nCREATE INDEX ON \"Zi\u0146ojumuRe\u0123istrs\"(\"\u012apa\u0161nieks\", \"Re\u0123istraTips\", \"DatumsLaiks\" DESC);\n\nCREATE TABLE \"T\u0113masDal\u012bbnieks\"(\n  \"T\u0113ma\"\n    uuid\n, \"Persona\"\n    uuid\n, PRIMARY KEY(\"T\u0113ma\", \"Persona\")\n);<\/code><\/pre>\n<p>\n<b class=\"spoiler_title\">Tabulas : EN<\/b><\/p>\n<pre><code class=\"sql\">CREATE TABLE message_registry(\n  owner\n    uuid\n, registry\n    smallint\n, dt\n    timestamp\n, message\n    uuid\n, PRIMARY KEY(owner, registry, message)\n);\nCREATE INDEX ON message_registry(owner, registry, dt DESC);\n\nCREATE TABLE theme_participant(\n  theme\n    uuid\n, person\n    uuid\n, PRIMARY KEY(theme, person)\n);<\/code><\/pre>\n<p>\n\u0160eit m\u0113s izmantojam divus tipiskus pieejas, kas tiek pielietotas pal\u012bgtabulu izveid\u0113:<\/p>\n<ul>\n<li><b>Ierakstu pavairo\u0161ana<\/b><br \/>\nIzveidojam no vienas s\u0101kotn\u0113j\u0101s zi\u0146ojuma ieraksta vair\u0101kas sekojo\u0161as ierakstu formas da\u017e\u0101diem \u012bpa\u0161niekiem \u2014 gan s\u016bt\u012bt\u0101jam, gan sa\u0146\u0113m\u0113jam. Bet tagad katrs no re\u0123istriem atbilst indeksam \u2014 jo tipisk\u0101 gad\u012bjum\u0101 m\u0113s v\u0113lamies redz\u0113t tikai pirmo lapu.<\/li>\n<li><b>Ierakstu unikiz\u0101cija<\/b><br \/>\nKatru reizi, kad tiek nos\u016bt\u012bts zi\u0146ojums konkr\u0113t\u0101 t\u0113m\u0101, pietiek p\u0101rbaud\u012bt, vai jau ir t\u0101ds ieraksts. Ja nav \u2014 pievienojam to m\u016bsu \"v\u0101rdn\u012bcai\".<\/li>\n<\/ul>\n<p>\nN\u0101kamaj\u0101 raksta da\u013c\u0101 tiks run\u0101ts par <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/483170\/\">sekciju ievie\u0161anu<\/a><\/noindex> m\u016bsu datu b\u0101zes strukt\u016br\u0101.<br \/>\n<br \/>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/483176\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u043f\u0435\u0440\u0435\u0432\u0435\u0441\u0442\u0438 \u0431\u0438\u0437\u043d\u0435\u0441-\u0442\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u044f \u0432 \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u00ab\u0441 \u043d\u0443\u043b\u044f\u00bb \u0431\u0430\u0437\u044b \u0434\u043b\u044f \u043c\u0435\u0441\u0441\u0435\u043d\u0434\u0436\u0435\u0440\u0430. \u0427\u0430\u0441\u0442\u044c 1: \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u0443\u0435\u043c \u043a\u0430\u0440\u043a\u0430\u0441 \u0431\u0430\u0437\u044b \u0427\u0430\u0441\u0442\u044c 2: \u0441\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u0443\u0435\u043c \u00ab\u043d\u0430\u0436\u0438\u0432\u0443\u044e\u00bb \u041d\u0430\u0448\u0430 \u0431\u0430\u0437\u0430 \u0431\u0443\u0434\u0435\u0442 \u043d\u0435 \u0442\u0430\u043a\u043e\u0439 \u043c\u0430\u0441\u0448\u0442\u0430\u0431\u043d\u043e\u0439 \u0438 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u043e\u0439, \u043a\u0430\u043a \u0443 \u0412\u041a\u043e\u043d\u0442\u0430\u043a\u0442\u0435 \u0438\u043b\u0438 Badoo, \u0430 \u00ab\u0447\u0442\u043e\u0431\u044b \u0431\u044b\u043b\u043e\u00bb, \u043d\u043e \u0431\u044b\u043b\u043e \u0445\u043e\u0440\u043e\u0448\u043e \u2014 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e, \u0431\u044b\u0441\u0442\u0440\u043e \u0438 \u0443\u043c\u0435\u0449\u0430\u043b\u043e\u0441\u044c \u043d\u0430 \u043e\u0434\u043d\u043e\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0435 PostgreSQL \u2014 \u0447\u0442\u043e\u0431\u044b [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-55011","post","type-post","status-publish","format-standard","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u043f\u0435\u0440\u0435\u0432\u0435\u0441\u0442\u0438 \u0431\u0438\u0437\u043d\u0435\u0441-\u0442\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u044f \u0432 \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u00ab\u0441 \u043d\u0443\u043b\u044f\u00bb \u0431\u0430\u0437\u044b \u0434\u043b\u044f \u043c\u0435\u0441\u0441\u0435\u043d\u0434\u0436\u0435\u0440\u0430. \u0427\u0430\u0441\u0442\u044c 1: \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u0443\u0435\u043c \u043a\u0430\u0440\u043a\u0430\u0441 \u0431\u0430\u0437\u044b\" \/>\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\/lv\/blog\/administrirovanie\/bd-messendzhera-ch-1-proektiruem-karkas-bazy\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\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\u0411\u0414 \u043c\u0435\u0441\u0441\u0435\u043d\u0434\u0436\u0435\u0440\u0430 (\u0447.1): \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u0443\u0435\u043c \u043a\u0430\u0440\u043a\u0430\u0441 \u0431\u0430\u0437\u044b | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u043f\u0435\u0440\u0435\u0432\u0435\u0441\u0442\u0438 \u0431\u0438\u0437\u043d\u0435\u0441-\u0442\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u044f \u0432 \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u00ab\u0441 \u043d\u0443\u043b\u044f\u00bb \u0431\u0430\u0437\u044b \u0434\u043b\u044f \u043c\u0435\u0441\u0441\u0435\u043d\u0434\u0436\u0435\u0440\u0430. \u0427\u0430\u0441\u0442\u044c 1: \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u0443\u0435\u043c \u043a\u0430\u0440\u043a\u0430\u0441 \u0431\u0430\u0437\u044b\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/bd-messendzhera-ch-1-proektiruem-karkas-bazy\" \/>\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-01-09T21:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-02-18T11:03:05+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\udd47Zin\u0101\u0161anu b\u0101ze (1. da\u013ca): projekt\u0113jam datu b\u0101zes strukt\u016bru | ProHoster","description":"K\u0101 var p\u0101rv\u0113rst biznesa pras\u012bbas konkr\u0113t\u0101s datu strukt\u016br\u0101s, \u0146emot par piem\u0113ru b\u0101zes projekt\u0113\u0161anu \"no nulles\" zi\u0146ojumapmai\u0146as sist\u0113mai. 1. da\u013ca: projekt\u0113jam b\u0101zes karkasu","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/bd-messendzhera-ch-1-proektiruem-karkas-bazy","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","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\u0411\u0414 \u043c\u0435\u0441\u0441\u0435\u043d\u0434\u0436\u0435\u0440\u0430 (\u0447.1): \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u0443\u0435\u043c \u043a\u0430\u0440\u043a\u0430\u0441 \u0431\u0430\u0437\u044b | ProHoster","og:description":"\u041a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u043f\u0435\u0440\u0435\u0432\u0435\u0441\u0442\u0438 \u0431\u0438\u0437\u043d\u0435\u0441-\u0442\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u044f \u0432 \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u00ab\u0441 \u043d\u0443\u043b\u044f\u00bb \u0431\u0430\u0437\u044b \u0434\u043b\u044f \u043c\u0435\u0441\u0441\u0435\u043d\u0434\u0436\u0435\u0440\u0430. \u0427\u0430\u0441\u0442\u044c 1: \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u0443\u0435\u043c \u043a\u0430\u0440\u043a\u0430\u0441 \u0431\u0430\u0437\u044b","og:url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/bd-messendzhera-ch-1-proektiruem-karkas-bazy","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-01-09T21:00:00+00:00","article:modified_time":"2020-02-18T11:03:05+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"55011","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":"2026-01-24 13:30:15","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 17:27:13","updated":"2026-01-24 13:30:15","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/55011","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=55011"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/55011\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=55011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=55011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=55011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}