Distributed DBMS architecture
As part of the distributed database setup, we need to configure a distributed database management system, which can synchronize the information retrieval and/or update each of the individual schemas. While each individual system can have its own database management system to control its respective database, having a distributed Database Management System (DBMS) takes care of the following purposes:
- Monitoring the data setup in the distributed database, so that individual users and applications see the distributed database as one logical instance of database and schema
- Govern the information by locating it during retrieval and updating requests from individual applications and users
- Taking the requests for individual database nodes, and retrieving the information from other remote databases as well, if the requested information is not available in the local database
- Ensuring that the distributed database access is following the roles of universal query optimization...