Distributed Database Architecture

1. Middleware System

1.1. The single query spans multiple servers

1.2. Middleware is software between servers

1.3. Advantages

1.3.1. it tries to extend the basic capabilities of systems

1.3.2. It integrates several legacy systems

1.4. Disadvantages

1.4.1. it does not maintain any data with itself

2. client server

2.1. client

2.1.1. client process sends query to server process

2.2. server

2.2.1. it manages data and executes transaction

2.3. Advantages

2.3.1. The functions are clearly assigned to client and server

2.3.2. The server is centralized

2.4. Disadvantage

2.4.1. To reduce communication overhead client-side caching techniques must be applied

2.4.2. The client is more complex

3. Collaborating server

3.1. Due to complex nature of client in client server architecture collaborating server was evolved

3.2. Advantages

3.2.1. 1. it overcomes the problmes of client server architecture

3.3. Disadvantages

3.3.1. 1.Cost of Network communication