Open In App

Difference Between Two-Tier And Three-Tier database architecture

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Share
Report issue
Report

1. Two-Tier Database Architecture –
In two-tier, the application logic is either buried inside the User Interface on the client or within the database on the server (or both). With two-tier client/server architectures, the user system interface is usually located in the user’s desktop environment and the database management services are usually in a server that is a more powerful machine that services many clients.

2. Three-Tier Database Architecture –
In three-tier, the application logic or process lives in the middle-tier, it is separated from the data and the user interface. Three-tier systems are more scalable, robust and flexible. In addition, they can integrate data from multiple sources. In the three-tier architecture, a middle tier was added between the user system interface client environment and the database management server environment. There are a variety of ways of implementing this middle tier, such as transaction processing monitors, message servers, or application servers.


Difference Between Two-Tier And Three-Tier Database Architecture

S.NO Two-Tier Database Architecture Three-Tier Database Architecture
1 It is a Client-Server Architecture. It is a Web-based application.
2 In two-tier, the application logic is either buried inside the user interface on the client or within the database on the server (or both). In three-tier, the application logic or process resides in the middle-tier, it is separated from the data and the user interface.
3 Two-tier architecture consists of two layers : Client Tier and Database (Data Tier). Three-tier architecture consists of three layers : Client Layer, Business Layer and Data Layer.
4 It is easy to build and maintain. It is complex to build and maintain.
5 Two-tier architecture runs slower. Three-tier architecture runs faster.
6 It is less secured as client can communicate with database directly. It is secured as client is not allowed to communicate with database directly.
7 It results in performance loss whenever the users increase rapidly. It results in performance loss whenever the system is run on Internet but gives more performance than two-tier architecture.
8 Example – Contact Management System created using MS-Access or Railway Reservation System, etc. Example – Designing registration form which contains text box, label, button or a large website on the Internet, etc.


Last Updated : 17 Jun, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads