Differentiate between centralized and distributed database system.

Differentiate between centralized and distributed database system.

ans:-

Following are differences between distributed and centralized database system.

Centralized system	Distributed System
1.Job is centralized.	1.Job is distributed.
2. Can not process if main server fails.	2. Can still be if a server fails;processing can be done by other servers.
3. Security is given to one machine.	3.Security is given to all.
4.No need to have network for communication.	4 Needs communication channel between all.
5.Not so expensive to set up.	5.It’s expensive to set up.
6.Data speed is comparatively fast.	6.Data speed is slow.
7.Low quality performance. Diagrammatically it can be shown as	7.High quality performance. Diagrammatically it can shown