2 tier and 3 tier architecture in DBMS

Database Architecture

Database Architecture is a representation of DBMS design. It uses programming languages to design a particular type of software for businesses or organizations. It focuses on the design, development, implementation, and maintenance of computer programs that store and organize information for businesses, agencies, and institutions.

A Database stores critical information and helps access data quickly and securely. Therefore, selecting the correct Architecture of DBMS helps in easy and efficient data management.

Types of DBMS Architecture


Sr No.2-Tier Architecture3-Tier Architecture
1.A 2-tier architecture is a database architecture where the presentation layer runs on a client and data is stored on a server called the second tier. A 3-tier architecture is a client-server architecture in which the development and maintenance of functional processes, logic, data access, data storage, and the user interface are done independently.
2. It is a client-server architecture.It is a web-based application.
3.It is easy to build and maintain.It is complex to build and maintain.
4.In a 2-tier architecture, one server is connected with different clients.3-tier database architecture design is an extension of 2-tier  client-server architecture.
5.It runs slower. It runs faster.
6.It is less secure as clients can communicate directly to the database.It is secured as the client is not allowed to communicate directly.
7.It results in a loss of performance whenever users increase rapidly. It results in performance loss when the system is running on the internet but gives the performance more than 2-tier architecture.
8.For example, A contact management system was created using MS- Access.For example Any large website on the internet