Cov txheej txheem:

Vim li cas kem taw qhia cov ntaub ntawv khaws cia ua cov ntaub ntawv nkag ntawm disks sai dua li kab qhia cov ntaub ntawv khaws cia?
Vim li cas kem taw qhia cov ntaub ntawv khaws cia ua cov ntaub ntawv nkag ntawm disks sai dua li kab qhia cov ntaub ntawv khaws cia?

Video: Vim li cas kem taw qhia cov ntaub ntawv khaws cia ua cov ntaub ntawv nkag ntawm disks sai dua li kab qhia cov ntaub ntawv khaws cia?

Video: Vim li cas kem taw qhia cov ntaub ntawv khaws cia ua cov ntaub ntawv nkag ntawm disks sai dua li kab qhia cov ntaub ntawv khaws cia?
Video: Tshuaj theem vim li cas thiaj tau nqi ?/ Siv kho mob dab tsi?/paris polyphylla use for? 2024, Lub peb hlis ntuj
Anonim

Kem taw qhia databases (aka columnar databases) yog ntau haum rau analytical workloads vim lub cov ntaub ntawv hom ntawv ( kem format) qiv nws tus kheej rau sai dua query processing - scans, aggregation thiab lwm yam. Ntawm qhov tod tes, kab oriented databases cia ib leeg kab (thiab tag nrho nws kab ) sib txuas.

Kuj tseem paub yog, vim li cas kab ntawv taw qhia cov ntaub ntawv nrawm dua?

Ib columnar database yog sai dua thiab muaj txiaj ntsig ntau dua li ib txwm muaj database vim cov ntaub ntawv khaws cia yog los ntawm kab tsis yog los ntawm kab. Kem oriented databases muaj sai dua nug kev ua tau zoo vim cov kem tsim kom cov ntaub ntawv los ze zog ua ke, uas txo cov sij hawm nrhiav.

Ib tug kuj yuav nug, dab tsi yog qhov txawv ntawm ib kab oriented thiab ib kab oriented database? Kab oriented databases yog databases uas npaj cov ntaub ntawv los ntawm cov ntaub ntawv, khaws tag nrho cov ntaub ntawv cuam tshuam nrog a sau tseg ib sab hauv nco. Kem oriented databases yog databases uas npaj cov ntaub ntawv los ntawm teb, khaws tag nrho cov ntaub ntawv cuam tshuam nrog a teb ntawm ib sab hauv nco.

Kuj nug, dab tsi yog qhov txiaj ntsig tseem ceeb ntawm kev khaws cov ntaub ntawv hauv kem taw qhia kev cia?

Ua ntej, cia peb tshawb pom qee qhov txiaj ntsig tseem ceeb rau cov kab ntawv taw qhia kab ke:

  • Kev ua tau zoo ntawm cov lus nug sib sau ua ke (xws li COUNT, SUM, AVG, MIN, MAX)
  • Cov ntaub ntawv muaj txiaj ntsig zoo compression thiab / lossis muab faib.
  • Muaj tseeb scalability thiab ceev cov ntaub ntawv loading rau cov ntaub ntawv loj.
  • Siv tau los ntawm ntau yam 3rd party BI analytic tools.

Dab tsi yog columnar databases zoo rau?

Los xaus, columnar databases yog zoo rau : Cov lus nug uas tsuas muaj ob peb kab xwb. Aggregation queries tiv thaiv ntau cov ntaub ntawv. Kem-wise compression.

Pom zoo: