Izihluthulelo zeDeskithophu yindlela elula yokudala idatha yokuxhumana ephumelelayo
Njengoba kungenzeka usuvele wazi, imininingwane yolwazi isebenzisa amatafula ukuhlela ulwazi. (Uma ungenalo ulwazi oluyisisekelo nemiqondo yedatha, funda i-Database? ) Ithebula ngalinye linamarowu amaningi, ngalinye lihambisana nerekhodi elilodwa lemininingwane. Ngakho-ke, imininingwane yolwazi igcina kanjani lawo marekhodi ngqo? Kungenxa yokusebenzisa okhiye.
Amakhidi ayisisekelo
Uhlobo lokuqala lokhiye esizoxoxa ngalo luyisihluthulelo esiyinhloko . Yonke ithebula lemininingwane kufanele libe nekholomu eyodwa noma ngaphezulu ekhethiwe njengekhiye eyinhloko . Ukubaluleka kwalesi sikhiye kubamba kufanele kube okuhlukile kwirekhodi ngalinye ku-database.
Isibonelo, cabanga ukuthi sinetafula elibizwa ngokuthi Abasebenzi eliqukethe ulwazi lomsebenzi kubo bonke abasebenzi ku-firm yethu. Sidinga ukukhetha ukhiye oyinhloko oyenawo ozokhomba ngokukhethekile umsebenzi ngamunye. Umcabango wakho wokuqala kungenzeka ukuthi usebenzise igama lomsebenzi. Lokhu ngeke kusebenze kahle ngoba kubonakala sengathi uzoqasha abasebenzi ababili ngegama elifanayo. Kungcono ukhethe ukusebenzisa inombolo ye-ID yomsebenzi ohlukile oyinikezela isisebenzi ngasinye uma kuqashwe. Ezinye izinhlangano zikhetha ukusebenzisa i-Social Security Numbers (noma izikhombisi ezifanayo zikahulumeni) kulo msebenzi ngoba isisebenzi ngasinye sesivele sinalo futhi siqinisekisiwe ukuthi sihlukile. Kodwa-ke, ukusetshenziswa kweNombolo yokuPhepha kwezenhlalakahle kule njongo kuyinkinga kakhulu ngenxa yokukhathazeka kwangasese. (Uma usebenzela inhlangano kahulumeni, ukusetshenziswa kweNombolo Yokuphepha Komphakathi kungase kube nomthetho ngaphansi koMthetho Wobumfihlo ka-1974.) Ngenxa yalesi sizathu, izinhlangano eziningi ziye zashintsha ekusebenziseni izihlonzi eziyingqayizivele (ID yomsebenzi, i-ID yomfundi, njll. .) ezingahlanganyeli nalezi zinto eziyimfihlo.
Uma usuqedile ukhiye oyinhloko futhi usethe i-database, uhlelo lokuphathwa kwedatha luzophoqelela ukuhlukile kwesihluthulelo.
Uma uzama ukufaka irekhodi etafuleni ngekhibhodi eyinhloko ephinda irekhodi ekhona, ukufaka kuzohluleka.
Iningi yolwazi lukwazi futhi ukukhiqiza izihluthulelo zabo eziyinhloko. Ukufinyelela kwe-Microsoft, ngokwesibonelo, kungalungiswa ukusebenzisa uhlobo lwe-AutoNumber yedatha ukuze unikeze i-ID eyingqayizivele kumrekhodi ngamunye etafuleni. Ngenkathi isebenza kahle, lokhu kuyimiklamo emibi yokuklama ngoba ikushiya ngenani elingenangqondo kumrekhodi ngamunye etafuleni. Kungani ungasebenzisi leso sikhala ukugcina into ewusizo?
Izinkambo zangaphandle
Olunye uhlobo luyisihluthulelo sangaphandle , esetshenziselwa ukudala ubuhlobo phakathi kwamatafula. Ubuhlobo bemvelo bukhona phakathi kwamatafula ezinhlobonhlobo eziningi zesisekelo. Ukubuyela kubasebenzi bethu basebenzi, sicabange ukuthi sifuna ukwengeza itafula equkethe ulwazi lomnyango kwi database. Leli tafula elisha lingase libizwa ngokuthi iMinyango futhi lingaqukatha ulwazi oluningi mayelana nomnyango wonke. Siphinde sifuna ukufaka ulwazi mayelana nabasebenzi emnyangweni, kodwa kungaba ngaphezulu ukuthola ulwazi olufanayo ematafuleni amabili (Abasebenzi kanye neMinyango). Kunalokho, singakha ubudlelwano phakathi kwamatafula amabili.
Ake sicabange ukuthi iMinyango ithebula isebenzisa ikholomu Igama lomnyango njengesihluthulelo esiyinhloko. Ukwakha ubudlelwane phakathi kwamatafula amabili, sengeza ikholomu entsha kwiThebula labasebenzi elibizwa ngokuthi uMnyango. Sabe sigcwalisa igama lomnyango lapho umsebenzi ngamunye ekhona. Siphinde sitshele uhlelo lokuphathwa kwedatha ukuthi ikholomu yoMnyango etafuleni labasebenzi liyisihluthulelo sangaphandle esichaza ithebula leMinyango.
I-database izobe iphoqelele ubuqotho bokubheka ngokuqinisekisa ukuthi zonke izindinganiso emkhombeni weMinyango weThebula labasebenzi zinamakholi afanayo etafuleni loMnyango.
Qaphela ukuthi ayikho isibopho esiyingqayizivele sokhiye wangaphandle. Singase (futhi cishe kungenzeka) sibe nesisebenzi esingaphezu kwesisodwa somnyango owodwa. Ngokufanayo, asikho isidingo sokuthi ukungena kuthebula leMinyango kunoma yikuphi ukungena okuhambisanayo kuthebula labasebenzi. Kungenzeka ukuthi sibe nomnyango ongekho abasebenzi.
Ukuze uthole okwengeziwe ngalesi sihloko, funda Ukudala Amakhidi Wangaphandle .