Isolation Property in Database

Isolation inodzora kuti sei uye kana kuchinja kunogadzirwa sei mu database

Isolation ndiyo chikamu chinokosha chekutengeserana kwepa database. Icho chinhu chechitatu che ACID (Atomicity, Consistency, Isolation, Durability) uye zvinhu izvi zvinochengetedza kuti data yakagadzikana uye yakarurama.

Isolation ndiyo inzvimbo yepamusoro-yepamusoro-soro inotarisira kuti uye sei kana kuchinja kunenge kwaitwa uye kana vakazoonekwa kune mumwe nemumwe. Imwe yezvinangwa zvekuzviparadzanisa ndeyekubvumira kutengesa kwakawanda kunoitika panguva imwe chete pasina kuchinjanisa kusarudzwa kweumwe.

Kuita Isolation Kushanda Sei

Semuenzaniso, kana Joe achitaura mutengesi kune database pane imwechete iyo Mariya anotaura nezvekutengeserana kwakasiyana, zvose zviri kutengeserana zvinofanira kushanda pane dheedheni nenzira iri yoga. Dhiyabhorosi inofanira kuita Joe yekutengesa kusati yasvika Mariya kana kuti vice-versa. Izvi zvinodzivirira kutengesa kwaJoea kubva pakuverenga dhepfenyuro yakadhindwa inobudiswa sechikamu chechikamu chechikamu chekutengesa kwaMariya izvo zvisingagone kuendeswa kune dhesi. Cherechedza kuti nzvimbo yega yoga inenge isina kudzivirira haisimbisi kuti mutengesi uchaita sei pakutanga, kungoti havazopindirani.

Isolation Levels

Pane maitiro mana okuzvimirira:

1. Zvinotarisirwa ndiyo yepamusoro-soro, izvo zvinoreva kuti kutengesa kuchapedzwa mushure mumwe mutengo unogona kutanga.
2. Kudzokorora kunoverengeka kubvumira kutengesa kunowanikwa kana mutengesi watanga, kunyange zvazvo usina kupera.
3. Kuzvidzivirira kunobvumira kuti data iwanikwe mushure mekunge data yaitwa kune dhesiyo, asi zvisati zvamboitika.
4. Verenga usina kugadziriswa ndiyo yakaderera yega yega yega uye inobvumira deta kuti iwanikwe musati machinja.