what is database schema in DBMS in hindi

Schema ek database management system (DBMS) mein data ka logical structure ya blueprint hota hai. Schema database mein stored data ko organize karne ke liye use kiya jata hai aur ye database ki structure, relationships, constraints, aur properties ko define karta hai.

what is database schema in DBMS in hindi

DBMS के ये Topics के बारे में जानें :-

Schema ke madhyam se database mein tables, views, indexes, functions, stored procedures, aur other database objects ko define kiya jata hai. Schema define karte samay data types, primary keys, foreign keys, constraints, aur other rules bhi specify kiye jate hain. Schema ka upyog data integrity aur data consistency ko maintain karne, data retrieval aur manipulation ko facilitate karne, aur database ko structure aur organization dena ke liye kiya jata hai.

Schema ko do prakar se samajha ja sakta hai:

  1. Logical Schema: Logical schema database ka overall structure aur organization define karta hai. Ye data model (jaise ki Relational, Network, Hierarchical) ke according tables, relationships, aur constraints ko represent karta hai. Logical schema database ke data model ke sath closely related hota hai aur user aur application level par database ka logical view pradan karta hai. Ye schema database design, data relationships, aur data manipulation operations ko define karta hai.

  2. Physical Schema: Physical schema database ki physical storage aur organization ko define karta hai. Ye disk space allocation, file organization, indexes, aur other physical aspects ko represent karta hai. Physical schema database ke underlying storage architecture aur operating system ke sath closely related hota hai. Ye schema database performance, storage optimization, aur data retrieval efficiency ko define karta hai.

Schema definition ko ek baar specify karne ke baad, uska upyog database create, data insertion, data retrieval, aur data manipulation operations ke liye hota hai. Schema database ke structure aur organization ko standardized aur consistent rakhta hai, jisse data integrity aur data quality ka dhyan rakha ja sakta hai. Schema changes ko carefully manage kiya jata hai, taki database consistency aur compatibility maintain ki ja sake.

Samanya taur par, ek database multiple schemas ko contain kar sakta hai. Har schema apne unique namespace aur object definitions ke saath hota hai, jisse data isolation aur access control prapt hota hai. Schema-based access control se authorized users ko unke specific schemas tak hi restricted access milta hai, jisse data security aur privacy ka dhyan rakha ja sakta hai.

Overall, schema database ke logical aur physical structure ko define karta hai aur data ko organize karne mein madad karta hai.

2 thoughts on “what is database schema in DBMS in hindi”

Leave a Comment