DBMS vs Database
Ib qho system npaj rau kev teeb tsa yooj yim, khaws cia thiab khaws cov ntaub ntawv ntau, hu ua database. Hauv lwm lo lus, ib lub chaw khaws ntaub ntawv tuav cov ntaub ntawv tsim nyog (feem ntau hauv daim ntawv digital) rau ib lossis ntau tus neeg siv. Databases, feem ntau abbreviated DB, raug cais raws li lawv cov ntsiab lus, xws li cov ntaub ntawv-ntawv nyeem, phau ntawv thiab cov ntaub ntawv txheeb cais. Tab sis, DBMS (Database Management System) yog tag nrho cov kab ke siv los tswj cov ntaub ntawv digital uas tso cai rau khaws cov ntsiab lus ntawm cov ntaub ntawv, tsim / tu cov ntaub ntawv, tshawb nrhiav thiab lwm yam haujlwm. Nyob rau hauv lub ntiaj teb niaj hnub no cov ntaub ntawv nws tus kheej tsis muaj txiaj ntsig yog tias tsis muaj DBMS cuam tshuam nrog nws rau kev nkag mus rau nws cov ntaub ntawv. Tab sis, nce ntxiv, lo lus Database yog siv los ua luv luv rau Database Management System.
Database
A Database tej zaum yuav muaj ntau theem ntawm abstraction hauv nws cov architecture. Feem ntau, peb theem: sab nraud, tswv yim thiab sab hauv tsim cov database architecture. Sab nraud theem txhais tau li cas cov neeg siv saib cov ntaub ntawv. Ib lub database tuaj yeem muaj ntau qhov kev pom. Cov theem sab hauv txhais tau li cas cov ntaub ntawv khaws cia hauv lub cev. Lub tswv yim theem yog kev sib txuas lus nruab nrab ntawm cov theem sab hauv thiab sab nraud. Nws muab qhov tshwj xeeb saib ntawm cov ntaub ntawv tsis hais nws yuav khaws lossis saib li cas. Muaj ntau ntau hom databases xws li Analytical databases, Data warehouses and Distributed databases. Cov ntaub ntawv (ntau dua, cov ntaub ntawv sib raug zoo) yog tsim los ntawm cov ntxhuav thiab lawv muaj kab thiab kab, zoo li cov ntawv nthuav dav hauv Excel. Txhua kab sib raug rau tus cwj pwm thaum txhua kab sawv cev rau ib cov ntaub ntawv. Piv txwv li, hauv cov ntaub ntawv khaws cia cov neeg ua haujlwm cov ntaub ntawv ntawm lub tuam txhab, cov kab ntawv tuaj yeem muaj cov neeg ua haujlwm npe, tus neeg ua haujlwm ID thiab nyiaj hli, thaum ib kab sawv cev rau ib tus neeg ua haujlwm.
DBMS
DBMS, qee zaum tsuas yog hu ua tus thawj tswj hwm database, yog ib qho kev sau ntawm cov khoos phis tawj uas tau mob siab rau kev tswj hwm (piv txwv li lub koom haum, khaws cia thiab rov qab) ntawm tag nrho cov databases uas tau teeb tsa hauv qhov system (piv txwv li hard drive lossis network). Muaj ntau hom Database Management Systems uas twb muaj lawm nyob rau hauv lub ntiaj teb no, thiab ib co ntawm lawv yog tsim los rau kev tswj kom zoo databases configured rau tej lub hom phiaj. Cov lag luam nrov tshaj plaws Database Management Systems yog Oracle, DB2 thiab Microsoft Access. Tag nrho cov khoom no muab kev faib tawm ntawm ntau theem ntawm cov cai rau cov neeg siv sib txawv, ua rau nws muaj peev xwm rau DBMS los tswj hwm hauv nruab nrab los ntawm ib tus thawj coj lossis muab faib rau ntau tus neeg sib txawv. Muaj plaub lub ntsiab lus tseem ceeb nyob rau hauv ib qho Database Management System. Lawv yog cov qauv lus, cov qauv ntaub ntawv, lus nug thiab cov txheej txheem rau kev lag luam. Cov qauv qauv txhais cov lus ntawm txhua qhov chaw khaws cia hauv DBMS. Tam sim no ntau txoj hauv kev nrov xws li hierarchal, network, kev sib raug zoo thiab cov khoom siv hauv kev xyaum. Cov txheej txheem cov ntaub ntawv pab npaj cov ntaub ntawv xws li cov ntaub ntawv tus kheej, cov ntaub ntawv, cov teb thiab lawv cov ntsiab lus thiab cov khoom xws li kev tshaj tawm pom. Cov lus nug cov ntaub ntawv tswj kev ruaj ntseg ntawm cov ntaub ntawv los ntawm kev saib xyuas cov ntaub ntawv nkag, nkag mus rau cov neeg siv sib txawv, thiab cov txheej txheem ntxiv cov ntaub ntawv rau hauv lub system. SQL yog ib hom lus nug nrov uas yog siv hauv Relational Database Management Systems. Thaum kawg, cov txheej txheem uas tso cai rau kev lag luam pab sib koom ua ke thiab ntau yam. Cov txheej txheem ntawd yuav ua kom cov ntaub ntawv qub yuav tsis raug hloov kho los ntawm ntau tus neeg siv tib lub sijhawm, yog li khaws cov ntaub ntawv ncaj ncees hauv kev sib tw. Tsis tas li ntawd, DBMSs muab cov ntaub ntawv thaub qab thiab lwm qhov chaw ib yam nkaus.
Qhov txawv ntawm DBMS thiab Database
A database is a collection of organisation data and system that manages a collection of databases is called a Database Management System. Lub database tuav cov ntaub ntawv, teb thiab hlwb ntawm cov ntaub ntawv. DBMS yog cov cuab yeej siv los tswj cov ntaub ntawv hauv cov ntaub ntawv. Txawm li cas los xij, lub sij hawm database yog nce siv raws li shorthand rau Database Management System. Txhawm rau ua kom qhov sib txawv yooj yim, xav txog thiab kev ua haujlwm thiab cov ntaub ntawv tus kheej khaws cia hauv qhov system. Ib yam li koj xav tau lub operating system nkag mus thiab hloov kho cov ntaub ntawv hauv qhov system, koj xav tau DBMS los tswj cov ntaub ntawv khaws cia hauv qhov system database.
