Nws txhais li cas rau cov ntaub ntawv theem?
Nws txhais li cas rau cov ntaub ntawv theem?

Video: Nws txhais li cas rau cov ntaub ntawv theem?

Video: Nws txhais li cas rau cov ntaub ntawv theem?
Video: Dab Ntub Hlub - Cheng Xiong Ft. Douachi Yang (Official Music Video) 2024, Kaum ib hlis
Anonim

A theem thaj chaw, lossis thaj chaw tsaws, yog thaj chaw cia nruab nrab siv rau cov ntaub ntawv Kev ua haujlwm thaum lub sijhawm rho tawm, hloov pauv thiab thauj khoom (ETL) txheej txheem. Cov data theem cheeb tsam zaum ntawm lub cov ntaub ntawv source(s) thiab cov ntaub ntawv hom phiaj (s), uas feem ntau cov ntaub ntawv warehouses, cov ntaub ntawv marts, los yog lwm yam cov ntaub ntawv chaw khaws cia.

Tib neeg kuj nug, cov ntaub ntawv staging txhais li cas?

A data theem cheeb tsam (DSA) yog ib ntus cia chaw nruab nrab ntawm lub cov ntaub ntawv qhov chaw thiab a cov ntaub ntawv lub tsev khaws khoom. Cov theem cheeb tsam yog feem ntau yog siv los sai sai extract cov ntaub ntawv los ntawm nws cov ntaub ntawv qhov chaw, txo qhov cuam tshuam ntawm qhov chaw. Hauv TX koj tsis tuaj yeem thauj khoom ncaj qha ntawm cov ntaub ntawv qhov chaw thiab a cov ntaub ntawv lub tsev khaws khoom.

Qhov thib ob, lub rooj sib tham yog dab tsi? staging rooj tsuas yog database rooj muaj koj cov ntaub ntawv ua lag luam nyob rau hauv qee daim ntawv lossis lwm yam. Staging yog cov txheej txheem ntawm kev npaj koj cov ntaub ntawv ua lag luam, feem ntau yog coj los ntawm qee daim ntawv thov kev lag luam. Rau koj qhov nruab nrab BI system koj yuav tsum npaj cov ntaub ntawv ua ntej thauj khoom.

Tsis tas li ntawd, vim li cas peb thiaj xav tau cov rooj sib tham?

Staging rooj txuas nrog rau thaj chaw ua haujlwm lossis qhov tseeb rooj . Peb hauv paus xav tau staging thaj chaw tuav cov ntaub ntawv, thiab ua cov ntaub ntawv ntxuav thiab sib koom ua ke, ua ntej thauj cov ntaub ntawv mus rau hauv lub tsev khaws khoom. Kev ntxuav cov ntaub ntawv, tseem hu ua cov ntaub ntawv scrubbing, yog cov txheej txheem los xyuas kom meej tias cov txheej txheem ntawm cov ntaub ntawv raug thiab raug.

Dab tsi yog staging database hauv SQL Server?

SQL Server Parallel Data Warehouse (PDW) siv a theem database khaws cov ntaub ntawv ib ntus thaum lub sijhawm thauj khoom. Los ntawm lub neej ntawd, SQL Server PDW siv qhov chaw database raws li cov theem database , uas tuaj yeem ua rau lub rooj fragmentation. Txhawm rau txo cov lus fragmentation, koj tuaj yeem tsim tus neeg siv txhais tau tias theem database.

Pom zoo: