Ipropati yokuHlaliswa kweMpahla kwiDatabase

Ukuqhawulwa kwezilwanyana kulawula indlela kwaye nini utshintsho lwenziwe kwiziko ledatha

Ukuqhawulwa kwezona zinto ziyingxenye ebalulekileyo yeepropati ezithengiswayo zeenkcukacha. Yayipropati yesithathu ye- ACID (i-Atomicity, i-Consistency, Isolation, i-Durability) kwaye ezi zakhiwo ziqinisekisa ukuba idatha iyahambelana kwaye ichanekile.

Ukuqhawulwa kwepropati yipropati ye-level-level elawula iinguqu kunye nokuba zivelaphi na. Enye yeenjongo zokuzihlukanisa kukuvumela ukuthengiswa kwezinto ezininzi kwenzeke ngexesha elifanayo ngaphandle kokuphazamiseka komsebenzi ngamnye.

Indlela yokuHlulwa kweeNkcitho

Ngokomzekelo, ukuba uJoe unika ukuthengiselana kunye nedatha ngexesha elifanayo ukuba uMariya uphatha umthengiso ohlukeneyo, zombini ukuthengiselana kufuneka kusebenze kwiziko leenkcukacha ngendlela ekhethiweyo. Isiseko kufuneka senze yonke intsebenzo kaJoe ngaphambi kokuba enze uMariya okanye i-vice-versa. Oku kuvimbela ukuthengiswa kukaJoe ekufundeni ulwazi oluphakathi oluveliswe njengempembelelo yecandelo lento yokuthengiswa kukaMariya engeyikugqitywa ekugcineni kwi-database. Qaphela ukuba umhlaba wokuzihlalisa awuqinisekisi ukuba yeyiphi intsebenzo eya kuqala, kuphela nje yokuba abayikuphazamisana.

Amanqanaba okuQinisa

Kukho amanqanaba amane okuhlukanisa:

  1. I-Serializable yinqanaba eliphezulu, oko kuthetha ukuba ukuthengiselana kuya kugqitywa ngaphambi kokuba omnye umthengi akwazi ukuqala.
  2. Ukufundwa okuphindaphindiweyo kuvumela ukuthengiselana ukuba kufumaneke xa kuthengiswa umthengi, nangona ingaqedwanga.
  3. Ukuzibophezela okuzivumelayo kuvumela idatha ukuba ifumaneke emva kokuba idata lenziwe kwi-database, kodwa kungekhona ngaphambi koko.
  4. Ukufunda okungaqhelekanga yinqanaba elincinane kunazo zonke kunye nokuvumela ukuba idatha ifumaneke phambi kokuba utshintsho lwenziwe.