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 CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Difference between Centralized Database and Distributed Database
- Distributed Database System
- Advantages of Distributed database
- Date's Twelve Rules for Distributed Database Systems
- How to pre populate database in Android using SQLite Database
- Difference between Database Administrator (DBA) and Database Engineer
- Database Management System | Dependency Preserving Decomposition
- Introduction of DBMS (Database Management System) | Set 1
- Federated database management system issues
- Personnel involved in Database Management System
- Advantages of Database Management System
- Difference between Database System and Data Warehouse
- Top 5 Free, Cross-Platform, and Open-Source Database System in 2020
- Structure of Database Management System
- Getting started with Database Management System
- SQL | Functions (Aggregate and Scalar Functions)
- Comparison - Centralized, Decentralized and Distributed Systems
- Difference between Parallel Computing and Distributed Computing
- Disadvantages of Distributed DBMS
- Concepts of Distributed databases
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. 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.