Dab tsi yog cov ntaub ntawv staging hauv kev lag luam txawj ntse?
Dab tsi yog cov ntaub ntawv staging hauv kev lag luam txawj ntse?

Video: Dab tsi yog cov ntaub ntawv staging hauv kev lag luam txawj ntse?

Video: Dab tsi yog cov ntaub ntawv staging hauv kev lag luam txawj ntse?
Video: Larva to adult: 金魚の発生学実験#04: 仔魚から成魚へ Ver.2022 0605-GF04 2024, Kaum ib hlis
Anonim

A data theem cheeb tsam (DSA) yog thaj chaw cia ib ntus nruab nrab ntawm cov cov ntaub ntawv qhov chaw thiab a cov ntaub ntawv lub tsev khaws khoom. Cov theem cheeb tsam yog tsuas yog siv los sai sai extract cov ntaub ntawv los ntawm nws cov ntaub ntawv qhov chaw, txo qhov cuam tshuam ntawm qhov chaw. In TX data theem cheeb tsam yog siv raws li ib tug Staging Database muaj los ntawm a Kev lag luam Unit khoom.

Yog li ntawd, nws txhais li cas rau theem cov ntaub ntawv?

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.

Ib yam li ntawd, vim li cas peb thiaj xav tau lub rooj sib tham? Staging thaj chaw yog qhov chaw koj tuav ib ntus rooj ntawm cov ntaub ntawv warehouse server. 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.

Tom qab ntawd, lo lus nug yog, dab tsi yog staging hauv database?

A theem database yog siv los ua "chaw ua haujlwm" rau koj ETL. Olaf muaj lub ntsiab lus zoo: A theem database los yog cheeb tsam yog siv los thauj cov ntaub ntawv los ntawm qhov chaw, hloov kho & ntxuav lawv ua ntej koj zaum kawg thauj lawv rau hauv DWH; Feem ntau qhov no yog qhov yooj yim dua los ua qhov no hauv ib txheej txheem ETL.

Dab tsi yog staging database hauv SQL Server?

SQL Server Parallel Data Warehouse (PDW) siv a chaw 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: