Impahla Yokuhlukanisa I-Database

Ukuzihlukanisa kulawula ukuthi izinguquko zenziwa kanjani futhi uma kwenziwa nini ku-database

Ukuhlukaniswa okuyingxenye yingxenye ebalulekile yezindawo zokuthengiswa kwedatha. Yimpahla yesithathu ye- ACID (i-atomicity, i-Consistency, Isolation, i-Durability) futhi lezi zakhiwo ziqinisekisa ukuthi idatha iyaqhubeka futhi inembile.

Ukuhlukaniswa kwempahla yisakhiwo semininingwane yedatha esilawula ukuthi izinguquko zenziwa kanjani futhi uma zibonakala komunye nomunye. Enye yezinhloso zokuzihlukanisa ukuvumela ukuthengiselana okuningi kwenzeka ngesikhathi esisodwa ngaphandle kokuthinta ukukwenziwa komunye nomunye.

Indlela UkuSusa Ukusebenza Kusebenza Kanjani

Isibonelo, uma uJoe ebeka ukuthengiselana ngokumelene nedatha ngesikhathi esifanayo ukuthi uMariya uphawula ukuthengiselana okuhlukile, kokubili ukuthengiselana kumele kusebenze kwi database ngendlela ehlukile. I-database kufanele yenza yonke into kaJoe ngaphambi kokukhipha uMary noma okuyi-vice-versa. Lokhu kuvimbela ukuthengiswa kukaJoe ngokufunda idatha ephakathi okukhiqizwa njengomphumela ohlangothini lwezingxenye zokuthengiswa kukaMariya ezingeke zenzeke ekugcineni kwedatha. Qaphela ukuthi impahla yokuzihlukanisa ayiqinisekisi ukuthi yikuphi ukuthengiselana okuzokwenza kuqala, kuphela ukuthi ngeke kuphazamisane.

Izinga lokuSusa

Kunamazinga amane okuhlukaniswa:

  1. I-Serializable yizinga eliphakeme kakhulu, okusho ukuthi ukuthengiselana kuzoqedwa ngaphambi kokuba omunye umthengi akwazi ukuqala.
  2. Ukufundwa okuphindaphindiwe kuvumela ukuthengiselana kufinyeleleke uma ukuthengiswa sekuqalile, nakuba kungakapheli.
  3. Ukuzibophezela okufundiwe kuvumela idatha ukuthi ifinyelelwe ngemuva kokuthi idatha yenziwe ku-database, kodwa hhayi ngaphambi kwalokho.
  4. Funda okungavunyelwe yizinga elingezansi kunazo zonke lokuzihlukanisa futhi ivumela idatha ukuthi ifinyelelwe ngaphambi kokuthi kwenziwe izinguquko.