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

Today, what the editor shares with you is the detailed analysis of the database architecture, which many people don't know much about. Today, in order to let you know more about the database architecture, the editor summarizes the following contents. Let's look down together. I'm sure you'll get something.

One: what is the database architecture

The DBMS architecture is helpful to the design, development, implementation and maintenance of the database. The database can store the key information of the enterprise, and choosing the correct database architecture is helpful to access the data quickly and safely.

Second, there are several layers of database architecture.

1-tier architecture

The simplest database architecture is tier 1, where the client, server, and database all reside on the same machine. Whenever the database is installed and accessed in the system, it is a 1-tier architecture, but this architecture is rarely used in production.

2-tier architecture

The two-tier architecture is a database architecture in which the presentation layer runs on the client (PC, mobile devices, tablets, etc.) and stores data on the server.

An application program interface called ODBC (Open Database Connectivity) allows client programs to call DBMS. Today, most DBMS provides ODBC drivers for DBMS, and the 2-tier architecture provides additional security for DBMS because it is not exposed directly to end users. The current example of a two-tier architecture is a contact management system created using MS-Access.

3-tier architecture

The 3-tier architecture is an extension of the 2-tier architecture. The three-tier architecture has the following layers

Presentation layer (PC, tablet, mobile phone, etc.)

Application layer (server)

Database server

The DBMS architecture includes an Application layer between the user and the DBMS, which is responsible for passing the user's request to the DBMS system and sending the response from the DBMS to the user. The application layer (business logic layer) also handles functional logic, constraints and rules before passing data to the user or down to the DBMS

Three-tier architecture is the most popular DBMS architecture.

Three: summary

DBMS architecture contributes to the design, development, implementation and maintenance of databases.

The simplest database architecture is tier 1, where the client, server, and database all reside on the same machine.

A two-tier architecture is a database architecture in which the presentation layer runs on the client and .data is stored on the server.

The three-tier architecture consists of presentation layer (PC, tablet, mobile device, etc.), application layer (server) and database server.

The above is a detailed introduction of the database architecture, of course, the detailed use of the above differences have to be used by everyone to understand. If you want to know more, welcome to follow the industry information channel!

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.