BCA / B.Tech 7 min read

RDBMS Architecture

RDBMS Architecture:

The architecture of a Relational Database Management System (RDBMS) defines its structure and how its components interact. The most common architectures are two-tier and three-tier.

1. Two-Tier Architecture:
This is a client-server architecture.
  • Client Layer: The user interface and application logic reside on the client machine.
  • Database Server Layer: The database resides on a server, which processes queries sent by the client.

2. Three-Tier Architecture:
This architecture separates the application into three logical layers:
  • Presentation Layer: The user interface that the end-user interacts with (e.g., a web browser).
  • Business Logic Layer: The application server that contains the business logic and processes data.
  • Database Layer: The database server that stores and manages the data.

This separation makes the system more scalable, flexible, and secure.