What is data independence? How is it used to protect the database from changes? What are the two types of data independence? Mention the differences in these two types of approaches. Which of these types is more difficult to achieve? What is a view? How does a view help in achieving logical data independence?
Data independence is a kind of database management where data is separated from the programs that use it. As a basis for the idea of a database management system, this guarantees that the data can’t be reorganized or redefined by the applications that use it. This way, the data stays accessible and stable and cannot be corrupted by applications.
In the environment of a centralized database management, the database management depends on the process of data independence. Although data transparency is still present, programs or applications are not allowed to read and then start to modify the data itself. One of the tasks of data independence is to prevent the user applications from accessing the storage structure of the data.
This way, it is no longer possible for any application to modify the nature of the data since the details of the structure are hidden. There are 2 basic types of data independence, the logical data independence and the physical data independence.
