I-SQL Server - umkhiqizo oyingqayizivele ongasebenza nenani elikhulu lezinqolobane zolwazi futhi wenze imisebenzi yokuhlela nokuphatha.
Ukuphathwa kweseva ye-sql kuhilela ukuthuthukiswa kwesistimu yesisekelo solwazi, ukwakhiwa kwesistimu yezokuphepha, ukuhlanganiswa kwesizindalwazi, izinto, nokwenza kube nokwenzeka ngabasebenzisi ukufinyelela ulwazi olutholakala kusizindalwazi.
Umlawuli ngezikhathi ezithile udala amakhophi ekhophi yasenqolobaneni, ahlole ubuqotho besistimu yolwazi, futhi alawule umthamo ovumelekile wamafayela olwazi namalogi okwenziwayo.
I-DB isethi yezingxenye ezihlobene
Le database ilawulwa uhlelo olukhethekile, oluyinkimbinkimbi yamathuluzi olimi nesofthiwe agcina ukuhambisana kwawo futhi ahlele ukusesha okusheshayo kolwazi oludingekayo.
Ukwakhiwa kwesizindalwazi
Ukuhlela isisekelo solwazi esiseqophelweni eliphezulu, umlawuli kumele asondele kuso ngokuzibophezela, afunde ngokucophelela izinketho eziningi zokusebenzisa ulwazi olutholakalayo, ahlinzekele ukuhlanganiswa okungenzeka nezinye izinhlelo nokufinyelela, kanye nokusebenzisa ubuchwepheshe besimanje, ukwenza izinguquko ezidingekayo uhlelo.
Ukuphathwa kweseva ye-SQL kwenziwa ngezinguqulo ezimbili
Eyokuqala iseva yefayela, lapho i-database itholakala kuseva yefayela; inikeza ukugcinwa kwesisekelo solwazi nokufinyelela kuso ngamakhasimende asebenza kumakhompyutha ahlukene. Ukucutshungulwa kwenziwa ezindaweni zokusebenza lapho amafayela esizindalwazi adluliselwa khona. Amakhompyutha womuntu siqu amaklayenti anesistimu yokulawula ecubungula ulwazi oludlulisiwe.
Inguqulo ye-client-server, ngaphezu kokuvikeleka, icubungula yonke ivolumu yedatha. Isicelo esithunyelwe ukubulawa, esikhishwe iklayenti, sivusa ukusesha kanye nokubuyiswa kolwazi oludingekayo. Lolu lwazi luthuthwa ngenethiwekhi lusuka kuseva luye kuklayenti.
Iseva yeklayenti inezingxenye ezimbili: iklayenti neseva.
Iklayenti itholakala kukhompuyutha yomuntu siqu; lenza imisebenzi yokuhlinzeka ngesithombe esibonakalayo.
Ingxenye yeseva ivuliwe iseva ezinikezele futhi inegalelo ekuhlinzekweni kokwabelana ngolwazi, ukuphathwa kwesisekelo solwazi, izinsizakalo zokuphatha kanye nezinyathelo zokuphepha.
Uhlelo lweseva yeklayenti lubonakala ngokusetshenziswa kwesu lolimi olukhethekile olwakha imibuzo futhi luhlinzeka ngamathuluzi asebenzayo okufinyelela kusizindalwazi.