Advantages and Disadvantages of Centralized Database System

Advantages Centralized Database

• The data integrity is maximized as the whole database is stored at a single physical location This means that it is easier to coordinate the data and it is as accurate and consistent as possible
• The data redundancy is minimal in the centralized database
• Since all the data is in one place, there can be stronger security measures around it so the centralized database is much more secure
• Data is easily portable because it is stored at the same place
• The centralized database is cheaper than other type of databases as it requires less power and maintenance
• All the information in the centralized database can be easily accessed from the same location and at the same time

Disadvantages Centralized Database

• Since all the data is at one location it takes more time to search and access it if the network is slow this process takes even more time
• There is a lot of data access traffic for the centralized database this may create a bottleneck situation
• Since all the data is at the same location if multiple users try to access it simultaneously it creates a problem this may reduce the efficiency of the system
• If there are no database recovery measures in place and a system failure occurs then all the data in the database will destroyed