Difference Between Centralized and Distributed Database Management System

What is Distributed Database system in DBMS

A collection of Logically Interrelated database that are spread physically across multiple locations connected by a data communication links.

What is Centralize Database System

In a centralize database there is a single database file at one location in the network
Multiple users can access this single database it is called a centralized database
This kind of database provides multiple advantages
As there is an only single database file it is easier to get a complete view of the data
Moreover, it is easier to manage update and take backups of data

Difference Between Centralized and Distributed Database Management System

Centralized Database	Distributed Database
A type of database that contains a single database located at one location in the network	A type of Database that contains two or more database files located at different location in the network
Managing Updating and taking in backups of data is easier because there is only one database file	As there are multiple database files in a distributed database it require time to synchronize data
Requires time for accessing data because multiple users access the database file	Speed in accessing the data is higher because the data is retrieved from the nearest database file
If the database fails the users do not have access to a database	If one database fails the users can still access other database files
Has more data consistency and it provides the complete view to the user	Can have data replications and there can be some data inconsistency