Centralised and distributed database

GO

1. Centralised and Distributed database MADE BY: Santosh Singh BBA(G) 1st year

2. Centralised database A centralised database is a database  that is located, stored, and maintained in a single location. This location is most often a central computer or database  system, for example a desktop or server CPU, or a mainframe computer.

3. Distributed database A  d istributed database is a database   in which portions of the  database are stored in multiple physical locations and processing is Distributed database among multiple database  nodes

4. Advantages: Since there is only 1 database file, it is easier to: Get a complete view of data Manage update an backup data

5. Disadvantages: Bottle necking from multiple users accessing the same File –slowing down productivity

6. Advantages : Having Multiple database file means: Users won’t interfere with each other when accessing/ manipulating data Speed since files are retrieved from nearest location If one site fails , the system can still run

7. Disadvantages: Time for Synchronization of the multiple database Data Replication for each different database