The type of database which is located, managed, compiled and processed at a single and particular location, is called a Centralized database. And there is a machine or system that manages and runs this database form that very location.
The type of database in which all the responsible devices (mostly storage devices) are placed at various locations and not at a particular location, is called a Decentralized database. And there is no single machine or system that manages this kind of database.
DIFFERENCE BETWEEN CENTRALIZED DATABASE AND DECENTRALIZED DATABASE:
1. DATABASE LOCATION
In the case of a centralized database, the database is managed by a single machine or system which is at a single location that keeps in check the whole database and makes sure of its fluidity.
In case of a decentralized database, the database is spread and split up across various storage device locations which are geographically far away from each other and this requires a centralized system for efficient and fluidity among all the devices.
2. EASE OF MAINTAINING
In the case of a centralized database, this kind of database where all the data and information is stored at a particular location is quite easy to maintain because of its ease of access and its ease of reach.
In case of a decentralized database, this kind of database where all the data and information is split up at various locations is very difficult and complex because we need to deal with varied problems such as avoiding data redundancy and maintaining data consistency.
3. DATABASE EFFICIENCY
In the case of a centralized database, it is less efficient as compared to the decentralized database because all the data is being stored at one particular location which makes data finding job quite complex.
In case of a decentralized database, it has more efficiency as compared to the centralized database because the data is divided and stored at various locations which makes certain of the fact that data finding process is smooth and less time-consuming.