2 Tier Architecture in DBMS

Components of two tier architecture 

It consists of two tiers

1. Client-side application:  

• • User interfaces and application programs run generally on the client-side
  • It is generally a presentation layer that runs on a client (PC, Mobile, Tablet, etc) 
  • This client application establishes a connection by sending a request to the server-side up an application in order to establish communication between the database 

 2. Server side application 

• • The server side is responsible for query processing and transaction management 
  • In this, client-side directly communicates with the database base that is present on the server-side and the server sends a response to the request received from the client
  • Simply server-side represented data is stored on a Server.
  • Generally, APIS like ODBC, JDBC is used for this interaction i.e for sending requests from the client-side application.

Real-time examples for two-tier architecture 

• Desktop applications excel sheets, word document, desktop games
• The contact management system that is created using MS Access is the most observed example is for this two-tier architecture.

Advantages of two-tier architecture

• As it is simple and easily understandable provides direct and faster communication 
• Compatible with existing systems 
• Provides some secretary to the DBMS as it is not directly e exposed to the end-user range.

Limitation of this two-tier architecture 

It cannot be used for dynamic web applications where there are a large number of users and generally used for static desktop and small web applications.