{"id":84225,"date":"2020-06-06T07:42:14","date_gmt":"2020-06-06T05:42:14","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/vitriny-dannyh-data-vault"},"modified":"2020-06-06T07:42:14","modified_gmt":"2020-06-06T05:42:14","slug":"vitriny-dannyh-data-vault","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/vitriny-dannyh-data-vault","title":{"rendered":"Andmevitriinid DATA VAULT","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Eelmistes <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/users\/asenterprise\/posts\/\">artiklites<\/a><\/noindex>, tutvustasime DATA VAULT'i aluseid, DATA VAULT'i laiendamist anal\u00fc\u00fcsile sobivasse seisundisse ja BUSINESS DATA VAULT'i loomist. On aeg l\u00f5petada sari kolmanda artikliga.<\/p>\n<p>Nagu ma eelnevas mainisin <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/504214\/\">v\u00e4ljaandmise<\/a><\/noindex>, on see artikkel p\u00fchendatud BI teemale, t\u00e4psemalt DATA VAULT'i ettevalmistamisele BI andmeallikana. Vaatame, kuidas luua faktide ja m\u00f5\u00f5tmete tabelid ning seel\u00e4bi luua t\u00e4he skeem.<\/p>\n<p>Kui ma alustasin ingliskeelsete materjalide uurimist DATA VAULT'i andmevitriinide loomisest, tekkis mul tunne, et protsess on piisavalt keeruline. Kuna artiklid on mahukad, sisaldavad nad viiteid terminoloogilistele muudatustele, mis on tekkinud Data Vault 2.0 metoodikas, ja r\u00f5hutavad nende m\u00e4\u00e4ratlemise t\u00e4htsust. <\/p>\n<p>Kuid s\u00fcvenedes t\u00f5lkesse, sai selgeks, et see protsess pole sugugi nii keeruline. Kuid v\u00f5ib-olla teil kujuneb v\u00e4lja teine arvamus.<\/p>\n<p>Nii et liigutame edasi tuumani.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h3>M\u00f5\u00f5tmete ja faktide tabelid DATA VAULT'is<\/h3>\n<p>\nK\u00f5ige keerulisem arusaamine on j\u00e4rgmine:<\/p>\n<ul>\n<li>M\u00f5\u00f5tmete tabelid on rajatud hubide ja nende satelliitide teabele;<\/li>\n<li>Faktide tabelid on rajatud linkide ja nende satelliitide teabele.<\/li>\n<\/ul>\n<p>\nJa see on ilmne p\u00e4rast artikli lugemist <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/502968\/\">DATA VAULT'i alustest<\/a><\/noindex>. Hubid salvestavad ainulaadsed v\u00f5tmed \u00e4riesemetest, nende sateellid sisaldavad \u00e4riesemete atribuutide seisundeid, mis on ajaga seotud; linkidega seotud satelliidid, mis toetavad tehingute salvestamist, salvestavad nende tehingute numbrilised omadused.<\/p>\n<p>Teooria sellega p\u00f5him\u00f5tteliselt l\u00f5ppeb.<\/p>\n<p>Kuid siiski arvan, et on oluline m\u00e4rkida paar m\u00f5istet, mis v\u00f5ivad esineda DATA VAULT'i metoodikat k\u00e4sitlevates artiklites:<\/p>\n<ul>\n<li>Raw Data Marts \u2013 \u201etoore\u201c andmete vitriinid;<\/li>\n<li>Information Marts \u2013 teavevitriinid.<\/li>\n<\/ul>\n<p>\nM\u00f5isted \u201eRaw Data Marts\u201c t\u00e4hendavad vitriine, mis on rajatud DATA VAULT'i andmetele, sooritades piisavalt lihtsaid JOIN'e. \u201eRaw Data Marts\u201c l\u00e4henemine v\u00f5imaldab paindlikult ja kiiresti laiendada andmeladu anal\u00fc\u00fcsiks sobiva teabega. Selline l\u00e4henemine ei eelda keeruliste andmete transformatsioonide ning \u00e4rireeglite t\u00e4itmist enne vitriini paigutamist, kuid andmed \u201eRaw Data Marts'is\u201c peavad olema \u00e4rikasutajale arusaadavad ja luua aluse edasiseks t\u00f6\u00f6tlemiseks, n\u00e4iteks BI t\u00f6\u00f6riistadega.<\/p>\n<p>M\u00f5isted \u201cInformation Marts\u201d tuli esile Data Vault 2.0 metodoloogias, asendades vana m\u00f5iste \u201cData Marts\u201d. See muudatus tuleneb arusaamast, et andmemudeli elluviimise eesm\u00e4rk aruannete koostamiseks on andmete muutmine informatsiooniks. \u201cInformation Marts\u201d schema peaks esmaj\u00e4rjekorras tagama, et ettev\u00f5ttel on otsuste tegemiseks sobiv teave.<\/p>\n<p>Piisavalt s\u00f5naselged m\u00e4\u00e4ratlused peegeldavad kahte lihtsat fakti:<\/p>\n<ol>\n<li>T\u00fc\u00fcpi \u201cRaw Data Marts\u201d vitriinid p\u00f5hinevad toorandmete (RAW) DATA VAULT'il, andmesalvestusel, mis sisaldab ainult baasm\u00f5isted: HUBS, LINKS, SATELLITES;<\/li>\n<li>Vitriinid \u201cInformation Marts\u201d ehitatakse kasutades BUSINESS VAULT elemente: PIT, BRIDGE.<\/li>\n<\/ol>\n<p>\nKui vaatame n\u00e4iteks t\u00f6\u00f6taja teabe salvestamise n\u00e4iteid, siis v\u00f5ib \u00f6elda, et vitriin, mis n\u00e4itab t\u00f6\u00f6taja praegust (t\u00e4nast) telefoninumbrit \u2014 see on t\u00fc\u00fcp \u201cRaw Data Marts\u201d vitriin. Sellise vitriini loomiseks kasutatakse t\u00f6\u00f6taja \u00e4ri v\u00f5tme ja funktsiooni MAX(), mis on rakendatud satelliidi laadimise kuup\u00e4evale (MAX(SatLoadDate)). Kui on vajalik s\u00e4ilitada ajaloo muutus vitriinis \u2014 on oluline m\u00f5ista, kui kaua telefon oli kehtiv, selle tabeli peamiseks v\u00f5tmekomponendiks on \u00e4ri v\u00f5ti koos laadimiskuup\u00e4evaga satelliidis, samuti lisatakse kehtivuse l\u00f5ppkuup\u00e4ev.<\/p>\n<p>Vitriini loomine, mis salvestab iga atribuudiga seotud mitme satelliidi ajakohast teavet, n\u00e4iteks telefoninumber, aadress, nimi, eeldab PIT tabeli kasutamist, mille kaudu on lihtne saada k\u00f5ik kehtivuse kuup\u00e4evad. Selliseid vitriine peetakse \u201cInformation Marts\u201d t\u00fc\u00fcpi vitriinideks.<\/p>\n<p>M\u00f5lemad l\u00e4henemisviisid on asjakohased nii m\u00f5\u00f5tmete kui ka faktide jaoks. <\/p>\n<p>Mitme linkide ja hubide teabe salvestamiseks m\u00f5eldud vitriinide loomiseks v\u00f5ib kasutada BRIDGE tabelite abil.<\/p>\n<p>Selle artikliga l\u00f5petan DATA VAULT kontseptsiooni ts\u00fckli, loodan, et jagatud teave on kasulik teie projektide elluviimisel.<\/p>\n<p>Nagu alati, l\u00f5puks, m\u00f5ned kasulikud lingid:<\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.vertabelo.com\/blog\/data-vault-series-building-an-information-mart-with-your-data-vault\/\">Artikkel<\/a><\/noindex> Kent Graziiano, millel on lisaks detailsele kirjeldamisele ka mudeli skeemid;<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>Raamat: \u201cBuilding a Scalable Data Warehouse with DATA VAULT 2.0\u201d;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/502968\/\">Artikkel \u201cData Vault\u2019i p\u00f5him\u00f5tted\u201d<\/a><\/noindex>;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/504214\/\">Artikkel \u201cDATA VAULT\u2019i areng ja \u00fcleminek BUSINESS DATA VAULT\u2019ile\u201d<\/a><\/noindex>.<\/li>\n<\/ul>\n<p>Allikas: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/505292\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0412 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0438\u0445 \u0441\u0442\u0430\u0442\u044c\u044f\u0445, \u043c\u044b \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u043b\u0438\u0441\u044c \u0441 \u043e\u0441\u043d\u043e\u0432\u0430\u043c\u0438 DATA VAULT, \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435\u043c DATA VAULT \u0434\u043e \u0431\u043e\u043b\u0435\u0435 \u043f\u043e\u0434\u0445\u043e\u0434\u044f\u0449\u0435\u0433\u043e \u0434\u043b\u044f \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u044f \u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435\u043c BUSINESS DATA VAULT. \u041d\u0430\u0441\u0442\u0430\u043b\u043e \u0432\u0440\u0435\u043c\u044f \u0437\u0430\u0432\u0435\u0440\u0448\u0430\u0442\u044c \u0441\u0435\u0440\u0438\u044e \u0442\u0440\u0435\u0442\u044c\u0435\u0439 \u0441\u0442\u0430\u0442\u044c\u0435\u0439. \u041a\u0430\u043a \u044f \u0430\u043d\u043e\u043d\u0441\u0438\u0440\u043e\u0432\u0430\u043b \u0432 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u0439 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438, \u044d\u0442\u0430 \u0441\u0442\u0430\u0442\u044c\u044f \u0431\u0443\u0434\u0435\u0442 \u043f\u043e\u0441\u0432\u044f\u0449\u0435\u043d\u0430 \u0442\u0435\u043c\u0435 BI, \u0430 \u0442\u043e\u0447\u043d\u0435\u0435 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0435 DATA VAULT \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f BI. \u0420\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c, \u043a\u0430\u043a \u0441\u043e\u0437\u0434\u0430\u0442\u044c [&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-84225","post","type-post","status-publish","format-standard","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0412 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0438\u0445 \u0441\u0442\u0430\u0442\u044c\u044f\u0445, \u043c\u044b \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u043b\u0438\u0441\u044c \u0441 \u043e\u0441\u043d\u043e\u0432\u0430\u043c\u0438 DATA VAULT, \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435\u043c DATA VAULT \u0434\u043e \u0431\u043e\u043b\u0435\u0435 \u043f\u043e\u0434\u0445\u043e\u0434\u044f\u0449\u0435\u0433\u043e \u0434\u043b\u044f \u0430\u043d\u0430\u043b\u0438\u0437\u0430.\" \/>\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\/et\/blog\/administrirovanie\/vitriny-dannyh-data-vault\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\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\u0412\u0438\u0442\u0440\u0438\u043d\u044b \u0434\u0430\u043d\u043d\u044b\u0445 DATA VAULT | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0412 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0438\u0445 \u0441\u0442\u0430\u0442\u044c\u044f\u0445, \u043c\u044b \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u043b\u0438\u0441\u044c \u0441 \u043e\u0441\u043d\u043e\u0432\u0430\u043c\u0438 DATA VAULT, \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435\u043c DATA VAULT \u0434\u043e \u0431\u043e\u043b\u0435\u0435 \u043f\u043e\u0434\u0445\u043e\u0434\u044f\u0449\u0435\u0433\u043e \u0434\u043b\u044f \u0430\u043d\u0430\u043b\u0438\u0437\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/vitriny-dannyh-data-vault\" \/>\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-06-06T05:42:14+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-06-06T05:42:14+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\udd47Andmete vitriinid DATA VAULT | ProHoster","description":"Eelnevates artiklites oleme tutvunud DATA VAULT\u2019i p\u00f5him\u00f5tetega, DATA VAULT\u2019i laiendamisega anal\u00fc\u00fcsiks sobivamaks.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/vitriny-dannyh-data-vault","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\u0412\u0438\u0442\u0440\u0438\u043d\u044b \u0434\u0430\u043d\u043d\u044b\u0445 DATA VAULT | ProHoster","og:description":"\u0412 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0438\u0445 \u0441\u0442\u0430\u0442\u044c\u044f\u0445, \u043c\u044b \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u043b\u0438\u0441\u044c \u0441 \u043e\u0441\u043d\u043e\u0432\u0430\u043c\u0438 DATA VAULT, \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435\u043c DATA VAULT \u0434\u043e \u0431\u043e\u043b\u0435\u0435 \u043f\u043e\u0434\u0445\u043e\u0434\u044f\u0449\u0435\u0433\u043e \u0434\u043b\u044f \u0430\u043d\u0430\u043b\u0438\u0437\u0430.","og:url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/vitriny-dannyh-data-vault","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-06-06T05:42:14+00:00","article:modified_time":"2020-06-06T05:42:14+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"84225","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 15:02:36","updated":"2022-09-28 01:55:29","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/84225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=84225"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/84225\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=84225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=84225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=84225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}