Question

Difference between centralized and distributed database in tabular form

Answer 1

Centralized DBMS Distributed DBMS

In Centralized DBMS the database are stored in a only one site In Distributed DBMS the database are stored in different site and help of network it can access it

If the data is stored at a single computer site,which can be used by multiple users Database and DBMS software distributed over many sites,connected by a computer network

Database is maintained at one site Database is maintained at a number of different sites

If centralized system fails,entire system is halted If one system fails,system continues work with other site