Scribd
Upload
89 views3 pages

Types of DBMS Architecture Explained

There are three types of database management system (DBMS) architectures: single tier, two tier, and three tier. In a single tier architecture, the database resides on the client machine. In a two tier architecture, the database resides on the server machine and the client application resides separately. In a three tier architecture, an additional middle layer is present between the client application and database server.

Uploaded by

Sachin Kondawar
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
89 views3 pages

Types of DBMS Architecture Explained

There are three types of database management system (DBMS) architectures: single tier, two tier, and three tier. In a single tier architecture, the database resides on the client machine. In a two tier architecture, the database resides on the server machine and the client application resides separately. In a three tier architecture, an additional middle layer is present between the client application and database server.

Uploaded by

Sachin Kondawar
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

There are three types of DBMS architecture:

1. Single tier architecture

2. Two tier architecture

3. Three tier architecture

1. Single tier architecture

In this type of architecture, the database is readily available on the client


machine, any request made by client doesn’t require a network connection to
perform the action on the database.

For example, lets say you want to fetch the records of employee from the
database and the database is available on your computer system, so the
request to fetch employee details will be done by your computer and the
records will be fetched from the database by your computer as well. This type
of system is generally referred as local database system.
2. Two tier architecture

DBMS Architecture - 2-tier

In two-tier architecture, the Database system is present at the server machine


and the DBMS application is present at the client machine, these two machines
are connected with each other through a reliable network as shown in the
above diagram.

Whenever client machine makes a request to access the database present at


server using a query language like sql, the server perform the request on the
database and returns the result back to the client. The application connection
interface such as JDBC, ODBC are used for the interaction between server and
client.
3. Three tier architecture

DBMS Architecture - 3 tier

In three-tier architecture, another layer is present between the client machine


and server machine. In this architecture, the client application doesn’t
communicate directly with the database systems present at the server
machine, rather the client application communicates with server application
and the server application internally communicates with the database system
present at the server.

You might also like