What is Data Independence in DBMS in Hindi
What is Data Independence in DBMS in Hindi
What is Data Independence in DBMS in Hindi :
Data Independence Data transparency рдХрд╛ рдкреНрд░рдХрд╛рд░ рд╣реИ рдЬреЛ рдПрдХ centralized DBMS рдХреЗ рд▓рд┐рдП Value рд░рдЦрддрд╛ рд╣реИред рдпрд╣ Data рдХреА definition рдФрд░ organization рдореЗрдВ рдХрд┐рдП рдЧрдП changes рдХреЗ рд▓рд┐рдП users applications рдХреА Immunity рдХреЛ Referenced рдХрд░рддрд╛ рд╣реИред Application programs idealрд░реВрдк рд╕реЗ, Data representation рдФрд░ storage рдХреА details рдХреЗ contact рдореЗрдВ рдирд╣реАрдВ рд╣реЛрдирд╛ рдЪрд╛рд╣рд┐рдПред DBMS Data рдХрд╛ рдПрдХ abstract view provide рдХрд░рддрд╛ рд╣реИ ред
Data Independence рдХреЗ 2 Type рдХреЗ рд╣реЛрддреЗ рд╣реИрдВ :
1. physical data independence
2. logical data independence
Data Independence рдФрд░ operation Independence рдПрдХ рд╕рд╛рде Data abstraction рдХреА рд╕реБрд╡рд┐рдзрд╛ рджреЗрддрд╛ рд╣реИред Data Independence рдХреЗ рджреЛ Type рд╣реИрдВред
First Level of Data Independence
Data рдХреЗ logical structure рдХреЛ 'schema definition' рдХреЗ рд░реВрдк рдореЗрдВ рдЬрд╛рдирд╛ рдЬрд╛рддрд╛ рд╣реИред рд╕рд╛рдорд╛рдиреНрдп рддреМрд░ рдкрд░, рдпрджрд┐ рдХреЛрдИ user Application рдХрд┐рд╕реА relation рдХреЗ attributes рдХреЗ subset рдкрд░ рд╕рдВрдЪрд╛рд▓рд┐рдд рд╣реЛрддрд╛ рд╣реИ, рддреЛ рдмрд╛рдж рдореЗрдВ рддрдм affected рдирд╣реАрдВ рд╣реЛрдирд╛ рдЪрд╛рд╣рд┐рдП рдЬрдм рдПрдХ рд╣реА Relation рдореЗрдВ рдирдИ attributes Add рдХрд┐рдпреЗ рдЬрд╛рддреЗ рд╣реИрдВред Logical Data Independence indicates рдХрд░рддреА рд╣реИ рдХрд┐ рдореМрдЬреВрджрд╛ Schema рдХреЛ affected рдХрд┐рдП рдмрд┐рдирд╛ conceptual schema рдХреЛ рдмрджрд▓рд╛ рдЬрд╛ рд╕рдХрддрд╛ рд╣реИред
Second Level of Data Independence
Data рдХреЗ physical structure рдХреЛ "physical data description" рдХрд╣рд╛ рдЬрд╛рддрд╛ рд╣реИред physical data independence users application рд╕реЗ storage structure рдХреЗ details рдХреА hiding рд╕реЗ рд╕рдВрдмрдВрдзрд┐рдд рд╣реИ:
1.logical data independence: logical schema (User View) рдХреЛ рдмрджрд▓реЗ рдмрд┐рдирд╛ logical (conceptual) schema рдХреЛ рдмрджрд▓рдиреЗ рдХреА ability рдХреЛ logical data independence рдХрд╣рд╛ рдЬрд╛рддрд╛ рд╣реИред рдЙрджрд╛рд╣рд░рдг рдХреЗ рд▓рд┐рдП, conceptual schema рдореЗрдВ new entities, attributes рдпрд╛ relationships рдХреЛ addition рдпрд╛ removal рдпрд╛ existing application program рдХреЛ рдлрд┐рд░ рд╕реЗ рд▓рд┐рдЦрдирд╛ред
2.Physical data independence: logical schema рдХреЛ рдмрджрд▓реЗ рдмрд┐рдирд╛ physical schema рдХреЛ рдмрджрд▓рдиреЗ рдХреА ability рдХреЛ physical data independence рдХрд╣рд╛ рдЬрд╛рддрд╛ рд╣реИред рдЙрджрд╛рд╣рд░рдг рдХреЗ рд▓рд┐рдП, internal schema рдореЗрдВ change, рдЬреИрд╕реЗ рдХрд┐ different file organization рдпрд╛ storage structures, storage devices, рдпрд╛ indexing strategy рдХрд╛ рдЙрдкрдпреЛрдЧ рдХрд░рдирд╛, conceptual рдпрд╛ external schemas рдХреЛ рдмрджрд▓рдиреЗ рдХреЗ рдмрд┐рдирд╛ рд╕рдВрднрд╡ рд╣реЛрдирд╛ рдЪрд╛рд╣рд┐рдПред
Related Articles
Advantages and Disadvantages of Database Management System in Hindi
Advantages and Disadvantages of Database Management System in Hindi ...
Read More тЖТWhat is DBMS in Hindi | What is Database Management System in Hindi | Introduction of DMBS in Hindi
What is DBMS in Hindi | What is Database Management System in Hindi | Introduction of DMBS i...
Read More тЖТWhat is Data Model in DBMS in Hindi | Types of Data Models in DBMS in Hindi
What is Data Model in DBMS in Hindi | Types of Data Models in DBMS in Hindi Data Model Data description, ...
Read More тЖТWhat is an Entity in DBMS in Hind | Entity type in DBMS in Hindi | what is Entity set in DBMS in Hindi
What is an Entity in DBMS in Hind | Entity type in DBMS in Hindi | what is Entity set in DBMS in Hindi...
Read More тЖТER Data Model in DBMS in Hindi | Entities and Attributes in DBMS in Hindi
ER Data Model in DBMS in Hindi | Entities and Attributes in DBMS in Hindi ...
Read More тЖТ