Centralized databse

Centralized database is a single database in one location. All users and client applications connect directly to the DBMS and this means that the database is stored in only one location and everyone in the system is directly connected to it.

• Advantage
• Manageability
• Speed of operation
• Portability
• Integration is easy
• Upgrades, backups, mirroring is a lot easier
• Reduced redundancy
• Reduced inconsistancy
• Enforced data security
• Disadvantage
• If center goes down, everything is down
• It may be expensive and cumversome than it becomes ineffective
• Installing and maintaining database are costly
• A single database is particularly vulnerable to equipment failure,