Dab tsi yog snowflake hauv huab?
Dab tsi yog snowflake hauv huab?

Video: Dab tsi yog snowflake hauv huab?

Video: Dab tsi yog snowflake hauv huab?
Video: Ua Li Ntawv Tsis Yog - David Yang Ft. Keeneng Vang (Official Lyrics Video) 2024, Kaum ib hlis
Anonim

Snowflake yog lub tsev khaws ntaub ntawv txheeb xyuas cov ntaub ntawv muab ua Software-as-a-Service (SaaS). Snowflake cov cov ntaub ntawv warehouse tsis yog tsim los ntawm cov ntaub ntawv uas twb muaj lawm lossis "cov ntaub ntawv loj" software platform xws li Hadoop. Cov Snowflake cov ntaub ntawv warehouse siv SQL database tshiab cav nrog ib tug tshwj xeeb architecture tsim rau lub huab.

Ntxiv mus, snowflake yog dab tsi hauv AWS?

Snowflake ntawm Amazon Web Services ( AWS ) sawv cev rau SQL AWS cov ntaub ntawv warehouse ua rau huab. Snowflake's tshwj xeeb architecture ib txwm lis cov ntaub ntawv sib txawv hauv ib qho system, nrog rau elasticity los txhawb txhua qhov teev ntawm cov ntaub ntawv, kev ua haujlwm, thiab cov neeg siv. Nyeem dab tsi AWS yuav tsum hais txog lawv Snowflake kev sib koom tes ntawm no.

Ib tug kuj yuav nug, dab tsi yog tus tsim tawm snowflake? Snowflake muab builders thiab tus tsim tawm ntawm cov ntaub ntawv-tsav daim ntawv thov cov ntaub ntawv npaj txhij los tsim cov kev daws teeb meem uas ua tau raws li qhov xav tau ntawm cov koom haum niaj hnub no thiab lawv cov neeg siv khoom. Yog li ntawd, koj tuaj yeem ua kom koj cov ntaub ntawv engineering ntau tshaj plaws los ntawm kev tsim thiab xa cov ntaub ntawv-tsav cov khoom thiab cov kev pabcuam.

Xav txog qhov no, dab tsi database yog snowflake?

Nws yog ib qho columnar-kho kev sib raug zoo database thiab ua haujlwm zoo nrog Tableau, Excel thiab ntau lwm yam cuab yeej paub txog cov neeg siv kawg. Snowflake Nws muaj nws tus kheej cov lus nug cov cuab yeej, txhawb lub luag hauj lwm raws li kev ruaj ntseg, ntau nqe lus muas, tag nrho DML, windowing functions thiab txhua yam uas xav tau hauv SQL database.

Snowflake database ua haujlwm li cas?

Snowflake npaj cov ntaub ntawv mus rau hauv ntau lub micro partitions uas yog internally optimized thiab compressed. Nws siv ib hom ntawv columnar khaws cia. Cov ntaub ntawv khaws cia hauv huab cia thiab ua haujlwm raws li tus qauv sib koom-disk li no muab kev yooj yim hauv kev tswj cov ntaub ntawv.

Pom zoo: