Distributed databases basically provide us the advantages of distributed computing to the database management domain. Basically, we can define a Distributed database as a collection of multiple interrelated databases distributed over a computer network and a distributed database management system as a software system that basically manages a distributed database while making the distribution transparent to the user.
Distributed database management basically proposed for the various reason from organizational decentralization and economical processing to greater autonomy. Some of these advantages are as follows:
1. Management of data with different level of transparency –
Ideally, a database should be distribution transparent in the sense of hiding the details of where each file is physically stored within the system. The following types of transparencies are basically possible in the distributed database system:
- Network transparency:
This basically refers to the freedom for the user from the operational details of the network. These are of two types Location and naming transparency.
- Replication transparencies:
It basically made user unaware of the existence of copies as we know that copies of data may be stored at multiple sites for better availability performance and reliability.
- Fragmentation transparency:
It basically made user unaware about the existence of fragments it may be the vertical fragment or horizontal fragmentation.
2. Increased Reliability and availability –
Reliability is basically defined as the probability that a system is running at a certain time whereas Availability is defined as the probability that the system is continuously available during a time interval. When the data and DBMS software are distributed over several sites one site may fail while other sites continue to operate and we are not able to only access the data that exist at the failed site and this basically leads to improvement in reliability and availability.
3. Easier Expansion –
In a distributed environment expansion of the system in terms of adding more data, increasing database sizes, or adding more data, increasing database sizes or adding more processor is much easier.
4. Improved Performance –
We can achieve interquery and intraquery parallelism by executing multiple queries at different sites by breaking up a query into a number of subqueries that basically executes in parallel which basically leads to improvement in performance.
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.
- Difference between Centralized Database and Distributed Database
- Advantages of Database Management System
- Distributed Database System
- Functions of Distributed Database System
- Date's Twelve Rules for Distributed Database Systems
- Difference between Database Administrator (DBA) and Database Engineer
- How to pre populate database in Android using SQLite Database
- Advantages and Disadvantages of SQL
- Advantages and Disadvantages of Using Stored Procedures - SQL
- Advantages of DBMS over File system
- Difference between Network OS and Distributed OS
- Synchronization in Distributed Systems
- Hashing in Distributed Systems
- Disadvantages of Distributed DBMS
- Distributed Application Paradigms
- Limitation of Distributed System
- Various Failures in Distributed System
- Concepts of Distributed databases
- Interprocess Communication in Distributed Systems
- Implementation of Access Matrix in Distributed OS
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.