DBMS Architecture | let's update

DBMS Architecture

The DBMS design depends upon its architecture. the basic client/server architecture is used to deal with a large number of PCs, web servers, database servers, and other components that are connected with networks.

The client or server architecture consists of many pcs and a workstation that is connected via the network.

DBMS architecture depends upon how users are connected to the database to get their requests done.

Types of DBMS Architecture

1. Tier-1 architecture
2. Tier-2 architecture
3. Tier-3 architecture

Database architecture is commonly considered as a single-tier and multi-tier architecture.

Tier-1 architecture

1) In this type of architecture, the database is directly available to the user. it means the user can directly sit on the DBMS and use it.

2) Any changes done here will directly be done on the database itself.

3) It doesn't provide a handle tool for end users.

Tier 2 architecture

1) The tier 2 architecture is same as basic clint-server. in the two-tier architecture, applications programs are run on the client-side.

2)The server side is responsible to provide the functionalities like: query processing and transition management.

Tier -3 architecture

1) The tierr-3 architecture contains another layer between the clientand server. in this architecture, clint can't directly communicate with the server.

2)The application on the client-end iteracts with an application server which further communicates with the database system.