Q.2)

  Illustrate and explain the complete architecture of a DBMS system in detail.





Database Architecture

Database Architecture DBMS ke internal components ko refer karta hai, jisme Query Processor, Storage Manager, aur Disk Storage shamil hain. Yeh in components ke beech ke interaction ko bhi define karta hai.

Components of a Database System

Database system mainly Query Processor, Storage Manager, aur Disk Storage mein divided hota hai. Inhe neeche detail mein explain kiya gaya hai.

System Diagram Overview (Diagram Labels)



  • DBA → Database Schema → DDL Compiler

  • Users → Queries → Query Processor

  • Application Programs → Application Programs → DML Compiler

DBMS (dashed box) ke andar hota hai:

  • Data Dictionary Manager

  • Query Optimizer

  • Scheduler

  • Recovery Manager

  • Authorization Control

  • Command Processor

  • Transaction Manager

  • Buffer Manager

  • Database Manager

  • Integrity Checker

  • Data Manager

(Yeh sab Data Files aur Data Dictionary se connected hote hain).

1. Query Processor

Yeh end-user se application program ke through aane wali requests (queries) ko instructions mein interpret (translate) karta hai. Yeh DML compiler se aane wali user request ko execute bhi karta hai. Query Processor mein yeh components hote hain:

  • DML Compiler: Yeh DML statements ko low-level instructions (machine language) mein process karta hai, taaki unhe execute kiya ja sake.

  • DDL Interpreter: Yeh DDL statements ko process karke tables ka ek set banata hai jisme meta-data (data about data) hota hai.

  • Embedded DML Pre-compiler: Yeh application program mein embedded DML statements ko procedural calls mein process karta hai.

  • Query Optimizer: Query Optimizer DML Compiler dwara generate ki gayi instructions ko execute karta hai aur best query plan choose karke query execution efficiency ko improve karta hai. Yeh indexing, join order, aur available system resources jaise factors ko consider karta hai. Example ke liye, agar ek query mein do badi tables ko join karna hai, toh optimizer execution time ko minimize karne ke liye best join order select karega.

2. Storage Manager

Storage Manager database mein stored data aur aane wali queries ke beech ek interface ka kaam karta hai. Ise Database Control System bhi kaha jata hai. Yeh constraints apply karke aur DCL statements execute karke database ki consistency aur integrity maintain karta hai. Yeh database mein data ko update, store, delete aur retrieve karne ke liye responsible hai. Isme yeh components hote hain:

  • Authorization Manager: Yeh role-based access control ensure karta hai, yani check karta hai ki kisi particular person ke paas requested operation perform karne ka privilege (permission) hai ya nahi.

  • Integrity Manager: Jab database modify hota hai, tab yeh integrity constraints ko check karta hai.

  • Transaction Manager: Yeh concurrent access ko control karta hai by performing operations in a scheduled way. Is tarah yeh ensure karta hai ki transaction execute hone se pehle aur baad mein database ek consistent state mein rahe.

  • File Manager: Yeh file space aur database mein information ko represent karne ke liye use hone wale data structure ko manage karta hai.

  • Buffer Manager: Yeh cache memory aur secondary storage se main memory ke beech data transfer ke liye responsible hota hai.

3. Disk Storage

Yeh physical storage ko handle karta hai aur isme yeh essential components hote hain:

  • Data Files: Yeh database mein actual data ko store karti hain.

  • Data Dictionary: Isme database objects (jaise tables, constraints, aur relationships) ke structure ki information hoti hai. Yeh metadata (data about data) ko govern karne wali information ka repository hai.

  • Indices: Yeh DBMS ko records jaldi find karne mein madad karke faster data retrieval provide karta hai, jisse query performance kaafi improve hoti hai.

Levels of DBMS Architecture

Ek Database Management System (DBMS) ke structure ko teen main components mein divide kiya ja sakta hai:

1. Internal Level

Yeh level database mein data ki physical storage ko represent karta hai. Yeh storage devices, jaise hard drives ya solid-state drives (SSDs) se data store aur retrieve karne ke liye responsible hota hai. Yeh low-level implementation details ke saath deal karta hai, jaise data compression, indexing, aur storage allocation.

2. Conceptual Level

Yeh level database ke logical view ko represent karta hai. Yeh database mein data ki overall organization aur unke beech ke relationships se deal karta hai. Yeh data schema define karta hai, jisme tables, attributes, aur unke relationships shamil hote hain. Conceptual level kisi specific DBMS software par depend nahi karta (independent hota hai) aur isko different DBMS ka use karke implement kiya ja sakta hai.

3. External Level

Yeh level database ke user's view ko represent karta hai. Yeh is baat se deal karta hai ki users database mein data ko kaise access karte hain. Yeh users ko unke samajh aane wale format mein data dekhne allow karta hai, bina underlying implementation details ki chinta kiye. External level database ke liye aise views ya interfaces ka set provide karta hai, jo specific user groups ki needs ko meet karne ke liye tailored (customized) hote hain.

Schema Mapping in DBMS

Yeh teenon levels schema mapping ke through aapas mein connected hote hain, jo yeh ensure karta hai ki ek level par hone wale changes (e.g., conceptual level par) dusre levels mein accurately reflect hon. Yeh process data independence maintain karta hai, jisse logical ya user views ko affect kiye bina physical storage (internal level) mein changes kiye ja sakte hain.

Comments

Post a Comment

Popular posts from this blog

Q.1)

Q1) What is normalization in databases? Why is it important? Describe the normal forms (1NF, 2NF, 3NF, 4NF, and BCNF) with appropriate examples. Normalization Normalization ek systematic process hai jisme database ke data ko organize kiya jata hai taaki redundancy (duplicacy) eliminate ho aur data integrity ensure ho sake. Yeh badi tables ko smaller, well-structured tables mein divide karta hai aur unke beech relationships establish karta hai. Yeh ensure karta hai ki har table ek single concept ko represent kare, jisse insert, update aur delete operations ke dauran aane wali anomalies (errors) kam ho jayein. Yeh repetitive data ko minimize karke aur logical data grouping ensure karke query efficiency ko improve karta hai. Yeh consistency maintain karne mein madad karta hai by ensuring ki har attribute sirf key, puri key, aur kuch nahi balki sirf key par depend kare. Yeh storage wastage ko reduce karta hai aur relational databases mein optimal performance ensure karta hai. Yeh database ...
Read more