Funda ukuthi yini eyenza ukhiye oyinhloko noma omubi ku-database
Iyini ukhiye oyinhloko? Ezweni yolwazi , ukhiye oyinhloko wetafula elihlobeneyo uveza kuphela irekhodi ngalinye etafuleni. Amasu asetshenziswa okhiye ukuqhathanisa, ukuhlunga, nokugcina amarekhodi, nokudala ubuhlobo phakathi kwamarekhodi.
Ukukhetha ukhiye oyinhloko ku-database kungenye yezinyathelo ezibaluleke kakhulu kule nqubo. Kungaba isici esijwayelekile esiqinisekisiwe ukuba siyingqayizivele njengeNombolo yezokuThuthukiswa Komphakathi etafuleni engenakho irekhodi elilodwa lomuntu ngamunye noma - mhlawumbe - lingahle lenziwe uhlelo lokuphathwa kwedatha njengesihlonzi esiyingqayizivele somhlaba, noma i-GUID , ku- Microsoft SQL Server . Izihluthulelo eziyinhloko zingase zibe nesici esisodwa noma izimfanelo eziningi ngokuhlanganiswa.
Izihluthulelo eziyinhloko yizixhumanisi ezihlukile kolwazi oluhlobene kwamanye amatafula lapho ukhiye oyinhloko osetshenziswa khona. Kumele ifakwe lapho irekhodi lidalwa, futhi akufanele lishintshe. Ithebula ngalinye ku-database linakholomu noma amabili ngokuqondile ukhiye oyinhloko.
Isibonelo Esiyisisekelo Sokhiye
Cabanga ukuthi unetafula le-STUDENTS eliqukethe irekhodi lomfundi ngamunye enyuvesi. Inombolo ye-ID yomfundi eyingqayizivele yomfundi kuyisinqumo esihle sokhiye oyinhloko etafuleni le-STUDENTS. Igama lokuqala nelokugcina lomfundi akuyona ukukhetha okuhle ngoba kukhona ithuba lokuthi abafundi abangaphezu kweyodwa babe negama elifanayo.
Okunye ukukhetha okungalungile okhiye oyinhloko kufaka ikhodi ye-ZIP, ikheli le-imeyili, nomqashi, konke okungashintsha noma ukumelela abantu abaningi. Isihlonzi esisetshenziselwa ukhiye oyinhloko kumele sibe sehlukile. Ngisho nezinombolo zokuphepha zezenhlalakahle zingashintsha lapho ukuPhathwa kwezokuPhepha koMphakathi kususa inombolo kumuntu oye wathinteka ukwebiwa kwezisi. Abanye abantu abanayo ngisho nenombolo yezokuphepha komphakathi. Noma kunjalo, ngoba zombili lezo zimo azivamile. Izinombolo Zokuvikeleka Kwezenhlalakahle zingaba yisinqumo esihle sokhiye oyinhloko.
Amathiphu Wokukhetha Amakhadi Asemqoka
Uma ukhetha ukhiye oyinhloko oyinhloko, ukubuka kwe-database kuyashesha futhi kunokwethenjelwa. Khumbula nje:
- Gcina kube mfushane . Ngenxa yokuthi ukhiye oyinhloko usetshenziselwa ukulinganisa nokuqhathanisa, ukhiye obalulekile oyisisekelo ukuthi uhlelo lokuphathwa kwedatha lungakucubungula ngokushesha kunenkinobho eyinhloko eyisisekelo.
- Sebenzisa inombolo yekhi eyinhloko uma kunokwenzeka. I-SQL Server noma ezinye izinhlelo zokuphathwa kwedatha yezinhlelo zokucubungula izinombolo zezinombolo zezinombolo ngokushesha kunezinhlobo zamadatha ezinhlamvu.
- Gcina kube lula. Ungasebenzisi noma yiliphi izinhlamvu ezikhethekile, izikhala ezifakiwe, noma ukuxhunyaniswa kwemali engenayo engenhla nephansi.
- Ungalokothi ushintshe ukhiye oyinhloko ngemuva kokuthi uyinikeze.