Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Table of contents
1.
Introduction
2.
DBMS Architecture
3.
Types Of DBMS Architecture
3.1.
One-Tier Architecture
3.2.
Two-Tier Architecture
3.3.
Three Tier Architecture
4.
Frequently Asked Questions
5.
Key Takeaways
Last Updated: Mar 27, 2024

DBMS Architecture

Author Rhythm Jain
2 upvotes
Master Python: Predicting weather forecasts
Speaker
Ashwin Goyal
Product Manager @

Introduction

A database management system (DBMS) is software that helps you organize data in a database by allowing you to create, retrieve, update, and manage it. 

The DBMS takes a data request from an application and instructs the system to provide the desired data.

Let us learn more about DBMS.

Also Read - Specialization and Generalization in DBMS and Checkpoint in DBMS

DBMS Architecture

A DBMS Architecture is a representation of DBMS design.

DBMS architecture aids in developing, implementing, and upkeep the database management system.

DBMS Architecture might be hierarchical, decentralized, or centralized. 

It also helps divide the whole DBMS system into individual components that can be modified, replaced, or altered independently can work together efficiently.

Therefore it becomes essential to design and select the architecture of a Database Management System.

Let us learn about different types of DBMS architecture.

Must Recommended Topic, Schema in DBMS,Lock based protocol in DB

Get the tech career you deserve, faster!
Connect with our expert counsellors to understand how to hack your way to success
User rating 4.7/5
1:1 doubt support
95% placement record
Akash Pal
Senior Software Engineer
326% Hike After Job Bootcamp
Himanshu Gusain
Programmer Analyst
32 LPA After Job Bootcamp
After Job
Bootcamp

Types Of DBMS Architecture


 

Broadly there are three types of DBMS architecture:

  1. One Tier / Single Tier Architecture
  2. Two-Tier Architecture
  3. Three Tier Architecture


Let‘s learn about each of them in detail.

One-Tier Architecture

It is the most straightforward database design. The client, server, and database all reside on the same system. The database is immediately accessible to the user in this architecture. It means that the user may directly use the DBMS system. Any modifications made here will be applied immediately to the database.

Two-Tier Architecture

In DBMS, a two-tier architecture is a Database architecture in which communication is done through an application.

Client-side acts as User Interface and application programs.

The Server-side acts as data storage and query processing.

The client-side application creates a connection with the server-side to communicate with the DBMS.

Since DBMS is not immediately exposed to the end-user, the two-tier architecture allows direct and quick communication and increased protection.

Three Tier Architecture

A Three-tier architecture divides its tiers based on the complexity of the users and how they interact with the database's contents. 

It is the most extensively used architecture for developing a database management system.

Between the client and the server is another layer in the 3-tier design. 

The client cannot connect directly with the server with this design. The application on the client-end interacts with an application server which further communicates with the database system.

The application server serves as a link between the user and the database. 

Beyond the application server, the end-user is unaware of the database's existence. 

Aside from the application, the database does not know any other users.

Three-Tier database Architecture design is an extension of the two-tier client-server architecture. 

A 3-tier architecture has the following layers:

  • Presentation layer
  • Application layer
  • Database Server


In an extensive online application, the 3-tier design is employed.

Recommended Topic, B+ Tree in DBMS, Recursive Relationship in DBMS and Entity in DBMS

Frequently Asked Questions

  1. What is the One-Tier DBMS Architecture?
    The client, server, and database all reside on the same system. The database is immediately accessible to the user in this architecture.
     
  2. What is the Two-Tier DBMS Architecture?
    In DBMS, a two-tier architecture is a database architecture in which communication is done through an application. The client-side application creates a connection with the server-side to communicate with the DBMS.
     
  3. What are the advantages of Three-Tier DBMS Architecture?
    Advantages of Three-Tier DBMS Architecture are:
    1. Improved Scalability: Scalability is enhanced due to the dispersed deployment of application servers. Individual connections between client and server are no longer required.
    2. Data Integrity: The integrity of the data is preserved. Data corruption may be avoided/removed since there is an intermediate layer between the client and the server.
    3. Improved Security: The level of security has been raised. This architecture stops the client from interacting directly with the server, limiting access to illegal data.

Key Takeaways

In this article, we learned about different DBMS architecture types and their importance. To practice more questions and prepare for programming interviews, you can visit Coding Ninjas Studio

Recommended Reading: Data Warehouse Architecture

You can also consider our Database Management Course to give your career an edge over others!

Happy Coding!

Live masterclass