top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

what logical data Independence rule states?

+3 votes
what logical data Independence rule states?
posted May 15, 2015 by Kunal Kapoor

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote

In practice there are changes you can make to your table structures that won't effect queries, but you have to be careful. SQL is not comprehensive enough allow any logical change. There are known limits of SQL. In real life this is a challenge, but generally dealt with by common practices and certain safeguards (such as copying a table before major logical changes). I think by "logical changes" the rule refers to adding columns, changing column data types, and perhaps even adding and deleting rows. It would be very bad (and unlikely) to design a data warehouse where deleting rows from one table made a query fail. (Where "fail" is "crash". Returning no records when no records exist is not failure from the databases's point of view.)Changes to the logical level (tables, columns, rows, and so on) must not require a change to an application based on the structure. Logical data independence is more difficult to achieve than physical data independence.

answer May 18, 2015 by Manikandan J
0 votes

In simple:

Logical data Independence rule states that users and user programmes should be independent of the logical structure of the database.

answer May 20, 2015 by Arun Gowda