SQL Server -imveliso eyodwa enokusebenza ngenani elikhulu leenkcukacha zolwazi kwaye yenze imisebenzi yenkqubo nolawulo.
Ulawulo lomncedisi we-sql lubandakanya ukuphuhliswa kwenkqubo yesiseko solwazi, ukudala inkqubo yokhuseleko, ukuqulunqwa kwedathabheyisi, izinto, kunye nokwenza ukuba abasebenzisi bafikelele kulwazi olukhoyo kwisiseko sedatha.
Umlawuli ngamaxesha athile udala iikopi ezigcinayo, ujonga ingqibelelo yenkqubo yolwazi, kwaye ulawula umthamo ovumelekileyo weefayile zolwazi kunye neelogi zentengiselwano.
I-DB yiseti yamacandelo anxulumeneyo
Le datha ilawulwa yinkqubo ekhethekileyo, eyinkimbinkimbi yeelwimi kunye nezixhobo zesofthiwe ezigcina ukufaneleka kwayo kwaye ziququzelele ukukhangela ngokukhawuleza ulwazi oluyimfuneko.
Ulwakhiwo lwesiseko sedatha
Ukuququzelela isiseko solwazi oluphezulu, umlawuli kufuneka asondele kuye ngokuthembekileyo, afunde ngokucokisekileyo iindlela ezininzi zokusebenzisa ulwazi olukhoyo, ukubonelela ngokudibanisa okunokwenzeka kunye nezinye iinkqubo kunye nokufikelela, kunye nokusebenzisa iteknoloji yanamhlanje, ukwenza utshintsho olufunekayo inkqubo.
Ulawulo lweseva yeSQL lwenziwa kwiinguqulelo ezimbini
Eyokuqala yiseva yefayile, apho i-database ibekwe kwiseva yefayile; ibonelela ngogcino lwesiseko solwazi kunye nokufikelela kuyo ngabathengi abasebenza kwiikhompyuter ezahlukeneyo. Ukulungiswa kuqhutyelwa kwiindawo zokusebenza apho iifayile zedatha zithunyelwa khona. Iikhomputha zobuqu zabathengi zinenkqubo yolawulo eqhuba ulwazi olugqithisiweyo.
Inguqulo ye-client-server, ukongeza kukhuseleko, iqhuba yonke umthamo wedatha. Isicelo esithunyelwe ukubulawa, esikhutshwe ngumxhasi, sixhokonxa ukukhangela kunye nokufunyanwa kolwazi oluyimfuneko. Olu lwazi luthuthwa ngothungelwano ukusuka kumncedisi ukuya kumxhasi.
Umxhasi-umncedisi unamacandelo amabini: umxhasi kunye nomncedisi.
Umxhasi ubekwe kwikhompyuter yakhe, yenza imisebenzi yokubonelela ngojongano lomzobo.
Indawo yomncedisi ibekwe kwi umncedisi ozinikeleyo kunye negalelo ekuboneleleni ngokwabelana ngolwazi, ulawulo olusisiseko solwazi, iinkonzo zolawulo kunye nemilinganiselo yokhuseleko.
Inkqubo yomxhasi-iseva ibonakala ngokusetyenziswa kobuchule bolwimi obukhethekileyo obubuza imibuzo kwaye ikwabonelela ngezixhobo ezisebenzayo zokufikelela kwiziko ledatha.