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 тЖТ