Isimo seNgcaciso seNgcaciso singacaciswa kwiDatabase
Isiganeko segama lesiseko sedatha kaninzi asiqondwa kakuhle ngenxa yokuba ithetha izinto ezahlukeneyo kubathengisi abahlukeneyo. Ngokuqhelekileyo kusetyenziswe rhoqo malunga nokuphunyezwa kwedatha ye-Oracle.
Injongo YesiGaba seNgcaciso
Ngokuqhelekileyo, umzekelo weenkcukacha uchaza indawo egciniweyo ye-database, kubandakanywa isofthiwe ye-RDBMS, isakhiwo setafile, iinkqubo ezigcinwe kunye nezinye izinto zokusebenza. Abalawuli beDatabase bangenza iziganeko ezininzi zeenkcukacha ezifanayo kwiinjongo ezahlukeneyo.
Umzekelo, inhlangano eneenkcukacha zabasebenzi ingaba neziganeko ezintathu ezihlukeneyo: ukuveliswa (kusetyenziswe ukufumana idatha ephilayo), ngaphambi kokuveliswa (kusetyenziswa ukuvavanya ukusebenza okutsha ngaphambi kokukhutshwa kwimveliso) nophuhliso (elisetyenziswe ngabavelisi beenkcukacha ukudala ukusebenza okutsha ).
Izikhokelo zeDatural Database
Ukuba unedatha ye- Oracle , uyazi ukuba umzekelo we-database uthetha into ethile.
Ngoxa i-database ngokwayo ibandakanya yonke idatha yesicelo kunye nemethadatha egcinwe kwiifayile eziphathekayo kumncedisi, umzekelo unxulumene nesofthiwe kunye nememori esetyenziselwa ukufikelela kule datha.
Umzekelo, ukuba ungena kwiziko le-Oracle, iseshoni yakho yokungena ngumzekelo. Ukuba uvala okanye uvale ikhomputha yakho, umzekelo wakho uphela, kodwa i-database - kunye nedatha yakho yonke - uhlale uhambelana. Isibonelo se-Oracle sinokufikelela kwiziko elilodwa kuphela ngexesha, ngelixa i-Oracle database ingafumaneka ngamaxesha amaninzi.
Iimviwo zeSQL Server
Isibonelo seSQL Server sithetha ngokufakela ukufakela kweSQL Server. Akuyiyo yedatha ngokwayo; Kunoko, isofthiwe esetyenziselwa ukudala isiseko sedata. Ukugcina iziganeko ezininzi kunokuba luncedo xa ulawula izixhobo zeseva kuba umzekelo ngamnye unokuqwalaselwa kwimemori kunye nokusetyenziswa kwe-CPU-into ongenakuyenza ngokweenkcukacha zoluntu ngaphakathi kwimeko ye SQL Server.
Isicwangciso seNgcaciso kunye neSibonelelo seNgcaciso
Kwakhona kunokuba luncedo ukucinga ngomzekelo kwimeko kunye nenkqubo yedatha. Iskimu yimethadatha esichaza ukucwangciswa kwedatha kunye nendlela idityaniswe ngayo idatha. Oku kubandakanya iitafile zayo kunye neentsika zazo kunye nayiphi na imithetho elawula idatha. Ngokomzekelo, itafile yomqeshwa kwisiseko sekhompyutha ingaba nekholomu ngegama, idilesi, i-ID yomqeshwa kunye nenkcazelo yomsebenzi. Esi sisakhiwo, okanye iskimu, sedata.
Umzekelo weziko ledatha ngumfanekiso wenkcazelo yangempela kunini nayiphi na ixesha, kubandakanywa nedatha ngokwayo kunye nolwalamano lwalo nolunye ulwazi kwiziko ledatha.