Data marts DATA VAULT

Mune yapfuura zvinyorwa, takaona izvo zvekutanga zveDATA VAULT, kuwedzera DATA VAULT kune imwe nzvimbo inonzwisisika, uye kugadzira BUSINESS DATA VAULT. Yasvika nguva yekupedzisa nhevedzano nechinyorwa chechitatu.

Sezvandakazivisa kare mabhuku, chinyorwa ichi chichatarisa pamusoro weBI, kana kuti panzvimbo yekugadzirira kweDATA VAULT sechinyorwa cheBI. Ngatitarisei maitiro ekugadzira chokwadi uye dimension matafura uye nekudaro gadzira nyeredzi schema.

Pandakatanga kudzidza zvinyorwa zvemutauro weChirungu pamusoro pekugadzira data marts pamusoro peDATA VAULT, ndakave nekunzwa kuti maitiro acho aive akaoma. Sezvo zvinyorwa zvacho zviri zvehurefu hwakakura, kune mareferensi ekuchinja kwemazwi akaonekwa muData Vault 2.0 nzira, kukosha kwemazwi aya kunoratidzwa.

Zvisinei, mushure mekuongorora mushanduro, zvakava pachena kuti iyi nzira haina kunyanya kuoma. Asi unogona kunge uine maonero akasiyana.

Uye saka, ngatisvike pane iyo pfungwa.

Dimension uye chokwadi matafura muDATA VAULT

Ruzivo rwakaoma kunzwisisa:

• Matafura ekuyerwa akavakirwa paruzivo kubva kuhubs nemasatellite avo;
• Matafura echokwadi akavakirwa paruzivo kubva kune zvinongedzo uye masatellite avo.

Uye izvi zviri pachena mushure mekuverenga chinyorwa nezve DATA VAULT zvekutanga. Hubs inochengeta makiyi akasiyana ezviro zvebhizinesi, masatellite avo anosungwa nenguva emamiriro ezvinhu echinhu chebhizinesi, masatelliti akasungirirwa kune zvinongedzo zvinotsigira kutengeserana anochengetedza nhamba dzemabatirwo aya.

Apa ndipo panoperera dzidziso yacho.

Asi, zvakadaro, mumaonero angu, zvinofanirwa kucherechedza akati wandei pfungwa dzinogona kuwanikwa muzvinyorwa nezve iyo DATA VAULT nzira:

• Raw Data Marts - inoratidza ye "raw" data;
• Information Marts - ruzivo showcases.

Pfungwa ye "Raw Data Marts" - inoreva mart akavakirwa pamusoro peDATA VAULT data nekuita zviri nyore JOINs. Iyo "Raw Data Marts" nzira inobvumidza iwe kuchinjika uye nekukurumidza kuwedzera purojekiti yekuchengetera ruzivo ruzivo rwakakodzera kuongororwa. Iyi nzira haisanganisi kuita shanduko yakaoma yedata uye kuita mitemo yebhizinesi isati yaiswa pamberi pechitoro, zvisinei, iyo Raw Data Marts data inofanirwa kunzwisiswa kumushandisi webhizinesi uye inofanirwa kushanda sehwaro hwekumwe shanduko, semuenzaniso, neBI zvishandiso. .

Pfungwa ye "Information Marts" yakaonekwa muData Vault 2.0 methodology, yakatsiva pfungwa yekare ye "Data Marts". Shanduko iyi imhaka yekuzadzikiswa kwebasa rekushandisa muenzaniso wedata rekuzivisa seshanduko yedata kuita ruzivo. Iyo "Information Marts" chirongwa, chekutanga, chinofanira kupa bhizinesi ruzivo rwakakodzera kuita sarudzo.

Asi tsanangudzo dzemazwi dzinoratidza zvinhu zviviri zviri nyore:

1. Zviratidziro zverudzi rwe "Raw Data Marts" zvakavakwa pane mbishi (RAW) DATA VAULT, repository ine chete pfungwa dzinokosha: HUBS, LINKS, SATELLITES;
2. Showcases "Information Marts" inovakwa uchishandisa zvinhu zveBUSINESS VAULT: PIT, BRIDGE.

Kana tikatendeukira kumienzaniso yekuchengetedza ruzivo nezve mushandi, tinogona kutaura kuti chitoro chinoratidza ikozvino (ikozvino) nhamba yefoni yemushandi inzvimbo yechitoro yerudzi rwe "Raw Data Marts". Kugadzira ratidziro yakadai, kiyi yebhizinesi revashandi uye iyo MAX () basa rinoshandiswa pane satellite yekurodha zuva hunhu (MAX(SatLoadDate)) inoshandiswa. Pazvinenge zvichidikanwa kuchengetedza nhoroondo yekushandurwa kwehunhu mune showcase - inoshandiswa, iwe unofanirwa kunzwisisa kuti kubva kupi foni yaive yazvino, kuunganidzwa kwekiyi yebhizinesi uye zuva rekurodha kune satellite. ichawedzera kiyi yekutanga kune tafura yakadaro, munda wekupedzisira wenguva yechokwadi inowedzerwawo.

Kugadzira chitoro chinochengetedza ruzivo rwechizvino-zvino kune yega yega setiraiti akati wandei anosanganisirwa muhubhu, semuenzaniso, nhamba yefoni, kero, zita rakazara, zvinoreva kushandiswa kwePIT tafura, kuburikidza iyo zviri nyore kuwana misi yese. zvine chekuita. Zviratidziro zverudzi urwu zvinonzi "Information Marts".

Maitiro ese ari maviri akakodzera kune ese zviyero uye chokwadi.

Kugadzira zvitoro zvinochengeta ruzivo nezve akati wandei malink uye hubs, kuwana BRIDGE matafura kunogona kubatanidzwa.

Nechinyorwa ichi, ndinopedzisa nhevedzano pane iyo pfungwa yeDATA VAULT, ndinovimba ruzivo rwandakagovera ruchabatsira mukuitwa kwemapurojekiti ako.

Senguva dzose, mukupedzisa, mashoma anobatsira links:

• Chirevo Kenta Graziano, iyo, kuwedzera kune tsanangudzo yakazara, ine mifananidzo yemuenzaniso;

• Bhuku: "Kuvaka Scalable Data Warehouse ine DATA VAULT 2.0";
• Chinyorwa "Data Vault Basics";
• Chinyorwa "Kuvandudzwa kweDATA VAULT uye shanduko kuenda kune BUSINESS DATA VAULT".

Source: www.habr.com