What is database schema? How many layers does the database architecture have?

1: What is database architecture

DBMS architecture helps in the design, development, implementation and Maintenance, the database can store the critical information of the enterprise, and choosing the right database architecture can help to access the data quickly and securely.

2: The database architecture has several layers

1-layer architecture

The simplest database architecture is 1-layer, in which the client, server and The databases all reside on the same machine. Whenever a 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

Two-tier architecture is a database architecture where the presentation layer runs on the client (PC, mobile device, tablet, etc.) and the data is stored on the server.

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

3-tier architecture

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

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

Application layer (server)

Database server

The 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) is also responsible for passing data to the user or Functional logic, constraints and rules are processed before being passed down to the DBMS

Three-tier architecture is the most popular DBMS architecture.

Three: Summary

DBMS architecture helps in the design, development, implementation and maintenance of databases.

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

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

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

What is the database architecture? There are several layers of database architecture that are fully introduced. If you want to know more about MySQL tutorial, please pay attention to the php Chinese website.

The above is the detailed content of What is database schema? How many layers does the database architecture have?. For more information, please follow other related articles on the PHP Chinese website!