What are distributed relational databases?

Question

Database design

Hello, the following task is worth:
Develop a model of a distributed relational database of an enterprise consisting of a main production and several remote branches. Parts of the enterprise are connected by a computer network, have their own local databases, and can use data from remote nodes. Global information is stored at a central site.

Which distributed database to choose and what kind of distributed databases are there?
How are local databases connected?

Answer 1

PostgreSQL + partial replication

Answer 2

Architecturally, there are many ways to solve this problem. There are expensive and boxed ones. Oracle + GoldenGate.
There are cheaper ones (mentioned above). It all depends on your ambitions. Do you want to develop more yourself or just take ready-made solutions.

Answer 3

MSSQL
here the main thing is what you mean by "distributed"