What do you mean by distributed DBMS and what are its types?/ What is the need for a distributed database?

A distributed database management system(DDBMS) is a software system that manages a distributed database while making the distribution transparent to the user. In simple meaning, the whole data of the database is not kept in one place instead it is distributed DBMS on the basis of various parameters like the place, requirement and etc|What do you mean by distributed DBMS and what are its types|

Most of you will be aware of Facebook, Facebook distributes its database on the basis of country and has multiple servers to handle their database. So a database can be distributed on the basis of department, organization, company, people and etc|What do you mean by distributed DBMS and what are its types|

Using this blog post(What do you mean by distributed DBMS and what are its types) we will explore What is the need for a distributed database? What is a distributed database with an example? What do you mean by distributed DBMS and what are its types? How does a distributed database work?…

…Advantages of distributed database, Distributed database design, Distributed database Management system|What do you mean by distributed DBMS and what are its types|

What is a distributed database with an example?| What do you mean by distributed DBMS and what are its types?

This is a database system where one data file is kept at a different location, and this location can be in the existing network or a different network. The same files are kept at different physical locations and then accessed by different-2 users at various different places.

Few examples of the distributed database systems are Apache Ignite, Apache Cassandra, Apache HBase, Couchbase Server, Amazon SimpleDB, Clusterpoint, and FoundationDB.

What do you mean by distributed DBMS and what are its types?

A distributed database system is a system where the storage of data files is not limited to one machine. The data is spared over several computer systems wither in one network or in the different-2 networks.

There are two types of a distributed database system:

Homogeneous:

Inside this type of distributed database system all the data files and database architecture are the same at all the sites where it is kept. The data files, data structure, database management system schema will be the same and identical at all the sites.

Heterogeneous:

This is just the opposite of a homogeneous system. Here operating system, database application, data structure, and schema can be totally different from the other sites. And one site can be totally unaware of other site management. So it could problems in query processing and transaction. So, to avoid such a problem translation is done between each site about the updates of any application and software.

Distributed database storage: They are also of two types:

Replication and fragmentation, Inside the replication the copies of the full database are kept across the two or more sites and the queries can execute parallelly at all the sites. And in the fragmentation data storage approach the small group of data after division is kept across the different sites.

How does a distributed DBMS work?

In a distributed database system environment the copy of data is kept at the different-2 physical location. Now, this could be like you store all the copies of the database at the same physical location in the multiple computer systems. And the other way could be to keep these database copies into different networks interconnected.

Need for Distributed database DBMS?/ What is the need for a distributed database?

In the distributed database system, there are several replicas of data are placed in different-2 places. And they are all identical and can be access by the users at all the places.

This multiple instances of one data file at several places reduces the traffic in one place. And if one data file or instance is damaged or corrupted then our data file is still safe at the other places and we can again make a backup copy and place it again at the position.

If you see the enterprises then you will find they are already been distributed, at least logically(into division, department, workgroups, etc.) and very likely physical too (into plants, factories, laboratories, etc.) from which it follows that data is usually distributed already as well.

Because each organization unit within the enterprise will maintain data that is relevant to its own operation. The total information asset of the enterprise is thus splintered into what is sometimes called an island of information.

distributed-dbms
What do you mean by distributed DBMS and what are its types: Distributed DBMS System

The distributed system provides the necessary bridges to connect those island together. In other words, it enables the structure of the database to mirror the structure of the enterprise.

Local data can be kept locally, where it most logically belongs while at the same time remote data can be accessed when necessary. so ultimately data distribution makes our work very easy as we can access the data frequently with high speed without any conflict and complication.

Difference between Centralized database and Distributed database?

Centralized Database system:

All the database is stored, managed and maintained at one single place or location.

Since database is stored at single location so it become easier to access the data and coordinate with the data.

Advantages:

Chance of data redundancy is very less as all the data is stored at one location so can be checked easily.

This type of database system is cheaper than other available database system.

Disadvantages:

The data traffic is more in the case of centralizing database systems and this can cause slow processing and system hang problems sometimes.

In the case of system failure, all the data can be destroyed, so it is a must to keep a backup copy of the centralizing database system somewhere with daily updates.

Distributed database system:

Advantages:

Data expansion is easy as the database is spared at a different-2 location so it is very little chance to overload data at a single point.

Data can be easily access from the different networks.

Data is much secure as compared to the centralize database system.

Disadvantages:

It is complex and difficult to manage and maintain.

It is difficult to provide the uniform view to the end users as it is spared across multiple sites.

Conclusion:

Distributed DBMS is all about reducing the complication in accessing the data. If data will be distributed on the basis of its nature and category then it will be very easy to access the data without any traffic in one place. Hope you would have enjoyed this post(What do you mean by distributed DBMS and what are its types).

Using this blog post(What do you mean by distributed DBMS and what are its types) we will explore What is the need for a distributed database? What is a distributed database with an example? What do you mean by distributed DBMS and what are its types? How does a distributed database work? Advantages of distributed database, Distributed database design, Distributed database Management system.

Feel free to write us at [email protected] if you have any query in your mind, We would love to sort it out asap|What do you mean by distributed DBMS and what are its types|

Have a great time!

Anurag

I am a blogger by passion, a software engineer by profession, a singer by consideration and rest of things that I do is for my destination.