KEMBAR78
Architecture DBMS | PDF
Scribd
Upload
7 views3 pages

Architecture DBMS

DBMS architecture outlines user interaction with databases for data management. It includes 1-Tier, 2-Tier, and 3-Tier architectures, each varying in how clients communicate with databases. The 1-Tier architecture allows direct interaction, the 2-Tier uses a client-server model, and the 3-Tier introduces an application server for larger web applications.

Uploaded by

prathameshmartawar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views3 pages

Architecture DBMS

DBMS architecture outlines user interaction with databases for data management. It includes 1-Tier, 2-Tier, and 3-Tier architectures, each varying in how clients communicate with databases. The 1-Tier architecture allows direct interaction, the 2-Tier uses a client-server model, and the 3-Tier introduces an application server for larger web applications.

Uploaded by

prathameshmartawar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Architecture DBMS-

DBMS architecture defines how users interact with the database to read, write, or
update information. A well-designed architecture and schema (a blueprint detailing
tables, fields and relationships) ensure data consistency, improve performance and
keep data secure.

Types of DBMS Architecture


There are several types of DBMS Architecture that we use according to the usage
requirements.
1-Tier Architecture
2-Tier Architecture
3-Tier Architecture

1-Tier Architecture
In 1-Tier Architecture, the user works directly with the database on the same system.
This means the client, server and database are all in one application. The user can
open the application, interact with the data and perform tasks without needing a
separate server or network connection.
2-Tier Architecture
The 2-tier architecture is similar to a basic client-server model. The application at
the client end directly communicates with the database on the server side. APIs like
ODBC and JDBC are used for this interaction. The server side is responsible for
providing query processing and transaction management functionalities.

3-Tier Architecture
In 3-Tier Architecture, there is another layer between the client and the server. The
client does not directly communicate with the server. Instead, it interacts with an
application server which further communicates with the database system and then
the query processing and transaction management takes place. This intermediate
layer acts as a medium for the exchange of partially processed data between the
server and the client. This type of architecture is used in the case of large web
applications.

You might also like