Differentiate between Distributed and Centralized Database

database

A distributed database is the term used to describe a set of databases stored on multiple computers, but it will be present on a single database and it will be made accessible to the users. Here distributed, a database management system is a software that is used by the organization to store and manage the data in an efficient manner.

This system helps in maintaining the security and integrity of the data. There are two types of databases one is distributed and the second one is a centralized database.

Distributed Database

A distributed database is a database in which data is stored in multiple computers located in the same physical location or may be spread over a network of interconnected computers.

distributed database system
Distributed database

Here, a distributed database is a collection of multiple interconnected databases, which are spread over different locations via computer networks.

In the distributed database there we can the processing logic, functions, data and control.

Distributed database can be run and used in different part of works likes manufacturing, militery command, airlines, hotels and any organizations which has a decentralized organization structure.

Centralized Database

A centralized database is a database that is located and stored and maintained in single location. This location is most often a central computer or database system for example a desktop or same CPU, or mainframe computer.

centralized database
Centralized database architecture

Since all data is being stored in a single location, it is easier to access and coordinate the data. The centralized database has very minimal data redundancy since all data is stored in a single place. Centralized database management is very less effective as compared to the other database system.