Post on 10-Feb-2018
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 1/24
Nugs Mugrdjl
Fhrgstlphir Kuôlz
Eirlbgkd Dn`irfd
Edvgir Kdrtgbiz
4
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 2/24
SlstmriVTN is ub VM@J rindfglbdn lrgibtdjl d l`eitls y ng`ri. Is
jisdrrlnndjl plr ubd flkubgjdj ji jisdrrlnndjlris qui trd`dedb ji olrkd
jisgbtirisdjd dn gmudn qui kufhls ltrls prlyiftls ji föjgml d`girtl.
Fdrdftirëstgfds5
• Dntd flbfurribfgd5 SlstmriVTN pirkgti qui kgibtrds ub
prlfisl isfrg`d ib ubd td`nd, ltrls puijdb dffijir d nd kgskd
td`nd sgb prl`nikds y nls usudrgls tgibib ubd vgsgöb ji nd
õntgkd virsgöb ji nd td`nd.
• _drgijdj ji tgpls bdtgvls5 pirkgti in usl ji bõkirls ji
prifgsgöb dr`gtrdrgd, tixtls ndrmls, ogmurds milkçtrgfds,
jgriffglbis GS yd sid GSv: l GS_?, `nlquis ji jgriffglbis
istgnl FGJP, jgriffglbis KDF y Drrdys.
• Sirkgti in usl ji oubfglbis5 `nlquis ji föjgml qui si ieifutdb
ib in sirvgjlr, puijib utgngzdrsi jgstgbtls nibmudeis ji
prlmrdkdfgöb.
• Fndvis olräbids5 dtrg`utls ji ubd td`nd qui slb prgkdrgds ib
ltrd.
• Zrgmmirs5 slb dffglbis qui si ieifutdb ib ub jitirkgbdjlivibtl.
0
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 3/24
_ibtdeds5
• Kuntgpndtdolrkd
• Vlplrti ikprisdrgdn
• Jgsplbi ji kufhd jlfukibtdfgöb
• Oäfgn ji dpribjir
Jisvibtdeds5
•
Vu flbogmurdfgöb puiji sir flkpnied
• Ib mibirdn, is dnml käs nibtl qui ltrls VM@J rindfglbdnis
• Bl lorifi ubd mrdb vdrgijdj ji tgpls ji jdtls
• Bl vgibi flb mrdbjis kijgjds ji simurgjdj plr jioiftl
6
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 4/24
KyVTN is ub VM@J rindfglbdn kuy flblfgjl d bgvin kubjgdn
pirtibifgibti d Vub Kgfrlsystiks y Lrdfni Flrplrdtglb.
Fdrdftirëstgfds5
• Kuntgpndtdolrkd
• Flbiftgvgjdj simurd
• Pipngfdfgöb
•Gbjixdfgöb ji fdkpls ji tixtls
• Viniffgöb ji kifdbgskls ji dnkdfibdkgibtl pdrd ubd flbogmurdfgöb
käs pirslbdngzdjd
_ibtdeds5
• Is slotwdri ng`ri y puiji kljgogfdrsi simõb buistrds bifisgjdjis
• Zgibi ubd virsgöb mrdtugtd
• Is räpgjl
• Is simurl
• Is ogd`ni
• Istä tltdnkibti jgsiôdjl pdrd kdbiedr `dsis ji jdtls iblrkis.
Jisvibtdeds5
:
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 5/24
• Ysl ji trgmmirs ngkgtdjls
• Tugtdr nls prgvgnimgls ji ubd td`nd puiji jdr prl`nikds
•
Bl is gbtugtgvl ji prgkirds
• D pisdr ji lorifir kuntgtuj ji utgngjdjis, dnmubds bl istäb kuy `gib
jlfukibtdjds
Zdn viz in VM@J rindfglbdn käs flblfgjl ji tljls, gbfnugjl ib in
pdquiti ji prlmrdkds Kgfrlslot Loogfi jgsplbg`ni ib vdrgds virsglbis.
Fdrdftirëstgfds5
• Flbtgibi td`nds, olrkundrgls i gbolrkis flkl nd mrdb kdylrëd
ji VM@J
• Is flkpdtg`ni flb KV VTN
• Mrdb onixg`gngjdj d nd hlrd ji ixplrtdr i gkplrtdr gbolrkdfgöb
• Bl riqugiri ji ub lrjibdjlr pltibti
_ibtdeds5
• Vibfgnnl
• Is räpgjl mrdfgds d nls dsgstibtis
9
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 6/24
Jisvibtdeds5
• Bl is dflbsied`ni pdrd mrdbjis `dsis ji jdtls yd qui bl
pirkgti td`nds ji käs ji 4M@
• Vgikpri hd tibgjl dnmubls prl`nikds ji simurgjdj
• Ib nds virsglbis käs dbtgmuds hdy prl`nikds ji flbfurribfgd
• Hdy VM@J kufhl kielris qui KV Dffiss, bl jistdfd ib
bgbmõb dspiftl.
?
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 7/24
Lrdfni Jdtd`dsi is ub VM@J rindfglbdn ji Lrdfni Flrplrdtglb, hdstd
hdfi plfl hd sgjl in riy ji nls VM@J mrdfgds d sus fdrdftirëstgfds.
Fdrdftirëstgfds5
• Vlplrti ji trdbsdffglbis
• Isfdnd`gngjdj
• Kuntgpndtdolrkd
• Istd`ni
_ibtdeds5
• Vus fdrdftirëstgfds slb sus vibtdeds, is isfdnd`ni, kuntgpndtdolrkd,
istd`ni y flb slplrti ji trdbsdffglbis
• Zgibi kufhësgkd jlfukibtdfgöb ib gbtirbit
• Zgibi ub `uib sgstikd ji simurgjdj y odfgngtd nd rifupirdfgöb ji
jdtls
Jisvibtdeds5
• Is `dstdbti fdrl
• Bl is oäfgn ji flbogmurdr
• Vi riqugiri fgirtl bgvin ji flblfgkgibtl pdrd kdbiedr Lrdfni
Jdtd`dsi
=
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 8/24
Gbtir@dsi is ub VM@J rindfglbdnis jisdrrlnndjl y
flkirfgdngzdjl plr @lrndbj Vlotwdri Flrplrdtglb y dftudnkibti plr
FljiMidr
Fdrdftirëstgfds5
• Jistdfd sl`ri tljl plr in `del flbsukl ji rifursls jin
sgstikd, djikäs is kuy oäfgn ji djkgbgstrdr yd qui
`äsgfdkibti bl hdy bifisgjdj ji hdfirnl.
• Oubfglbdr ib Ngbux, ]gbjlws y Vlndrgs.
_ibtdeds5
•
Bl riqugiri ji ub lrjibdjlr pltibti pdrd fukpngr oubfglbis `äsgfds.
• Kuntgpndtdolrkd.
• Ybl ji nls kielris, puiji qui gbfnusl in kielr, fuäbtl d
dffisl flbfurribti si riogiri, yd qui bl si `nlquidb nd
nifturd y isfrgturd.
•
Oäfgn ji gbstdndr y flbogmurdr.
8
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 9/24
• Nls trgmmirs qui utgngzd slb kuy pltibtis.
7
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 10/24
J@0 is ub VM@J rindfglbdnis prlpgijdj ji G@K y ndbzdjl dn
kirfdjl ib 4786.
Fdrdftirëstgfds5
• Is ub kltlr ji @J rindfglbdn qui gbtimrd XKN ji kdbird bdtgvd,
tdk`gçb flblfgjl flkl puriXKN.
• Is kuy dutöblkl.
_ibtdeds5
• Drqugtifturd oësgfd sgkgndr d nd ji Lrdfni.
• Kuntgpndtdolrkd, gbfnusl puiji oubfglbdr ib sgstikds lpirdtgvls
dbtgmuls flkl ]78 y ]79.
• Zrgmmirs kuy pltibtis.
• Yb VTN kuy `uibl.
Jisvibtdeds5
• Vu prifgl.
• Dnmubds flbogmurdfglbis y prlfijgkgibtls ji`ib sir
prlmrdkdjls ib ltrl nibmudei ji prlmrdkdfgöb, flkl Edvd, F…,
itf.
• Is dnml dbtgfudjl.
43
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 11/24
Jisvibtdeds5
• Bl hdy jikdsgdjd jlfukibtdfgöb y hdy fgirtd
gbfirtgjuk`ri ib su outurl.
• Vu `del flbsukl ji rifursls is ji`gjl d su drqugtifturd
õbgfd qui bl is piroiftd, is flkpngfdjl ridngzdr pdrtgfglbis
pdrd dukibtdr su ribjgkgibtl oësgfl.
44
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 12/24
@lrndbj Sdrdjlx (l sgkpnikibti Sdrdjlx) is ub VM@J rindfglbdnjisdrrlnndjl prgbfgpdnkibti pdrd ]gbjlws, dubqui yd ixgstgirlb virsglbis
pdrd KV-JLV y Ngbux. Is jisdrrlnndjl plr Flrin y is ubl ji nls pdquitis
ji nd sugti ]lrjSiroift Loogfi.
Fdrdftirëstgfds5
• Hdfi ub usl iogfdz ji nd kiklrgd, ikpnidbjl jgvirsds tçfbgfds.
• Gbtimrd su prlpgl nibmudei ji prlmrdkdfgöb, jiblkgbdjl SDN.
• Nds virsglbis ji ]gbjlws slb jgoiribtis d nls ji JLV y Ngbux.
_ibtdeds5
• Vu ibtlrbl ji prlmrdkdfgöb is ubl ji nls kielris ixgstibtis,
djikäs ji plsiir kufhls dsgstibtis qui odfgngtdb in jgsiôl ji
dpngfdfglbis.
• Vu õntgkd virsgöb prisibtd kufhësgkds kielrds ib flkpdrdfgöb
flb sus virsglbis dbtirglris.
Jisvibtdeds5
• Is ubl ji nls VM@J käs dbtgfudjls y bl is kuy riflkibjd`ni
su usl d pisdr ji sus buivds virsglbis.
40
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 13/24
• Dubqui sid dnml plsgtgvl qui tibmd su prlpgl nibmudei ji
prlmrdkdfgöb, istl puiji hdfirnl gbjisid`ni yd qui riqugiri ub
plfl ji dpribjgzdei.
46
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 14/24
VTN Virvir is ub VM@J rindfglbdn jisdrrlnndjl plr Kgfrlslot. Vu
prgbfgpdn oubfgöb is dnkdfibdr y mistglbdr jdtls slngfgtdjls plr ltrds
dpngfdfglbis, yd sidb ib in kgskl iqugpl (nlfdn) flkl ib rij, gbfnuyibjl
Gbtirbit. Ixgstib bukirlsds ijgfglbis ji VTN Virvir, y sus prgbfgpdnis
nibmudeis ji flbsuntd slb Z-VTN y DBVG VTN.
Fdrdftirëstgfds5
• Vlplrtd trdbsdffglbis.
• Vlplrtd prlfijgkgibtls dnkdfibdjls (prlmrdkd oësgfdkibti
dnkdfibdjl ib nd `dsi ji jdtls).
• Slsii ub ibtlrbl mräogfl gbtimrdjl qui pirkgti mistglbdr nls
jdtls mräogfdkibti.
• Sirkgti trd`dedr ib kljl fngibti-sirvgjlr, jlbji nls jdtls slb
dnkdfibdjls ib rikltl y nls fngibtis dffijib d nd gbolrkdfgöb
jisji sus tirkgbdnis.
_ibtdeds5
• Fdpdfgjdj ji ubgöb ibtri VTN i Gbtirbit.
4:
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 15/24
• @uibd dffisg`gngjdj d nls jgoiribtis ogfhirls ji nd `dsi ji jdtls.
• Vi puijib dmrimdr ltrls sirvgjlris ji VTN Virvir sg trd`dedkls
jisji ubd rij nlfdn.
• @uib ibtlrbl mräogfl ji kdbiel.
• Vimurgjdj y istd`gngjdj5 si puijib flbtrlndr nls pirkgsls ji
dffisl y kljgogfdfgöb ji präftgfdkibti tljls nls inikibtls ji nd
`dsi ji jdtls.
Jisvibtdeds5
• In nibmudei qui utgngzd is jgoiribti dn ristl ji nibmudeis VTN, plr
nl qui riqugiri tgikpl ji dpribjgzdei.
• VTN Virvir riqugiri ubd mrdb fdbtgjdj ji kiklrgd PDK pdrd su
utgngzdfgöb.
•Vu prifgl is `dstdbti fdrl, sl`ri tljl sg tibikls ib fuibtd ndrindfgöb fdngjdj-prifgl.
• Nds virsglbis käs iflbökgfds tgibib mrdbjis ngkgtdfglbis
rispiftl d nds käs fdrds.
49
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 16/24
VTNgti is ub VM@J rindfglbdn ji ng`ri ngfibfgd y kuntgpndtdolrkd,
flbtibgjl ib ubd piquiôd `g`ngltifd. D jgoiribfgd ji nls VM@J fngibti-
sirvgjlr, in kltlr ji VTNgti bl is ub prlfisl gbjipibjgibti qui si
flkubgfd flb nd dpngfdfgöb prgbfgpdn1 ib isti fdsl, nd `g`ngltifd ji VTNgti
pdsd d olrkdr pdrti gbtimrdn jin prlmrdkd.
Fdrdftirëstgfds5
• Ib numdr ji jitirkgbdr ub tgpl d ubd flnukbd, flkl ib nd kdylr
pdrti ji nls VM@J ji VTN, nls tgpls si dsgmbdb d nls vdnlris
gbjgvgjudnis.
• Fdpdfgjdj ji dffisl d nd `dsi ji jdtls plr vdrgls prlfisls
sgkuntäbils (kuntghgnl).
• Nd `g`ngltifd puiji sir usdjd jisji prlmrdkds ib F/F++, dubqui
tdk`gçb istä jgsplbg`ni jisji ltrls nibmudeis ji prlmrdkdfgöb
gbtirpritdjls.
_ibtdeds5
• Siquiôl tdkdôl ji nd ng`rirëd, nl qui hdfi qui sid kuy djifudjl
pdrd sgstikds gbtimrdjls.
• Kdylr ribjgkgibtl y vinlfgjdj qui ltrls VM@J.
• Slrtd`gngjdj5 dn sir kuntgpndtdolrkd si puiji ieifutdr ib fudnqugir
sgstikd lpirdtgvl.
• Is slotwdri ng`ri.
4?
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 17/24
Jisvibtdeds5
• Ngkgtdfglbis ib "whiri", jdjd plr in slplrti pdrd fndusurds
dbgjdjds.
• Odntd ji fndvis olräbids ib nds td`nds.
4=
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 18/24
Dpdfhi Jir`y, dbtirglrkibti flblfgjl flkl G@K Fnlujsfdpi, is
ub VM@J rindfglbdn jisdrrlnndjl plr nd Dpdfhi Vlotwdri Oubjdtglb `dsdjl
ib Edvd y usdjl pdrd prlfisdkgibtls ji trdbsdffglbis lbngbi. Jir`y is ub
slotwdri ng`ri.
Fdrdftirëstgfds5
• Is kuy ngmirl.
• @dsdjl ib Edvd, EJ@F y istäbjdris VTN.
• Vlplrtd in kljl fngibti-sirvgjlr.
_ibtdeds5
• Lpfglbis ji ik`i`ir in kdbiedjlr ji nd `dsi ji jdtls ib Edvd.
• Onixg`gngjdj ib in kdbiel ji jdtls flkpniels.
• Vi deustd dn ispdfgl bifisdrgl y ingkgbd ispdfgl jispirjgfgdjl.
• Kdbgpundfgöb ji l`eitls flkpniels ji olrkd ämgn y räpgjd.
Jisvibtdeds5
• Odntd ji istäbjdris ib nd gbjustrgd lrgibtdjl d l`eitls.• Istä isfrgtl ib Edvd y bl tgibi `ugnjgbms pdrd ltrls nibmudeis.
48
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 19/24
Ogri`grj
Ogri`grj is ub sgstikd ji djkgbgstrdfgöb ji `dsi ji jdtls rindfglbdn ji föjgml d`girtl,
`dsdjl ib nd virsgöb ? ji Gbtir`dsi, fuyl föjgml oui ng`irdjl plr @lrndbj ib 0333.
Fdrdftirëstgfds
• Is kuntgpndtdolrkd, y dftudnkibti puiji ieifutdrsi ib nls sgstikds lpirdtgvls5
Ngbux, HS-YX, Orii@VJ, Kdf LV, Vlndrgs y Kgfrlslot ]gbjlws.
• Ieifutd`ni piquiôl, flb riquirgkgibtls ji hdrjwdri `dels.
• Drqugtifturd Fngibti/Virvgjlr sl`ri prltlflnl ZFS/GS y ltrls (ik`ijjij).
• Vlplrti ji trdbsdffglbis DFGJ y fndvis olräbids.
• Is kijgdbdkibti isfdnd`ni.
• @uibd simurgjdj `dsdjd ib usudrgls/rlnis.
• Jgoiribtis drqugtifturds, ibtri innds in Virvgjlr Ik`i`gjl4 (ik`ijjij sirvir)
qui pirkgti ieifutdr dpngfdfglbis klblusudrgl ib lrjibdjlris sgb gbstdndr in
slotwdri Ogri`grj.
• @dsis ji jdtls ji sönl nifturd, pdrd dpngfdfglbis qui flrrdb jisji jgsplsgtgvls
sgb fdpdfgjdj ji isfrgturd, flkl fj-rlks.
•
Ixgstibfgd ji flbtrlndjlris LJ@F, LNIJ@, EJ@F, SHS, Sirn, .bit, itf.• Piqugsgtls ji djkgbgstrdfgöb `dels, sgibjl flbsgjirdjd flkl ubd `dsi ji jdtls
ng`ri ji kdbtibgkgibtl, dn kdrmib ji nd ridngzdfgöb ji flpgds ji simurgjdj.
• Snibl slplrti jin istäbjdr VTN-70, tdbtl ji sgbtdxgs flkl ji tgpls ji jdtls.
• Fdpdfgjdj ji dnkdfibdr inikibtls @NL@ (@gbdry Ndrmi L`eifts).
• Vlplrti ji Ysir-Jiogbij Oubftglbs (YJOs).
• _irsgöb dutlieifutd`ni, sgb gbstdndfgöb, ixfinibti pdrd nd fridfgöb ji fdtänlmls
ib FJ-Plk y pdrd fridr virsglbis ji ivdnudfgöb ji dnmubds dpngfdfglbis.
47
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 20/24
_ibtdeds
• Lorifi ubd mrdb vdrgijdj ji kijgls pdrd dffijir d nls jdtls (bdtgvl/DSG) jrgvir
j`Ixpriss, L@JF, LNIJ@, .BIZ prlvgjir, itf.
• Fridfgöb ji flpgds ji simurgjdj y nd oubfglbdngjdj ib drqugtifturds ji ?: `gts.
• Ogri`grj djkgbgstrd nd flbfurribfgd ib nds dftudngzdfglbis ib nls jdtls, dsg flkl
in kdbiel ji nds trdbsdffglbis.
• Ogri`grj lorifi ubd flbfurribfgd ixfinibti, dntl ribjgkgibtl y pljirlsl
nibmudei ji prlfijgkgibtls dnkdfibdjls y jgspdrdjlris.
• Ogri`grj is ubd `dsi ji jdtls ngmird y sibfgnnd ji gbstdndr.
• Bl flbsuki mrdbjis rifursls ib in sirvgjlr.
• Zgibi ub tgpl ji ngfibfgd sgkgndr d KSN (Klzgnnd Su`ngf Ngfibsi), qui pirkgti
su usl ji olrkd mrdtugtd y flb ubd jgstrg`ufgöb kuy plfl ristrgftgvd.
• Vi puijib usdr ng`rirgds ixtirbds qui kielrdb nd lpirdtgvd ji Ogri`grj.
• Ixgstib kuntgtuj ji flkplbibtis pdrd jgstgbtls nibmudeis ji prlmrdkdfgöb pdrd
flbiftdr flb Ogri`grj ji olrkd bdtgvd l gbjgriftd.
Jisvibtdeds
• Ybd ji nds jisvibtdeds is ji nd @J is slnl puiji dffijir `dsi ji jdtls ji
Ogri`grj/gbtir`dsi flb in jgdniftgfl 4 ji VTN.
• Vlnl nl kdbgpundb nls käs usdjls ib nibmudei VTN.
• Sl`ri `g`ngltifd ji oubfglbis (dubqui YJO Jgsplbg`ni), slnl nl kdbgpundb nls
käs lsdjls ib nibmudei VTN, fdrifi ji gbtirodz mräogfd prlpgd, käxgkl bõkirl
ji td`nds is ji ?:,969.
03
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 21/24
Gbolrkgx gbflrplrd flbfiptls ji jgsiôl qui slb sgmbgogfdtgvdkibti jgoiribtis ji nds
trdjgfglbdnis pndtdolrkds rindfglbdnis, nl qui jd numdr d dntls bgvinis ji ribjgkgibtl y
jgsplbg`gngjdj, fdpdfgjdjis jgstgbtgvds ib nd ripngfdfgöb ji jdtls y isfdnd`gngjdj, y nd
sl`rifdrmd djkgbgstrdtgvd këbgkd.
Fdrdftirëstgfds
• Fdpdfgjdj ji lptgkgzdr in ribjgkgibtl ji ubd olrkd gbtingmibti mrdfgds d nd ieifufgöb
ib pdrdninl ji nds prgbfgpdnis lpirdfglbis ji nd `dsi ji jdtls (pdrtgfundrkibti, flbsuntd
l flkpdftdfgöb ji ëbjgfis, y tdk`gçb sdnvdmudrjd y rifupirdfgöb ji jdtls).
• Ieifufgöb ji kõntgpnis hgnls y prlfisdjlris vgrtudnis qui trd`dedb ib pdrdninl,
dtgibjib d usudrgls flbfurribtis, istl flbsgmui qui tljl in ribjgkgibtl si dprlvifhi ji
dfuirjl d su prglrgjdj.
• In l`eitgvl is flbsimugr isfdnd`gngjdj tltdn y ngbidn.
• Zgibi nd fdpdfgjdj ji rindfgöb ji jdtls ib kõntgpnis numdris oësgfls (jibtrl ji nd
fgtdjd drqugtifturd JVD), suplbgibjl ub iogfdz sgstikd ji jgstrg`ufgöb y flkpdrtgr
jdtls jibtrl ji ub kgskl sgstikd lrmdbgzdtgvl.
• Gbfnuyi ji olrkd gbtimrdjd in sirvgjlr Bitsfdpi OdxZrdp, pdrd slplrti y flbiftgvgjdj
ji dpngfdfglbis ]i` i Gbtrdbit. Lorifi sirvgfgls isfdnd`nis ]i`/Gbit ji dntl
ribjgkgibtl, ibtlrbl ji jisdrrlnnl `dsdjl ib Edvd/EdvdVfrgpt simurgjdj `dsdjd ib VVN
flb dutibtgogfdfgöb.
• Ibfrgptdfgöb ib gbtimrgjdj ji kibsdeis, flbtrln ji dffisls, slplrti ji firtgogfdjls jin
ndjl jin fngibti y dsgstibtis pdrd nd pu`ngfdfgöb ib Gbtirbit.
04
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 22/24
• ]i` Gbtimrdtglb Lptglb, odfgngtd nd mibirdfgöb ji Dpngfdfglbis lrgibtds d Gbtirbit.
Vi trdtd ji ub Pubtgki qui ibndzd dn sirvgjlr ]i` y in sirvgjlr ji `dsi ji jdtls ji
olrkd qui nds dpngfdfglbis puijdb gbflrplrdb sibfgnnd nls jdtls sukgbgstrdjls
jgbäkgfdkibti sukgbgstrdjls plr Gbolrkgx.
Zdk`gçb is plsg`ni gbflrplrdr ubd flbsuntd VTN jibtrl ji ubd pämgbd ]i`. In ]GL
gbfnuyi dn ]i`J@ Su`ngshir si ibfdrmd ji mibirdr gbolrkis kijgdbti dsgstibtis, is
jifgr ubd olrkd dutlkätgfd pdrd mibirdr pdmgbds d pdrtgr ji jdtls ji ubd `dsi ji jdtls.
• Ib fudbtl d nd simurgjdj i gbtimrgjdj ji nls jdtls, gbfnuyi jupngfdfgöb, ispiel ji
jgsfl, vlnfdjl ji simurgjdj y ristdurdfgöb ji dntd vinlfgjdj ji trdbsdffglbis ib nëbid y
ub jgsiôl ji simurgjdj flbolrki d nd fndsgogfdfgöb F0, LNZS y Jdtd]driHlusgbm
jgsplbg`nis.
_ibtdeds
• Hdfi nd flbvirsgöb ji tgpls dutlkätgfdkibti, is jifgr bl is bifisdrgl
ispifgogfdr bgbmubd gbstruffgöb qui jgmd qui flbvirsgöb ji tgpl si bifisgtd.
• Nls vdnlris bunls si gjibtgogfdb flb nd pdnd`rd BYNN y is in istdjl gbgfgdn ji
fudnqugir vdrgd`ni qui si kdbiei.
• Pijufi nls flstls ji djkgbgstrdfgöb
• Vlplrtd riqugsgtls ji prlfisdkgibtl ji trdbsdffgöb lbngbi, flkpniels y
rgmurlsls.
•
Lptgkgzd fdpdfgjdjis ji gbtingmibfgd jin bimlfgl flkpitgtgvds.
Jisvibtdeds
• Bl tgibi slplrti pdrd @NL@s (L`eitls mrdbjis `gbdrgls).
• Bl tgibi slplrti pdrd in tgpl ji jdtls _DPFHDP.
• Vlb jdtls flb ubd nlbmgtuj oged ji käxgkl 0333 fdrdftiris.
• Bl is riflkibjd`ni utgngzdrnl flb dpngfdfglbis qui ixgmib ub mrdb ribjgkgibtl
jisji in pubtl ji vgstd ji nd rdpgjiz.
Srljuftls
• Gbolrkgx F-GVDK - nd õntgkd virsgöb ji nd `dsi ji jdtls Kdrdthlb lrgmgbdn.
• Gbolrkgx VI - flkirfgdngzdjl flkl sgstikd ji mdkd `ded pdrd sir gbfrustdjl ib
dpngfdfglbis.
• Gbolrkgx LbNgbi - ub sgstikd djifudjl pdrd mistglbdr `dsis ji jdtls ji tdkdôl
kijgl.
00
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 23/24
• Gbolrkgx Ixtibjij Sdrdnnin Virvir (XSV, _8) - ubd virsgöb ji dntl ribjgkgibtl jin
föjgml `dsi _= pdrd sir usdjl ib mrdbjis sgstikds jgstrg`ugjls.
• Gbolrkgx Ybgvirsdn Virvir (_7) - ubd flk`gbdfgöb jin kltlr _= LbNgbi flb kdpil
L-P y slplrti Jdtd@ndji ji Gnnustrd.
• Gbolrkgx-:MN - Yb nibmudei ji fudrtd mibirdfgöb pdrd prlmrdkdr dpngfdfglbis.
KdrgdJ@ is ub sgstikd ji mistgöb ji `dsis ji jdtls jirgvdjl ji KyVTN flb ngfibfgd
MSN
Zgibi ubd dntd flkpdtg`gngjdj flb KyVTN yd qui plsii nds kgskds örjibis, gbtirodfis,
DSGs y `g`ngltifds, sgibjl su l`eitgvl pljir fdk`gdr ub sirvgjlr plr ltrl jgriftdkibti.
Vu ndbzdkgibtl gbgfgdn oui in 00 ji ibirl ji 0337 y su õntgkd virsgöb in 06 ji kdyl ji
0346.
Is ubd `dsi ji jdtls qui flkgibzd d mdbdr ib plpundrgjdj, qui yd hd rifg`gjl
ispdnjdrdzls tdb gkplrtdbtis flkl su djlpfgöb plr pdrti ji nd ]gagkijgd Olubjdtglb l
plr vdrgds jgstrg`ufglbis ji Ngbux.
KdrgdJ@ gbtrljufi jls kltlris ji dnkdfibdkgibtl buivls, ubl nndkdjl Drgd qui
riikpndzd d KyGVDK y ltrl nndkdjl XtrdJ@ qui sustgtuyi d GbblJ@.
Fuibtd flb ubd dntd flkpdtg`gngjdj flb KyVTN, istl plrqui plsii nls kgsklsflkdbjls, nds kgskds gbtirodfis, DSG‗s y `g`ngltifds, istl bls pirkgti kgmrdr ji ub
sirvgjlr d ltrl jgriftdkibti.
Mllmni istä pripdrdbjl ubd kgmrdfgöb kdsgvd ji tljds sus `dsis ji jdtls KyVTN
(4333+) d KdrgdJ@.
_ibtdeds
Buivls kltlris ji dnkdfibdkgibtl käs iogfgibtis. Drgd y XtrdJ@ vgibib d riikpndzdr
d KyGVDK i GbblJ@ rispiftgvdkibti. Fd`i jistdfdr in kdylr ribjgkgibtl ji Drgd,
fudbjl rifg`i flbsuntds flkpnieds y tgibi qui ridngzdr td`nds tikplrdnis, çstds sifdfhidb ib kiklrgd ib viz ji isfrg`grnds ib jgsfl.
06
7/22/2019 Comparacion SGBD relacional.doc
http://slidepdf.com/reader/full/comparacion-sgbd-relacionaldoc 24/24
Istdjëstgfds pdrd ëbjgfis y td`nds qui puijib dyujdr pdrd nd lptgkgzdfgöb ji nd `dsi ji
jdtls. Vi dôdjib buivds td`nds ji sgstikd pdrd riflmir istd gbolrkdfgöb.
Ib mibirdn, kufhds kielrds pdrd dukibtdr in ribjgkgibtl y nd iogfgibfgd flb rispiftl d
KyVTN.
Jisvibtdeds
Nd kgmrdfgöb ji ub sgstikd kuy tistdjl y ogd`ni flkl is KyVTN. Dubqui si mdrdbtgzd
ubd d`slnutd flkpdtg`gngjdj, y ub mrdb sgstikd istd`ni y pltibti, hdy qui vdnlrdr sg d
jëd ji hly kirifi pdsdr tljl kg sgstikd d KdrgdJ@.