Home >Daily Programming >Mysql Knowledge >Database independence means that the database is independent of what?

Database independence means that the database is independent of what?

烟雨青岚
烟雨青岚Original
2020-07-06 14:58:0213115browse

Database independence means that the database and data structure are independent of each other. The independence of data is one of the basic characteristics of a database system; it can make data independent of applications, data and programs, separate the definition of data from programs, simplify the preparation of application programs, and greatly reduce the number of applications. Maintenance and modification.

Database independence means that the database is independent of what?

Database independence means that the database and data structure are independent of each other.

Data independence is one of the basic characteristics of the database system . Data independence means that applications and data structures are independent of each other and do not affect each other.

In the three-tier schema architecture, data independence refers to the ability of the database system to change the schema at a certain level without changing the schema at the upper level.

It is the two-layer image between the three-level modes that ensures that the data in the database system has high data independence. Data independence includes data logical independence and data physical independence.

Data independence is also one of the most important goals of the database system. It makes data independent of applications.

The independence of data and program separates the definition of data from the program, and the DBMS is responsible for data access, thus simplifying the preparation of application programs and greatly reducing the maintenance and modification of application programs. .

Independence of data and program

Separates the definition of data from the program, and the DBMS is responsible for data access, thus simplifying the application process Compilation, greatly reducing application maintenance and modification. It can be said that the history of data processing is the history of the continuous evolution of data independence. In the manual management stage, data and programs are completely intertwined, and there is no independence at all. Any changes to the data structure require corresponding modifications to the application program.

Independent development

After the emergence of the file system, although the two were separated, the application still had to reflect the organization and storage of files on the storage device. Physical details such as retrieval methods, so as long as the data is modified, the program still needs to be modified. An important goal of the database system is to truly separate programs and data so that they can develop independently.

Recommended tutorial: "MySQL Tutorial"

The above is the detailed content of Database independence means that the database is independent of what?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn