Ingqibelelo yokubonakalisa yinkcazelo yedatha kwiinkqubo zolawulo lweenkcukacha zobudlelwane. Iqinisekisa ukuba ubudlelwane phakathi kweethala kwi-database buhlala buchanekileyo ngokufaka imithintelo ekukhuseleni abasebenzisi okanye izicelo ukuba bangenise idatha engalungile okanye baxelele idatha engekho.
Iinkcukacha zisebenzisa amatafula ukuhlela ulwazi abanalo. Zifana neesepredishithi, ezifana ne-Excel, kodwa zinamandla kakhulu kubasebenzisi abaphambili. Umsebenzi wesiseko kunye nokusetyenziswa kwezicwangciso eziphambili kunye nezitshixo zangaphandle, ezigcina ubudlelwane phakathi kweetafile.
Eziphambili
Ingundoqo ephambili kwitheyibhile yedatha yesazisi esikhethekileyo esinikezelwe kwirekhodi nganye. Itheyibhile nganye iya kuba neyodwa okanye iikholomu ezikhethiweyo njengeyona nto ephambili. Inombolo yoKhuseleko lweNtlalo ingaba yintloko ephambili yoluhlu lwezithuba zabasebenzi kuba inombolo nganye yeNtlalo yoKhuseleko iyodwa.
Nangona kunjalo, ngenxa yokukhathazeka kwangasese, inombolo ye-ID yenkampani eyabelwe yinto ekhethekileyo yokusebenza njengenjongo ephambili yabasebenzi. Elinye ifowuni ye-database-njenge-Microsoft Access-inikezela ngokubalulekileyo ngokuzenzekelayo, kodwa ikhefu elingenanto ayinalo intsingiselo yangempela. Kungcono ukusebenzisa isitshixo ngentsingiselo kwirekhodi. Indlela elula yokunyanzelisa intembeko yokubaluleka akuvumelekanga ukuvumela utshintsho kwikhiye oyintloko.
Key Key
Ikhonkco yangaphandle yisihlomelo kwitheyibhile efana nentloko ephambili yeetafile ezahlukeneyo. Iqhosha langaphandle lidala ubudlelwane kunye netafile eyahlukileyo, kwaye intembeko yokubonakalisa ibhekisela kulwalamano phakathi kwezi tafile.
Xa itheyibhile enye inekona yangaphandle kwelinye itafile, umgaqo wokuthembeka uthetha ukuba ungenakongeza irekhodi kwitafile equle ikhiye wangaphandle ngaphandle kokuba kukho irekhodi ehambelana netafile edibeneyo. Kwakhona kubandakanya ubuchule obubizwa ngokuba yi-cascading update kunye ne-cascading delete, eqinisekisa ukuba utshintsho olwenziwe kwitafile edibeneyo lubonakaliswe kwitafile eyintloko.
Umzekelo weMigaqo yoBungqina boBulungisa
Cinga imeko apho unetafile ezimbini: Abasebenzi kunye nabaPhathi. Itheyibhile yabasebenzi inomxholo wesigxina sangaphandle onesihloko esithi ManagedBy, esichazela kwingxelo yomphathi ngamnye kumqeshwa wetafile. Inyaniso yokubonakalisa ibambelela kule migaqo emithathu elandelayo:
- Awukwazi ukufaka irekhodi kwitafile zabasebenzi ngaphandle kokuba i-AttededBy attribute ibonisa irekhodi elivumelekileyo kwiThebula labaphathi. Ingqibelelo yokubonakalisa ivimbela ukufakwa kweenkcukacha ezingalunganga kwitafile. Nawuphi na umsebenzi ongenelisekanga umgaqo-mbopheleleko wokubambelela.
- Ukuba isisiseko esisisiseko serekhodi kwiifayile zeGosa liguqulwa, zonke iirekhodi ezihambelana netafile zebasebenzi ziguqulwa ngokusebenzisa ukuhlaziywa kwe-cascading.
- Ukuba irekhodi kwiThebula loLawulo liyakususwa, zonke iirekhodi ezihambelana neetafile zabasebenzi ziyacinywa zisuse i-cascading delete.
Iingenelo zoLungiso lweeNkcazo zokuBambeka
Ukusebenzisa inkqubo yolawulo lweenkcukacha zobudlelwane kunye neentembelelo zokubaluleka kunika inzuzo eninzi:
- Ithintela ukungena kwedatha yedatha.
- Ikhusela itafile enye ekuboniseni insimu engekhoyo kwenye ietafile.
- Ukuqinisekiswa okuqinisekileyo phakathi kwetafile "ezidibeneyo".
- Ikhusela ukususwa kwerekhodi equlethe ixabiso elibhekiswe kwinqhosha langaphandle kwelinye itafile.
- Ithintela ukongeza kwirekhodi etafileni equle ikhiye wangaphandle ngaphandle kokuba kukho ikona ephambili kwitafile edibeneyo.