What is a disadvantage associated with centralized databases?

Centralized databases consolidate data storage in one location, which can enhance data management and accessibility. However, a significant disadvantage of this architecture is the potential for the creation of data silos and shadow databases.

Data silos occur when departments or teams within an organization begin to rely on their own isolated systems or databases instead of accessing the centralized database. This can result in fragmented data that is not uniformly shared across the organization, leading to inconsistencies and challenges in maintaining accurate, up-to-date information. Shadow databases refer to unauthorized or informal storage solutions that employees may use, often without IT oversight. These issues can create barriers to data sharing and collaboration, ultimately undermining the advantages of having a centralized database by allowing critical information to be dispersed and unregulated.

In contrast, improved data visibility, ease of data manipulation, and reduced data redundancy are generally seen as advantages of centralized databases, as they promote better oversight, simpler updates, and less duplication of data across various system points.