OLAP vs OLTP
Ob leeg OLTP thiab OLAP yog ob qho tib si rau kev tswj cov ntaub ntawv. OLTP (Online Transaction Processing) yog ib pawg ntawm cov tshuab uas tswj xyuas kev ua lag luam. OLAP (Online Analytical Processing) raws li lub npe qhia, yog muab tso ua ke ntawm txoj hauv kev los nug cov ntaub ntawv ntau qhov chaw. OLAP yog BI (Business Intelligence) cuab yeej. BI hais txog cov txheej txheem hauv computer los txheeb xyuas thiab rho tawm cov ntaub ntawv tseem ceeb los ntawm cov ntaub ntawv lag luam.
OLAP yog dab tsi?
OLAP yog chav kawm ntawm cov kab ke, uas muab cov lus teb rau ntau cov lus nug. Feem ntau OLAP yog siv rau kev lag luam, kev siv nyiaj txiag, kev kwv yees thiab kev siv zoo sib xws. Nws mus yam tsis tau hais tias cov ntaub ntawv siv rau OLAP tau teeb tsa rau cov lus nug nyuaj thiab ad-hoc nrog kev ua tau zoo hauv siab. Feem ntau cov matrix yog siv los tso saib cov zis ntawm OLAP. Qhov ntev ntawm cov lus nug yog los ntawm tus naj npawb ntawm kab / kab. Lawv feem ntau siv cov kev sib sau ua ke ntawm ntau lub rooj kom tau txais cov ntsiab lus. Piv txwv li, nws tuaj yeem siv los nrhiav kev muag khoom ntawm xyoo no hauv Wal-Mart piv rau xyoo tas los? Dab tsi yog qhov kev kwv yees ntawm kev muag khoom hauv lub quarter tom ntej? Yuav hais li cas txog qhov sib txawv los ntawm saib qhov feem pua ntawm kev hloov pauv?
OLTP yog dab tsi?
OLTP yog ib pawg ntawm cov kab ke uas tau mob siab rau kev tswj cov ntawv thov uas tau taw qhia rau kev lag luam. Lawv pab txhawb cov ntaub ntawv nkag thiab rov qab rau kev ua lag luam. Ntawm no, kev lag luam yuav xa mus rau lub computer lossis database kev lag luam lossis kev lag luam kev lag luam. OLTP systems feem ntau tuaj yeem teb rau cov neeg siv kev thov tam sim. Piv txwv li, ATM (Automatic Teller Machines) yog ib qho piv txwv ntawm kev lag luam kev lag luam. Tsis ntev los no OLTP cov tshuab muaj peev xwm nthuav dav ntau tshaj ib lub tuam txhab thiab tuaj yeem ua haujlwm hauv lub network. Rau cov ntawv thov loj uas khiav OLTP-oriented databases, nws yuav tsum tau siv Transaction Management software systems xws li CICS. Decentralized OLTP databases systems faib cov kev lag luam kom ua tiav rau ntau lub khoos phis tawj ntawm lub network. Feem ntau, SOA (Service-oriented architecture) thiab Web cov kev pabcuam muaj OLTP systems.
Qhov txawv ntawm OLAP thiab OLTP yog dab tsi?
Feem ntau, OLTP cov tshuab muab cov ntaub ntawv rau cov ntaub ntawv khaws cia, thiab OLAP cov tshuab pab txheeb xyuas cov ntaub ntawv. Hauv lwm lo lus, OLTP yog thawj qhov chaw ntawm cov ntaub ntawv thiab OLAP cov ntaub ntawv tau los ntawm ntau yam OLTP databases. OLTP systems yog siv los khiav cov haujlwm tseem ceeb ntawm lub koom haum, thaum OLAP systems siv rau kev npaj thiab daws teeb meem. Qhov ntawd txhais tau hais tias OLTP nthuav tawm cov duab thaij duab ntawm cov txheej txheem kev lag luam tam sim no uas tsis yog OLAP cov tshuab muab kev pom ntau yam ntawm ntau yam dej num. Ntxig thiab hloov tshiab rau OLTP yog luv thiab ceev thiab feem ntau yog pib los ntawm cov neeg siv kawg, thaum tib yam rau OLAP systems yog cov haujlwm ua haujlwm ntev ntev. Ib yam li ntawd, cov lus nug rau OLTP systems yog qhov yooj yim heev thiab feem ntau muab cov txiaj ntsig tau yooj yim uas muaj cov ntaub ntawv tsawg heev. Tab sis, cov lus nug rau OLAP systems yog cov lus nug sib sau ua ke. Kev ua haujlwm ceev ntawm OLTP systems yog ceev heev piv rau OLAP speeds. Feem ntau, OLTP systems muaj qhov chaw me me dua li OLAP systems vim tias lawv muaj cov ntaub ntawv keeb kwm thiab cov qauv sib sau ua ke ntxiv rau cov ntaub ntawv tsis tu ncua.
