Mene ne huluffin jeri da ACID properties?

Question

Accepted Answer

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.

## Jeri — duk-ko babu

```sql
BEGIN;                                              -- start the transaction
  UPDATE accounts SET balance = balance - 100 WHERE id = 1;   -- debit
  UPDATE accounts SET balance = balance + 100 WHERE id = 2;   -- credit
COMMIT;                                             -- both succeed → save permanently
-- if anything fails: ROLLBACK → undo EVERYTHING (no partial transfer)
```

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.

## ACID — garantin hudu

```text
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.

## Me yasa atomicity ya yiyuwa (buhacar haɗi)

```text
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.).
```

## Kewarewa da kummar aiki

```text
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.)
```

## Me yasa ya yiyuwa

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.