OLAP technology yog dab tsi?
OLAP technology yog dab tsi?

Video: OLAP technology yog dab tsi?

Video: OLAP technology yog dab tsi?
Video: Hmong new song 2016 - Yog dab tsi - Xub Hluav Taws (Official MV) 2024, Hlis ntuj nqeg
Anonim

OLAP (Online Analytical Processing) yog qhov tshuab tom qab ntau daim ntawv thov Kev Txawj Ntse (BI). OLAP yog tus muaj zog tshuab rau kev tshawb pom cov ntaub ntawv, suav nrog kev muaj peev xwm rau kev saib daim ntawv ceeb toom tsis pub dhau, kev txheeb xyuas nyuaj, thiab kwv yees "dab tsi yog" qhov xwm txheej (pob nyiaj, kev kwv yees) kev npaj.

Ib yam li ntawd, nws raug nug, OLAP piv txwv yog dab tsi?

OLAP Cube txhais. Ib OLAP Lub voos xwmfab yog cov qauv ntaub ntawv uas tso cai rau kev soj ntsuam ceev ntawm cov ntaub ntawv raws li ntau qhov Dimensions uas txhais cov teeb meem kev lag luam. Lub voos xwmfab multidimensional rau kev tshaj tawm kev muag khoom yuav yog, rau piv txwv , muaj li ntawm 7 Dimensions: Tus Neeg Muag Khoom, Tus Nqi Muag Khoom, Thaj Chaw, Khoom Muag, Thaj Chaw, Lub Hlis, Xyoo.

Kuj Paub, OLAP yog dab tsi thiab nws hom? OLAP yog ib lub tshuab uas tso cai rau cov kws tshuaj ntsuam kom rho tawm thiab saib cov ntaub ntawv ua lag luam los ntawm cov ntsiab lus sib txawv. Muaj thawj tsib hom ntawm kev ua haujlwm analytical hauv OLAP 1) Npog-up 2) Drill-down 3) Slice 4) tsuav thiab 5) Pivot. Peb hom ntawm dav siv OLAP systems yog MOLAP, ROLAP, thiab Hybrid OLAP.

Ib yam li ib tug yuav nug, OLAP lub hom phiaj yog dab tsi?

OLAP (online analytical processing) yog ib txoj hauv kev suav uas ua rau cov neeg siv tau yooj yim thiab xaiv rho tawm thiab nug cov ntaub ntawv txhawm rau txheeb xyuas nws los ntawm cov ntsiab lus sib txawv.

OLAP qauv yog dab tsi?

Online Analytical Processing Server ( OLAP ) yog raws li cov ntaub ntawv multidimensional qauv . Nws tso cai rau cov thawj coj, thiab cov kws tshuaj ntsuam kom tau txais kev nkag siab ntawm cov ntaub ntawv los ntawm kev ceev, zoo ib yam, thiab sib tham sib nkag mus rau cov ntaub ntawv.

Pom zoo: