Koj siv ETL cov ntaub ntawv li cas?
Koj siv ETL cov ntaub ntawv li cas?

Video: Koj siv ETL cov ntaub ntawv li cas?

Video: Koj siv ETL cov ntaub ntawv li cas?
Video: ET Yaj & Sua Ham - Kev Hlub Txiav Tsis Tau 2024, Lub peb hlis ntuj
Anonim

Ib txwm ETL txheej txheem

tus ETL txheej txheem: extract, transform thiab load. Tom qab ntawd txheeb xyuas. Tshem tawm los ntawm cov peev txheej uas khiav koj txoj haujlwm. Cov ntaub ntawv yog muab rho tawm los ntawm kev lag luam hauv online (OLTP) databases, niaj hnub no feem ntau hu ua 'transactional databases', thiab lwm yam. cov ntaub ntawv qhov chaw.

Cov lus nug tseem yog, ETL yog dab tsi thiab nws ua haujlwm li cas?

ETL yog luv luv rau extract, transform, load, peb database functions uas yog ua ke rau hauv ib lub cuab tam los rub cov ntaub ntawv tawm ntawm ib tug database thiab muab tso rau hauv lwm database. Extract yog tus txheej txheem ntawm kev nyeem cov ntaub ntawv los ntawm ib tug database. Kev hloov pauv tshwm sim los ntawm kev siv cov cai lossis saib cov lus lossis los ntawm kev sib txuas cov ntaub ntawv nrog lwm cov ntaub ntawv.

Kuj Paub, ETL yog dab tsi hauv cov ntaub ntawv warehousing? ETL yog ib txoj hauv kev Cov ntaub ntawv khaws cia thiab nws stands rau Extract, Hloov thiab Load. Nws yog ib tug txheej txheem uas ib ETL tool extract cov cov ntaub ntawv los ntawm ntau yam cov ntaub ntawv qhov system, transforms nws nyob rau hauv lub staging cheeb tsam thiab ces thaum kawg, loads nws mus rau hauv lub Data Warehouse qhov system.

Ib yam li ntawd, nws tau nug, ETL txheej txheem piv txwv yog dab tsi?

ETL Nyob rau hauv cov ntaub ntawv warehousing: Feem ntau piv txwv ntawm ETL yog ETL yog siv nyob rau hauv cov ntaub ntawv warehousing. Nws cov ntaub ntawv qhov chaw yuav txawv. Tus neeg siv yuav tsum tau nqa cov ntaub ntawv los ntawm ntau lub tshuab heterogeneous thiab thauj mus rau hauv ib lub hom phiaj uas tseem hu ua cov ntaub ntawv warehouse.

Dab tsi yog cov ntaub ntawv sib txawv rau ETL system?

Feem ntau ETL systems ua ke cov ntaub ntawv los ntawm ntau qhov chaw tshuab , txhua tus nrog nws tus kheej cov ntaub ntawv lub koom haum thiab hom - suav nrog cov ntaub ntawv sib txheeb, cov ntaub ntawv tsis sib xws, XML, JSON, CSV cov ntaub ntawv, thiab lwm yam. cov ntaub ntawv rau hauv ib hom ntawv rau kev ua qauv.

Pom zoo: