Lesson 11: Distributed DBMS Architecture

University:
California State University, Northridge
Course:
COMP 440 | Database Design
Academic year:

2024
Views:

0

Pages:

2
Author:

Osage newton

11 Distributed DBMS Architecture The architecture of a system defines its structure. This means that the components of the system are identified, the function of each component is specified, and the interrelationships and interactions among these components are defined. 11.1 Architectural Models for Distributed DBMS Let us consider the possible ways in which multiple databases may be put together for sharing by multiple DBMSs. We use a classification that organizes the systems as characterized with respect to (1) the autonomy of local systems, (2) their distribution, and (3) their heterogeneity. 11.2 Types of Distributed DBMS Architecture The distributed DBMS architecture types namely client server, collaborating servers, and Middleware architecture. 11.2.1 Client-server architecture 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. 11.2.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. 1 11.2.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 software used for execution of queries and transactions across one or more independent database servers, is referred to as middleware. 2