Stay Tuned!

Subscribe to our newsletter to get our newest articles instantly!

Database Differences

Differentiate between Distributed and Centralized 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.



About Author provides tutorials related to tech and programmings. We are also setting up a community for the users and students.

You may also like

advantages of database
Database Pros and Cons

Advantages of Database & Disadvantages of Database

  • July 18, 2019
Here are some advantages of database and disadvantages of database. A database management system is a collection of interrelated data
Difference Between Microprocessor and Microcontroller

Difference Between Microprocessor and Microcontroller

  • July 18, 2019
What is Microprocessor? A microprocessor is an electronic component that is used by a computer to do its work. It is a