RDBMS vs ORDBMS
A Relational Database Management System (RDBMS) yog Database Management System (DBMS) uas yog raws li tus qauv kev sib raug zoo. DBMSs nrov tshaj plaws tam sim no siv yog RDMSs. Object-Relational database (ORDBMS) kuj yog DBMS uas txuas ntxiv RDBMS los txhawb cov chav kawm dav dua ntawm cov ntawv thov thiab sim tsim tus choj ntawm kev sib raug zoo thiab cov khoom taw qhia.
Raws li tau hais, RDBMS ua ntej yog raws li tus qauv kev sib raug zoo thiab cov ntaub ntawv hauv RDMS tau muab khaws cia rau hauv daim ntawv muaj feem cuam tshuam. Yog li, cov ntaub ntawv sib raug zoo tuaj yeem pom tau yooj yim raws li kev sau ntawm ib lossis ntau qhov kev sib raug zoo lossis cov rooj nrog kab thiab kab. Txhua kem sib raug rau tus cwj pwm ntawm kev sib raug zoo thiab txhua kab sib raug rau cov ntaub ntawv uas muaj cov ntaub ntawv tseem ceeb rau ib qho chaw. RDMSs yog tsim los ntawm kev nthuav dav hierarchical thiab cov qauv hauv network, uas yog ob lub tshuab database yav dhau los. Cov ntsiab lus tseem ceeb ntawm RDMS yog cov ntsiab lus ntawm kev sib raug zoo ntawm kev ncaj ncees thiab normalization. Cov ntsiab lus no yog ua raws li 13 txoj cai rau kev sib raug zoo uas tsim los ntawm Ted Codd. Ua raws li peb lub hauv paus tseem ceeb yuav tsum ua raws li RDMS. Ua ntej, tag nrho cov ntaub ntawv yuav tsum muaj nyob rau hauv daim ntawv ntawm lub rooj. Qhov thib ob, txhua tus nqi pom hauv kab lus yuav tsum tsis txhob rov qab thiab thaum kawg siv Standard Query Language (SQL). Qhov zoo tshaj plaws ntawm RDBMSs yog nws qhov yooj yim rau cov neeg siv los tsim kev nkag mus thiab txuas ntxiv cov ntaub ntawv. Tom qab tsim database, tus neeg siv tuaj yeem ntxiv cov ntaub ntawv tshiab rau hauv cov ntaub ntawv yam tsis tau hloov daim ntawv thov uas twb muaj lawm. Muaj qee qhov kev txwv tseem ceeb hauv RDBMSs kuj. Ib qho kev txwv yog tias lawv tsis muaj kev ua haujlwm zoo thaum ua haujlwm nrog cov lus uas tsis yog SQL thiab tseem yog qhov tseeb tias txhua cov ntaub ntawv yuav tsum nyob hauv cov rooj uas kev sib raug zoo ntawm cov koom haum tau txhais los ntawm qhov tseem ceeb. Tsis tas li ntawd, RDMSs tsis muaj chaw cia txaus los lis cov ntaub ntawv xws li cov duab, suab thiab yees duab. Tam sim no feem ntau ntawm cov tseem ceeb DBMSs xws li IBM's DB2 tsev neeg, Oracle, Microsoft's Access thiab SQL Server yog RDMS.
Raws li tau hais ua ntej ORDBMS muab lub hauv paus nruab nrab ntawm RDMS thiab cov khoom siv cov khoom siv (OODBMS). Koj tuaj yeem hais tau yooj yim tias ORDBMS tso cov khoom taw qhia pem hauv ntej kawg ntawm RDBMS. Thaum ib daim ntawv thov sib txuas lus nrog ORDBMS nws yuav nquag ua raws li cov ntaub ntawv khaws cia ua khoom. Tom qab ntawd ORDBMS yuav hloov cov ntaub ntawv khoom mus rau hauv cov ntaub ntawv cov ntaub ntawv nrog kab thiab kab thiab lis cov ntaub ntawv raws li nws tau khaws cia hauv RDBMS. Tsis tas li ntawd, thaum cov ntaub ntawv raug muab rov qab, nws yuav rov qab tau ib qho khoom nyuaj tsim los ntawm kev rov ua cov ntaub ntawv yooj yim. Qhov zoo tshaj plaws ntawm ORDBMS yog tias nws muab txoj hauv kev los hloov cov ntaub ntawv ntawm RDBMS hom thiab OODBMS hom, yog li ntawd tus programmer tsis tas yuav sau cov lej los hloov ntawm ob hom ntawv thiab cov ntaub ntawv nkag tau yooj yim los ntawm hom lus taw qhia.
Txawm tias RDBMS thiab ORDBMS yog ob qho tib si DBMSs, lawv txawv li cas lawv cuam tshuam nrog cov ntawv thov. Cov ntawv thov siv RDBMS yuav tsum ua haujlwm ntxiv thaum khaws cov ntaub ntawv nyuaj thaum ORDBMS inherently muab kev txhawb nqa rau qhov no. Tab sis vim yog kev hloov pauv sab hauv ntawm cov ntaub ntawv tawm tswv yim, kev ua haujlwm ntawm ORDBMSs tuaj yeem degraded. Yog li xaiv ib qho ntawm lwm qhov yog nyob ntawm cov ntaub ntawv uas yuav tsum tau khaws cia / tswj.
