2. What is a distributed database?

A distributed database is a single logical database whose parts are physically located in more than one place, each location is accessible across a network.

A standard database on a network looks like this

typical database

This shows a central database being accessed from a workstation over a network.

Note that all traffic has to flow over the network, and this may be a problem.

A typical distributed database looks like this:

Distributed database

In this case the database is split across different sites and each site is connected over a network.

Each site has a database management system (DBMS) that allows queries and updates to be made locally. But each site also has a distributed database component (DDBMS) that allows each site to make global queries of the whole system.

 

challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: what is a distributed database