Global organizations are geographically spread across and would like to maintain their information in the local database, where each database location is situated close to the organization site while making it accessible to global users. This brought the need for the database to have multiple instances and for information to be collated from these multiple systems connected over the communication network and administered through a central system/resource. This central control should allow the applications/users, from the same or different location to the database, to access both local and remote information to effectively support the distributed computing behavior. Such access of the distributed database from the application gets complicated when the application tries to add/update more information across it in a single transaction.
In this chapter, we will cover the following:
- Distributed and decentralized databases
- Distributed database environments
- Homogeneous distributed database environment
- Heterogeneous distributed database environment
- Distributed database setup methodologies
- Replication
- Horizontal partitioning
- Vertical partitioning
- Hybrid Setup
- Distributed DBMS architecture
- Design goals
- Java Database Connectivity (JDBC)
- JTA for distributed transactions
- XA transactions programming