Enterprise Data Warehouse EDW architecture yog dab tsi?
Enterprise Data Warehouse EDW architecture yog dab tsi?

Video: Enterprise Data Warehouse EDW architecture yog dab tsi?

Video: Enterprise Data Warehouse EDW architecture yog dab tsi?
Video: What is a Data Warehouse? 2024, Hlis ntuj nqeg
Anonim

Hauv kev suav, a cov ntaub ntawv warehouse (DW lossis DWH), tseem hu ua ib qho Enterprise cov ntaub ntawv warehouse ( EDW ), yog ib qho system siv rau kev tshaj tawm thiab cov ntaub ntawv tsom xam, thiab suav hais tias yog ib feem tseem ceeb ntawm kev txawj ntse ua lag luam. DWs yog lub hauv paus repositories ntawm kev koom ua ke cov ntaub ntawv los ntawm ib lossis ntau qhov chaw sib txawv.

Raws li, kev lag luam cov ntaub ntawv warehouse architecture yog dab tsi?

Ib Enterprise cov ntaub ntawv warehouse yog ib lub koom haum repository rau tag nrho cov tuam txhab lag luam cov ntaub ntawv puas tau tshwm sim hauv lub koom haum. Reflects qhov chaw cov ntaub ntawv . EDW qhov chaw cov ntaub ntawv los ntawm nws thawj qhov chaw cia xws li Google Analytics, CRMs, IoT li, thiab lwm yam. Yog hais tias tus cov ntaub ntawv Nws yog tawg nyob rau hauv ntau lub system, nws unmanageable.

Ib yam li ntawd, database warehouse yog dab tsi? Ib cov ntaub ntawv lub tsev khaws khoom yog kev sib txheeb database uas yog tsim los rau kev nug thiab kev tshuaj xyuas es tsis yog rau kev ua lag luam. Nws feem ntau muaj cov ntaub ntawv keeb kwm muab los ntawm cov ntaub ntawv hloov pauv, tab sis nws tuaj yeem suav nrog cov ntaub ntawv los ntawm lwm qhov chaw.

Xav txog qhov no, qhov txawv ntawm cov ntaub ntawv warehouse thiab enterprise cov ntaub ntawv warehouse yog dab tsi?

Ib Enterprise cov ntaub ntawv warehouse (EDW) feem ntau suav nrog cov ntaub ntawv los ntawm ntau qhov system. Nyiaj txiag, HR, Kev Lag Luam, thiab lwm yam feem ntau pab txhawb cov ntaub ntawv rau EDW. Ib Enterprise cov ntaub ntawv warehouse (EDW) feem ntau suav nrog cov ntaub ntawv los ntawm ntau qhov system. Nyiaj txiag, HR, Kev Lag Luam, thiab lwm yam feem ntau pab txhawb cov ntaub ntawv rau EDW.

Hom kev ua dab tsi tshwm sim hauv lub tsev khaws ntaub ntawv piav qhia?

Extract thiab load lub cov ntaub ntawv . Cleaning thiab transforming lub cov ntaub ntawv . Thaub qab thiab archive lub cov ntaub ntawv . Tswj cov lus nug thiab coj lawv mus rau qhov tsim nyog cov ntaub ntawv qhov chaw.

Pom zoo: