What Are the Functions of a Distributed DBMS

Question

Examlex · Accepted Answer

The Answer is In a distributed database environment, the local database at each site will have a DBMS managing the local database. However, there is a centralized DBMS which handles the following:
1. Keeping track of where data are located in the distributed data dictionary
2. Determine the location from which to retrieve requested data and the location at which to process each part of a distributed query
3. Translate the request at one node using a local DBMS into a request at another node, perhaps using a different DBMS
4. Provide security, concurrency, deadlock control and other data management functions
5. Provide consistency among copies of data across multiple sites
6. Provide a single logical database that is physically distributed
7. Provide scalability
8. Replicate data and stored procedures across the nodes of the distributed database
9. Use residual computing power to improve the performance of database processing
10. Permit different nodes to run different DBMSs
11. Allow different versions of application code to reside on different nodes of the distributed database

What Are the Functions of a Distributed DBMS

Definitions: