Kev loj hlob ntawm DATA VAULT thiab hloov mus rau BUSINESS DATA VAULT

Hauv tsab xov xwm dhau los, kuv tau tham txog cov hauv paus ntawm DATA VAULT, tau piav qhia txog cov ntsiab lus tseem ceeb ntawm DATA VAULT thiab lawv lub hom phiaj. Qhov no tsis tuaj yeem suav hais tias yog lub ntsiab lus ntawm DATA VAULT uas yog tag nrho; nws yog qhov tsim nyog los tham txog cov kauj ruam tom ntej hauv kev hloov pauv ntawm DATA VAULT.

Thiab hauv tsab xov xwm no kuv yuav tsom mus rau kev txhim kho DATA VAULT thiab kev hloov pauv mus rau BUSINESS DATA VAULT lossis tsuas yog BUSINESS VAULT.

Yog vim li cas rau qhov tshwm sim ntawm BUSINESS DATA VAULT

Nws yuav tsum raug sau tseg tias DATA VAULT, thaum muaj qee qhov muaj zog, tsis yog yam tsis muaj qhov tsis zoo. Ib qho ntawm qhov tsis zoo no yog qhov nyuaj ntawm kev sau cov lus nug analytical. Cov lus nug muaj tus lej tseem ceeb ntawm JOINs, cov lej yog ntev thiab cumbersome. Tsis tas li ntawd, cov ntaub ntawv nkag mus rau DATA VAULT tsis muaj kev hloov pauv, yog li, los ntawm kev ua lag luam ntawm qhov pom, DATA VAULT hauv nws daim ntawv ntshiab tsis muaj nqi kiag li.

Nws yog txhawm rau tshem tawm cov kev tsis txaus no uas DATA VAULT txoj kev nthuav dav nrog cov ntsiab lus xws li:

• PIT (taw tes hauv lub sijhawm) cov rooj;
• BRIDGE rooj;
• PREDEFINED DERIVATIONS.

Cia peb ua tib zoo saib lub hom phiaj ntawm cov ntsiab lus no.

PIT rooj

Feem ntau, ib lub koom haum ua lag luam (HUB) yuav muaj cov ntaub ntawv nrog cov hloov tshiab sib txawv, piv txwv li, yog tias peb tab tom tham txog cov ntaub ntawv qhia tus neeg, peb tuaj yeem hais tias cov ntaub ntawv hais txog tus xov tooj, chaw nyob lossis email muaj tus nqi hloov tshiab dua li hais, lub npe tag nrho, cov ntaub ntawv hla tebchaws, kev txij nkawm lossis poj niam txiv neej.

Yog li ntawd, thaum txiav txim siab satellites, koj yuav tsum nco ntsoov lawv qhov hloov tshiab zaus. Vim li cas thiaj tseem ceeb?

Yog tias koj khaws cov cwj pwm nrog cov nqi hloov tshiab sib txawv hauv tib lub rooj, koj yuav tsum tau ntxiv ib kab rau lub rooj txhua zaus uas feem ntau hloov pauv hloov tshiab. Qhov tshwm sim yog qhov nce ntawm qhov chaw disk thiab nce cov lus nug ua tiav lub sijhawm.

Tam sim no peb tau faib cov satellites los ntawm kev hloov kho zaus, thiab tuaj yeem thauj cov ntaub ntawv rau hauv lawv tus kheej, peb yuav tsum xyuas kom meej tias peb tuaj yeem tau txais cov ntaub ntawv tshiab. Zoo dua, tsis tas siv JOINs tsis tsim nyog.

Cia kuv piav qhia, piv txwv li, koj yuav tsum tau txais tam sim no (raws li hnub hloov tshiab kawg) cov ntaub ntawv los ntawm satellites uas muaj qhov sib txawv hloov tshiab. Txhawm rau ua qhov no, koj yuav xav tau tsis yog los ua JOIN xwb, tab sis kuj tseem tsim ntau cov lus nug nested (rau txhua lub xov tooj cua uas muaj cov ntaub ntawv) nrog rau kev xaiv hnub hloov siab tshaj plaws MAX (Hnub Hloov Kho). Nrog rau txhua qhov JOIN tshiab, cov lej zoo li no loj hlob thiab sai heev ua nyuaj rau kev nkag siab.

Lub rooj PIT yog tsim los ua kom yooj yim cov lus nug; PIT rooj tau sau ib txhij nrog sau cov ntaub ntawv tshiab rau DATA VAULT. PIT rooj:

Yog li, peb muaj cov ntaub ntawv hais txog qhov tseem ceeb ntawm cov ntaub ntawv rau tag nrho cov satellites ntawm txhua lub sijhawm. Siv JOINs mus rau PIT lub rooj, peb tuaj yeem tshem tawm cov lus nug nested, ib txwm nrog cov xwm txheej uas PIT tau sau txhua hnub thiab tsis muaj qhov khoob. Txawm hais tias muaj qhov khoob hauv PIT, koj tuaj yeem tau txais cov ntaub ntawv tshiab tsuas yog siv ib qho lus nug ze rau PIT nws tus kheej. Ib qho nested query yuav ua sai dua nested queries rau txhua satellite.

CUA

BRIDGE cov rooj kuj tseem siv los ua kom yooj yim cov lus nug analytical. Txawm li cas los xij, qhov txawv ntawm PIT yog ib qho kev ua kom yooj yim thiab nrawm ntawm kev thov ntawm ntau lub hubs, txuas thiab lawv cov satellites.

Lub rooj muaj tag nrho cov yuam sij tsim nyog rau txhua lub satellites, uas feem ntau siv rau hauv cov lus nug. Ntxiv rau, yog tias tsim nyog, cov yuam sij lag luam hashed tuaj yeem ntxiv nrog cov yuam sij hauv daim ntawv ntawv yog tias cov npe ntawm cov yuam sij xav tau los tshuaj xyuas.

Qhov tseeb yog tias tsis siv BRIDGE, nyob rau hauv tus txheej txheem ntawm kev txais cov ntaub ntawv nyob rau hauv satellites teej tug mus rau txawv hubs, nws yuav tsum tau ua ib tug JOIN tsis tau tsuas yog ntawm lub satellites lawv tus kheej, tab sis kuj ntawm cov kev sib txuas ntawm cov hubs.

Lub xub ntiag lossis tsis muaj BRIDGE yog txiav txim siab los ntawm qhov chaw cia khoom thiab qhov xav tau los ua kom zoo dua qhov nrawm ntawm kev nug. Nws yog ib qho nyuaj los ua ib qho piv txwv thoob ntiaj teb ntawm BRIGE.

PREDEFINED DERIVATIONS

Lwm hom khoom uas coj peb los ze zog rau BUSINESS DATA VAULT yog cov ntxhuav uas muaj cov ntsuas ntsuas ua ntej. Cov ntxhuav zoo li no tseem ceeb heev rau kev lag luam; lawv muaj cov ntaub ntawv sib sau ua ke raws li cov cai tau muab thiab ua rau nws yooj yim rau kev nkag mus.

Architecturally, PREDEFINED DERIVATIONS tsis muaj dab tsi ntau tshaj li lwm satellite ntawm ib lub hub. Nws, zoo li lub hnub qub niaj hnub, muaj lub lag luam tseem ceeb thiab hnub tsim cov ntaub ntawv hauv satellite. Qhov no yog qhov zoo sib xws, txawm li cas los xij. Qhov sib ntxiv ntawm cov cwj pwm ntawm xws li "tshwj xeeb" satellite yog txiav txim siab los ntawm cov neeg siv kev lag luam raws li qhov nrov tshaj plaws, cov ntsuas ua ntej suav.

Piv txwv li, lub hub uas muaj cov ntaub ntawv hais txog tus neeg ua haujlwm yuav suav nrog satellite nrog cov ntsuas xws li:

• Nyiaj tsawg kawg nkaus;
• Cov nyiaj hli siab tshaj plaws;
• Cov nyiaj hli nruab nrab;
• Sau tag nrho ntawm cov nyiaj tau los, thiab lwm yam.

Nws yog qhov tsim nyog kom suav nrog PREDEFINED DERIVATIONS hauv PIT lub rooj ntawm tib lub hub, tom qab ntawd koj tuaj yeem tau txais cov ntaub ntawv yooj yim rau cov neeg ua haujlwm rau hnub tshwj xeeb.

LUS XAUS

Raws li kev xyaum qhia, kev siv DATA VAULT los ntawm cov neeg siv kev lag luam yog qhov nyuaj rau ntau yam:

• Cov lus nug code yog complex thiab cumbersome;
• Qhov ntau ntawm JOINs cuam tshuam rau kev ua haujlwm ntawm cov lus nug;
• Kev sau cov lus nug analytical xav tau kev paub zoo txog kev tsim khoom cia.

Txhawm rau kom yooj yim nkag tau cov ntaub ntawv, DATA VAULT txuas ntxiv nrog cov khoom ntxiv:

• PIT (taw tes hauv lub sijhawm) cov rooj;
• BRIDGE rooj;
• PREDEFINED DERIVATIONS.

Tom ntej no Tshooj Kuv npaj yuav qhia, hauv kuv lub tswv yim, qhov nthuav tshaj plaws rau cov neeg ua haujlwm nrog BI. Kuv yuav nthuav qhia txoj hauv kev los tsim cov rooj qhov tseeb thiab cov ntxhuav qhov ntev raws li DATA VAULT.

Cov ntaub ntawv ntawm tsab xov xwm yog raws li nram no:

• rau cov ntawv luam tawm Kenta Graziano, uas, ntxiv rau cov lus piav qhia ntxaws, muaj cov duab kos duab;
• Phau ntawv: "Tsim ib lub Scalable Data Warehouse nrog DATA VAULT 2.0";
• Tshooj lus Data Vault Basics.

Tau qhov twg los: www.hab.com