Bus matrix data warehouse yog dab tsi?
Bus matrix data warehouse yog dab tsi?

Video: Bus matrix data warehouse yog dab tsi?

Video: Bus matrix data warehouse yog dab tsi?
Video: Cupra Formentor 2021 test drive and launch control in feature film format. Seat Group 2024, Kaum ib hlis
Anonim

Cov Bus Matrix txhais ib feem ntawm cov Data Warehouse Bus Architecture thiab yog ib qho txiaj ntsig ntawm Kev Lag Luam Yuav Tsum Ua Haujlwm hauv Kimball Lifecycle. Nws yog siv nyob rau hauv cov nram qab no theem ntawm dimensional qauv thiab kev loj hlob ntawm lub Data Warehouse.

Kuj paub, dab tsi yog tsheb npav architecture hauv cov ntaub ntawv warehouse?

Cov Data Warehouse Bus Architecture . A bus architecture yog tsim los ntawm cov txheej txheem nruj nruj cov ntaub ntawv marts uas tau txais lawv lub hwj chim los ntawm conformed qhov ntev thiab qhov tseeb rooj. A bus architecture siv cov phiaj xwm sab saum toj-down thiab kab sib chaws ntawm kev ua lag luam thiab qhov ntev kom xa cov txheej txheem nruj nruj cov ntaub ntawv marts.

Tsis tas li ntawd, qhov txawv ntawm Bill Inmon thiab Ralph Kimball txoj hauv kev ntawm cov ntaub ntawv warehouse architecture yog dab tsi? Ob leeg Kimball thiab Inmon's architectures qhia ib yam zoo sib xws uas txhua tus muaj ib qho kev sib koom ua ke ntawm atomic repository cov ntaub ntawv . Hauv Inmon's architecture , nws yog hu ua enterprise cov ntaub ntawv warehouse . Inmon tsuas yog siv cov qauv me me rau cov ntaub ntawv marts tsuas yog thaum Kimball siv nws rau txhua tus cov ntaub ntawv.

Yog li ntawd, cov ntaub ntawv warehouse tsim li cas?

Ntawm nws qhov yooj yim tshaj plaws, cov ntaub ntawv warehouse yog ib qhov system siv rau khaws cia thiab qhia rau cov ntaub ntawv . Cov cov ntaub ntawv feem ntau originates nyob rau hauv ntau lub tshuab, ces nws yog tsiv mus rau hauv lub cov ntaub ntawv warehouse rau lub sij hawm ntev cia thiab tsom xam. Cov ntaub ntawv warehouses ua haujlwm rau tsim ib qho kev sib koom ua ke ntawm qhov tseeb rau tag nrho lub koom haum.

Dab tsi yog dimensional modeling nyob rau hauv cov ntaub ntawv warehouse?

A Dimensional qauv yog ib tug database qauv uas yog optimized rau cov lus nug hauv internet thiab Cov ntaub ntawv khaws cia cuab yeej. Nws yog suav nrog "qhov tseeb" thiab " qhov ntev " tables. A "fact" yog tus lej lej uas tus lag luam xav suav lossis suav. qhov ntev "yog qhov tseem ceeb ntawm qhov nkag mus rau qhov tseeb.

Pom zoo: