0
Logical Data Independence : The ability to change the logical schema without changing the external schema or application programs is called as Logical Data Independence.
Physical Data Independence : The ability to change the physical schema without changing the logical schema is called as Physical Data Independence.
Logical Data Independence :being able to maintain change at external layer without having to make any change at the concept.
Physical Data Independence : we want to be able to make any change on the conceptual level to deal without any change at the physical
Wiki User
∙ 14y ago
Wiki User
∙ 13y agoLogical Data Independence:
Logical data independence is the ability to modify the conceptual schema without having alteration in external schemas or application programs. Alterations in the conceptual schema may include addition or deletion of fresh entities, attributes or relationships and should be possible without having alteration to existing external schemas or having to rewrite application programs.
Physical Data Independence:
Physical data independence is the ability to modify the inner schema without having alteration to the conceptual schemas or application programs. Alteration in the internal schema might include.
* Using new storage devices.
* Using different data structures.
* Switching from one access method to another.
* Using different file organizations or storage structures.
* Modifying indexes.
Wiki User
∙ 13y agoThe ability to change the logical schema without changing the external schema or application programs is called as Logical Data Independence. (being able to maintain change at external layer without having to make any change at the concept.
Physical Data Independence :The ability to change the physical schema without changing the logical schema is called as Physical Data Independence.(we want to be able to make any change on the conceptual level to deal without any change at the physical)
source: What_Logical_data_independence_and_physical_data_independence
Add your answer:
Earn +20 pts
Why logical data independence is more difficult than physical data independence?
Logical data independence is considered more difficult than physical data independence because it involves changes to the conceptual schema and external schema, which are more closely tied to the way data is organized and viewed in the application. Physical data independence, on the other hand, deals with changes to the internal schema, which is more abstract and can be modified with less impact on the overall system.
What Logical data independence and physical data?
what is physical datd independence
Which one between logical and physical data independent is harder to achieve and why?
the logical data independence is hard to achieve because all the manipulation is belonging in logical data independence but in physical data independence only show the physical view .
2.5 What is the difference between logical data independence and physical data independence?
Logical data independence refers to the ability to change the conceptual schema without affecting the external schema or application programs. Physical data independence, on the other hand, refers to the ability to change the physical schema without affecting the conceptual schema. This allows changes in the storage structure or access methods without changing how data is viewed or accessed by applications.
How it is related to data independence?
Hi, Data Independence refers to the immunity of user application to make changes in the definition and organization of Data. There are three types of Data Independence - 1. Logical Data Independence - The ability to change the logical (conceptual) schema without changing the External schema (User View) is called logical data independence. 2. Physical Data Independence - The ability to change the physical schema without changing the logical schema is called physical data independence. 3. View Data Independence - always independent,no effect.
Is it harder to achieve logical data independence or physical data independence?
It is generally considered more difficult to achieve logical data independence compared to physical data independence. Logical data independence involves separating the conceptual structure of the data from the physical storage aspects, which can be complex depending on the database design. Physical data independence primarily deals with shielding the application from changes in the storage structure, which is usually more straightforward to achieve.
What do you mean by data independence?
Data independence refers to the ability to make changes in the database structure without affecting the applications that use the data. It is achieved through different levels: physical, logical, and view-level independence. This helps in isolating the applications from underlying changes, providing flexibility and reducing dependency.
Distinguish between logical data independence and physical data independence?
logical data : refer to the immunity of the external scheme towards changes in the conceptual scheme.physical data: refer to the immunity of the conceptual scheme towards changes in the internal scheme.
Does a relational model provide physical and logical data independence?
Since a user can define a views, logical data independence can achieved by using view definition to hide changes in the conceptual schema. since the sql user has no knowledge of how the data is physically represented, relying solely on the relation abstraction for querying, physical data independence is also achieved.
Which of the two types of Data Independence Types is harder to achieve?
The ability to modify a scheme definition in one level without affecting a scheme definition in next higher level is called data independence there are two types of data independence physical data independence:- refers to the ability to modify the scheme followed at the physical level without affecting the scheme followed at logical level logical data independence:- refers to the ability to modify the conceptual scheme without affecting the schemes followed at view level logical independence is difficult to achieve
What is the difference between logical and physical data independence?
The logical data independence is the ability to modify a logical schema without making external view or application program change. The physical data independence is the ability to modify a physical schema without making external view or application prrogram change.
Explain the difference of internal external and conceptual schemas how are these schema layers related to the concept of logical and physical data independence?
External schemas allows data access to be customized (and authorized) at the level of individual users or groups of users. Conceptual (logical) schemas describes all the data that is actually stored in the database. While there are several views for a given database, there is exactly one conceptual schema to all users. Internal (physical) schemas summarize how the relations described in the conceptual schema are actually stored on disk (or other physical media). External schemas provide logical data independence, while conceptual schemas offer physical data independence.
