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