What is tier-2 architecture in DBMS?

DBMSDatabaseBig Data Analytics

The overall design of the Database Management System (DBMS) depends on its architecture. A large amount of data on web servers, Personal Computers (PC) and other elements are linked with networks with the help of basic client or server architecture.

PCs and workstations are part of Client architecture that are connected over the network. The architecture of DBMS depends on how the users are linked to the database.

There are three kinds of DBMS Architecture, which are as follows −

  • Tier-1 Architecture.

  • Tier-2 Architecture.

  • Tier-3 Architecture.

Tier-2 Architecture

The 2-tier Architecture is based on a client-server machine.

In this type of architecture, the applications on client-side interact directly with the database present at the server-side.

This interaction between client and server uses Application Program Interface like ODBC and JDBC.

  • ODBC − Open Database Connectivity

  • JDBC − Java Database Connectivity

When there are a large number of users at client side to access the database, this architecture gives a poor performance.

The server side is responsible for delivering the functionalities like query processing and management of transactions.

For example − Oracle, Sybase, Microsoft SQL Server etc.

The Tier-2 architecture of DBMS is diagrammatically represented as follows −

Published on 03-Jul-2021 08:58:00