Role of Data Independence in a centralized DBMS

Asked By Abrianna 60 points N/A Posted on - 11/18/2014

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?

• Status: Open
• Question Views: 546
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Sharath Reddy 590495 points N/A #131738

Role of Data Independence in a centralized DBMS

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.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 12/21/2014
• Question Category: Database