Question

different between centralized and distributed database..​

Answer 1

Answer:

Centralized Database :

A centralized database is basically a type of database that is stored, located as well as maintained at a single location only. This type of database is modified and managed from that location itself. This location is thus mainly any database system or a centralized computer system. The centralized location is accessed via an internet connection (LAN, WAN, etc). This centralized database is mainly used by institutions or organizations.

Distributed Database :

A distributed database is basically a type of database which consists of multiple databases that are connected with each other and are spread across different physical locations. The data that is stored on various physical locations can thus be managed independently of other physical locations. The communication between databases at different physical locations is thus done by a computer network

Answer 2

The difference between centralized and distributed databases are:

1. Centralized database is stored and maintained at a single location. On the other hand, a distributed database consists of multiple databases which are connected and are spread across different physical locations.
2. Centralized database provides a uniform and complete view to the user and since the distributed database is spread it is difficult to provide a uniform view to the users.
3. It is inexpensive and distributed database is expensive.
4. The user cannot use a centralized database if it fails, whereas the distributed database provides access to another database if one fails.