Episode : 7 - DataGaav Mein Isolation Levels Ka Jaadu: Gudiya Beti Ko Samjhana

 

Sence1 : DataGaav Mein Isolation Levels Ka Jaadu: Gudiya Beti Ko Samjhana

Gudiya beti ko isolation levels ka jaadu samajh mein nahi aaya, toh chachi ne Mongo Baba se request kiya ki thoda aur simple aur interesting tareeke se samjhaye. Mongo Baba ne phir se apne magic potli se ek kahani nikali, jisme isolation levels ka jaadu asaani se samajh aayega.


Isolation Levels: A Story of Gudiya's Toy Shop

Imagine karo, Gudiya beti ek toy shop chalati hai jahan par bahut sare bachhe ek saath khilone lene aate hain. Gudiya ke paas 4 tareeke hain jisse wo ensure kar sake ki sab bachon ko unke pasand ke khilone mil jaye bina kisi jhagade ke. Ye 4 tareeke hi MySQL ke Isolation Levels hain.

1. READ UNCOMMITTED:

  • Scenario: Ek chhota bachha shop mein ghusa aur dekha ki Gudiya ne ek naya teddy bear shelf par rakh diya. Lekin teddy bear abhi properly set nahi hua tha (yaani ki abhi transaction commit nahi hui thi).
  • Result: Us bachhe ne wo teddy bear utha liya, lekin wo defective nikla, kyunki Gudiya ne abhi apna kaam complete nahi kiya tha. Matlab, Gudiya ne abhi apna transaction commit nahi kiya tha, lekin bachhe ne pehle hi dekh liya aur apne teddy bear mein error dekh liya.
  • Explanation: READ UNCOMMITTED mein, ek transaction ke incomplete (uncommitted) changes doosre log dekh sakte hain. Yeh level sabse kam secure hai.

2. READ COMMITTED:

  • Scenario: Is baar Gudiya ne teddy bear shelf par properly rakh diya, aur abhi abhi apna kaam complete kiya (transaction commit kiya). Ab doosra bachha shop mein aaya aur usne woh teddy bear dekha.
  • Result: Us bachhe ko ekdum sahi teddy bear mila, jo properly set tha (committed changes).
  • Explanation: READ COMMITTED mein, ek transaction ke sirf committed changes hi doosre log dekh sakte hain. Incomplete ya uncommitted changes nahi dekhe ja sakte.

3. REPEATABLE READ:

  • Scenario: Gudiya beti ne abhi abhi teddy bear shelf par rakh diya, aur ek bachha aaya aur usne us teddy bear ko dekha. Usne decide kiya ki wo thoda aur shop mein ghoom kar phir se teddy bear dekhega.
  • Result: Jab bhi wo bachha us teddy bear ko dekhta hai, usko hamesha wahi teddy bear waisa hi dikhta hai, chahe shop mein aur bhi teddy bears rakh diye gaye ho ya hataye gaye ho. Matlab, jab tak wo bachha shop mein hai, us teddy bear ki image uske liye consistent rahegi.
  • Explanation: REPEATABLE READ mein, ek transaction ke dauran jo bhi data dekha jata hai, wo hamesha consistent rehta hai, chahe doosri transactions execute ho rahi ho.

4. SERIALIZABLE:

  • Scenario: Gudiya beti apne shop mein ek strict rule follow karti hai. Har bachha ek time mein sirf ek teddy bear ko hi dekh sakta hai. Dusra bachha tab tak wait karega jab tak pehla bachha apne teddy bear ko check kar ke apna decision nahi le leta.
  • Result: Is rule se koi jhagda nahi hota, kyunki har bachha ek ke baad ek apne pasand ke teddy bear ko peacefully choose kar leta hai.
  • Explanation: SERIALIZABLE mein, transactions ko serially, ek ke baad ek execute kiya jata hai, jaise sab bachhe line mein khade ho kar apni bari ka wait karte hain. Yeh level sabse zyada secure hai, lekin performance slow ho sakta hai.

Gudiya Beti Ki Seekh:

Gudiya beti ne ab yeh samajh liya ki isolation levels kaise kaam karte hain. Usko samajh aaya ki:

  1. READ UNCOMMITTED: Kabhi kabhi galtiyaan ho sakti hain, kyunki incomplete data dikhta hai.
  2. READ COMMITTED: Sirf complete (commit) hua data dikhai deta hai.
  3. REPEATABLE READ: Jo data pehli baar dekha, wo hamesha waisa hi rahega transaction ke dauran.
  4. SERIALIZABLE: Sabko ek ke baad ek apna kaam karna padta hai, toh sabko sahi aur safe data milta hai.

Chachi ne bhi yeh kahani sun kar Gudiya beti ki muskaan dekhi, aur usse samajh mein aa gaya ki ab uski gudiya ko MySQL ke isolation levels ka jaadu samajh mein aa gaya hai.


DataGaav mein aaj ki kahani yahi khatam hoti hai. Aur koi sawaal ya kahani ka part samajh mein nahi aaya ho, to batao!


Sence2 : DataGaav Mein Mongo Baba Ka Jaadu: Dusre Gaanv Ke Bacchon Ke Sawal

Dusre gaanv ke bacche bhi DataGaav mein aa gaye aur Mongo Baba se MongoDB ke aur bhi secrets jaan'ne lage. Baba ne apni kahaniyon ke zariye unhein sab kuch samjhane ka wada kiya.


1. MapReduce: Bacchon Ko Data Ka Jaadu Samjhana

MapReduce ek jaadu hai jo data ko process karne ke liye use hota hai, jab data bahut bada hota hai aur usse efficiently handle karna padta hai.

MapReduce Ka Kissa:

  • Map (Batao):

    • Bacchon ko apni apni roti banani hai. Sab apne apne aata, paani aur ingredients alag alag le kar apni rotiyan banane lagte hain. Ye Map process hai, jisme sab apna kaam alag alag kar rahe hain.
  • Reduce (Jodo):

    • Ab sab apni apni rotiyan ek jagah lekar aate hain aur unhe mila kar ek badi thali banayi jati hai. Ye Reduce process hai, jisme sabka kaam mila kar final result tayar hota hai.

    Example: Agar Ravi ko class ke sab bachon ke marks ka average nikalna hai:

    • Map: Sab bachon ke marks alag alag collect karte hain.
    • Reduce: Sab marks ko add karte hain aur unka average nikalte hain.

2. Splitting: Jaadu Ke Hisse

  • Splitting ka matlab hota hai data ko chhote chhote hisso mein tod dena, taaki data ko process karna asaan ho jaye. Bacchon ke school mein exam ke papers alag alag students ko distribute kiye jaate hain, taaki sab mil kar jaldi se checking kar sake. Ye splitting ka jaadu hai.

    Example: Agar Ravi ko poore gaav ke logon ke tax data ko process karna hai, to wo us data ko multiple computers par split kar dega, taaki sab data jaldi process ho jaye.

3. save() Method: Bachon Ki Bachat Ka Jaadu

  • save() method ka use tab hota hai jab hum MongoDB mein koi document save ya update karna chahte hain. Jaise bacche apne piggy bank mein paisa daal kar save karte hain, waise hi MongoDB mein documents ko save() method ke zariye database mein store karte hain.

    Example: Ravi ko apne project ke details MongoDB mein save karne hain:


    db.projects.save({name: "Science Project", marks: 95});

4. MongoDB Ka Use: Bacchon Ka Library Ka Jaadu

  • MongoDB ka use tab hota hai jab hume data ko store karna ho, access karna ho, aur manage karna ho. Ye ek library ki tarah kaam karta hai, jahan bahut saare books (data) rakhe jaate hain, aur hum unhe zaroorat padne par nikal kar padh sakte hain.

    Example: Gaav ke library mein sab bachon ki favourite books rakhi hoti hain, aur wo kabhi bhi jaake apni favourite books nikal kar padh sakte hain. Yehi kaam MongoDB data ke saath karta hai.

5. DB Command Ka Purpose: Data Ka Hukum

  • DB command ka use MongoDB mein data ko control karne ke liye hota hai. Jaise ek teacher class mein hukumat karta hai ki kaunse topics padhe jaayenge, waise hi DB command MongoDB mein define karta hai ki data ke saath kya karna hai.

    Example: Agar Mongo Baba ko pata lagana hai ki kaunsi databases gaav ke log use kar rahe hain, to wo yeh command use karenge:


    show dbs;

Dusre Gaanv Ke Bacchon Ka Samjhadari

Dusre gaanv ke bacche bhi khushi khushi Mongo Baba ke sab jaadu samajh kar chale gaye. Unhone yeh samajh liya ki MongoDB ke MapReduce, Splitting, save(), aur DB commands kitne powerful tools hain jo data ko manage karne mein madad karte hain.

DataGaav mein aaj ka episode yahin khatam hota hai. Agle episode mein fir milenge kisi naye kisse ke saath!

Post a Comment

0 Comments