Types of DBMS Architecture 1-Tier Architecture
2-Tier Architecture
3-Tier Architecture

Summary

An Architecture of DBMS helps in design, development, implementation, and maintenance of a database The simplest database system architecture is 1 tier where the Client, Server, and Database all reside on the same machine A two-tier architecture is a database architecture in DBMS where presentation layer runs on a client and data is stored on a server Three-tier client-server architecture consists of the Presentation layer (PC, Tablet, Mobile, etc.), Application layer (server) and Database Server

One Tier Architecture (Single Tier Architecture) Two Tier Architecture Three Tier Architecture

1-Tier Architecture

1 Tier Architecture in DBMS is the simplest architecture of Database in which the client, server, and Database all reside on the same machine. A simple one tier architecture example would be anytime you install a Database in your system and access it to practice SQL queries. But such architecture is rarely used in production.

In the above 2 Tier client-server architecture of database management system, we can see that one server is connected with clients 1, 2, and 3. Two Tier Architecture Example: A Contact Management System created using MS- Access. 3-Tier database Architecture design is an extension of the 2-tier client-server architecture. A 3-tier architecture has the following layers:

Presentation layer (your PC, Tablet, Mobile, etc.) Application layer (server) Database Server

The Application layer resides between the user and the DBMS, which is responsible for communicating the user’s request to the DBMS system and send the response from the DBMS to the user. The application layer(business logic layer) also processes functional logic, constraint, and rules before passing data to the user or down to the DBMS.

The goal of Three Tier client-server architecture is:

To separate the user applications and physical database To support DBMS characteristics Program-data independence Supporting multiple views of the data

Three Tier Architecture Example: Any large website on the internet, including guru99.com.