DBMS Architecture 

 DBMS Architecture Kya Hota Hai?

DBMS Architecture ka matlab hota hai kaise database system design kiya gaya hai — matlab kaunse part kis se connected hai aur kis tarah kaam karta hai.

Sochiye DBMS ek building jaise hai — jisme har floor (layer) ka apna kaam hai.

 Types of DBMS Architecture

DBMS mainly 3 tarah ka architecture use karta hai:

1. 1-Tier Architecture

2. 2-Tier Architecture

3. 3-Tier Architecture

Chaliye ek-ek karke simple example aur diagram ke saath samjhte hain 

 1-Tier Architecture

 Kya hota hai?

Isme user directly database ke saath interact karta hai. Sab kuch ek hi machine pe hota hai.

 Real-Life Example:

Aapne MS Access ya Excel pe student project banaya ho — jisme data bhi wahi hai aur software bhi wahi hai.

 Key Point:

• -> No internet/network needed.

• -> Chhoti applications ke liye useful.

 Diagram:

 2-Tier Architecture

 Kya hota hai?

Isme system do parts mein divided hota hai:

• Client (User Interface)

• Server (Database + DBMS)

User ek application ke through database se directly baat karta hai.

 Real-Life Example:

College library software — librarian ke computer mein ek application hoti hai, aur woh central database se data fetch karta hai.

 Key Point:

• -> Secure than 1-tier

• -> LAN ya chhoti organizations ke liye best

 Diagram:

 3-Tier Architecture

 Kya hota hai?

Yeh sabse advanced aur commonly used architecture hai. Isme system 3 layers mein divided hota hai:

1. Presentation Layer – User ka interface (web page, app)

2. Application Layer – Business logic (kaam karne wali layer)

3. Database Layer – Data ko store aur manage karti hai

 Real-Life Example:

College ka student portal jahan:

• Student browser se login karta hai

• Server request ko process karta hai

• Data database se fetch hota hai

 Key Point:

• -> Best security

• -> Zyada users ko support karta hai

• -> Mostly web applications mein use hota hai

 Diagram:

 Comparison Table

 Short Summary

• -> 1-Tier: Sab kuch ek hi jagah pe (software + data)

• -> 2-Tier: Client app → directly server se data leta hai

• -> 3-Tier: User → App Server → Database (sab alag-alag layers)