Shulou(Shulou.com)06/01 Report--

What the editor shares with you today is what does the independence of the database mean? Many people do not understand, today, in order to let you know more about the independence of the database, so give you a summary of the following content, let's look down together. I'm sure you'll get something.

What is the independence of the database?

Data independence is one of the most important goals of the database system, which makes the data independent of the application. It can be said that the development history of data processing is the history of the continuous evolution of data independence. In the manual management stage, the data and the program are completely intertwined and there is no independence to speak of. If any changes are made to the data structure, the application program also needs to be modified accordingly.

After the emergence of the file system, although the two are separated, in fact, the application still has to reflect the physical details such as the organization and access methods of files on the storage device, so as long as the data has been modified, the program still needs to be changed. One of the important goals of the database system is to really separate the program from the data so that they can develop independently.

Data independence includes physical independence and logical independence of data.

Physical independence means that the user's application is independent of the data stored in the database on disk. That is, how the data is stored on disk is managed by DBMS (DataBase Management System Database Management system). The user program does not need to understand, and the application only deals with the logical structure of the data, so that when the physical storage of the data changes, the application does not have to change.

Logical independence means that the logical structure of the user's application and the database are independent of each other, that is, when the logical structure of the data changes, the user program can remain unchanged.

The independence of data and program separates the definition of data from the program, and DBMS is responsible for the access of data, which simplifies the programming of the application and greatly reduces the maintenance and modification of the application.

These are the details of what the independence of the database means, and do you have anything to gain after reading it? If you want to know more about it, welcome to the industry information!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.