{"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\/ro\/blog\/administrirovanie\/vitriny-dannyh-data-vault","title":{"rendered":"Vitrine de date DATA VAULT","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>\u00cen articolele anterioare <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/users\/asenterprise\/posts\/\">articole<\/a><\/noindex>, ne-am familiarizat cu fundamentele DATA VAULT, extinderea DATA VAULT pentru a fi mai potrivit\u0103 pentru analiz\u0103 \u0219i crearea BUSINESS DATA VAULT. A sosit vremea s\u0103 \u00eencheiem seria cu articolul trei.<\/p>\n<p>A\u0219a cum am anun\u021bat \u00een articolul anterior <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/504214\/\">publica\u021biei<\/a><\/noindex>, acest articol va fi dedicat subiectului BI, mai exact preg\u0103tirii DATA VAULT ca surs\u0103 de date pentru BI. S\u0103 vedem cum putem crea tabele de fapte \u0219i dimensiuni \u0219i, astfel, s\u0103 construim o schem\u0103 stea.<\/p>\n<p>C\u00e2nd am \u00eenceput s\u0103 studiez materialele \u00een limba englez\u0103 despre cum s\u0103 construiesc vitrine de date pe baza DATA VAULT, am avut impresia c\u0103 procesul este suficient de complex. Articolele sunt de volum considerabil, fiind incluse referin\u021be la modific\u0103rile \u00een formul\u0103rile ap\u0103rute \u00een metodologia Data Vault 2.0, care subliniaz\u0103 importan\u021ba acestor formul\u0103ri. <\/p>\n<p>Cu toate acestea, aprofund\u00e2ndu-m\u0103 \u00een traducere, a devenit evident c\u0103 procesul nu este at\u00e2t de complicat. Totu\u0219i, poate c\u0103 ve\u021bi avea o alt\u0103 p\u0103rere.<\/p>\n<p>A\u0219adar, s\u0103 trecem la subiect.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h3>Tabele de dimensiuni \u0219i fapte \u00een DATA VAULT<\/h3>\n<p>\nInforma\u021bia cea mai complicat\u0103 de \u00een\u021beles:<\/p>\n<ul>\n<li>Tabelele de dimensiuni se bazeaz\u0103 pe informa\u021biile hub-urilor \u0219i sateli\u021bilor lor;<\/li>\n<li>Tabelele de fapte se bazeaz\u0103 pe informa\u021biile link-urilor \u0219i sateli\u021bilor lor.<\/li>\n<\/ul>\n<p>\n\u0218i este evident, dup\u0103 citirea articolului despre <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/502968\/\">fundamentele DATA VAULT<\/a><\/noindex>. Hub-urile stocheaz\u0103 cheile unice ale obiectelor de afaceri, sateli\u021bii con\u021bin informa\u021bii despre st\u0103rile atributelor obiectelor de afaceri legate de timp, iar sateli\u021bii lega\u021bi de link-uri care sus\u021bin tranzac\u021bii stocheaz\u0103 caracteristicile numerice ale acestor tranzac\u021bii.<\/p>\n<p>Aceasta este, \u00een principiu, teoria.<\/p>\n<p>Totu\u0219i, cred c\u0103 este necesar s\u0103 subliniem c\u00e2teva concepte care pot ap\u0103rea \u00een articolele despre metodologia DATA VAULT:<\/p>\n<ul>\n<li>Raw Data Marts \u2013 vitrine de \u201edate brute\u201d;<\/li>\n<li>Information Marts \u2013 vitrine informa\u021bionale.<\/li>\n<\/ul>\n<p>\nConceptul de \u201eRaw Data Marts\u201d se refer\u0103 la vitrine construite pe baza datelor din DATA VAULT prin efectuarea de JOIN-uri destul de simple. Abordarea \u201eRaw Data Marts\u201d permite extinderea flexibil\u0103 \u0219i rapid\u0103 a proiectului depozitului cu informa\u021bii adecvate pentru analiz\u0103. Aceast\u0103 abordare nu implic\u0103 efectuarea de transform\u0103ri complexe ale datelor \u0219i aplicarea regulilor de afaceri \u00eenainte de a fi plasate \u00een vitrin\u0103, totu\u0219i, datele din \u201eRaw Data Marts\u201d trebuie s\u0103 fie clare pentru utilizatorii de afaceri \u0219i s\u0103 serveasc\u0103 drept baz\u0103 pentru transformarea ulterioar\u0103, de exemplu, prin instrumente BI.<\/p>\n<p>Conceptul \u201eInformation Marts\u201d a ap\u0103rut \u00een metodologia Data Vault 2.0, \u00eenlocuind vechiul concept de \u201eData Marts\u201d. Aceast\u0103 schimbare se datoreaz\u0103 con\u0219tientiz\u0103rii necesit\u0103\u021bii de a implementa un model de date pentru a transforma datele \u00een informa\u021bii utile pentru rapoarte. Schema \u201eInformation Marts\u201d trebuie, \u00een principal, s\u0103 furnizeze informa\u021bii adecvate pentru luarea deciziilor de afaceri.<\/p>\n<p>Defini\u021biile destul de prolixe reflect\u0103 dou\u0103 fapte simple:<\/p>\n<ol>\n<li>Vitrinele de tip \u201eRaw Data Marts\u201d sunt construite pe RAW DATA VAULT, un depozit care con\u021bine doar conceptele fundamentale: HUBS, LINKS, SATELLITES;<\/li>\n<li>Vitrinele \u201eInformation Marts\u201d sunt construite folosind elemente din BUSINESS VAULT: PIT, BRIDGE.<\/li>\n<\/ol>\n<p>\nReferindu-ne la exemplele de stocare a informa\u021biilor despre angaja\u021bi, putem spune c\u0103 vitrina care reflect\u0103 num\u0103rul de telefon curent (valabil ast\u0103zi) al unui angajat este o vitrin\u0103 de tip \u201eRaw Data Marts\u201d. Pentru a forma o astfel de vitrin\u0103 se utilizeaz\u0103 cheia de business a angajatului \u0219i func\u021bia MAX(), aplicat\u0103 atributului datei de \u00eenc\u0103rcare \u00een satellite (MAX(SatLoadDate)). C\u00e2nd este necesar\u0103 p\u0103strarea istoriei modific\u0103rii atributului \u00een vitrin\u0103 \u2013 trebuie s\u0103 \u00een\u021belegem din ce dat\u0103 p\u00e2n\u0103 la ce dat\u0103 telefonul a fost valabil; cheia principal\u0103 a unei astfel de tabele se formeaz\u0103 din compilarea cheii de business \u0219i a datei de \u00eenc\u0103rcare \u00een satellite, ad\u0103ug\u00e2ndu-se de asemenea un c\u00e2mp pentru data de \u00eencheiere a perioadei de valabilitate.<\/p>\n<p>Crearea unei vitrine care stocheaz\u0103 informa\u021bia actual\u0103 a fiec\u0103rui atribut din mai multe satellite care intr\u0103 \u00een hub, de exemplu, num\u0103rul de telefon, adres\u0103, nume, implic\u0103 utilizarea tabelei PIT, prin intermediul c\u0103reia este u\u0219or de ob\u021binut toate datele de valabilitate. Vitrinele de acest tip sunt considerate \u201eInformation Marts\u201d.<\/p>\n<p>Ambele abord\u0103ri sunt relevante at\u00e2t pentru dimensiuni, c\u00e2t \u0219i pentru fapte. <\/p>\n<p>Pentru a crea vitrine care stocheaz\u0103 informa\u021bia despre mai multe links \u0219i hubs, se poate apela la tabelele BRIDGE.<\/p>\n<p>Prin acest articol, finalizez ciclul despre conceptul DATA VAULT; sper c\u0103 informa\u021bia pe care am \u00eemp\u0103rt\u0103\u0219it-o va fi util\u0103 \u00een implementarea proiectelor dumneavoastr\u0103.<\/p>\n<p>Ca de obicei, la final, c\u00e2teva linkuri utile:<\/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\/\">Articol<\/a><\/noindex> Centa Graziano, care con\u021bine, pe l\u00e2ng\u0103 descrierea detaliat\u0103, schemele modelului;<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>Cartea: \u201eBuilding a Scalable Data Warehouse with DATA VAULT 2.0\u201d;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/502968\/\">Articolul \u201eFundamentele Data Vault\u201d<\/a><\/noindex>;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/504214\/\">Articolul \u201eEvolu\u021bia DATA VAULT \u0219i tranzi\u021bia la BUSINESS DATA VAULT\u201d<\/a><\/noindex>.<\/li>\n<\/ul>\n<p>Sursa: <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.2.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\/ro\/blog\/administrirovanie\/vitriny-dannyh-data-vault\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\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\/ro\/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\udd47Vitrine de date DATA VAULT | ProHoster","description":"\u00cen articolele anterioare, ne-am familiarizat cu fundamentele DATA VAULT, extinderea DATA VAULT pentru a deveni mai potrivit\u0103 pentru analiz\u0103.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/administrirovanie\/vitriny-dannyh-data-vault","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","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\/ro\/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\/ro\/wp-json\/wp\/v2\/posts\/84225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=84225"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/84225\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=84225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=84225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=84225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}