Imakethe yedatha DATA VAULT

Ngaphambilini izihloko, sibone izisekelo ze-DATHA VAULT, inweba i-DATHA VAULT ibe sesimweni esihlukaniseka kakhudlwana, nokudala I-VAULT YEDATHA YEBHIZINISI. Sekuyisikhathi sokuqeda uchungechunge ngesihloko sesithathu.

Njengoba ngimemezele ngaphambilini izincwadi, lesi sihloko sizogxila esihlokweni se-BI, noma kunalokho ukulungiswa kwe-DATA VAULT njengomthombo wedatha we-BI. Ake sibheke ukuthi angawakha kanjani amathebula eqiniso nobukhulu futhi ngaleyo ndlela sakhe i-schema yenkanyezi.

Ngenkathi ngiqala ukufunda izinto zolimi lwesiNgisi esihlokweni sokudala ama-data mart ngaphezulu kwe-DATA VAULT, ngaba nomuzwa wokuthi le nqubo yayiyinkimbinkimbi. Njengoba ama-athikili enobude obukhulu, kunezinkomba zezinguquko zamagama ezivele ku-Data Vault 2.0 methodology, ukubaluleka kwalawa magama kuyakhonjiswa.

Nokho, ngemva kokuhlolisisa ukuhumusha, kwacaca ukuthi le nqubo ayinzima kangako. Kodwa ungase ube nombono ohlukile.

Ngakho-ke, ake sifinyelele ephuzwini.

Ubukhulu namathebula amaqiniso kokuthi DATA VAULT

Ulwazi olunzima kakhulu ukuliqonda:

• Amathebula okulinganisa akhiwe phezu kolwazi oluvela kuma-hubs namasathelayithi awo;
• Amathebula amaqiniso akhelwe olwazini oluvela kuzixhumanisi namasathelayithi azo.

Futhi lokhu kusobala ngemva kokufunda isihloko mayelana Idatha ye-VAULT eyisisekelo. Amahabhu agcina okhiye abahlukile bezinto zebhizinisi, amasathelayithi awo anesikhathi esifushane esimo sezinto zebhizinisi, amasathelayithi aboshelwe kuzixhumanisi ezisekela imisebenzi agcina izici zezinombolo zalokhu kuthenga.

Yilapho inkolelo-mbono iphela khona.

Kodwa, nokho, ngokubona kwami, kubalulekile ukuqaphela imiqondo embalwa engatholakala ezihlokweni mayelana nendlela ye-DATA VAULT:

• I-Raw Data Marts - imibukiso yedatha "eluhlaza";
• Ulwazi Marts - imibukiso yolwazi.

Umqondo we-"Raw Data Marts" - uchaza ama-marts akhelwe phezu kwedatha ye-VAULT YEDATHA ngokwenza JOIN okulula kakhulu. Indlela ye-“Raw Data Marts” ikuvumela ukuba unwebe kalula futhi ngokushesha iphrojekthi ye-warehouse ngolwazi olufanele ukuhlaziya. Le ndlela ayibandakanyi ukwenza ukuguqulwa kwedatha eyinkimbinkimbi kanye nokusebenzisa imithetho yebhizinisi ngaphambi kokubekwa endaweni yesitolo, nokho, idatha ye-Raw Data Marts kufanele iqondakale kumsebenzisi webhizinisi futhi kufanele isebenze njengesisekelo soshintsho oluqhubekayo, isibonelo, ngamathuluzi e-BI. .

Umqondo othi “Information Marts” uvele ku-Data Vault 2.0 methodology, wathatha indawo yomqondo wakudala we-“Data Marts”. Lolu shintsho lubangelwa ukufezeka komsebenzi wokusebenzisa imodeli yedatha yokubika njengokuguqulwa kwedatha kulwazi. Uhlelo lwe-“Information Marts”, okokuqala nje, kufanele lunikeze ibhizinisi ulwazi olufanele ukwenziwa kwezinqumo.

Kunalokho izincazelo zamagama zibonisa amaqiniso amabili alula:

1. Imibukiso yohlobo lwe-“Raw Data Marts” yakhelwe ku-VAULT (RAW) DATA VAULT, inqolobane equkethe kuphela imiqondo eyisisekelo: HUBS, LINKS, SATELLITES;
2. Imibukiso ethi "Information Marts" yakhiwe kusetshenziswa izici ze-BUSINESS VAULT: PIT, BRIDGE.

Uma siphendukela ezibonelweni zokugcinwa kolwazi olumayelana nomsebenzi, singasho ukuthi indawo yangaphambili yesitolo ebonisa inombolo yocingo yamanje (yamanje) yesisebenzi iyindawo engaphambili yesitolo yohlobo lwe-“Raw Data Marts”. Ukuze wakhe umbukiso onjalo, ukhiye webhizinisi wesisebenzi kanye nomsebenzi othi MAX() osetshenziswe kusibaluli sedethi yokulayisha isathelayithi (MAX(SatLoadDate)) kuyasetshenziswa. Uma kudingeka ukuthi kugcinwe umlando wokushintsha kwesibaluli embukisweni - isetshenziswa, udinga ukuqonda ukuthi ifoni ibuyekezwa kusukela kuyiphi idethi, ukuhlanganiswa kokhiye webhizinisi kanye nedethi yokulayisha isathelayithi. izongeza ukhiye oyinhloko kuthebula elinjalo, inkambu yedethi yokuphela yenkathi yokuqinisekisa nayo yengezwa.

Ukudala indawo yesitolo egcina imininingwane yakamuva yesibaluli ngasinye samasathelayithi amaningana afakwe kuhabhu, isibonelo, inombolo yocingo, ikheli, igama eligcwele, kusikisela ukusetshenziswa kwetafula le-PIT, lapho kulula khona ukufinyelela zonke izinsuku. lokufaneleka. Imibukiso yalolu hlobo ibizwa ngokuthi "Information Marts".

Zombili izindlela zibalulekile kukho kokubili izilinganiso namaqiniso.

Ukwakha izitolo ezigcina ulwazi mayelana nezixhumanisi ezimbalwa namahabhu, ukufinyelela kumathebula e-BRIDGE kungabandakanywa.

Ngalesi sihloko, ngiqedela uchungechunge lomqondo we-DATA VAULT, ngithemba ukuthi ulwazi engihlanganyele nalo luyoba usizo ekusetshenzisweni kwamaphrojekthi akho.

Njengenjwayelo, ekuphetheni, izixhumanisi ezimbalwa eziwusizo:

• Isihloko I-Kenta Graziano, okuyinto, ngaphezu kwencazelo eningiliziwe, iqukethe imidwebo yamamodeli;

• Incwadi: “Ukwakha Indawo Yokugcina Yedatha E-Scalable Nge-DATA VAULT 2.0”;
• I-athikili "Izisekelo Ze-Data Vault";
• I-athikili "Ukuthuthukiswa kwe-DATA VAULT nokushintshela ku-BUSINESS DATA VAULT".

Source: www.habr.com