03 Sep  Admin

DBMS architecture will help us understand the components of database system and the relation among them. The architecture of DBMS depends on the computer system on which it runs.

Types of DBMS Architecture

There are three types of DBMS 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.

2. Two tier architecture :-

        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.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. 

 3Three tier architecture :-

       In this 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.