CHAPTER 18 Managing Distributed Databases
In a distributed environment, databases on separate servers (hosts) may be accessed during a single transaction or query. Each server can be physically isolated without being logically isolated from the other servers.
A typical distributed database implementation involves corporate headquarters servers that replicate data to departmental servers in various locations. Each database supports local client applications and also has the ability to communicate with other databases in the network. This architecture is shown in Figure 18-1.
When one of the servers sends a database request to another server, the sending server acts like a client. The receiving server executes the SQL statement that is passed to ...