A transaction jeri ne rukuni na ayyuka da ake magudi da undessu sai daya, ba shakaruwa — duk suka yi nasara tare (COMMIT) ko duk suka gagara tare (ROLLBACK). Huluffin jeri suna ba da garantin ACID, wajen tabbatar da cewa bayanai suna zauna daidai kuma suna tsaya daidai har ma da gazawa ko kummar aiki.
;
accounts balance balance id ;
accounts balance balance id ;
;
Misalin gidaje: yin jiya azurfa. Duka cire da kara dole ne su faru, ko babu diya — in ba haka ba azurfa mai ɓatua ne. Jeri yana garantin haka: idan akwai kudin cin zarafi, ROLLBACK yana baca duk canje-canjen, wajen barin jijiya a matsayinta na asali.
A — ATOMICITY → all operations succeed or all fail (no partial transactions)
C — CONSISTENCY → the database moves from one valid state to another (constraints hold)
I — ISOLATION → concurrent transactions don't interfere (as if run sequentially)
D — DURABILITY → once committed, changes survive crashes (persisted permanently)
Wannan takalmi ne abin da yasa jiya na ala-jiya ya zama amintacciya ga bayanai na mahimmanci.
Without transactions, a failure mid-way leaves data in an inconsistent state:
money debited from one account but not credited to another → data corruption.
Atomicity (all-or-nothing) prevents this — the cornerstone of data integrity for
any multi-step operation (transfers, orders with line items, etc.).
When many transactions run concurrently, ISOLATION controls what they can see of
each other's uncommitted changes. Isolation LEVELS (Read Committed, Repeatable Read,
Serializable) trade off consistency vs performance — higher isolation = more correct
but more locking/contention. (A deeper topic on its own.)
Huluffin jeri da ACID properties sune tushen jijiyar gida mai aminci — su ne abin da yake ba da garantin cewa bayanai suna zauna daidai kuma suna tsaya daidai har ma da gazawa da kummar aiki, wanda ya zama mahimmanci ga kowane aikace-aikacen da ke hanani bayanai masu muhimmanci, don haka fahimtar su ya yiyuwa.
Ainihin muhimmanci shine atomicity (duk-ko babu): kowane aiki da ya shamu mataki masu yawa (cire azurfa, samarwa, sabunta bayanai da ke da dangantaka) dole ne ya yi nasara gaba daya ko babu — in ba haka ba gazawa a tsakar aiki yana bari jijiya a cikin rashin daidaito, jijiya mai ciwo (misalin gidaje: azurfa ta cire amma ba ta kara ba).
Huluffin jeri suna garantin haka tare da COMMIT/ROLLBACK, wajen sauya su masu mahimmanci don daidaito bayanai a ayyuka masu mataki.
Fahimtar gajeriyar ACID takalmi — Atomicity (duk-ko babu), Consistency (matsananci masu inganci), Isolation (jeri da aka kumkarwa ba sa shiga juna), da Durability (canje-canjen da aka mallaka suna tsira cire) — yana bayanin me yasa jiya na ala-jiya ta sa taninsan don bayanai masu muhimmanci (kudin azurfa, odar, kaya).
Sanin cewa isolation yana kula da halayen kummar aiki (tare da matakan kewarewa da suke sadarwa daidaito da iko) yana haɗa da jira jira masu ƙarancin kummar aiki.
Tun jiya daidaito ke mahimmanci ga aikace-aikace mai aminci, kuma tun huluffin jeri (wajen samarwa atomicity da ACID garantin) sune hanya da ke tabbatar da cewa ayyuka masu mataki ba sa shiryar bayanai ba ciwo kuma cewa jijiya ta zauna daidai a hankalin gazawa da kummar aiki, fahimtar huluffin jeri da ACID ita ce mahimmanci, kankancin ilmi ga gida mai aminci — ita ce babbar tushen daidaito jijiya da mahimmancin jira jira aiki wanda ya nuna fahimta da me yasa jijiya ta ba da garantin daidaito.
Ɗakin karatu na tambayoyin hira na IT tare da amsoshi cikakke — daga Junior zuwa Senior.
Ba da Gudummawa