Centralized and Client Server Architecture For DBMS

Centralized and Client Server Architecture For DBMS

Centralized and Client Server Architecture For DBMS

Centralized and Client/Server Architectures for DBMSS

Early days the centralized architecture are often used by Mainframe computers for processing all kind of system functions for example user application programs and user interface program and this  is also performed DBMS functionalities.  The reason behind of this in earlier days, maximum users accessed such kinds of systems via computer terminals, on that time computer terminals can’t process and it has a only display capability. That’s why processing activity performed by computer systems and for display information this sent to display terminals which are connected to mainframe computer via different kinds of computer Networks.

So after some days we got a personal computer in the markets. But still in the initially days centralized architecture was  continuously used for DBMS. Gradually DBMS system to processing it means computer has been coming with processing power , then started use of Client /Server Architecture. Centralized and Client Server Architecture For DBMS

Basic Client/Server Architectures 

Clinet / server architecture

  • The client/server architecture is mostly used to deal with  so many pcs, database sever , web servers and other  devices which  are connected with networks.
  • The client /server architecture consists of many PCs and a workstation which are connected via the networks . Client request the server for a service. Sever service to the client which requested by client like if client demand any page of particular website . Centralized and Client Server Architecture For DBMS

Single or 1-tier Architecture

  1. In single or 1 tier architecture, the database is directly available to the user. The Client, Server, and Database all reside on the same machine i.e. the user can directly access DBMS. Centralized and Client Server Architecture For DBMS
  2. Any changes done here will directly be done on the database itself. It does not  provide a handy tool for end users.
  3. No network connection is required to perform the action on the database 

1 tier architecture is used

  1. 1.where data does not change frequently and where no multiple user is accessing the system
  2. 2.this is generally use for development of the local application, due to this features programmers can directly communicate with database for the fast response.
  3. This kind of architecture is rarely used in production. Centralized and Client Server Architecture For DBMS

2-Tier Architecture

  • It is same a client-server
  1. In this architecture client can directly communicate with database at server side easily
  2.  An Application Programming Interfaces (APIs) like ODBC & JDBC are used by client side program to call the DBMS
  3. The user interfaces and application programs are run on the client-side
  4.  To communicate with the DBMS, client-side application establishes a connection with the server side
  5.  The server side is responsible to provide the functionalities like: query processing and transaction management.
  6. The 2-tier architecture is used inside any organization, where multiple clients accessing the database server directly
  7.  Example: Railway reservation from counter, where clerk as a client accesses the railway server directly.

Advantage :

  • Direct and faster communication
  •  Maintenance and understanding is easier
  •  Compatible with existing systems


  • Scalability i.e. It gives poor performance when there are a large number of users
  • Less secure as client can access the server directly


3-Tier Architecture

  1. The 3-Tier architecture contains another layer of Application Server between the client & server. In the 3 tire architecture , client can not directly contact with server.
  2. The application on the client-end interacts with an application server which further communicates with the database system and then the query processing and transaction management takes place.
  3. In this intermediate layer of application server work as a medium for exchange of partially proceed data between client and server. Centralized and Client Server Architecture For DBMS
  4. End user’s There n any idea about the existence of database beyond the application server.
  5. In 3-tier architecture, an application is virtually split into three separate logical layers.
  6. The 3-tier architecture is used in large web applications
  7. It is the most popular DBMS architecture.


  • Enhanced scalability due to distributed deployment of application servers. Now, individual connections need not be made between client and server.
  •  Data Integrity is maintained. Because there is a middle layer between client and server. So data corruption can be avoided or removed. Centralized and Client Server Architecture For DBMS
  • Security is improved. In this model client can not access direct server thereby its secure..
  • Increased complexity of implementation and communication.


Centralized and Client Server Architecture For DBMS


Click Here For :- Human Nervous System
Click Here For :-Human Skeletal System
Click Here For :- Human Endocrine System
Click Here For ::- Tissue’

Embedded SQL in DBMS
Spread the love

Leave a Comment

Your email address will not be published. Required fields are marked *