Distribution basically leads to increased complexity in the system design and implementation. This is to achieve the potential advantages such as:
- Network Transparencies
- Increased Reliability
- Improved Performance
- Easier Expansion
Function of Centralized DBMS:
- The basic function of centralized DBMS is that it provides complete view of our data.
For example, we can have the query for the number of customers who are willing to buy worldwide.
- The second basic function of Centralized DBMS is that it is easy to manage than other distributed systems.
The Distributed Database must be able to provide the following function in addition to those of a centralized DBMS’s.
Functions of Distributed database system:
- Keeping track of data –
The basic function of DDBMS is to keep track of the data distribution, fragmentation and replication by expanding the DDBMS catalog.
- Distributed Query Processing –
The basic function of DDBMS is basically its ability to access remote sites and to transmits queries and data among the various sites via a communication network.
- Replicated Data Management –
The basic function of DDBMS is basically to decide which copy of a replicated data item to access and to maintain the consistency of copies of replicated data items.
- Distributed Database Recovery –
The ability to recover from the individual site crashes and from new types of failures such as failure of communication links.
- Security –
The basic function of DDBMS is to execute Distributed Transaction with proper management of the security of the data and the authorization/access privilege of users.
- Distributed Directory Management –
A directory basically contains information about data in the database. The directory may be global for the entire DDB, or local for each site. The placement and distribution of the directory may have design and policy issues.
- Distributed Transaction Management –
The basic function of DDBMS is its ability to devise execution strategies for queries and transaction that access data from more than one site and to synchronize the access to distributed data and basically to maintain the integrity of the complete database.
But These function basically increases the complexity of a DDBMS over centralized DBMS.
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.
- Distributed Database System
- Difference between Centralized Database and Distributed Database
- Advantages of Distributed database
- Structure of Database Management System
- Advantages of Database Management System
- Personnel involved in Database Management System
- Difference between Database System and Data Warehouse
- Introduction of DBMS (Database Management System) | Set 1
- Federated database management system issues
- Database Management System | Dependency Preserving Decomposition
- Top 5 Free, Cross-Platform, and Open-Source Database System in 2020
- How to pre populate database in Android using SQLite Database
- SQL | Functions (Aggregate and Scalar Functions)
- Concepts of Distributed databases
- Disadvantages of Distributed DBMS
- Comparison - Centralized, Decentralized and Distributed Systems
- What is Database ?
- Multimedia Database
- SQL Trigger | Student Database
- Introduction of Database Normalization
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.