Architectures of Distributed DBMS

The basic types of distributed DBMS are as follows:

1. Client-server architecture of Distributed system.

  • A client server architecture has a number of clients and a few servers connected in a network.
  • A client sends a query to one of the servers. The earliest available server solves it and replies.
  • A Client-server architecture is simple to implement and execute due to centralized server system.
client server

2. Collaborating server architecture.

  • Collaborating server architecture is designed to run a single query on multiple servers.
  • Servers break single query into multiple small queries and the result is sent to the client.
  • Collaborating server architecture has a collection of database servers. Each server is capable for executing the current transactions across the databases.
collaborative server

3. Middleware architecture.

  • Middleware architectures are designed in such a way that single query is executed on multiple servers.
  • This system needs only one server which is capable of managing queries and transactions from multiple servers.
  • Middleware architecture uses local servers to handle local queries and transactions.
  • The softwares are used for execution of queries and transactions across one or more independent database servers, this type of software is called as middleware.