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

This article mainly introduces what are the three types of DBMS architecture, which can be used for reference by friends who need them. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

There are three types of DBMS architecture: single-tier architecture, two-tier architecture and three-tier architecture.

The architecture of DBMS depends on the computer system on which it runs. There are generally three types of DBMS architecture: single-tier architecture, two-tier architecture, and three-tier architecture. Let's take a look at the details below:

1. Single-tier architecture

In this type of architecture, the database is easily requested on the client computer, and any request made by the client can operate on the database without a network connection.

2. Two-tier architecture

In a two-tier architecture, the database system exists on the server machine and the DBMS application exists on the client, and the two machines are connected to each other through a reliable network, as shown in the following figure.

Whenever the client machine makes a request to access a database that exists on the server using a query language such as sql, the server executes the request against the database and returns the results to the client. Application connection interfaces such as JDBC,ODBC are used for interaction between the server and the client.

3. Three-tier architecture

In a three-tier architecture, there is another layer between the client computer and the server computer, as shown in the following figure.

In the three-tier architecture, the client application does not directly communicate with the database system that exists on the server machine, but the client application communicates with the server application. The server application communicates internally with the database system that exists on the server.

Thank you for reading this article carefully. I hope the editor will share what the three types of DBMS architecture are helpful to you. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.