Dab tsi yog qhov zoo tshaj plaws hauv kev khaws cov ntaub ntawv?
Dab tsi yog qhov zoo tshaj plaws hauv kev khaws cov ntaub ntawv?

Video: Dab tsi yog qhov zoo tshaj plaws hauv kev khaws cov ntaub ntawv?

Video: Dab tsi yog qhov zoo tshaj plaws hauv kev khaws cov ntaub ntawv?
Video: Poj Niam Tsis Zoo Neej Thiaj Tsis Sawv By Pheej Lauj 2022 2024, Hlis ntuj nqeg
Anonim

Sab saum toj - Txoj hauv kev

Cov cov ntaub ntawv warehouse tuav atomic lossis kev lag luam cov ntaub ntawv uas yog muab rho tawm los ntawm ib los yog ntau qhov chaw systems thiab kev koom ua ke nyob rau hauv ib tug normalized, enterprise cov ntaub ntawv qauv. Los ntawm no, lub cov ntaub ntawv yog summarized, dimensionalized, thiab faib rau ib los yog ntau tshaj "dependent" cov ntaub ntawv marts.

Yog li ntawd, dab tsi yog qhov sib txawv ntawm cov ntaub ntawv warehousing?

Hauv qhov nutshell, ntawm no yog ob txoj hauv kev : hauv Bill Inmon's enterprise cov ntaub ntawv warehouse mus kom ze (tus tsim sab saum toj-down), ib tug normalized cov ntaub ntawv qauv yog tsim ua ntej, ces qhov seem cov ntaub ntawv marts, uas muaj cov ntaub ntawv xav tau rau cov txheej txheem kev lag luam tshwj xeeb lossis cov chaw haujlwm tshwj xeeb, yog tsim los ntawm cov cov ntaub ntawv warehouse.

Tom qab ntawd, lo lus nug yog, koj txhais li cas los ntawm cov ntaub ntawv warehousing? A cov ntaub ntawv warehouse yog ib qho kev kawm-oriented, integrated, time-variant thiab non-volatile sau ntawm cov ntaub ntawv nyob rau hauv kev txhawb nqa ntawm kev tswj cov txheej txheem kev txiav txim siab. Kev Kawm Txuj Ci: A cov ntaub ntawv warehouse tuaj yeem siv los txheeb xyuas ib qho kev kawm tshwj xeeb. Piv txwv li, "muag" tuaj yeem yog ib qho kev kawm tshwj xeeb.

Ib yam li ntawd, tib neeg nug, dab tsi yog thawj zaug hauv qab mus kom ze ntawm kev tsim cov ntaub ntawv warehouse?

Raws li Wikipedia, lub tsim methodologies ntawm cov ntaub ntawv warehouses yog: Hauv qab - up tsim : Hauv hauv qab - nce mus kom ze , cov ntaub ntawv marts yog thawj tsim los muab kev tshaj tawm thiab kev tshuaj ntsuam muaj peev xwm rau cov txheej txheem kev lag luam tshwj xeeb. Cov no cov ntaub ntawv marts tuaj yeem ua ke nrog tsim ua tiav cov ntaub ntawv warehouse.

Kimball txoj hauv kev yog dab tsi?

Kimball yog ib tug proponent mus kom ze rau cov ntaub ntawv warehouse tsim tau piav raws li hauv qab-up nyob rau hauv uas seem cov ntaub ntawv marts yog thawj tsim los muab kev qhia thiab analytical muaj peev xwm rau tej lag luam tej chaw xws li "Kev muag khoom" los yog "Production".

Pom zoo: